home / pf

albums_artists

18 rows where artist_id = 176

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
181 181 175 175 176 176
1154 1154 1086 1086 176 176
1797 1797 1697 1697 176 176
6763 6763 6469 6469 176 176
13108 13108 12770 12770 176 176
13737 13737 13382 13382 176 176
18714 18714 18470 18470 176 176
21501 21501 21380 21380 176 176
21502 21502 21381 21381 176 176
21503 21503 21382 21382 176 176
21504 21504 21383 21383 176 176
22286 22286 22196 22196 176 176
22287 22287 22197 22197 176 176
22288 22288 22198 22198 176 176
22289 22289 22199 22199 176 176
23346 23346 23242 23242 176 176
23752 23752 23642 23642 176 176
26197 26197 26095 26095 176 176

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)
);
Powered by Datasette · Queries took 59.475ms