albums_artists

8 rows where artist_id = 3512

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
4929 4929 4696 4696 3512 3512
9264 9264 8918 8918 3512 3512
10693 10693 10358 10358 3512 3512
14977 14977 14627 14627 3512 3512
15282 15282 14937 14937 3512 3512
15606 15606 15268 15268 3512 3512
19803 19803 19608 19608 3512 3512
21210 21210 21084 21084 3512 3512

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