albums_artists

12 rows where artist_id = 1014

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
1072 1072 1016 1016 1014 1014
5094 5094 4851 4851 1014 1014
7903 7903 7587 7587 1014 1014
8396 8396 8070 8070 1014 1014
14792 14792 14438 14438 1014 1014
17044 17044 16742 16742 1014 1014
18849 18849 18605 18605 1014 1014
19857 19857 19664 19664 1014 1014
22857 22857 22763 22763 1014 1014
25875 25875 25777 25777 1014 1014
26418 26418 26311 26311 1014 1014
26965 26965 26818 26818 1014 1014

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