albums_artists

8 rows where artist_id = 508

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
521 521 500 500 508 508
5050 5050 4811 4811 508 508
9119 9119 8776 8776 508 508
13134 13134 12795 12795 508 508
16990 16990 16682 16682 508 508
19114 19114 18890 18890 508 508
21139 21139 21009 21009 508 508
23596 23596 23493 23493 508 508

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