albums_artists

5 rows where artist_id = 6255

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
11150 11150 10812 10812 6255 6255
12773 12773 12431 12431 6255 6255
14010 14010 13656 13656 6255 6255
14741 14741 14387 14387 6255 6255
15835 15835 15492 15492 6255 6255

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