albums_artists

15 rows where artist_id = 2552

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
3195 3195 3015 3015 2552 2552
4205 4205 4003 4003 2552 2552
6176 6176 5897 5897 2552 2552
10535 10535 10197 10197 2552 2552
10661 10661 10328 10328 2552 2552
11052 11052 10711 10711 2552 2552
12099 12099 11759 11759 2552 2552
13418 13418 13067 13067 2552 2552
15158 15158 14812 14812 2552 2552
16277 16277 15961 15961 2552 2552
17240 17240 16937 16937 2552 2552
18449 18449 18180 18180 2552 2552
20612 20612 20448 20448 2552 2552
21861 21861 21757 21757 2552 2552
22889 22889 22795 22795 2552 2552

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