home / pf

albums_labels

5 rows where label_id = 4409

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
23486 23486 21000 21000 Novamute 4409
27463 27463 24769 24769 Novamute 4409
27613 27613 24909 24909 Novamute 4409
28174 28174 25424 25424 Novamute 4409
28235 28235 25479 25479 Novamute 4409

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