albums_artists

5 rows where artist_id = 3276

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
4469 4469 4254 4254 3276 3276
7627 7627 7320 7320 3276 3276
10162 10162 9822 9822 3276 3276
11381 11381 11042 11042 3276 3276
26471 26471 26361 26361 3276 3276

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE albums_artists (
	album_id integer NOT NULL,
	artist_id integer NOT NULL,
	FOREIGN KEY(artist_id) REFERENCES artists(id),
	FOREIGN KEY(album_id) REFERENCES albums(id),
	UNIQUE(album_id, artist_id)
);