SELECT

rs_adresat_object.*,

rs_core_users.name AS user_name,

rs_core_users.email AS user_email,

rs_core_users.id AS user_id,

 

(SELECT dir_param_rooms.value_int AS param_rooms

FROM rs_adresat_directory_values       

LEFT JOIN rs_adresat_directory_values_to_object AS param_rooms ON param_rooms.object_id = rs_adresat_directory_values.id_directory AND param_rooms.id_directory=6

LEFT JOIN rs_adresat_directory_values AS dir_param_rooms ON dir_param_rooms.id = param_rooms.link AND dir_param_rooms.id_directory=6

WHERE rs_adresat_directory_values.id_directory=rs_adresat_object.id)

 

FROM rs_adresat_object

 

LEFT JOIN rs_adresat_object_owner ON rs_adresat_object_owner.object_id = rs_adresat_object.id

LEFT JOIN rs_core_users ON rs_core_users.id=rs_adresat_object_owner.user_id

 

WHERE rs_adresat_object.type_id=1

ORDER BY rs_adresat_object.date_add DESC LIMIT 50 OFFSET 0