select networkrul0_.id as id1_30_, networkrul0_.close_code_id as close_co9_30_, networkrul0_.external_id as external2_30_, networkrul0_.is_active as is_activ3_30_, networkrul0_.is_deleted as is_delet4_30_, networkrul0_.name as name5_30_, networkrul0_.process_name as process_6_30_, networkrul0_.version as version7_30_, networkrul0_.sort as sort8_30_, networkrul0_.target_unit_role_id as target_10_30_, from cache_network_rule networkrul0_ left outer join cache_network_rule_source_system_link sourcesyst1_ on networkrul0_.id=sourcesyst1_.rule_id left outer join cat_source_system sourcesyst2_ on sourcesyst1_.source_system_id=sourcesyst2_.id left outer join cache_network_rule_issue_class_link issueclass3_ on networkrul0_.id=issueclass3_.rule_id left outer join cat_network_ticket_issue_class issueclass4_ on issueclass3_.issue_class_id=issueclass4_.id left outer join cache_network_rule_source_unit_role_link sourceunit5_ on networkrul0_.id=sourceunit5_.rule_id left outer join cat_unit_role unitrole6_ on sourceunit5_.unit_role_id=unitrole6_.id left outer join cache_network_rule_source_task_type_link sourcetask7_ on networkrul0_.id=sourcetask7_.rule_id left outer join cat_task_type tasktype8_ on sourcetask7_.task_type_id=tasktype8_.id where networkrul0_.is_active is true and networkrul0_.process_name='network_ticket_process' and networkrul0_.version=28 and (tasktype8_.id=15 or tasktype8_.id is null) and (unitrole6_.id=165 or unitrole6_.id is null) and (issueclass4_.id=1 or issueclass4_.id is null) and (sourcesyst2_.id=1 or sourcesyst2_.id is null);