albums_artists

10 rows where artist_id = 3107

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
4177 4177 3975 3975 3107 3107
7814 7814 7502 7502 3107 3107
11931 11931 11589 11589 3107 3107
14733 14733 14379 14379 3107 3107
14734 14734 14380 14380 3107 3107
15960 15960 15621 15621 3107 3107
19570 19570 19358 19358 3107 3107
20159 20159 19982 19982 3107 3107
21988 21988 21888 21888 3107 3107
23863 23863 23751 23751 3107 3107

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