albums_artists

10 rows where artist_id = 1723

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
1960 1960 1845 1845 1723 1723
7122 7122 6823 6823 1723 1723
8627 8627 8292 8292 1723 1723
9315 9315 8969 8969 1723 1723
11417 11417 11078 11078 1723 1723
11770 11770 11430 11430 1723 1723
13274 13274 12929 12929 1723 1723
14923 14923 14577 14577 1723 1723
15379 15379 15036 15036 1723 1723
16224 16224 15903 15903 1723 1723

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