albums_artists

7 rows where artist_id = 2095

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
2482 2482 2331 2331 2095 2095
7021 7021 6722 6722 2095 2095
10939 10939 10598 10598 2095 2095
13968 13968 13612 13612 2095 2095
14913 14913 14567 14567 2095 2095
15688 15688 15351 15351 2095 2095
27492 27492 27315 27315 2095 2095

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