albums_artists

13 rows where artist_id = 4058

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
6081 6081 5805 5805 4058 4058
10265 10265 9925 9925 4058 4058
10266 10266 9926 9926 4058 4058
10267 10267 9927 9927 4058 4058
10268 10268 9928 9928 4058 4058
10269 10269 9929 9929 4058 4058
10270 10270 9930 9930 4058 4058
10271 10271 9931 9931 4058 4058
10272 10272 9932 9932 4058 4058
13273 13273 12928 12928 4058 4058
16108 16108 15780 15780 4058 4058
22465 22465 22369 22369 4058 4058
26124 26124 26021 26021 4058 4058

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