albums_artists

6 rows where artist_id = 1667

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
1886 1886 1779 1779 1667 1667
15806 15806 15464 15464 1667 1667
17615 17615 17320 17320 1667 1667
19326 19326 19108 19108 1667 1667
20354 20354 20186 20186 1667 1667
20968 20968 20822 20822 1667 1667

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