albums_artists

11 rows where artist_id = 4750

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
7686 7686 7380 7380 4750 4750
10400 10400 10059 10059 4750 4750
13325 13325 12978 12978 4750 4750
13326 13326 12979 12979 4750 4750
13327 13327 12980 12980 4750 4750
13328 13328 12981 12981 4750 4750
14014 14014 13660 13660 4750 4750
15239 15239 14894 14894 4750 4750
18021 18021 17731 17731 4750 4750
18446 18446 18177 18177 4750 4750
19747 19747 19551 19551 4750 4750

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