string(1511) "SELECT `accommodations`.*, `accommodations`.`address_street_hu` as `address_street`, `accommodations`.`description_hu` as `description`, `accommodations`.`fictive_name_hu` as `fictive_name`, `accommodations`.`original_name_hu` as `original_name`, `map_cities`.`name_hu` as `address_city_name`, `map_counties`.`name_hu` as `address_county_name`, `map_countries`.`name_hu` as `address_country_name`, `map_countries`.`id` as `address_country_id`, `price_ron` as `price`, `revelion_price_type` as `price_type`, `accommodation_types`.`name_hu` as `type_name`, `accommodation_types`.`type_id`, `accommodation_types`.`name_hu` as `type_name_hu`, `accommodation_types`.`name_ro` as `type_name_ro`, `map_cities`.`name_hu` as `address_city_name_hu`, `map_cities`.`name_ro` as `address_city_name_ro`, `map_cities`.`name_en` as `address_city_name_en`, `map_counties`.`name_hu` as `address_county_name_hu`, `map_counties`.`name_ro` as `address_county_name_ro`, `map_counties`.`name_en` as `address_county_name_en`
FROM `accommodations`
JOIN `map_cities` ON `map_cities`.`id` = `accommodations`.`address_city_id`
JOIN `map_counties` ON `map_counties`.`id` = `map_cities`.`county_id`
JOIN `map_countries` ON `map_countries`.`id` = `map_counties`.`country_id`
JOIN `accommodation_types` ON `accommodation_types`.`type_id` = `accommodations`.`type_id`
WHERE `accommodations`.`status` >= 1
AND accommodations.fictive_name_hu !=''
AND `map_countries`.`id` = '2'
ORDER BY `reserved` ASC, `last_update` DESC, `accommodation_id` DESC"