albums_artists

16 rows where artist_id = 43

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
48 48 47 47 43 43
1133 1133 1068 1068 43 43
3130 3130 2952 2952 43 43
12588 12588 12249 12249 43 43
12589 12589 12250 12250 43 43
12590 12590 12251 12251 43 43
12591 12591 12252 12252 43 43
12592 12592 12253 12253 43 43
12593 12593 12254 12254 43 43
12594 12594 12255 12255 43 43
12595 12595 12256 12256 43 43
12596 12596 12257 12257 43 43
12597 12597 12258 12258 43 43
12598 12598 12259 12259 43 43
27009 27009 26859 26859 43 43
27223 27223 27062 27062 43 43

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