Форумы портала PHP.SU

CODE (SQL):
скопировать код в буфер обмена
 
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 
 