albums_artists

9 rows where artist_id = 105

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
110 110 108 108 105 105
6800 6800 6502 6502 105 105
12069 12069 11728 11728 105 105
16324 16324 16010 16010 105 105
16825 16825 16516 16516 105 105
16855 16855 16546 16546 105 105
20417 20417 20251 20251 105 105
21852 21852 21748 21748 105 105
22895 22895 22801 22801 105 105

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