albums_artists

15 rows where artist_id = 355

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
363 363 345 345 355 355
973 973 917 917 355 355
1539 1539 1452 1452 355 355
2003 2003 1885 1885 355 355
2949 2949 2778 2778 355 355
4845 4845 4623 4623 355 355
9349 9349 9000 9000 355 355
11362 11362 11023 11023 355 355
11686 11686 11346 11346 355 355
12930 12930 12586 12586 355 355
16637 16637 16326 16326 355 355
26668 26668 26547 26547 355 355
26945 26945 26800 26800 355 355
27092 27092 26935 26935 355 355
27179 27179 27017 27017 355 355

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