home / pf

albums_labels

5 rows where label_id = 3255

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
15429 15429 13632 13632 Service 3255
15479 15479 13676 13676 Service 3255
17953 17953 15882 15882 Service 3255
19510 19510 17360 17360 Service 3255
20956 20956 18671 18671 Service 3255

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