albums_artists

10 rows where artist_id = 1222

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
1328 1328 1249 1249 1222 1222
8464 8464 8136 8136 1222 1222
11698 11698 11357 11357 1222 1222
14538 14538 14182 14182 1222 1222
19585 19585 19373 19373 1222 1222
20983 20983 20838 20838 1222 1222
21137 21137 21006 21006 1222 1222
22303 22303 22214 22214 1222 1222
23387 23387 23284 23284 1222 1222
25368 25368 25271 25271 1222 1222

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)
);