home / pf

albums_labels

6 rows where label_id = 397

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
663 663 557 557 Night Time Stories Ltd. 397
3090 3090 2702 2702 Night Time Stories Ltd. 397
3637 3637 3171 3171 Night Time Stories Ltd. 397
4398 4398 3838 3838 Night Time Stories Ltd. 397
6535 6535 5687 5687 Night Time Stories Ltd. 397
7232 7232 6294 6294 Night Time Stories Ltd. 397

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