albums_artists

6 rows where artist_id = 6016

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
10656 10656 10323 10323 6016 6016
16231 16231 15910 15910 6016 6016
16668 16668 16358 16358 6016 6016
18892 18892 18649 18649 6016 6016
21960 21960 21860 21860 6016 6016
24251 24251 24142 24142 6016 6016

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