home / pf

albums_labels

11 rows where label_id = 442

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
763 763 646 646 Future Classic 442
4180 4180 3658 3658 Future Classic 442
4682 4682 4087 4087 Future Classic 442
4837 4837 4225 4225 Future Classic 442
5939 5939 5178 5178 Future Classic 442
6157 6157 5355 5355 Future Classic 442
7903 7903 6879 6879 Future Classic 442
9016 9016 7875 7875 Future Classic 442
12019 12019 10520 10520 Future Classic 442
12468 12468 10938 10938 Future Classic 442
13555 13555 11936 11936 Future Classic 442

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 55.242ms