albums_artists

6 rows where artist_id = 3006

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
3993 3993 3790 3790 3006 3006
6064 6064 5790 5790 3006 3006
7387 7387 7088 7088 3006 3006
8259 8259 7940 7940 3006 3006
9252 9252 8906 8906 3006 3006
12013 12013 11672 11672 3006 3006

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