Compare Pastes

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;