public

Custom SQL query returning 2 rows (hide)

select rowid, 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 apple_photos_scores where "ZINTERACTIONSCORE" = :p0 order by rowid limit 101

Query parameters

This data as json, CSV

rowid	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
147	52F687D4-86F5-437D-9EC5-5FB7F7EAD2B5	0.428466796875	0.75	0.0	0.058020592930207726	0.504817545413971	-0.000690460205078125	0.040313720703125	0.002216339111328125	0.10000000149011612	0.53076171875	-0.03643798828125	0.0511474609375	0.0287628173828125	-0.00885009765625	0.00891876220703125	0.3388671875	0.28759765625	0.01422882080078125	0.2119140625	0.0172882080078125	0.0030670166015625	0.0055999755859375	0.43798828125	0.417724609375	0.203857421875	0.84521484375	0.369140625
158	578C0EBB-DB86-40B7-9F4C-10156D8962CD	0.67431640625	0.75	0.0	0.061102877136405186	0.5051581263542175	-0.0007643699645996094	0.03277587890625	0.001941680908203125	0.10000000149011612	0.61767578125	-0.061431884765625	0.02618408203125	0.039703369140625	-0.008544921875	0.009307861328125	0.25048828125	0.242431640625	0.01287078857421875	0.1942138671875	0.0166015625	0.002025604248046875	0.004848480224609375	0.366943359375	0.433837890625	0.091552734375	0.8076171875	0.38623046875