albums_artists

10 rows where artist_id = 2685

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
3430 3430 3236 3236 2685 2685
3502 3502 3305 3305 2685 2685
6651 6651 6360 6360 2685 2685
7526 7526 7221 7221 2685 2685
8583 8583 8249 8249 2685 2685
8933 8933 8597 8597 2685 2685
9511 9511 9166 9166 2685 2685
11913 11913 11570 11570 2685 2685
12526 12526 12187 12187 2685 2685
13618 13618 13267 13267 2685 2685

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