albums_artists

6 rows where artist_id = 6521

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
11797 11797 11456 11456 6521 6521
16422 16422 16108 16108 6521 6521
18262 18262 17983 17983 6521 6521
20699 20699 20538 20538 6521 6521
25782 25782 25683 25683 6521 6521
25920 25920 25822 25822 6521 6521

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