albums_artists

7 rows where artist_id = 2015

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
2372 2372 2223 2223 2015 2015
3212 3212 3030 3030 2015 2015
3248 3248 3065 3065 2015 2015
6498 6498 6206 6206 2015 2015
7442 7442 7142 7142 2015 2015
7939 7939 7625 7625 2015 2015
26951 26951 26806 26806 2015 2015

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