albums_artists

6 rows where artist_id = 3806

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
5580 5580 5321 5321 3806 3806
10190 10190 9850 9850 3806 3806
13308 13308 12961 12961 3806 3806
15724 15724 15387 15387 3806 3806
17610 17610 17315 17315 3806 3806
19754 19754 19558 19558 3806 3806

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