albums_artists

8 rows where artist_id = 1508

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
1674 1674 1580 1580 1508 1508
1676 1676 1581 1581 1508 1508
3586 3586 3390 3390 1508 1508
3652 3652 3456 3456 1508 1508
4826 4826 4606 4606 1508 1508
4866 4866 4640 4640 1508 1508
6543 6543 6254 6254 1508 1508
27157 27157 26998 26998 1508 1508

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