albums_artists

8 rows where artist_id = 5216

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
8814 8814 8481 8481 5216 5216
8930 8930 8594 8594 5216 5216
10076 10076 9732 9732 5216 5216
11191 11191 10853 10853 5216 5216
12553 12553 12213 12213 5216 5216
12554 12554 12214 12214 5216 5216
21577 21577 21463 21463 5216 5216
25434 25434 25334 25334 5216 5216

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