albums_artists

7 rows where artist_id = 5480

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
9441 9441 9094 9094 5480 5480
14066 14066 13712 13712 5480 5480
18080 18080 17794 17794 5480 5480
20654 20654 20491 20491 5480 5480
23614 23614 23511 23511 5480 5480
25285 25285 25182 25182 5480 5480
26131 26131 26028 26028 5480 5480

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