home / pf

albums_labels

9 rows where label_id = 1513

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
4582 4582 4001 4001 Creation 1513
18858 18858 16721 16721 Creation 1513
23355 23355 20880 20880 Creation 1513
23357 23357 20882 20882 Creation 1513
24026 24026 21513 21513 Creation 1513
24027 24027 21514 21514 Creation 1513
24028 24028 21515 21515 Creation 1513
24029 24029 21516 21516 Creation 1513
24030 24030 21517 21517 Creation 1513

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