home / pf

albums_labels

43 rows where label_id = 742

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
1610 1610 1398 1398 Sanctuary 742
15078 15078 13315 13315 Sanctuary 742
19163 19163 17016 17016 Sanctuary 742
21480 21480 19151 19151 Sanctuary 742
21562 21562 19226 19226 Sanctuary 742
21698 21698 19349 19349 Sanctuary 742
22698 22698 20259 20259 Sanctuary 742
22902 22902 20448 20448 Sanctuary 742
23248 23248 20778 20778 Sanctuary 742
23379 23379 20903 20903 Sanctuary 742
23609 23609 21119 21119 Sanctuary 742
23721 23721 21220 21220 Sanctuary 742
24007 24007 21494 21494 Sanctuary 742
24253 24253 21724 21724 Sanctuary 742
24286 24286 21757 21757 Sanctuary 742
24292 24292 21762 21762 Sanctuary 742
24296 24296 21765 21765 Sanctuary 742
24558 24558 22009 22009 Sanctuary 742
24682 24682 22127 22127 Sanctuary 742
24720 24720 22161 22161 Sanctuary 742
24744 24744 22183 22183 Sanctuary 742
24879 24879 22315 22315 Sanctuary 742
24909 24909 22345 22345 Sanctuary 742
24949 24949 22385 22385 Sanctuary 742
25703 25703 23108 23108 Sanctuary 742
25949 25949 23345 23345 Sanctuary 742
26019 26019 23409 23409 Sanctuary 742
26042 26042 23432 23432 Sanctuary 742
26101 26101 23489 23489 Sanctuary 742
26145 26145 23530 23530 Sanctuary 742
26160 26160 23544 23544 Sanctuary 742
26253 26253 23633 23633 Sanctuary 742
26255 26255 23635 23635 Sanctuary 742
26289 26289 23666 23666 Sanctuary 742
26645 26645 24012 24012 Sanctuary 742
26768 26768 24129 24129 Sanctuary 742
26850 26850 24204 24204 Sanctuary 742
27172 27172 24498 24498 Sanctuary 742
27872 27872 25148 25148 Sanctuary 742
27993 27993 25262 25262 Sanctuary 742
28009 28009 25278 25278 Sanctuary 742
28037 28037 25302 25302 Sanctuary 742
28442 28442 25674 25674 Sanctuary 742

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