albums_artists

6 rows where artist_id = 604

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
624 624 600 600 604 604
3850 3850 3646 3646 604 604
5606 5606 5346 5346 604 604
7418 7418 7118 7118 604 604
8247 8247 7927 7927 604 604
27017 27017 26867 26867 604 604

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