albums_artists

17 rows where artist_id = 123

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
128 128 124 124 123 123
2317 2317 2173 2173 123 123
4080 4080 3881 3881 123 123
11868 11868 11526 11526 123 123
13176 13176 12836 12836 123 123
13836 13836 13478 13478 123 123
17949 17949 17657 17657 123 123
18686 18686 18439 18439 123 123
20172 20172 19995 19995 123 123
21287 21287 21162 21162 123 123
22221 22221 22130 22130 123 123
23106 23106 23005 23005 123 123
23947 23947 23833 23833 123 123
24235 24235 24125 24125 123 123
26030 26030 25931 25931 123 123
26324 26324 26219 26219 123 123
26902 26902 26759 26759 123 123

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