public

Custom SQL query returning 3 rows (hide)

select rowid, photo, uuid, date, albums, persons, ext, sha256, size, latitude, longitude, favorite, portrait, screenshot, slow_mo, time_lapse, hdr, selfie, panorama, place_city, place_state_province, place_country, ZUUID, ZOVERALLAESTHETICSCORE, ZCURATIONSCORE, ZPROMOTIONSCORE, ZHIGHLIGHTVISIBILITYSCORE, ZBEHAVIORALSCORE, ZFAILURESCORE, ZHARMONIOUSCOLORSCORE, ZIMMERSIVENESSSCORE, ZINTERACTIONSCORE, ZINTERESTINGSUBJECTSCORE, ZINTRUSIVEOBJECTPRESENCESCORE, ZLIVELYCOLORSCORE, ZLOWLIGHT, ZNOISESCORE, ZPLEASANTCAMERATILTSCORE, ZPLEASANTCOMPOSITIONSCORE, ZPLEASANTLIGHTINGSCORE, ZPLEASANTPATTERNSCORE, ZPLEASANTPERSPECTIVESCORE, ZPLEASANTPOSTPROCESSINGSCORE, ZPLEASANTREFLECTIONSSCORE, ZPLEASANTSYMMETRYSCORE, ZSHARPLYFOCUSEDSUBJECTSCORE, ZTASTEFULLYBLURREDSCORE, ZWELLCHOSENSUBJECTSCORE, ZWELLFRAMEDSUBJECTSCORE, ZWELLTIMEDSHOTSCORE from photos_with_apple_metadata where "ZCURATIONSCORE" = :p0 and rowid in ( select photos_with_apple_metadata.rowid from photos_with_apple_metadata, json_each(photos_with_apple_metadata.albums) j where j.value = :p1 ) and "hdr" = :p2 limit 101

Query parameters

This data as json, CSV

rowid	uuid	date	albums	persons	ext	sha256	size	latitude	longitude	panorama	place_city	place_state_province	place_country	ZUUID	ZOVERALLAESTHETICSCORE	ZCURATIONSCORE	ZHIGHLIGHTVISIBILITYSCORE	ZBEHAVIORALSCORE	ZFAILURESCORE	ZHARMONIOUSCOLORSCORE	ZIMMERSIVENESSSCORE	ZINTERACTIONSCORE	ZINTERESTINGSUBJECTSCORE	ZINTRUSIVEOBJECTPRESENCESCORE	ZLIVELYCOLORSCORE	ZLOWLIGHT	ZNOISESCORE	ZPLEASANTCAMERATILTSCORE	ZPLEASANTCOMPOSITIONSCORE	ZPLEASANTLIGHTINGSCORE	ZPLEASANTPATTERNSCORE	ZPLEASANTPERSPECTIVESCORE	ZPLEASANTPOSTPROCESSINGSCORE	ZPLEASANTREFLECTIONSSCORE	ZPLEASANTSYMMETRYSCORE	ZSHARPLYFOCUSEDSUBJECTSCORE	ZTASTEFULLYBLURREDSCORE	ZWELLCHOSENSUBJECTSCORE	ZWELLFRAMEDSUBJECTSCORE	ZWELLTIMEDSHOTSCORE
122	9A7D9C6D-9566-4DAF-BDF6-84DE9FFAC1E1	2019-03-24T21:44:46+00:00	[ "Super bloom 2019", "Museums", "Public" ]	[]	heic	3a12affbffa3b6db27667fefeed162b43cb3e25559862509652ca7b96fea0e32	3178521	35.13239166666666	-119.44756333333333	0	Taft	CA	United States	9A7D9C6D-9566-4DAF-BDF6-84DE9FFAC1E1	0.444580078125	0.5	0.038931297721298594	0.5034549832344055	-0.0005154609680175781	0.11798095703125	0.0482177734375	0.009999999776482582	0.17236328125	-0.01495361328125	0.27392578125	0.0015306472778320312	-0.0031108856201171875	-0.007080078125	0.28662109375	0.1546630859375	0.04327392578125	0.1629638671875	0.0251922607421875	0.005100250244140625	0.007175445556640625	0.022369384765625	0.0044403076171875	0.036590576171875	0.0257415771484375	0.015777587890625
299	DD6E4630-85BD-41BF-A7B3-524C02942A65	2019-03-24T17:53:38+00:00	[ "Super bloom 2019", "Public" ]	[]	heic	8f49702a9cdd8ab729df55e30f2394524312f7f972c3e6c1615fe457b6bac72c	9765384	34.738725	-118.38710833333333	1	Lancaster	CA	United States	DD6E4630-85BD-41BF-A7B3-524C02942A65	0.61279296875	0.5	0.04201835029907809	0.503333330154419	-0.0020904541015625	0.115478515625	0.00547027587890625	0.03999999910593033	-0.006591796875	-0.040313720703125	0.2203369140625	0.0150146484375	-0.00392913818359375	0.002899169921875	0.1368408203125	0.185791015625	0.10894775390625	0.177490234375	0.031951904296875	0.001537322998046875	0.00453948974609375	0.251953125	0.67138671875	0.09588623046875	0.296142578125	0.0736083984375
205	7243AA57-2BA0-446E-8ED2-5C4709A272FE	2019-03-24T16:15:07+00:00	[ "Super bloom 2019", "Public" ]	[]	jpeg	660e3c1367cedf766f5d08651f82eefb56dfa355dc5bc62bc3191f586e30c983	8825391			0				7243AA57-2BA0-446E-8ED2-5C4709A272FE	0.669921875	0.5	0.04200850643274438	0.10000000149011612	-0.0007948875427246094	0.0256195068359375	0.0294189453125	0.009999999776482582	-0.267578125	-0.0309600830078125	0.0194091796875	0.00577545166015625	-0.007843017578125	-0.0095367431640625	0.196533203125	0.093017578125	0.054107666015625	0.225830078125	0.009765625	-0.00146484375	0.0207977294921875	0.033599853515625	0.00414276123046875	0.04400634765625	0.1923828125	0.01552581787109375