SELECT usertask0_.id AS id2_272_, usertask0_.actual_unit_id AS actual_40_272_, usertask0_.answer_to_client AS answer_t3_272_,
usertask0_.can_be_assigned AS can_be_a4_272_, usertask0_.claim_time AS claim_ti5_272_, usertask0_.cms_tt_id AS cms_tt_41_272_,
usertask0_.comment AS comment6_272_, usertask0_.coordinator_id AS coordin42_272_, usertask0_.coordinator_user_uuid AS coordin43_272_,
usertask0_.departure_time_exceed_limit AS departur7_272_, usertask0_.end_time AS end_time8_272_, usertask0_.exec_unit_id AS exec_un44_272_,
usertask0_.exec_unit_role_id AS exec_un45_272_, usertask0_.exec_user_uuid AS exec_us46_272_, usertask0_.foreign_ticket AS foreign_9_272_,
usertask0_.is_called_pause AS is_call10_272_, usertask0_.is_parallel_initiator AS is_para11_272_, usertask0_.kd_ola AS kd_ola12_272_,
usertask0_.network_tt_id AS network47_272_, usertask0_.number AS number13_272_, usertask0_.parent_process_id AS parent_14_272_,
usertask0_.parent_task_id AS parent_15_272_, usertask0_.provider_inn AS provide16_272_, usertask0_.provider_name AS provide17_272_,
usertask0_.show_answer_client_field AS show_an18_272_, usertask0_.show_waiting_time AS show_wa19_272_, usertask0_.start_time AS start_t20_272_,
usertask0_.task_status_id AS task_st48_272_, usertask0_.task_type_id AS task_ty49_272_, usertask0_.ticket_id AS ticket_21_272_, usertask0_.updated AS updated22_272_,
usertask0_.user_end_time AS user_en23_272_, usertask0_.accident_reason_id AS acciden50_272_, usertask0_.actual_waiting_time AS actual_24_272_,
usertask0_.close_code_id AS close_c51_272_, usertask0_.damage_level_id AS damage_52_272_, usertask0_.damage_type_id AS damage_53_272_,
usertask0_.depart_limit_time AS depart_25_272_, usertask0_.event_severity_id AS event_s54_272_, usertask0_.execution_id AS executi26_272_,
usertask0_.no_context AS no_cont27_272_, usertask0_.non_implementation_reason_id AS non_imp55_272_, usertask0_.proc_id AS proc_id28_272_,
usertask0_.process_key AS process29_272_, usertask0_.process_version AS process30_272_, usertask0_.reason_fail_norm AS reason_31_272_,
usertask0_.recovery_time AS recover32_272_, usertask0_.rule_id AS rule_id33_272_, usertask0_.target_unit_id AS target_56_272_,
usertask0_.target_unit_role_id AS target_57_272_, usertask0_.task_duration AS task_du34_272_, usertask0_.task_id AS task_id35_272_,
usertask0_.task_name AS task_na36_272_, usertask0_.task_stop_date AS task_st37_272_, usertask0_.task_work_time AS task_wo38_272_,
usertask0_.waiting_time AS waiting39_272_ FROM tasks usertask0_
left outer join cat_task_status AS taskstatus1_ on usertask0_.task_status_id=taskstatus1_.id
left outer join cat_task_type AS tasktype2_ on usertask0_.task_type_id=tasktype2_.id
left outer join cat_unit AS unit3_ on usertask0_.coordinator_id=unit3_.id
left outer join cat_task_status AS taskstatus4_ on usertask0_.task_status_id=taskstatus4_.id
left outer join trouble_tickets AS troubletic5_ on usertask0_.ticket_id=troubletic5_.id
left outer join cat_unit AS unit6_ on troubletic5_.curator_unit_id=unit6_.id
WHERE usertask0_.task_type='User' AND taskstatus1_.id<>1 AND tasktype2_.id<>27 AND (unit3_.id IN (50))
and (taskstatus4_.id in (3)) and (unit6_.id in (28001 , 3138 , 28042 , 10000 , 112 , 10002 , 10003 , 10004 , 10005 , 10006 , 151 , 10007 , 10008 , 25 , 10009 , 26));
Text paste