SELECT `icn_hotels`.`id` AS `id`, `icn_hotels`.`fullname` AS `fullname`, `icn_hotels`.`slug` AS `slug`, `icn_hotels`.`stars` AS `stars`, `icn_hotels`.`rooms` AS `rooms`, `icn_hotels`.`latitude` AS `latitude`, `icn_hotels`.`longitude` AS `longitude`, `icn_hotels`.`commission` AS `commission`, `icn_hotels`.`booking_com_id` AS `booking_com_id`, `icn_hotels`.`booking_com_type_thumbnail` AS `booking_com_type_thumbnail`, `icn_hotels`.`booking_com_active` AS `booking_com_active`, `icn_hotels`.`publication_date` AS `publication_date`, `icn_hotels`.`district_id` AS `district_id`, `icn_hotels`.`languages_id` AS `languages_id`, `icn_city_translate`.`fullname` AS `city_name`, `icn_categories_translate`.`categories_id` AS `categories_id`, `icn_categories_translate`.`fullname` AS `categories_name` FROM `icn_hotels` LEFT JOIN `icn_city_translate` ON `icn_city_translate`.`city_id` = `icn_hotels`.`city_id` LEFT JOIN `icn_categories_translate` ON `icn_categories_translate`.`categories_id` = `icn_hotels`.`categories_id` WHERE `icn_hotels`.`active` = '1' AND `icn_hotels`.`show_booking` = '1' AND `icn_hotels`.`city_id` != '79' AND `icn_hotels`.`booking_com_active` = '1' AND `icn_city_translate`.`languages_id` = '2' AND `icn_categories_translate`.`languages_id` = '2' AND TRUNCATE (6363 * sqrt(POW( RADIANS('43.674875') - RADIANS(icn_hotels.latitude), 2) + POW(RADIANS('11.253235') - RADIANS(icn_hotels.longitude), 2)), 3) < '10' ORDER BY `icn_hotels`.`stars` DESCArray ( [id] => 1179 [fullname] => Villa I Barronci Resort & Spa [slug] => villa-i-barronci [stars] => 4 [rooms] => 21 [latitude] => 43.66178700000 [longitude] => 11.16805600000 [commission] => 15 [booking_com_id] => 84234 [booking_com_type_thumbnail] => icastelli [booking_com_active] => 1 [publication_date] => 2010-06-07 09:35:44 [district_id] => 0 [languages_id] => 1 [city_name] => San Casciano in Val di Pesa [categories_id] => 5 [categories_name] => Villa ) Array ( [id] => 140 [fullname] => Castello di Bibbione [slug] => castello-di-bibbione [stars] => 0 [rooms] => 13 [latitude] => 43.63246100000 [longitude] => 11.18893400000 [commission] => 15 [booking_com_id] => 355682 [booking_com_type_thumbnail] => icastelli [booking_com_active] => 1 [publication_date] => 0000-00-00 00:00:00 [district_id] => 0 [languages_id] => 1 [city_name] => San Casciano in Val di Pesa [categories_id] => 3 [categories_name] => Castle ) Array ( [id] => 865 [fullname] => Villa Il Poggiale [slug] => villa-il-poggiale [stars] => 0 [rooms] => 24 [latitude] => 43.66586300000 [longitude] => 11.16439700000 [commission] => 12 [booking_com_id] => 85583 [booking_com_type_thumbnail] => booking [booking_com_active] => 1 [publication_date] => 0000-00-00 00:00:00 [district_id] => 0 [languages_id] => 1 [city_name] => San Casciano in Val di Pesa [categories_id] => 5 [categories_name] => Villa ) Array ( [id] => 980 [fullname] => Castello di Gabbiano [slug] => castello-di-gabbiano [stars] => 0 [rooms] => 16 [latitude] => 43.62823800000 [longitude] => 11.26058100000 [commission] => 15 [booking_com_id] => 370495 [booking_com_type_thumbnail] => icastelli [booking_com_active] => 1 [publication_date] => 0000-00-00 00:00:00 [district_id] => 0 [languages_id] => 1 [city_name] => San Casciano in Val di Pesa [categories_id] => 3 [categories_name] => Castle ) Array ( [id] => 1754 [fullname] => Salvadonica Borgo del Chianti [slug] => salvadonica-borgo-del-chianti [stars] => 0 [rooms] => 19 [latitude] => 43.63609500000 [longitude] => 11.21897000000 [commission] => 15 [booking_com_id] => 314750 [booking_com_type_thumbnail] => icastelli [booking_com_active] => 1 [publication_date] => 2013-01-16 09:39:51 [district_id] => 0 [languages_id] => 1 [city_name] => San Casciano in Val di Pesa [categories_id] => 10 [categories_name] => Country house ) Array ( [id] => 5111 [fullname] => Villa Il Sasso - Dimora d'Epoca [slug] => villa-il-sasso-dimora-depoca [stars] => 0 [rooms] => 7 [latitude] => 43.72968000000 [longitude] => 11.29857700000 [commission] => 0 [booking_com_id] => 16759 [booking_com_type_thumbnail] => booking [booking_com_active] => 1 [publication_date] => 2020-10-08 11:57:19 [district_id] => 0 [languages_id] => 0 [city_name] => Bagno a Ripoli [categories_id] => 5 [categories_name] => Villa )