albums_artists

7 rows where artist_id = 3564

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
5067 5067 4826 4826 3564 3564
7826 7826 7514 7514 3564 3564
7994 7994 7681 7681 3564 3564
10899 10899 10558 10558 3564 3564
16882 16882 16572 16572 3564 3564
22409 22409 22315 22315 3564 3564
25217 25217 25110 25110 3564 3564

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