albums_artists

7 rows where artist_id = 3679

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
5306 5306 5057 5057 3679 3679
10499 10499 10159 10159 3679 3679
12105 12105 11766 11766 3679 3679
13244 13244 12900 12900 3679 3679
13245 13245 12901 12901 3679 3679
13270 13270 12925 12925 3679 3679
14894 14894 14546 14546 3679 3679

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