albums_artists

8 rows where artist_id = 2464

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
3072 3072 2896 2896 2464 2464
8302 8302 7978 7978 2464 2464
12245 12245 11908 11908 2464 2464
13908 13908 13549 13549 2464 2464
14814 14814 14461 14461 2464 2464
14815 14815 14462 14462 2464 2464
20591 20591 20429 20429 2464 2464
20595 20595 20430 20430 2464 2464

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