albums_artists

5 rows where artist_id = 5571

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
9631 9631 9283 9283 5571 5571
13013 13013 12672 12672 5571 5571
14414 14414 14056 14056 5571 5571
16379 16379 16066 16066 5571 5571
17380 17380 17083 17083 5571 5571

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