albums_artists

9 rows where artist_id = 3627

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
5200 5200 4956 4956 3627 3627
7606 7606 7298 7298 3627 3627
7607 7607 7299 7299 3627 3627
7608 7608 7300 7300 3627 3627
7609 7609 7301 7301 3627 3627
7610 7610 7302 7302 3627 3627
12449 12449 12109 12109 3627 3627
16079 16079 15753 15753 3627 3627
27476 27476 27300 27300 3627 3627

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