array(9) {
  ["country_id"]=>
  string(1) "2"
  ["l"]=>
  string(2) "hu"
  ["c"]=>
  string(3) "ron"
  ["collpage"]=>
  string(12) "/szilveszter"
  ["p"]=>
  string(1) "2"
  ["city_name"]=>
  string(8) "tordatur"
  ["type_name"]=>
  string(7) "hotel3s"
  ["type_id"]=>
  string(2) "11"
  ["city_ids"]=>
  array(1) {
    [0]=>
    string(5) "15063"
  }
}
string(1606) "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`.`county_id` as `county_id`, `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'
AND `accommodations`.`type_id` IN('11')
ORDER BY `reserved` ASC, `last_update` DESC, `accommodation_id` DESC
 LIMIT 50, 50"