albums_artists

12 rows where artist_id = 4222

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
6517 6517 6226 6226 4222 4222
8756 8756 8424 8424 4222 4222
9251 9251 8906 8906 4222 4222
12893 12893 12550 12550 4222 4222
13444 13444 13091 13091 4222 4222
13573 13573 13222 13222 4222 4222
13787 13787 13431 13431 4222 4222
13788 13788 13432 13432 4222 4222
14250 14250 13891 13891 4222 4222
14597 14597 14243 14243 4222 4222
15497 15497 15154 15154 4222 4222
26435 26435 26327 26327 4222 4222

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