albums_artists

11 rows where artist_id = 21

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
26 26 26 26 21 21
4098 4098 3899 3899 21 21
6182 6182 5903 5903 21 21
6946 6946 6648 6648 21 21
10603 10603 10266 10266 21 21
17764 17764 17471 17471 21 21
18232 18232 17953 17953 21 21
19443 19443 19227 19227 21 21
19879 19879 19689 19689 21 21
21464 21464 21345 21345 21 21
22301 22301 22212 22212 21 21

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