albums_artists

5 rows where artist_id = 1083

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
1158 1158 1089 1089 1083 1083
2162 2162 2028 2028 1083 1083
5145 5145 4901 4901 1083 1083
5453 5453 5196 5196 1083 1083
21128 21128 20996 20996 1083 1083

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