albums_artists

9 rows where artist_id = 3794

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
5554 5554 5296 5296 3794 3794
12082 12082 11741 11741 3794 3794
17530 17530 17236 17236 3794 3794
22752 22752 22662 22662 3794 3794
23508 23508 23401 23401 3794 3794
23844 23844 23735 23735 3794 3794
24564 24564 24444 24444 3794 3794
25998 25998 25899 25899 3794 3794
27121 27121 26962 26962 3794 3794

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