albums_artists

6 rows where artist_id = 2654

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
3370 3370 3179 3179 2654 2654
15335 15335 14994 14994 2654 2654
18103 18103 17818 17818 2654 2654
19871 19871 19679 19679 2654 2654
20685 20685 20524 20524 2654 2654
23306 23306 23202 23202 2654 2654

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