albums_artists

11 rows where artist_id = 1970

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
2302 2302 2159 2159 1970 1970
3128 3128 2950 2950 1970 1970
8528 8528 8196 8196 1970 1970
13373 13373 13022 13022 1970 1970
17193 17193 16889 16889 1970 1970
19098 19098 18874 18874 1970 1970
19552 19552 19339 19339 1970 1970
20110 20110 19932 19932 1970 1970
22018 22018 21918 21918 1970 1970
24182 24182 24072 24072 1970 1970
25650 25650 25552 25552 1970 1970

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