| |
|
|
| |
SELECT
t.i_pz_task_property AS task2_id, t.dt_StartDate AS date_begin, t.dt_DueDate AS date_end,
t.dt_CreationTime AS date_create, t.dt_DateCompleted AS date_finish, t.i_tree, t.c_log AS log,
t.i_pz_super_sun_type_tz AS type, t.c_olcode, t.dt_LastModifacationTime, p.n_subject AS
task2_name, p.n_condition AS condition_id, avtor.i_user AS avtor, owner.i_user AS owner,
initiator.i_user AS initiator, `comment`.c_text, ispol_list.c_text, kontr_list.c_text
FROM
pz_task t
LEFT OUTER JOIN pz_task_property p ON t.i_pz_task_property = p.id
LEFT OUTER JOIN pz_super_sun avtor ON p.id = avtor.i_pz_task_property
LEFT OUTER JOIN pz_super_sun owner ON p.id = owner.i_pz_task_property
LEFT OUTER JOIN pz_super_sun initiator ON p.id = initiator.i_pz_task_property
LEFT OUTER JOIN pz_task_text `comment` ON p.id = `comment`.i_pz_task_property
LEFT OUTER JOIN pz_task_text ispol_list ON p.id = ispol_list.i_pz_task_property
INNER JOIN pz_task_text kontr_list ON p.id = kontr_list.i_pz_task_property
WHERE
avtor.i_pz_super_sun_type = 1 AND owner.i_pz_super_sun_type = 5 AND
initiator.i_pz_super_sun_type = 8 AND `comment`.i_pz_super_sun_type = 3 AND
ispol_list.i_pz_super_sun_type = 4 AND kontr_list.i_pz_super_sun_type = 2
|
возможно ли оптимизировать запросик? | |
| |
|
