albums_artists

8 rows where artist_id = 594

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
614 614 590 590 594 594
5674 5674 5410 5410 594 594
11684 11684 11345 11345 594 594
11748 11748 11406 11406 594 594
23799 23799 23689 23689 594 594
25468 25468 25368 25368 594 594
26279 26279 26177 26177 594 594
26281 26281 26178 26178 594 594

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