albums_artists

5 rows where artist_id = 6972

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
12984 12984 12641 12641 6972 6972
16447 16447 16134 16134 6972 6972
18832 18832 18588 18588 6972 6972
20367 20367 20199 20199 6972 6972
21563 21563 21447 21447 6972 6972

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