home / pf

albums_labels

8 rows where label_id = 2488

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
9800 9800 8574 8574 ReR 2488
22559 22559 20133 20133 ReR 2488
24015 24015 21502 21502 ReR 2488
24312 24312 21781 21781 ReR 2488
24858 24858 22294 22294 ReR 2488
25066 25066 22502 22502 ReR 2488
25781 25781 23185 23185 ReR 2488
28091 28091 25350 25350 ReR 2488

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.755ms