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` != '1218' 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('45.542112') - RADIANS(icn_hotels.latitude), 2) + POW(RADIANS('10.204592666667') - RADIANS(icn_hotels.longitude), 2)), 3) < '30' ORDER BY `icn_hotels`.`stars` DESCArray ( [id] => 63 [fullname] => L'Albereta [slug] => lalbereta-relais [stars] => 5 [rooms] => 53 [latitude] => 45.60789800000 [longitude] => 9.98060700000 [commission] => 20 [booking_com_id] => 426045 [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] => Erbusco [categories_id] => 4 [categories_name] => Relais ) Array ( [id] => 110 [fullname] => Relais Franciacorta [slug] => relais-franciacorta [stars] => 4 [rooms] => 50 [latitude] => 45.64626500000 [longitude] => 9.99199400000 [commission] => 15 [booking_com_id] => 83631 [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] => Corte Franca [categories_id] => 4 [categories_name] => Relais ) Array ( [id] => 1204 [fullname] => Cocca Hotel Royal Thai SPA [slug] => cocca-hotel-royal-thai-spa [stars] => 4 [rooms] => 66 [latitude] => 45.67805300000 [longitude] => 9.99614100000 [commission] => 0 [booking_com_id] => 26937 [booking_com_type_thumbnail] => icastelli [booking_com_active] => 1 [publication_date] => 2010-10-13 10:04:52 [district_id] => 0 [languages_id] => 1 [city_name] => Sarnico [categories_id] => 9 [categories_name] => Resort ) Array ( [id] => 5056 [fullname] => Boutique Hotel Villa dei Campi [slug] => hotel-villa-dei-campi [stars] => 4 [rooms] => 10 [latitude] => 45.57520700000 [longitude] => 10.45558300000 [commission] => 0 [booking_com_id] => 389066 [booking_com_type_thumbnail] => booking [booking_com_active] => 1 [publication_date] => 2020-09-21 08:14:38 [district_id] => 0 [languages_id] => 0 [city_name] => Gavardo [categories_id] => 5 [categories_name] => Villa ) Array ( [id] => 3562 [fullname] => Hotel Palazzo Novello [slug] => hotel-palazzo-novello [stars] => 3 [rooms] => 18 [latitude] => 45.40473500000 [longitude] => 10.38926000000 [commission] => 15 [booking_com_id] => 289529 [booking_com_type_thumbnail] => icastelli [booking_com_active] => 1 [publication_date] => 2018-01-15 09:43:32 [district_id] => 0 [languages_id] => 1 [city_name] => Montichiari [categories_id] => 12 [categories_name] => Historical building ) Array ( [id] => 2552 [fullname] => L'Unicorno Agriturismo [slug] => lunicorno-agriturismo [stars] => 0 [rooms] => 10 [latitude] => 45.51984200000 [longitude] => 10.44091700000 [commission] => 18 [booking_com_id] => 548820 [booking_com_type_thumbnail] => icastelli [booking_com_active] => 1 [publication_date] => 2014-05-31 16:22:56 [district_id] => 0 [languages_id] => 1 [city_name] => Bedizzole [categories_id] => 10 [categories_name] => Country house ) Array ( [id] => 3841 [fullname] => Le Quattro Terre [slug] => le-quattro-terre [stars] => 0 [rooms] => 11 [latitude] => 45.61073800000 [longitude] => 10.01721600000 [commission] => 0 [booking_com_id] => 1699904 [booking_com_type_thumbnail] => booking [booking_com_active] => 1 [publication_date] => 2018-09-19 15:26:26 [district_id] => 0 [languages_id] => 0 [city_name] => Corte Franca [categories_id] => 10 [categories_name] => Country house ) Array ( [id] => 4845 [fullname] => Borgo Santa Giulia [slug] => borgo-santa-giulia [stars] => 0 [rooms] => 7 [latitude] => 45.63704800000 [longitude] => 10.01423000000 [commission] => 0 [booking_com_id] => 535687 [booking_com_type_thumbnail] => booking [booking_com_active] => 1 [publication_date] => 2020-01-13 14:00:57 [district_id] => 0 [languages_id] => 0 [city_name] => Corte Franca [categories_id] => 10 [categories_name] => Country house )