apple_photos_scores

1 row where ZPLEASANTCAMERATILTSCORE = "-0.055145263671875"

descending

Link	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
95	95	39333D7D-3020-4A1B-970D-44F2DD6D5C52	0.68408203125	0.5	0.0	0.04356772708528824	0.10000000149011612	-0.0016813278198242188	0.00276947021484375	0.00453948974609375	0.05999999865889549	-0.255859375	-0.09027099609375	0.2310791015625	0.004180908203125	-0.014007568359375	-0.055145263671875	-0.4873046875	-0.0653076171875	0.17822265625	-0.05279541015625	-0.005138397216796875	-0.0148162841796875	0.0026836395263671875	0.01267242431640625	0.0071868896484375	-0.35205078125	-0.310546875	-0.05792236328125

Advanced export

JSON shape: default, array, newline-delimited

CREATE TABLE apple_photos_scores(
  ZUUID TEXT,
  ZOVERALLAESTHETICSCORE REAL,
  ZCURATIONSCORE REAL,
  ZPROMOTIONSCORE REAL,
  ZHIGHLIGHTVISIBILITYSCORE REAL,
  ZBEHAVIORALSCORE REAL,
  ZFAILURESCORE REAL,
  ZHARMONIOUSCOLORSCORE REAL,
  ZIMMERSIVENESSSCORE REAL,
  ZINTERACTIONSCORE REAL,
  ZINTERESTINGSUBJECTSCORE REAL,
  ZINTRUSIVEOBJECTPRESENCESCORE REAL,
  ZLIVELYCOLORSCORE REAL,
  ZLOWLIGHT REAL,
  ZNOISESCORE REAL,
  ZPLEASANTCAMERATILTSCORE REAL,
  ZPLEASANTCOMPOSITIONSCORE REAL,
  ZPLEASANTLIGHTINGSCORE REAL,
  ZPLEASANTPATTERNSCORE REAL,
  ZPLEASANTPERSPECTIVESCORE REAL,
  ZPLEASANTPOSTPROCESSINGSCORE REAL,
  ZPLEASANTREFLECTIONSSCORE REAL,
  ZPLEASANTSYMMETRYSCORE REAL,
  ZSHARPLYFOCUSEDSUBJECTSCORE REAL,
  ZTASTEFULLYBLURREDSCORE REAL,
  ZWELLCHOSENSUBJECTSCORE REAL,
  ZWELLFRAMEDSUBJECTSCORE REAL,
  ZWELLTIMEDSHOTSCORE REAL
);
CREATE INDEX [idx_apple_photos_scores_ZUUID]
                ON [apple_photos_scores] ([ZUUID]);