albums_artists

15 rows where artist_id = 2937

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
3879 3879 3674 3674 2937 2937
5416 5416 5163 5163 2937 2937
6704 6704 6413 6413 2937 2937
6892 6892 6593 6593 2937 2937
11799 11799 11458 11458 2937 2937
14151 14151 13796 13796 2937 2937
15009 15009 14662 14662 2937 2937
16462 16462 16149 16149 2937 2937
18682 18682 18434 18434 2937 2937
19837 19837 19643 19643 2937 2937
22335 22335 22246 22246 2937 2937
23412 23412 23308 23308 2937 2937
23551 23551 23447 23447 2937 2937
23552 23552 23448 23448 2937 2937
25477 25477 25376 25376 2937 2937

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