home / pf

albums_labels

11 rows where label_id = 3456

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
16934 16934 14958 14958 Fonal 3456
16950 16950 14973 14973 Fonal 3456
18363 18363 16269 16269 Fonal 3456
18380 18380 16285 16285 Fonal 3456
19863 19863 17704 17704 Fonal 3456
19991 19991 17817 17817 Fonal 3456
20810 20810 18539 18539 Fonal 3456
20896 20896 18617 18617 Fonal 3456
22705 22705 20266 20266 Fonal 3456
23640 23640 21147 21147 Fonal 3456
24006 24006 21493 21493 Fonal 3456

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