albums_artists

5 rows where artist_id = 6643

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
12100 12100 11760 11760 6643 6643
14709 14709 14354 14354 6643 6643
16871 16871 16561 16561 6643 6643
18909 18909 18668 18668 6643 6643
21762 21762 21654 21654 6643 6643

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