albums_artists

5 rows where artist_id = 4668

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
7477 7477 7173 7173 4668 4668
12098 12098 11757 11757 4668 4668
14673 14673 14317 14317 4668 4668
16575 16575 16265 16265 4668 4668
17781 17781 17489 17489 4668 4668

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