albums_artists

13 rows where artist_id = 933

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
977 977 921 921 933 933
5884 5884 5617 5617 933 933
6480 6480 6189 6189 933 933
11036 11036 10695 10695 933 933
11658 11658 11322 11322 933 933
13988 13988 13633 13633 933 933
15247 15247 14902 14902 933 933
16997 16997 16689 16689 933 933
17254 17254 16951 16951 933 933
23541 23541 23437 23437 933 933
25554 25554 25455 25455 933 933
26153 26153 26050 26050 933 933
26270 26270 26168 26168 933 933

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