albums_artists

7 rows where artist_id = 2195

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
2642 2642 2484 2484 2195 2195
3434 3434 3241 3241 2195 2195
6481 6481 6190 6190 2195 2195
20361 20361 20193 20193 2195 2195
20362 20362 20194 20194 2195 2195
20363 20363 20195 20195 2195 2195
23207 23207 23102 23102 2195 2195

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