albums_artists

9 rows where artist_id = 195

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
200 200 193 193 195 195
607 607 583 583 195 195
690 690 659 659 195 195
2102 2102 1973 1973 195 195
3223 3223 3040 3040 195 195
6156 6156 5877 5877 195 195
26563 26563 26451 26451 195 195
27257 27257 27094 27094 195 195
27505 27505 27325 27325 195 195

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