albums_artists

6 rows where artist_id = 6676

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
12182 12182 11845 11845 6676 6676
14781 14781 14427 14427 6676 6676
15187 15187 14842 14842 6676 6676
17573 17573 17277 17277 6676 6676
19566 19566 19354 19354 6676 6676
27310 27310 27142 27142 6676 6676

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