albums_artists

10 rows where artist_id = 175

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
180 180 174 174 175 175
2305 2305 2162 2162 175 175
5562 5562 5303 5303 175 175
11559 11559 11221 11221 175 175
14374 14374 14015 14015 175 175
16536 16536 16222 16222 175 175
16887 16887 16577 16577 175 175
19356 19356 19140 19140 175 175
20523 20523 20361 20361 175 175
20872 20872 20718 20718 175 175

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