public

Custom SQL query returning 5 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 "ZBEHAVIORALSCORE" = :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 ) limit 101

Query parameters

This data as json, CSV

rowid	uuid	date	albums	persons	ext	sha256	size	latitude	longitude	favorite	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
193	64497F20-E0C5-4705-AF2E-3138AEF78655	2018-02-20T22:17:20+00:00	[ "Ray Bandar for Niche Museums", "Ray Bandar's Bone Palace", "Public" ]	[]	heic	60ea66f88a4bb4344c83a3c7392e45c2d6136629ba7508338a135e592897714c	1609231	37.742338333333336	-122.44944666666666	0	San Francisco	CA	United States	64497F20-E0C5-4705-AF2E-3138AEF78655	0.463623046875	0.5	0.038931297721298594	0.5043308734893799	-0.000820159912109375	0.0396728515625	0.0029239654541015625	0.009999999776482582	0.62890625	-0.033843994140625	0.0357666015625	0.01233673095703125	-0.01024627685546875	0.0050201416015625	0.34765625	0.1142578125	0.01512908935546875	0.2293701171875	0.0142822265625	0.00513458251953125	0.007488250732421875	0.1796875	0.091064453125	0.263916015625	0.791015625	0.436279296875
413	73A384D3-8CE8-4B6A-9CCE-DFFA67A8138C	2018-02-20T22:16:37+00:00	[ "Ray Bandar for Niche Museums", "Ray Bandar's Bone Palace", "Public" ]	[]	heic	d0d20aaa9ea3d8f1f7a5ceee5548a5545a35a00ba7503f80168dd5f65a903783	1481901	37.74236666666667	-122.44930333333333	1	San Francisco	CA	United States	73A384D3-8CE8-4B6A-9CCE-DFFA67A8138C	0.36376953125	0.75	0.05801526718694745	0.5043308734893799	-0.0011920928955078125	0.028045654296875	0.00394439697265625	0.009999999776482582	0.51904296875	-0.039642333984375	-0.0184326171875	0.0164031982421875	-0.0162811279296875	-0.0003814697265625	0.305419921875	0.0206298828125	0.0170440673828125	0.26611328125	0.00893402099609375	0.001964569091796875	0.00948333740234375	0.09234619140625	0.0183258056640625	0.170654296875	0.6982421875	0.43212890625
359	B6387674-6F2C-43D6-9B8F-FE44DF4E2FB0	2018-02-20T22:15:33+00:00	[ "Ray Bandar for Niche Museums", "Ray Bandar's Bone Palace", "Public" ]	[]	heic	adfc1be11ff87adaae37e94af4eff631ca50324adcf3f5092ac56c3ce8c37068	1561278	37.74252833333333	-122.44922	0	San Francisco	CA	United States	B6387674-6F2C-43D6-9B8F-FE44DF4E2FB0	0.366943359375	0.5	0.038931297721298594	0.5043308734893799	-0.0006237030029296875	0.041015625	0.003749847412109375	0.009999999776482582	0.6123046875	-0.03192138671875	0.038848876953125	0.01078033447265625	-0.0090179443359375	0.00627899169921875	0.36328125	0.1629638671875	0.0187225341796875	0.275634765625	0.01690673828125	0.00243377685546875	0.008514404296875	0.1917724609375	0.09210205078125	0.259521484375	0.77099609375	0.3486328125
172	23E49325-8E53-44F6-9AD3-F54D95773B4C	2018-02-20T22:12:10+00:00	[ "Ray Bandar for Niche Museums", "Ray Bandar's Bone Palace", "Public" ]	[]	heic	578272a6bf16f512efefb8f0573daff8d85429f3406d9d966821abe9008e765f	1810771	37.74223	-122.44946333333333	0	San Francisco	CA	United States	23E49325-8E53-44F6-9AD3-F54D95773B4C	0.2890625	0.5	0.038931297721298594	0.5043308734893799	-0.0010728836059570312	0.0284576416015625	0.004962921142578125	0.009999999776482582	0.28662109375	-0.08465576171875	-0.015716552734375	0.02044677734375	-0.007232666015625	7.62939453125e-05	0.1383056640625	0.13037109375	0.0185089111328125	0.303466796875	0.01287841796875	0.0006866455078125	0.00679779052734375	0.10723876953125	0.104248046875	0.05499267578125	0.471435546875	0.2607421875
360	7C8CA810-91EB-45A1-AFAE-F331714EBA56	2018-02-20T22:05:16+00:00	[ "Ray Bandar for Niche Museums", "Ray Bandar's Bone Palace", "Public" ]	[]	heic	aeb16e4755e2eeff6289b587fe6234f3fee547cdc9e7ed07de1cee43ceb20812	969774	37.742171666666664	-122.44947833333333	0	San Francisco	CA	United States	7C8CA810-91EB-45A1-AFAE-F331714EBA56	0.548828125	0.5	0.038931297721298594	0.5043308734893799	-0.0011692047119140625	0.032867431640625	0.00269317626953125	0.009999999776482582	0.52978515625	-0.06097412109375	0.0498046875	0.01056671142578125	-0.00997161865234375	0.0048065185546875	0.163330078125	0.0828857421875	0.02630615234375	0.2283935546875	0.011505126953125	0.00072479248046875	0.005138397216796875	0.1466064453125	0.1546630859375	0.1324462890625	0.6640625	0.4560546875