albums_artists

6 rows where artist_id = 5712

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
9924 9924 9578 9578 5712 5712
12840 12840 12497 12497 5712 5712
18843 18843 18599 18599 5712 5712
19147 19147 18923 18923 5712 5712
20639 20639 20476 20476 5712 5712
22745 22745 22654 22654 5712 5712

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