albums_artists

5 rows where artist_id = 6412

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
11562 11562 11224 11224 6412 6412
14496 14496 14140 14140 6412 6412
18223 18223 17943 17943 6412 6412
20780 20780 20623 20623 6412 6412
22195 22195 22102 22102 6412 6412

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