MáJ 11.
2012
Az idei évben kínálatunkba került új szálláshelyek felkerültek helyükre.
PDF Katalógus Letöltés (106 mb)








object Database_MySQL_Result(7) {
protected _internal_row => integer 5
protected _query => string(839) "SELECT `special`.`date_from`, `route`.`uri`, `special`.`special_id`, `special`.`price`, `accomodation`.`hun` AS `ahun`, `location`.`hun` AS `lhun`, `picture`.`directory` AS `picture_directory`, concat(concat(picture.filename,'.'),picture.file_extension) AS `picture_file` FROM `special` JOIN `accomodation` ON (`special`.`accomodation_id` = `accomodation`.`accomodation_id`) JOIN `location` ON (`accomodation`.`location_id` = `location`.`location_id`) JOIN `picture` ON (`accomodation`.`accomodation_id` = `picture`.`accomodation_id`) JOIN `route` ON (`accomodation`.`route_id` = `route`.`id`) WHERE uExtractNumberFromString(special.price) < 50000 AND `picture`.`weight` = (SELECT MAX(pp.weight) FROM `picture` AS `pp` WHERE picture.accomodation_id = pp.accomodation_id) AND `special`.`date_from` >= curdate() GROUP BY `special_id` LIMIT 5"
protected _result => resource(mysql result)
protected _total_rows => integer 5
protected _current_row => integer 5
protected _as_object => bool FALSE
protected _object_params => NULL
}