select distinct slarule0_.id as id1_77_, slarule0_.is_deleted as is_delet2_77_,
slarule0_.ks_sla as ks_sla3_77_, slarule0_.ola_op1_1 as ola_op4_77_,
slarule0_.ola_op1_2 as ola_op5_77_, slarule0_.ola_op2_1 as ola_op6_77_,
slarule0_.ola_tp1_1 as ola_tp7_77_, slarule0_.ola_tp1_3 as ola_tp8_77_,
slarule0_.ola_tp2_2 as ola_tp9_77_, slarule0_.ola_tp2_4 as ola_tp10_77_,
slarule0_.ola_tp2_8 as ola_tp11_77_, slarule0_.priority_id as priorit15_77_,
slarule0_.removing_potential as removin12_77_, slarule0_.repeating as repeati13_77_,
slarule0_.degradation_level as degrada16_77_, slarule0_.vip as vip14_77_
from cache_sla_rule slarule0_
left outer join cache_sla_rule_technology_link technology1_ on slarule0_.id=technology1_.sla_rule_id
left outer join cat_technology technology2_ on technology1_.technology_id=technology2_.id
left outer join cache_sla_rule_service_class_link servicecla3_ on slarule0_.id=servicecla3_.sla_rule_id
left outer join cat_service_class servicecla4_ on servicecla3_.service_class_id=servicecla4_.id
left outer join cache_sla_rule_vip_link viptypelis5_ on slarule0_.id=viptypelis5_.sla_rule_id
left outer join cat_vip viptype6_ on viptypelis5_.vip_id=viptype6_.id
left outer join cache_sla_rule_macrosegment_link macrosegme7_ on slarule0_.id=macrosegme7_.sla_rule_id
left outer join cat_macrosegment macrosegme8_ on macrosegme7_.macrosegment_id=macrosegme8_.id
left outer join cache_sla_rule_service_link servicelis9_ on slarule0_.id=servicelis9_.sla_rule_id
left outer join cat_service service10_ on servicelis9_.service_id=service10_.id
left outer join cache_sla_rule_klass_np_link klassnplis11_ on slarule0_.id=klassnplis11_.sla_rule_id
left outer join cat_klass_np klassnp12_ on klassnplis11_.klass_np_id=klassnp12_.id
left outer join cache_sla_rule_segment_link segmentlis13_ on slarule0_.id=segmentlis13_.sla_rule_id
left outer join cat_segment segment14_ on segmentlis13_.segment_id=segment14_.id
where 1=1 and ( not (exists (select technology16_.id from cache_sla_rule_technology_link technology15_, cat_technology technology16_ where slarule0_.id=technology15_.sla_rule_id
and technology15_.technology_id=technology16_.id)) or technology2_.id in ('1'))
and ( not (exists (select servicecla18_.id from cache_sla_rule_service_class_link servicecla17_, cat_service_class servicecla18_ where slarule0_.id=servicecla17_.sla_rule_id
and servicecla17_.service_class_id=servicecla18_.id)) or servicecla4_.id in ('2'))
and ( not (exists (select viptype20_.id from cache_sla_rule_vip_link viptypelis19_, cat_vip viptype20_ where slarule0_.id=viptypelis19_.sla_rule_id and viptypelis19_.vip_id=viptype20_.id)) or viptype6_.id in ('1'))
and ( not (exists (select macrosegme22_.id from cache_sla_rule_macrosegment_link macrosegme21_, cat_macrosegment macrosegme22_ where slarule0_.id=macrosegme21_.sla_rule_id
and macrosegme21_.macrosegment_id=macrosegme22_.id)) or macrosegme8_.id in ('4'))
and (slarule0_.repeating is null or slarule0_.repeating='false')
and ( not (exists (select service24_.id from cache_sla_rule_service_link servicelis23_, cat_service service24_ where slarule0_.id=servicelis23_.sla_rule_id and servicelis23_.service_id=service24_.id)) or service10_.id in ('10'))
and ( not (exists (select klassnp26_.id from cache_sla_rule_klass_np_link klassnplis25_, cat_klass_np klassnp26_
where slarule0_.id=klassnplis25_.sla_rule_id and klassnplis25_.klass_np_id=klassnp26_.id)) or klassnp12_.id in ('4'))
and (slarule0_.degradation_level is null or slarule0_.degradation_level='4')
and (slarule0_.removing_potential is null or slarule0_.removing_potential='false')
and ( not (exists (select segment28_.id from cache_sla_rule_segment_link segmentlis27_, cat_segment segment28_
where slarule0_.id=segmentlis27_.sla_rule_id and segmentlis27_.segment_id=segment28_.id)) or segment14_.id in ('4')) order by slarule0_.ks_sla asc;
Text paste