albums_artists

8 rows where artist_id = 3561

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
5064 5064 4823 4823 3561 3561
8440 8440 8113 8113 3561 3561
11483 11483 11146 11146 3561 3561
12954 12954 12611 12611 3561 3561
14086 14086 13731 13731 3561 3561
16819 16819 16511 16511 3561 3561
18512 18512 18250 18250 3561 3561
19464 19464 19247 19247 3561 3561

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