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` != '1639' 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.083605') - RADIANS(icn_hotels.latitude), 2) + POW(RADIANS('11.422305') - RADIANS(icn_hotels.longitude), 2)), 3) < '40' ORDER BY `icn_hotels`.`stars` DESCArray ( [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] => 148 [fullname] => La Bagnaia Golf & Spa Resort Siena - Curio, A Collection by Hilton [slug] => borgo-la-bagnaia-resort-spa [stars] => 5 [rooms] => 72 [latitude] => 43.21673300000 [longitude] => 11.29232800000 [commission] => 15 [booking_com_id] => 84018 [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] => Siena [categories_id] => 9 [categories_name] => Resort ) 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] => 1769 [fullname] => Castello Banfi - Il Borgo [slug] => castello-banfi-il-borgo [stars] => 5 [rooms] => 14 [latitude] => 42.98032000000 [longitude] => 11.39884100000 [commission] => 15 [booking_com_id] => 439626 [booking_com_type_thumbnail] => icastelli [booking_com_active] => 1 [publication_date] => 2013-01-31 19:00:00 [district_id] => 0 [languages_id] => 1 [city_name] => Montalcino [categories_id] => 3 [categories_name] => Castle ) Array ( [id] => 654 [fullname] => Castello di Velona Spa Resort & Winery [slug] => castello-di-velona-tuscan-resort-spa [stars] => 5 [rooms] => 46 [latitude] => 42.98744200000 [longitude] => 11.53385300000 [commission] => 15 [booking_com_id] => 84760 [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] => Montalcino [categories_id] => 3 [categories_name] => Castle ) 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] => 5402 [fullname] => Relais Le Macine Di Stigliano [slug] => relais-le-macine-di-stigliano [stars] => 4 [rooms] => 10 [latitude] => 43.22429200000 [longitude] => 11.22843500000 [commission] => 0 [booking_com_id] => 3116722 [booking_com_type_thumbnail] => booking [booking_com_active] => 1 [publication_date] => 2022-01-31 18:19:54 [district_id] => 0 [languages_id] => 0 [city_name] => Sovicille [categories_id] => 4 [categories_name] => Relais ) 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] => 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] => 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] => 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] => 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] => 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] => 5093 [fullname] => Convento San Bartolomeo [slug] => convento-san-bartolomeo [stars] => 0 [rooms] => 15 [latitude] => 42.85176900000 [longitude] => 11.68905700000 [commission] => 18 [booking_com_id] => 268474 [booking_com_type_thumbnail] => icastelli [booking_com_active] => 1 [publication_date] => 2020-10-06 09:09:46 [district_id] => 0 [languages_id] => 1 [city_name] => San Casciano dei Bagni [categories_id] => 7 [categories_name] => Convent-monastery ) Array ( [id] => 5034 [fullname] => Podere Brizio [slug] => podere-brizio [stars] => 0 [rooms] => 12 [latitude] => 43.01758100000 [longitude] => 11.44195500000 [commission] => 0 [booking_com_id] => 252199 [booking_com_type_thumbnail] => booking [booking_com_active] => 1 [publication_date] => 2020-09-07 18:22:29 [district_id] => 0 [languages_id] => 0 [city_name] => Montalcino [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] => 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] => 4551 [fullname] => Borgo dé Brandi [slug] => borgo-de-brandi [stars] => 0 [rooms] => 11 [latitude] => 43.38161600000 [longitude] => 11.22930400000 [commission] => 0 [booking_com_id] => 1687814 [booking_com_type_thumbnail] => booking [booking_com_active] => 1 [publication_date] => 2019-10-06 11:59:21 [district_id] => 0 [languages_id] => 0 [city_name] => Monteriggioni [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] => 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] => 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] => 2793 [fullname] => Relais La Costa [slug] => relais-la-costa- [stars] => 0 [rooms] => 7 [latitude] => 43.35367500000 [longitude] => 11.22156900000 [commission] => 18 [booking_com_id] => 494717 [booking_com_type_thumbnail] => icastelli [booking_com_active] => 1 [publication_date] => 2015-09-22 09:55:54 [district_id] => 0 [languages_id] => 1 [city_name] => Monteriggioni [categories_id] => 20 [categories_name] => Historical village ) 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] => 189 [fullname] => Castello di Vicarello [slug] => castello-di-vicarello [stars] => 0 [rooms] => 6 [latitude] => 42.88500500000 [longitude] => 11.30876200000 [commission] => 12 [booking_com_id] => 88141 [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] => Cinigiano [categories_id] => 3 [categories_name] => Castle ) 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] => 207 [fullname] => Castello di Gargonza [slug] => castello-di-gargonza [stars] => 0 [rooms] => 45 [latitude] => 43.34018700000 [longitude] => 11.67307800000 [commission] => 15 [booking_com_id] => 321987 [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] => Monte San Savino [categories_id] => 3 [categories_name] => Castle ) 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] => 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 )