albums_artists

9 rows where artist_id = 411

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
420 420 402 402 411 411
4598 4598 4380 4380 411 411
6029 6029 5756 5756 411 411
9178 9178 8835 8835 411 411
10005 10005 9660 9660 411 411
14588 14588 14234 14234 411 411
19473 19473 19257 19257 411 411
22445 22445 22349 22349 411 411
27066 27066 26912 26912 411 411

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