albums_artists

7 rows where artist_id = 2478

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
3088 3088 2910 2910 2478 2478
9880 9880 9533 9533 2478 2478
12953 12953 12609 12609 2478 2478
16736 16736 16427 16427 2478 2478
18822 18822 18578 18578 2478 2478
19016 19016 18786 18786 2478 2478
22339 22339 22249 22249 2478 2478

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