home / pf

albums_labels

6 rows where label_id = 4491

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
24236 24236 21707 21707 File-13 4491
25230 25230 22656 22656 File-13 4491
25802 25802 23206 23206 File-13 4491
26110 26110 23497 23497 File-13 4491
28132 28132 25386 25386 File-13 4491
28201 28201 25448 25448 File-13 4491

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