Photo Overall Aesthetic Score content_string
0.97412109375 Trip, Entertainment, Travel, Photos, Water, Underwater, Animal, Jellyfish, Spring, May, 2015, P5221405.JPG
0.91162109375 Thanksgiving, Celebration, Holiday, Photos, Food, Fruit, Apple, Fall, November, 2013, IMG_2139.JPG
0.900390625 Photos, Outdoor, Spring, April, 2015, P4161171.JPG
0.8974609375 Beach Activity, Travel, Activity, Trip, , Live Photos, Blue Sky, Adult, People, Sky, Cloudy, Outdoor, Land, Beach, Water, Water Body, Ocean, Spring, March, 2020, IMG_0358.HEIC, Bahamas, Little San Salvador
0.88134765625 Beach Activity, Travel, Activity, Trip, , Live Photos, Ocean, Cloudy, Beach, Sky, Blue Sky, Land, Outdoor, Water, Water Body, Spring, March, 2020, IMG_0356.HEIC, Bahamas, Little San Salvador
0.8759765625 Trip, Travel, Photos, Blue Sky, Rocks, Ocean, Sky, Water, Water Body, Outdoor, Land, Winter, December, 2019, IMG_0417.HEIC, Cyprus, Paphos, B6
0.86572265625 Veterans Day, Photos, Christmas Decoration, Celebration, Sky, Night Sky, Christmas Tree, Outdoor, Plant, Tree, Fall, November, 2012, Flagged, PB113197.JPG
0.86328125 Trip, Travel, Photos, Water Body, Lake, Water, Frozen, Snow, Land, Mountain, Outdoor, Sky, Blue Sky, Summer, July, 2017, DSC05838.JPG
0.86181640625 Trip, Travel, Photos, Land, Cliff, Outdoor, Summer, August, 2020, IMG_0876.HEIC, United States, Idaho, Twin Falls, Neilsen Point Pl
0.8564453125 Beach Activity, Travel, Activity, Trip, , Live Photos, Ocean, Blue Sky, Outdoor, Sky, Cloudy, Water Body, Water, Spring, March, 2020, IMG_0350.HEIC, Bahamas, Little San Salvador
0.8564453125 Activity, Winter Sport, , Live Photos, Plant, Evergreen, Outdoor, Water, Frozen, Snow, Winter, December, 2017, IMG_1839.JPG, United States, Washington, The Mount Baker-Snoqualmie National Forest, Kittitas, Cle Elum
0.8564453125 Trip, Travel, Photos, Blue Sky, Rocks, Ocean, Outdoor, Sky, Water, Water Body, Winter, December, 2019, IMG_0416.HEIC, Cyprus, Paphos, B6
0.85302734375 Activity, Winter Sport, , Live Photos, Snow, Outdoor, Plant, Evergreen, Water, Frozen, Winter, December, 2017, IMG_1835.JPG, United States, Washington, The Mount Baker-Snoqualmie National Forest, Kittitas, Cle Elum
0.85205078125 Trip, Travel, Hotels & Events, Hotels & Travel, Oceanfront Lodge, , Live Photos, Water Body, Ocean, Sunset Sunrise, Water, Land, Beach, Outdoor, Sky, Winter, December, 2020, IMG_1533.HEIC, United States, California, Del Norte, Crescent City, Front St
0.8447265625 Trip, Travel, Photos, Cloudy, Water Body, Waterways, River, Water, Land, Outdoor, Sky, Summer, August, 2020, IMG_0873.HEIC, United States, Idaho, Twin Falls, Neilsen Point Pl
0.84423828125 Travel, Activity, Trip, Hiking, , Live Photos, Snow, Cloudy, Mountain, Frozen, Water, Blue Sky, Sky, Outdoor, Land, Summer, June, 2019, IMG_1394.HEIC, United States, Wyoming, Bridger-Teton National Forest, Teton, Teton Village, Rendevous Mountain Trail, Jackson Hole Mountain Resort
0.84423828125 Trip, Travel, Photos, Land, Cliff, Water, Water Body, Ocean, Rocks, Outdoor, Sky, Spring, April, 2016, DSC01806.JPG
0.84375 Trip, Travel, Photos, Plant, Evergreen, Blue Sky, Land, Mountain, Water, Water Body, Lake, Outdoor, Sky, Summer, July, 2017, 4ED3AC06-BF5E-4047-8EA0-843BC9E58A36.JPG
0.84326171875 Photos, Cityscape, Sunset Sunrise, Building, Sky, Outdoor, Summer, August, 2016, IMG_2539.JPG, United States, Washington, King, Downtown, Seattle, 2nd Ave
0.84326171875 Travel, Activity, Trip, Hiking, , Live Photos, Snow, Cloudy, Frozen, Land, Mountain, Water, Outdoor, Sky, Blue Sky, Summer, June, 2019, IMG_1393.HEIC, United States, Wyoming, Bridger-Teton National Forest, Teton, Teton Village, Cody Ln, Jackson Hole Mountain Resort
0.8408203125 Photos, Orchid, Flower, Plant, Winter, February, 2016, DSC00840.JPG
0.8408203125 Trip, Travel, Photos, Blue Sky, Frozen, Snow, Sky, Outdoor, Land, Mountain, Water, Water Body, Lake, Summer, July, 2017, DSC05836.JPG
0.84033203125 Beach Activity, Travel, Activity, Trip, Photos, Sky, Cloudy, Outdoor, Ocean, Water, Water Body, Winter, December, 2016, 7ED7AE41-524F-43B3-A8BE-CD7E4DF4F570.JPG
0.83935546875 Photos, Cloudy, Plant, Shrub, Outdoor, Sky, Winter, February, 2016, DSC00850.JPG
0.83740234375 Trip, Travel, Photos, Mountain, Land, Outdoor, Sky, Blue Sky, Lake, Water Body, Snow, Frozen, Water, Summer, July, 2017, DSC05837.JPG
0.83642578125 Trip, Travel, Photos, Cloudy, Rocks, Outdoor, Sky, Summer, August, 2017, IMG_1189.JPG, North Pacific Ocean, United States, Oregon, Clatsop
0.8330078125 Trip, Travel, Photos, Blue Sky, Cliff, Sky, Water, Water Body, Ocean, Outdoor, Land, Winter, December, 2019, IMG_0400.HEIC, Cyprus, Paphos, B6
0.8330078125 Trip, Travel, Photos, Cloudy, Sky, Water Body, Land, Cliff, Outdoor, Water, Rocks, Summer, July, 2017, DSC05772.JPG
0.8310546875 Trip, Travel, Photos, Blue Sky, Plant, Evergreen, Sky, Water, Water Body, Lake, Outdoor, Land, Mountain, Summer, July, 2017, DSC05744.JPG
0.83056640625 Trip, Travel, Photos, Cliff, Waterways, Water, Water Body, Outdoor, Land, Summer, August, 2020, IMG_0877.HEIC, United States, Idaho, Twin Falls, Neilsen Point Pl
0.83056640625 Trip, Travel, Photos, Ocean, Water, Water Body, Sky, Outdoor, Land, Hill, Rocks, Fall, September, 2014, P9050317.JPG
0.8291015625 Trip, Travel, Favorites, Portrait, Photos, Clothing, Water Body, Ocean, Sky, Optical Equipment, Sunglasses, Water, Adult, Outdoor, Land, Beach, People, Winter, December, 2020, IMG_1496.HEIC, North Pacific Ocean, United States, California, Humboldt, Redwood National and State Parks
0.82763671875 Trip, Travel, Hotels & Events, Hotels & Travel, Oceanfront Lodge, , Live Photos, Water Body, Ocean, Water, Sky, Sunset Sunrise, Outdoor, Land, Beach, Winter, December, 2020, IMG_1534.HEIC, United States, California, Del Norte, Crescent City, Front St
0.8271484375 Photos, Sky, Blue Sky, Outdoor, Land, Mountain, Water, Frozen, Snow, Summer, June, 2008, IMG_0549.JPG
0.826171875 Photos, Foliage, Plant, Flower, Rose, Fall, September, 2015, DSC00130.JPG
0.826171875 Favorites, Photos, Building, Machine, Vehicle, Watercraft, Outdoor, Sky, Sunset Sunrise, Water, Water Body, Summer, July, 2017, IMG_1075.JPG, United States, Washington, King, Downtown, Seattle, 2nd Ave
0.8251953125 Trip, Travel, Photos, Interior Room, Spring, April, 2016, IMG_1948.JPG
0.82421875 Photos, Water Body, Building, Sunset Sunrise, Outdoor, Sky, Apartment, Water, Summer, August, 2016, IMG_2540.JPG, United States, Washington, King, Downtown, Seattle, 2nd Ave
0.82275390625 Veterans Day, Photos, Night Sky, Outdoor, Sky, Fall, November, 2012, PB113219.JPG
0.82177734375 Trip, Travel, Photos, Sequoia, Land, Road, Tree, Outdoor, Plant, Vegetation, Forest, Winter, December, 2020, IMG_1456.HEIC, United States, California, Humboldt, Hoopa, Newton B Drury Scenic Pkwy, Prairie Creek Redwoods State Park, Redwood National and State Parks
0.8212890625 Travel, Activity, Trip, Hiking, , Live Photos, Water, Frozen, Snow, Blue Sky, Sky, Mountain, Outdoor, Land, Summer, June, 2019, IMG_1392.HEIC, United States, Wyoming, Bridger-Teton National Forest, Teton, Teton Village, Cody Ln, Jackson Hole Mountain Resort
0.8212890625 Trip, Travel, Photos, Outdoor, Moss, Rocks, Plant, Summer, August, 2017, IMG_1193.JPG, North Pacific Ocean, United States, Oregon, Clatsop
0.81982421875 Trip, Travel, Photos, Cloudy, Water Body, Ocean, Land, Cliff, Outdoor, Sky, Blue Sky, Water, Spring, April, 2016, DSC01796.JPG
0.8193359375 Trip, Travel, Photos, Land, Mountain, Sky, Blue Sky, Outdoor, Summer, July, 2017, 32A292D1-2623-46CC-B0F2-DB5F106CBADF.JPG
0.81689453125 Trip, Travel, Photos, Rocks, Water Body, Cloudy, Frozen, Water, Blue Sky, Land, Mountain, Outdoor, Sky, Summer, July, 2017, DSC05771.JPG
0.81689453125 Trip, Travel, Photos, Cloudy, Frozen, Snow, Sky, Water, Outdoor, Land, Mountain, Summer, July, 2017, D8DC3CB2-16AB-48E3-9868-213CC6BAA855.JPG
0.81640625 Trip, Travel, Photos, River, Water Body, Waterways, Land, Water, Outdoor, Sky, Cloudy, Summer, August, 2020, IMG_0874.HEIC, United States, Idaho, Twin Falls, Neilsen Point Pl
0.8154296875 Photos, Sky, Sunset Sunrise, Skyscraper, Outdoor, Building, Cityscape, Summer, June, 2016, IMG_2305.JPG, United States, Washington, King, Downtown, Seattle, 2nd Ave
0.81494140625 Trip, Travel, Photos, Blue Sky, Plant, Water, Water Body, Ocean, Sky, Cloudy, Outdoor, Land, Cliff, Winter, December, 2019, IMG_0404.HEIC, Cyprus, Paphos, B6
0.81396484375 Travel, Activity, Trip, Hiking, , Live Photos, Cloudy, Land, Mountain, Outdoor, Sky, Blue Sky, Water, Frozen, Snow, Summer, June, 2019, IMG_1391.HEIC, United States, Wyoming, Bridger-Teton National Forest, Teton, Teton Village, Cody Ln, Jackson Hole Mountain Resort
0.81396484375 Trip, Travel, Photos, Lake, Land, Mountain, Water Body, Snow, Water, Frozen, Outdoor, Sky, Blue Sky, Summer, July, 2017, DSC05835.JPG
0.8134765625 Activity, Winter Sport, Photos, Evergreen, Snow, Frozen, Plant, Water, Winter, December, 2017, IMG_1851.JPG, United States, Washington, The Mount Baker-Snoqualmie National Forest, Kittitas, Cle Elum
0.8134765625 Trip, Travel, Photos, Foliage, Plant, Flower, Spring, April, 2017, DSC04773.JPG
0.81298828125 Trip, Travel, Photos, Blue Sky, Water Body, Sky, Outdoor, Land, Mountain, Water, Frozen, Snow, Summer, July, 2017, CFA38835-9760-4263-9D88-3FB0DCC9C72A.JPG
0.8125 Photos, Hill, Water Body, Bridge, Cloudy, Sky, Water, Outdoor, Land, Summer, August, 2018, IMG_0585.JPG, Lake Bonneville, United States, Oregon, Hood River, Cascade Locks
0.8125 Trip, Travel, Photos, Blue Sky, Ocean, Water, Water Body, Outdoor, Sky, Rocks, Fall, November, 2017, DSC06599.JPG
0.8125 Photos, Winter, February, 2016, DSC00861.JPG
0.81201171875 Photos, Rocks, Cloudy, Water, Frozen, Snow, Land, Mountain, Outdoor, Sky, Spring, March, 2003, 66_4.jpg
0.81201171875 Photos, Snow, Water, Frozen, Rocks, Land, Mountain, Outdoor, Sky, Cloudy, Spring, March, 2003, 66_4.jpg
0.810546875 Photos, Water Body, Sky, Cloudy, Bridge, Water, Outdoor, Land, Hill, Summer, August, 2018, IMG_0571.JPG, Lake Bonneville, United States, Oregon, Hood River, Cascade Locks
0.810546875 Travel, Activity, Trip, Hiking, , Live Photos, Land, Mountain, Cloudy, Outdoor, Sky, Blue Sky, Water, Frozen, Snow, Summer, June, 2019, IMG_1402.HEIC, United States, Wyoming, Bridger-Teton National Forest, Teton, Teton Village, Rendevous Mountain Trail, Jackson Hole Mountain Resort
0.810546875 Photos, Skyscraper, Sky, Night Sky, Outdoor, Building, Cityscape, Spring, May, 2016, DSC02332.JPG
0.81005859375 Trip, Travel, Photos, Lake, Cloudy, Water Body, Rocks, Water, Sky, Outdoor, Land, Island, Summer, August, 2017, IMG_1261.JPG, North Pacific Ocean, United States, Oregon, Clatsop
0.81005859375 Travel, Activity, Trip, Hiking, , Live Photos, Cloudy, Sky, Lake, Water, Water Body, Outdoor, Land, Hill, Summer, July, 2020, IMG_0488.HEIC, Lake Chelan, United States, Washington, Okanogan-Wenatchee National Forest, Chelan
0.80810546875 Trip, Travel, Photos, Ocean, Blue Sky, Cliff, Water, Water Body, Land, Outdoor, Sky, Cloudy, Plant, Winter, December, 2019, IMG_0403.HEIC, Cyprus, Paphos, B6
0.8076171875 Photos, Cloudy, Outdoor, Sky, Sunset Sunrise, Water, Water Body, Summer, August, 2016, IMG_2538.JPG, United States, Washington, King, Downtown, Seattle, 2nd Ave
0.80712890625 Trip, Travel, Photos, Interior Room, Spring, April, 2016, DSC01118.JPG
0.80712890625 Photos, Sky, Haze, Skyscraper, Outdoor, Building, Cityscape, Summer, August, 2018, IMG_0607.JPG, United States, Washington, King, Bellevue, City Center, Downtown, NE 4th St
0.806640625 Photos, Rocks, Waterfall, Outdoor, Land, Water, Water Body, Waterways, Summer, August, 2007, IMG_0662_2.JPG
0.806640625 Trip, Travel, Photos, Water Body, Water, Outdoor, Sky, Blue Sky, Plant, Tree, Summer, July, 2017, B957C626-0EE1-41B8-8A46-0B077D8D76C2.JPG
0.80615234375 Trip, Travel, Photos, Cloudy, Frozen, Snow, Sky, Water, Outdoor, Land, Mountain, Summer, July, 2017, DSC05867.JPG
0.80615234375 Trip, Travel, Photos, Blue Sky, Sky, Plant, Evergreen, Mountain, Outdoor, Land, Summer, July, 2017, 6C6C82BE-3E45-48A0-AC52-3BEB802387D2.JPG
0.8056640625 Trip, Travel, Photos, Blue Sky, Cloudy, Sky, Bridge, Outdoor, Summer, August, 2020, IMG_0884.HEIC, United States, Idaho, Twin Falls, Neilsen Point Pl
0.8056640625 Trip, Travel, Photos, Canyon, Blue Sky, Land, Water, Water Body, Waterways, River, Outdoor, Sky, Cloudy, Summer, August, 2020, IMG_0878.HEIC, United States, Idaho, Twin Falls, Neilsen Point Pl
0.80517578125 Trip, Travel, Photos, Outdoor, Land, Summer, August, 2020, IMG_0885.HEIC, United States, Idaho, Twin Falls, Neilsen Point Pl
0.80517578125 Trip, Travel, Photos, Water, Water Body, Outdoor, Sky, Cloudy, Summer, July, 2017, DSC05776.JPG 

select path, ZOVERALLAESTHETICSCORE,
                group_concat(distinct content_string)
from apple_photos_scores
join apple_photos on apple_photos_scores.zuuid = apple_photos.uuid
    left join labels l on apple_photos.uuid = l.uuid
group by 1, 2
order by ZOVERALLAESTHETICSCORE desc limit 100