<story><title>Using SQL to find my best photo of a pelican according to Apple Photos</title><url>https://simonwillison.net/2020/May/21/dogsheep-photos/</url></story><parent_chain></parent_chain><comment><author>simonw</author><text>My favourite demo is hidden pretty deep in the text - here&amp;#x27;s a SQL query that shows the machine learning labels that were applied to each photo by Apple Photos:&lt;p&gt;&lt;a href=&quot;https:&amp;#x2F;&amp;#x2F;dogsheep-photos.dogsheep.net&amp;#x2F;public?sql=select%0D%0A++photo%2C%0D%0A++%28%0D%0A++++select%0D%0A++++++json_group_array%28%0D%0A++++++++normalized_string%0D%0A++++++%29%0D%0A++++from%0D%0A++++++labels%0D%0A++++where%0D%0A++++++labels.uuid+%3D+photos_with_apple_metadata.uuid%0D%0A++%29+as+labels%2C%0D%0A++date%2C%0D%0A++albums%2C%0D%0A++persons%2C%0D%0A++ZOVERALLAESTHETICSCORE%0D%0Afrom%0D%0A++photos_with_apple_metadata%0D%0Alimit+40&quot; rel=&quot;nofollow&quot;&gt;https:&amp;#x2F;&amp;#x2F;dogsheep-photos.dogsheep.net&amp;#x2F;public?sql=select%0D%0A...&lt;/a&gt;</text></comment>
<story><title>Using SQL to find my best photo of a pelican according to Apple Photos</title><url>https://simonwillison.net/2020/May/21/dogsheep-photos/</url></story><parent_chain></parent_chain><comment><author>renewiltord</author><text>This is incredible! Thank you for sharing!&lt;p&gt;I sync my Google Photos and Apple Photos and I hope they both also run the model on things I&amp;#x27;ve uploaded from a different device. Wish the Google stuff was also queriable like this.</text></comment>