home / pf

albums_labels

13 rows where label_id = 2241

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
8276 8276 7214 7214 Dust-to-Digital 2241
9204 9204 8049 8049 Dust-to-Digital 2241
15336 15336 13548 13548 Dust-to-Digital 2241
16387 16387 14470 14470 Dust-to-Digital 2241
18958 18958 16811 16811 Dust-to-Digital 2241
20455 20455 18219 18219 Dust-to-Digital 2241
20469 20469 18233 18233 Dust-to-Digital 2241
20571 20571 18328 18328 Dust-to-Digital 2241
21867 21867 19498 19498 Dust-to-Digital 2241
21868 21868 19499 19499 Dust-to-Digital 2241
23203 23203 20734 20734 Dust-to-Digital 2241
24678 24678 22123 22123 Dust-to-Digital 2241
25585 25585 22992 22992 Dust-to-Digital 2241

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