array(6) {
  ["collection"]=>
  string(10) "full_year_"
  ["country_id"]=>
  string(1) "2"
  ["l"]=>
  string(2) "hu"
  ["c"]=>
  string(3) "ron"
  ["collpage"]=>
  string(0) ""
  ["city_or_type_name"]=>
  string(9) "jaszvasar"
}
string(1526) "SELECT `accommodations`.*, `accommodations`.`address_street_hu` as `address_street`, `accommodations`.`description_hu` as `description`, `accommodations`.`full_year_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`, `full_year_price_ron` as `price`, `full_year_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.full_year_fictive_name_hu !=''
AND `map_countries`.`id` = '2'
ORDER BY `last_update` DESC, `accommodation_id` DESC"