albums_artists

7 rows where artist_id = 5010

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
8342 8342 8019 8019 5010 5010
17265 17265 16962 16962 5010 5010
19041 19041 18813 18813 5010 5010
19518 19518 19305 19305 5010 5010
22023 22023 21923 21923 5010 5010
22921 22921 22824 22824 5010 5010
24768 24768 24652 24652 5010 5010

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