home / pf

albums_labels

14 rows where label_id = 1503

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
4529 4529 3953 3953 Emperor Jones 1503
21677 21677 19329 19329 Emperor Jones 1503
25652 25652 23058 23058 Emperor Jones 1503
25820 25820 23224 23224 Emperor Jones 1503
26646 26646 24013 24013 Emperor Jones 1503
26685 26685 24049 24049 Emperor Jones 1503
26779 26779 24140 24140 Emperor Jones 1503
26780 26780 24141 24141 Emperor Jones 1503
27208 27208 24530 24530 Emperor Jones 1503
27364 27364 24676 24676 Emperor Jones 1503
27641 27641 24937 24937 Emperor Jones 1503
27695 27695 24986 24986 Emperor Jones 1503
27780 27780 25064 25064 Emperor Jones 1503
28304 28304 25544 25544 Emperor Jones 1503

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE albums_labels (
	album_id integer NOT NULL,
	label_id integer NOT NULL,
	FOREIGN KEY(album_id) REFERENCES albums(id),
	FOREIGN KEY(label_id) REFERENCES labels(id),
	UNIQUE(album_id,label_id)
);
Powered by Datasette · Queries took 67.596ms