home / pf

albums_labels

9 rows where label_id = 3413

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
16607 16607 14664 14664 Skin Graft 3413
20464 20464 18228 18228 Skin Graft 3413
23085 23085 20622 20622 Skin Graft 3413
23188 23188 20719 20719 Skin Graft 3413
23325 23325 20852 20852 Skin Graft 3413
25425 25425 22844 22844 Skin Graft 3413
25995 25995 23386 23386 Skin Graft 3413
27520 27520 24824 24824 Skin Graft 3413
28893 28893 26080 26080 Skin Graft 3413

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