SELECT
`rs-cms_adresat_object`.*,
`param_price`.value_int AS param_price ,
`dir_param_rooms`.value_int AS param_rooms ,
`dir_param_locality`.value AS param_locality ,
`param_param_street`.value AS param_param_street ,
`dir_param_floor`.value_int AS param_floor ,
`dir_param_floors`.value_int AS param_floors ,
`dir_param_status`.value AS param_status ,
`dir_param_info`.value AS param_info ,
`param_param_sole_owner`.value AS param_param_sole_owner ,
`param_tel_sole_owner`.value AS param_tel_sole_owner ,
`param_pl_obsh`.value_int AS param_pl_obsh ,
`param_pl_jilaya`.value_int AS param_pl_jilaya ,
`param_pl_kuhni`.value_int AS param_pl_kuhni ,
`dir_param_ul_new`.value AS param_ul_new ,
`rs-cms_core_users`.name AS user_name,
`rs-cms_core_users`.email AS user_email,
`rs-cms_core_users`.id AS user_id
FROM `rs-cms_adresat_object`
LEFT JOIN `rs-cms_adresat_directory_values_to_object` AS param_price ON
`param_price`.object_id = `rs-cms_adresat_object`.id AND `param_price`.id_directory=5
LEFT JOIN `rs-cms_adresat_directory_values_to_object` AS `param_rooms` ON
`param_rooms`.object_id = `rs-cms_adresat_object`.id AND `param_rooms`.id_directory=6
LEFT JOIN `rs-cms_adresat_directory_values` AS `dir_param_rooms` ON
`dir_param_rooms`.id = `param_rooms`.link AND `dir_param_rooms`.id_directory=6
LEFT JOIN `rs-cms_adresat_directory_values_to_object` AS `param_locality` ON
`param_locality`.object_id = `rs-cms_adresat_object`.id AND `param_locality`.id_directory=2
LEFT JOIN `rs-cms_adresat_directory_values` AS `dir_param_locality` ON
`dir_param_locality`.id = `param_locality`.link AND `dir_param_locality`.id_directory=2
LEFT JOIN `rs-cms_adresat_directory_values_to_object` AS param_param_street ON
`param_param_street`.object_id = `rs-cms_adresat_object`.id AND `param_param_street`.id_directory=16
LEFT JOIN `rs-cms_adresat_directory_values_to_object` AS `param_floor` ON
`param_floor`.object_id = `rs-cms_adresat_object`.id AND `param_floor`.id_directory=17
LEFT JOIN `rs-cms_adresat_directory_values` AS `dir_param_floor` ON
`dir_param_floor`.id = `param_floor`.link AND `dir_param_floor`.id_directory=17
LEFT JOIN `rs-cms_adresat_directory_values_to_object` AS `param_floors` ON
`param_floors`.object_id = `rs-cms_adresat_object`.id AND `param_floors`.id_directory=18
LEFT JOIN `rs-cms_adresat_directory_values` AS `dir_param_floors` ON
`dir_param_floors`.id = `param_floors`.link AND `dir_param_floors`.id_directory=18
LEFT JOIN `rs-cms_adresat_directory_values_to_object` AS `param_status` ON
`param_status`.object_id = `rs-cms_adresat_object`.id AND `param_status`.id_directory=11
LEFT JOIN `rs-cms_adresat_directory_values` AS `dir_param_status` ON
`dir_param_status`.id = `param_status`.link AND `dir_param_status`.id_directory=11
LEFT JOIN `rs-cms_adresat_directory_values_to_object` AS `param_info` ON
`param_info`.object_id = `rs-cms_adresat_object`.id AND `param_info`.id_directory=4
LEFT JOIN `rs-cms_adresat_directory_values` AS `dir_param_info` ON
`dir_param_info`.id = `param_info`.link AND `dir_param_info`.id_directory=4
LEFT JOIN `rs-cms_adresat_directory_values_to_object` AS param_param_sole_owner ON
`param_param_sole_owner`.object_id = `rs-cms_adresat_object`.id AND `param_param_sole_owner`.id_directory=19
LEFT JOIN `rs-cms_adresat_directory_values_to_object` AS param_tel_sole_owner ON
`param_tel_sole_owner`.object_id = `rs-cms_adresat_object`.id AND `param_tel_sole_owner`.id_directory=15
LEFT JOIN `rs-cms_adresat_directory_values_to_object` AS param_pl_obsh ON
`param_pl_obsh`.object_id = `rs-cms_adresat_object`.id AND `param_pl_obsh`.id_directory=8
LEFT JOIN `rs-cms_adresat_directory_values_to_object` AS param_pl_jilaya ON
`param_pl_jilaya`.object_id = `rs-cms_adresat_object`.id AND `param_pl_jilaya`.id_directory=9
LEFT JOIN `rs-cms_adresat_directory_values_to_object` AS param_pl_kuhni ON
`param_pl_kuhni`.object_id = `rs-cms_adresat_object`.id AND `param_pl_kuhni`.id_directory=10
LEFT JOIN `rs-cms_adresat_directory_values_to_object` AS `param_ul_new` ON
`param_ul_new`.object_id = `rs-cms_adresat_object`.id AND `param_ul_new`.id_directory=21
LEFT JOIN `rs-cms_adresat_directory_values` AS `dir_param_ul_new` ON
`dir_param_ul_new`.id = `param_ul_new`.link AND `dir_param_ul_new`.id_directory=21
LEFT JOIN `rs-cms_adresat_object_owner` ON
`rs-cms_adresat_object_owner`.object_id = `rs-cms_adresat_object`.id
LEFT JOIN `rs-cms_core_users` ON
`rs-cms_core_users`.id=`rs-cms_adresat_object_owner`.user_id
WHERE `rs-cms_adresat_object`.type_id=:type AND
`param_price`.value_int >= 1 AND
`param_price`.value_int <= 54 AND
`dir_param_rooms`.id =19 AND
`dir_param_locality`.id ='3' AND
`param_param_street`.value LIKE '%test%' AND
`dir_param_floor`.id =25 AND
`dir_param_floors`.id =50 AND
`param_pl_obsh`.value_int >= 2 AND
`param_pl_obsh`.value_int <= 6 AND
`param_pl_jilaya`.value_int >= 1 AND
`param_pl_jilaya`.value_int <= 6 AND
`param_pl_kuhni`.value_int >= 4 AND
`param_pl_kuhni`.value_int <= 54 AND
`dir_param_ul_new`.id ='2427'
GROUP BY `rs-cms_adresat_object`.id
ORDER BY `rs-cms_adresat_object`.date_add DESC
LIMIT 0,50