albums_artists

10 rows where artist_id = 1095

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
1182 1182 1113 1113 1095 1095
5541 5541 5284 5284 1095 1095
6980 6980 6681 6681 1095 1095
7429 7429 7130 7130 1095 1095
7430 7430 7131 7131 1095 1095
7431 7431 7132 7132 1095 1095
7432 7432 7133 7133 1095 1095
7433 7433 7134 7134 1095 1095
18015 18015 17725 17725 1095 1095
26098 26098 25994 25994 1095 1095

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