albums_artists

8 rows where artist_id = 2056

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
2423 2423 2272 2272 2056 2056
3474 3474 3278 3278 2056 2056
4602 4602 4384 4384 2056 2056
5187 5187 4944 4944 2056 2056
8230 8230 7910 7910 2056 2056
10397 10397 10056 10056 2056 2056
11516 11516 11179 11179 2056 2056
27585 27585 27395 27395 2056 2056

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