albums_artists

11 rows where artist_id = 1540

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
1721 1721 1622 1622 1540 1540
2865 2865 2698 2698 1540 1540
4087 4087 3888 3888 1540 1540
4710 4710 4494 4494 1540 1540
5381 5381 5129 5129 1540 1540
5500 5500 5244 5244 1540 1540
6711 6711 6420 6420 1540 1540
26409 26409 26303 26303 1540 1540
27177 27177 27017 27017 1540 1540
27235 27235 27074 27074 1540 1540
27598 27598 27408 27408 1540 1540

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