albums_artists

8 rows where artist_id = 1220

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
1326 1326 1247 1247 1220 1220
5528 5528 5272 5272 1220 1220
6236 6236 5954 5954 1220 1220
8420 8420 8094 8094 1220 1220
8849 8849 8517 8517 1220 1220
9828 9828 9481 9481 1220 1220
10667 10667 10333 10333 1220 1220
12422 12422 12085 12085 1220 1220

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