array(11) {
  ["country_id"]=>
  string(1) "2"
  ["l"]=>
  string(2) "hu"
  ["c"]=>
  string(3) "ron"
  ["collpage"]=>
  string(12) "/szilveszter"
  ["p"]=>
  string(1) "1"
  ["city_name"]=>
  string(13) "csikszentimre"
  ["type_name"]=>
  string(6) "hostel"
  ["type_id"]=>
  string(1) "7"
  ["city_id"]=>
  string(5) "10036"
  ["city_ids"]=>
  array(1) {
    [0]=>
    string(5) "10036"
  }
  ["distance_select"]=>
  int(50)
}
string(3753) "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`, (6371 * acos (cos(radians(46.28126090)) * cos(radians( latitude)) * cos(radians(longitude)-radians(25.85438910))+sin(radians(46.28126090))*sin(radians(latitude)))) as distance
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 `accommodations`.`address_city_id` IN('10036', '3441', '3462', '3466', '3469', '3498', '3622', '3624', '3626', '4119', '4120', '4121', '4122', '4124', '4131', '4132', '4133', '4135', '4136', '4137', '4138', '4155', '4156', '4157', '4158', '4159', '4160', '4161', '4162', '4163', '4164', '4165', '4166', '4167', '4168', '4169', '4170', '4171', '4172', '4319', '4320', '4321', '4322', '4323', '4324', '4325', '4582', '4774', '5284', '5285', '5286', '5287', '5288', '5289', '5290', '5291', '5292', '5562', '5563', '5564', '5565', '5566', '5597', '5647', '5711', '5712', '6970', '7392', '7397', '7400', '7420', '7453', '7455', '7458', '7487', '7488', '7561', '7562', '7563', '8598', '9143', '9144', '9224', '9229', '9231', '9232', '9252', '9253', '9264', '9265', '9272', '9273', '9906', '9908', '9909', '9910', '9911', '9912', '9913', '9914', '9915', '9916', '9917', '9918', '9928', '9929', '9943', '9944', '9945', '9946', '9947', '9948', '9956', '9957', '9958', '9959', '9960', '9961', '9962', '9966', '9975', '9976', '9977', '9978', '9979', '9980', '9981', '9983', '9987', '9988', '9989', '9990', '9991', '9992', '9993', '9994', '9995', '9996', '9997', '9998', '9999', '10000', '10001', '10002', '10004', '10009', '10010', '10011', '10012', '10013', '10014', '10015', '10016', '10032', '10033', '10034', '10035', '10036', '10037', '10038', '10039', '10040', '10059', '10060', '10061', '10062', '10063', '10064', '10065', '10066', '10067', '10068', '10069', '10070', '10071', '10072', '11408', '11409', '11410', '11411', '11418', '11419', '11420', '11421', '11422', '11423', '11427', '11428', '11429', '11430', '11431', '11432', '11433', '11434', '11435', '11436', '11437', '11443', '11444', '11445', '11447', '11448', '11449', '11450', '11451', '11452', '11457', '11458', '11459', '11460', '11464', '11465', '11466', '11467', '11468', '11469', '11472', '14955', '14958', '14990', '15002', '15053', '15114', '15124', '15133', '15145', '15147', '15150', '15151', '15152', '15155', '15156')
AND `accommodations`.`type_id` IN('7')
ORDER BY `reserved` ASC, `distance` ASC, `last_update` DESC, `accommodation_id` DESC
 LIMIT 50"