albums_artists

5 rows where artist_id = 4540

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
7188 7188 6889 6889 4540 4540
14499 14499 14143 14143 4540 4540
17505 17505 17210 17210 4540 4540
17946 17946 17654 17654 4540 4540
19061 19061 18834 18834 4540 4540

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