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` != '112' 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.340187') - RADIANS(icn_hotels.latitude), 2) + POW(RADIANS('11.673078') - RADIANS(icn_hotels.longitude), 2)), 3) < '40' ORDER BY `icn_hotels`.`stars` DESCArray ( [id] => 147 [fullname] => Castello di Spaltenna Exclusive Resort & Spa [slug] => castello-di-spaltenna [stars] => 5 [rooms] => 37 [latitude] => 43.46558200000 [longitude] => 11.42996500000 [commission] => 15 [booking_com_id] => 16586 [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] => Gaiole in Chianti [categories_id] => 3 [categories_name] => Castle ) Array ( [id] => 4340 [fullname] => Badia di Pomaio [slug] => badia-di-pomaio [stars] => 5 [rooms] => 19 [latitude] => 43.47778600000 [longitude] => 11.94680600000 [commission] => 0 [booking_com_id] => 84470 [booking_com_type_thumbnail] => booking [booking_com_active] => 1 [publication_date] => 2019-07-01 15:58:41 [district_id] => 0 [languages_id] => 0 [city_name] => Arezzo [categories_id] => 7 [categories_name] => Convent-monastery ) Array ( [id] => 3515 [fullname] => Il Borro Tuscany [slug] => il-borro-tuscany [stars] => 5 [rooms] => 40 [latitude] => 43.54148200000 [longitude] => 11.71503600000 [commission] => 18 [booking_com_id] => 80564 [booking_com_type_thumbnail] => icastelli [booking_com_active] => 1 [publication_date] => 2017-10-09 16:23:20 [district_id] => 0 [languages_id] => 1 [city_name] => San Giustino Valdarno [categories_id] => 20 [categories_name] => Historical village ) Array ( [id] => 1926 [fullname] => Grand Hotel Continental Siena - Starhotels Collezione [slug] => grand-hotel-continental [stars] => 5 [rooms] => 51 [latitude] => 43.32088800000 [longitude] => 11.33064800000 [commission] => 0 [booking_com_id] => 14895 [booking_com_type_thumbnail] => booking [booking_com_active] => 1 [publication_date] => 2013-02-05 16:04:53 [district_id] => 0 [languages_id] => 1 [city_name] => Siena [categories_id] => 12 [categories_name] => Historical building ) Array ( [id] => 1820 [fullname] => Castel Monastero [slug] => castel-monastero [stars] => 5 [rooms] => 73 [latitude] => 43.35066800000 [longitude] => 11.55997200000 [commission] => 18 [booking_com_id] => 189868 [booking_com_type_thumbnail] => icastelli [booking_com_active] => 1 [publication_date] => 2013-01-31 15:46:44 [district_id] => 0 [languages_id] => 1 [city_name] => Castelnuovo Berardenga [categories_id] => 3 [categories_name] => Castle ) Array ( [id] => 1821 [fullname] => Rosewood Castiglion del Bosco [slug] => castiglion-del-bosco [stars] => 5 [rooms] => 23 [latitude] => 43.08360500000 [longitude] => 11.42230500000 [commission] => 0 [booking_com_id] => 324180 [booking_com_type_thumbnail] => booking [booking_com_active] => 1 [publication_date] => 2013-01-31 17:13:02 [district_id] => 0 [languages_id] => 1 [city_name] => Castiglion del Bosco [categories_id] => 10 [categories_name] => Country house ) Array ( [id] => 5573 [fullname] => Borgo San Vincenzo [slug] => borgo-san-vincenzo [stars] => 4 [rooms] => 21 [latitude] => 43.10771200000 [longitude] => 11.85432900000 [commission] => 0 [booking_com_id] => 8811337 [booking_com_type_thumbnail] => booking [booking_com_active] => 1 [publication_date] => 2022-12-11 14:25:41 [district_id] => 0 [languages_id] => 0 [city_name] => Montepulciano [categories_id] => 20 [categories_name] => Historical village ) Array ( [id] => 10 [fullname] => Castello di Leonina Relais [slug] => castello-di-leonina-relais [stars] => 4 [rooms] => 21 [latitude] => 43.28796400000 [longitude] => 11.45366000000 [commission] => 15 [booking_com_id] => 80552 [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] => Asciano [categories_id] => 3 [categories_name] => Castle ) Array ( [id] => 5422 [fullname] => Chimera Tuscany Resort [slug] => chimera-tuscany-resort [stars] => 4 [rooms] => 6 [latitude] => 43.51228200000 [longitude] => 11.85374400000 [commission] => 0 [booking_com_id] => 7155677 [booking_com_type_thumbnail] => booking [booking_com_active] => 1 [publication_date] => 2022-03-03 10:55:42 [district_id] => 0 [languages_id] => 0 [city_name] => Arezzo [categories_id] => 9 [categories_name] => Resort ) Array ( [id] => 5421 [fullname] => Monastero Di Cortona Hotel & Spa [slug] => monastero-di-cortona-hotel-and-spa [stars] => 4 [rooms] => 40 [latitude] => 43.27648100000 [longitude] => 11.98699300000 [commission] => 0 [booking_com_id] => 3252322 [booking_com_type_thumbnail] => booking [booking_com_active] => 1 [publication_date] => 2022-03-03 10:48:07 [district_id] => 0 [languages_id] => 0 [city_name] => Cortona [categories_id] => 7 [categories_name] => Convent-monastery ) Array ( [id] => 5375 [fullname] => Ultimo Mulino Wellness Country Hotel [slug] => ultimo-mulino-country-hotel-gaiole [stars] => 4 [rooms] => 13 [latitude] => 43.47867500000 [longitude] => 11.39695800000 [commission] => 0 [booking_com_id] => 81050 [booking_com_type_thumbnail] => booking [booking_com_active] => 1 [publication_date] => 2021-10-15 16:09:08 [district_id] => 0 [languages_id] => 0 [city_name] => Gaiole in Chianti [categories_id] => 10 [categories_name] => Country house ) Array ( [id] => 5113 [fullname] => Villa Sassolini Luxury Boutique Hotel, The Originals Collection [slug] => villa-sassolini-luxury-boutique-hotel-the-originals-collection [stars] => 4 [rooms] => 20 [latitude] => 43.48555000000 [longitude] => 11.50954000000 [commission] => 0 [booking_com_id] => 1866926 [booking_com_type_thumbnail] => booking [booking_com_active] => 1 [publication_date] => 2020-10-08 14:53:05 [district_id] => 0 [languages_id] => 0 [city_name] => Montevarchi [categories_id] => 5 [categories_name] => Villa ) Array ( [id] => 4519 [fullname] => Laticastelli Country Relais [slug] => laticastelli-country-relais [stars] => 4 [rooms] => 21 [latitude] => 43.30759500000 [longitude] => 11.58315200000 [commission] => 18 [booking_com_id] => 14492 [booking_com_type_thumbnail] => icastelli [booking_com_active] => 1 [publication_date] => 2019-09-10 10:20:25 [district_id] => 0 [languages_id] => 1 [city_name] => Rapolano Terme [categories_id] => 10 [categories_name] => Country house ) Array ( [id] => 2935 [fullname] => Abbadia Sicille [slug] => abbadia-sicille [stars] => 4 [rooms] => 12 [latitude] => 43.16176000000 [longitude] => 11.70450000000 [commission] => 18 [booking_com_id] => 1359906 [booking_com_type_thumbnail] => icastelli [booking_com_active] => 1 [publication_date] => 2016-06-10 14:27:08 [district_id] => 0 [languages_id] => 1 [city_name] => Trequanda [categories_id] => 7 [categories_name] => Convent-monastery ) Array ( [id] => 1848 [fullname] => Hotel Certosa Di Maggiano [slug] => hotel-certosa-di-maggiano [stars] => 4 [rooms] => 17 [latitude] => 43.31037600000 [longitude] => 11.35024500000 [commission] => 0 [booking_com_id] => 86977 [booking_com_type_thumbnail] => booking [booking_com_active] => 1 [publication_date] => 2013-02-04 12:49:33 [district_id] => 0 [languages_id] => 1 [city_name] => Siena [categories_id] => 7 [categories_name] => Convent-monastery ) Array ( [id] => 13 [fullname] => Castelletto di Montebenichi [slug] => castelletto-di-montebenichi [stars] => 4 [rooms] => 9 [latitude] => 43.40556800000 [longitude] => 11.54476700000 [commission] => 10 [booking_com_id] => 251819 [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] => Bucine [categories_id] => 3 [categories_name] => Castle ) Array ( [id] => 885 [fullname] => Relais Vignale & Spa [slug] => relais-vignale [stars] => 4 [rooms] => 42 [latitude] => 43.48632500000 [longitude] => 11.37277000000 [commission] => 15 [booking_com_id] => 82958 [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] => Radda in Chianti [categories_id] => 4 [categories_name] => Relais ) Array ( [id] => 114 [fullname] => Relais Borgo Scopeto [slug] => relais-borgo-scopeto [stars] => 4 [rooms] => 58 [latitude] => 43.39275400000 [longitude] => 11.36964800000 [commission] => 15 [booking_com_id] => 17289 [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] => Castelnuovo Berardenga [categories_id] => 4 [categories_name] => Relais ) Array ( [id] => 4893 [fullname] => Rocca Di Castagnoli [slug] => rocca-di-castagnoli [stars] => 0 [rooms] => 13 [latitude] => 43.44294500000 [longitude] => 11.45176600000 [commission] => 0 [booking_com_id] => 83827 [booking_com_type_thumbnail] => booking [booking_com_active] => 1 [publication_date] => 2020-02-16 18:39:21 [district_id] => 0 [languages_id] => 0 [city_name] => Gaiole in Chianti [categories_id] => 20 [categories_name] => Historical village ) Array ( [id] => 19 [fullname] => Castello di Tornano Wine & Relais [slug] => castello-di-tornano [stars] => 0 [rooms] => 19 [latitude] => 43.42433000000 [longitude] => 11.40916700000 [commission] => 15 [booking_com_id] => 252821 [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] => Gaiole in Chianti [categories_id] => 3 [categories_name] => Castle ) Array ( [id] => 94 [fullname] => Wine Resort Villa Dievole [slug] => villa-dievole [stars] => 0 [rooms] => 27 [latitude] => 43.42004600000 [longitude] => 11.36065700000 [commission] => 12 [booking_com_id] => 13807 [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] => Castelnuovo Berardenga [categories_id] => 5 [categories_name] => Villa ) Array ( [id] => 5376 [fullname] => Brolio Agriroom [slug] => brolio-agriroom [stars] => 0 [rooms] => 4 [latitude] => 43.41556800000 [longitude] => 11.45769500000 [commission] => 0 [booking_com_id] => 6271852 [booking_com_type_thumbnail] => booking [booking_com_active] => 1 [publication_date] => 2021-10-15 16:10:17 [district_id] => 0 [languages_id] => 0 [city_name] => Gaiole in Chianti [categories_id] => 10 [categories_name] => Country house ) Array ( [id] => 5374 [fullname] => Bellavista Castello di Bossi [slug] => bellavista-castello-di-bossi [stars] => 0 [rooms] => 8 [latitude] => 43.37727300000 [longitude] => 11.45304300000 [commission] => 0 [booking_com_id] => 2421108 [booking_com_type_thumbnail] => booking [booking_com_active] => 1 [publication_date] => 2021-10-14 11:37:41 [district_id] => 0 [languages_id] => 0 [city_name] => Castelnuovo Berardenga [categories_id] => 3 [categories_name] => Castle ) Array ( [id] => 5373 [fullname] => Tenuta Cortedomina [slug] => tenuta-cortedomina [stars] => 0 [rooms] => 7 [latitude] => 43.49264300000 [longitude] => 11.37050200000 [commission] => 0 [booking_com_id] => 3681332 [booking_com_type_thumbnail] => booking [booking_com_active] => 1 [publication_date] => 2021-10-14 11:27:54 [district_id] => 0 [languages_id] => 0 [city_name] => Radda in Chianti [categories_id] => 10 [categories_name] => Country house ) Array ( [id] => 137 [fullname] => Castello di Meleto [slug] => castello-di-meleto [stars] => 0 [rooms] => 19 [latitude] => 43.45010700000 [longitude] => 11.42499300000 [commission] => 15 [booking_com_id] => 325852 [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] => Gaiole in Chianti [categories_id] => 3 [categories_name] => Castle ) Array ( [id] => 5109 [fullname] => Agriturismo San Martino Montepulciano [slug] => agriturismo-san-martino-montepulciano [stars] => 0 [rooms] => 4 [latitude] => 43.09533500000 [longitude] => 11.79682500000 [commission] => 0 [booking_com_id] => 242534 [booking_com_type_thumbnail] => booking [booking_com_active] => 1 [publication_date] => 2020-10-08 11:55:08 [district_id] => 0 [languages_id] => 0 [city_name] => Montepulciano [categories_id] => 10 [categories_name] => Country house ) Array ( [id] => 5033 [fullname] => Drogheria e Locanda Franci [slug] => drogheria-e-locanda-franci [stars] => 0 [rooms] => 3 [latitude] => 43.05673900000 [longitude] => 11.49003400000 [commission] => 0 [booking_com_id] => 1330392 [booking_com_type_thumbnail] => booking [booking_com_active] => 1 [publication_date] => 2020-09-07 18:21:34 [district_id] => 0 [languages_id] => 0 [city_name] => Montalcino [categories_id] => 12 [categories_name] => Historical building ) Array ( [id] => 5032 [fullname] => Capanna Suites [slug] => capanna-suites [stars] => 0 [rooms] => 11 [latitude] => 43.08194100000 [longitude] => 11.50007800000 [commission] => 0 [booking_com_id] => 4923349 [booking_com_type_thumbnail] => booking [booking_com_active] => 1 [publication_date] => 2020-09-07 18:18:38 [district_id] => 0 [languages_id] => 0 [city_name] => Montalcino [categories_id] => 10 [categories_name] => Country house ) Array ( [id] => 1318 [fullname] => Residenza d'Epoca Campo Regio Relais [slug] => residenza-depoca-campo-regio-relais [stars] => 0 [rooms] => 6 [latitude] => 43.32039900000 [longitude] => 11.32842800000 [commission] => 18 [booking_com_id] => 84087 [booking_com_type_thumbnail] => booking [booking_com_active] => 1 [publication_date] => 2011-12-29 09:15:40 [district_id] => 0 [languages_id] => 1 [city_name] => Siena [categories_id] => 12 [categories_name] => Historical building ) Array ( [id] => 4892 [fullname] => Badia a Coltibuono [slug] => badia-a-coltibuono [stars] => 0 [rooms] => 13 [latitude] => 43.49496600000 [longitude] => 11.44964800000 [commission] => 0 [booking_com_id] => 89654 [booking_com_type_thumbnail] => booking [booking_com_active] => 1 [publication_date] => 2020-02-16 18:38:33 [district_id] => 0 [languages_id] => 0 [city_name] => Gaiole in Chianti [categories_id] => 20 [categories_name] => Historical village ) Array ( [id] => 4841 [fullname] => Castello di Volpaia [slug] => castello-di-volpaia [stars] => 0 [rooms] => 8 [latitude] => 43.51671200000 [longitude] => 11.38097200000 [commission] => 0 [booking_com_id] => 451605 [booking_com_type_thumbnail] => booking [booking_com_active] => 1 [publication_date] => 2020-01-08 21:07:21 [district_id] => 0 [languages_id] => 0 [city_name] => Radda in Chianti [categories_id] => 3 [categories_name] => Castle ) Array ( [id] => 4755 [fullname] => Hotel Certosa di Pontignano Residenza d'Epoca [slug] => hotel-certosa-di-pontignano-residenza-depoca [stars] => 0 [rooms] => 13 [latitude] => 43.36939300000 [longitude] => 11.36012600000 [commission] => 0 [booking_com_id] => 1232110 [booking_com_type_thumbnail] => booking [booking_com_active] => 1 [publication_date] => 2019-11-30 15:37:57 [district_id] => 0 [languages_id] => 0 [city_name] => Ponte A Bozzone [categories_id] => 7 [categories_name] => Convent-monastery ) Array ( [id] => 194 [fullname] => Lucignanello Bandini [slug] => lucignanello-bandini [stars] => 0 [rooms] => 6 [latitude] => 43.12635900000 [longitude] => 11.59079100000 [commission] => 15 [booking_com_id] => 741516 [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 Giovanni d'Asso [categories_id] => 20 [categories_name] => Historical village ) Array ( [id] => 637 [fullname] => Tenuta di Lupinari [slug] => tenuta-di-lupinari [stars] => 0 [rooms] => 14 [latitude] => 43.44901900000 [longitude] => 11.59202500000 [commission] => 15 [booking_com_id] => 911797 [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] => Bucine [categories_id] => 3 [categories_name] => Castle ) Array ( [id] => 4329 [fullname] => Villa San Sanino - Tuscany [slug] => villa-san-sanino-tuscany [stars] => 0 [rooms] => 4 [latitude] => 43.15579200000 [longitude] => 11.75931900000 [commission] => 18 [booking_com_id] => 497243 [booking_com_type_thumbnail] => icastelli [booking_com_active] => 1 [publication_date] => 2019-06-18 09:30:04 [district_id] => 0 [languages_id] => 1 [city_name] => Torrita di Siena [categories_id] => 4 [categories_name] => Relais ) Array ( [id] => 1148 [fullname] => Castello delle Serre [slug] => castello-delle-serre [stars] => 0 [rooms] => 14 [latitude] => 43.25828900000 [longitude] => 11.61766100000 [commission] => 15 [booking_com_id] => 12324 [booking_com_type_thumbnail] => icastelli [booking_com_active] => 1 [publication_date] => 2010-03-08 15:23:29 [district_id] => 0 [languages_id] => 1 [city_name] => Rapolano Terme [categories_id] => 3 [categories_name] => Castle ) Array ( [id] => 2395 [fullname] => Castello di San Fabiano [slug] => castello-di-san-fabiano [stars] => 0 [rooms] => 6 [latitude] => 43.23692400000 [longitude] => 11.42429100000 [commission] => 18 [booking_com_id] => 506558 [booking_com_type_thumbnail] => icastelli [booking_com_active] => 1 [publication_date] => 2013-05-27 16:29:47 [district_id] => 0 [languages_id] => 1 [city_name] => Monteroni d'Arbia [categories_id] => 3 [categories_name] => Castle ) Array ( [id] => 1314 [fullname] => Villa Poggiano [slug] => villa-poggiano [stars] => 0 [rooms] => 14 [latitude] => 43.08774100000 [longitude] => 11.75031400000 [commission] => 18 [booking_com_id] => 45424 [booking_com_type_thumbnail] => booking [booking_com_active] => 1 [publication_date] => 2011-12-21 11:45:31 [district_id] => 0 [languages_id] => 1 [city_name] => Montepulciano [categories_id] => 5 [categories_name] => Villa )