albums_artists

12 rows where artist_id = 1345

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
1468 1468 1384 1384 1345 1345
5103 5103 4860 4860 1345 1345
9126 9126 8783 8783 1345 1345
12177 12177 11839 11839 1345 1345
14582 14582 14228 14228 1345 1345
19497 19497 19282 19282 1345 1345
22100 22100 22003 22003 1345 1345
24650 24650 24527 24527 1345 1345
25459 25459 25359 25359 1345 1345
25666 25666 25567 25567 1345 1345
25820 25820 25721 25721 1345 1345
26109 26109 26005 26005 1345 1345

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