albums_artists

15 rows where artist_id = 2060

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
2429 2429 2278 2278 2060 2060
4808 4808 4590 4590 2060 2060
5284 5284 5037 5037 2060 2060
5482 5482 5226 5226 2060 2060
6554 6554 6265 6265 2060 2060
8914 8914 8578 8578 2060 2060
9657 9657 9311 9311 2060 2060
11473 11473 11136 11136 2060 2060
12430 12430 12091 12091 2060 2060
12760 12760 12419 12419 2060 2060
13096 13096 12759 12759 2060 2060
13850 13850 13493 13493 2060 2060
15569 15569 15227 15227 2060 2060
16032 16032 15699 15699 2060 2060
27188 27188 27026 27026 2060 2060

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