albums_artists

6 rows where artist_id = 190

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
195 195 188 188 190 190
2454 2454 2303 2303 190 190
6429 6429 6137 6137 190 190
8499 8499 8167 8167 190 190
10604 10604 10267 10267 190 190
27108 27108 26951 26951 190 190

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