home / pf

albums_labels

25 rows where label_id = 2245

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
8313 8313 7247 7247 Quarterstick 2245
15221 15221 13445 13445 Quarterstick 2245
18524 18524 16420 16420 Quarterstick 2245
18841 18841 16705 16705 Quarterstick 2245
19200 19200 17053 17053 Quarterstick 2245
19531 19531 17380 17380 Quarterstick 2245
20013 20013 17835 17835 Quarterstick 2245
20136 20136 17939 17939 Quarterstick 2245
20992 20992 18706 18706 Quarterstick 2245
21311 21311 18998 18998 Quarterstick 2245
21910 21910 19538 19538 Quarterstick 2245
22856 22856 20408 20408 Quarterstick 2245
24319 24319 21788 21788 Quarterstick 2245
24468 24468 21929 21929 Quarterstick 2245
25532 25532 22943 22943 Quarterstick 2245
25550 25550 22959 22959 Quarterstick 2245
25758 25758 23161 23161 Quarterstick 2245
25994 25994 23385 23385 Quarterstick 2245
26818 26818 24175 24175 Quarterstick 2245
27473 27473 24778 24778 Quarterstick 2245
28230 28230 25474 25474 Quarterstick 2245
28371 28371 25607 25607 Quarterstick 2245
28502 28502 25726 25726 Quarterstick 2245
28885 28885 26074 26074 Quarterstick 2245
29052 29052 26215 26215 Quarterstick 2245

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