select id, vlocity_cmt__Value__c,vlocity_cmt__EntityFilterId__c from vlocity_cmt__EntityFilterCondition__c where vlocity_cmt__EntityFilterId__c in (select vlocity_cmt__EntityFilterId__c from vlocity_cmt__RuleAction__c where (vlocity_cmt__ProductRelationshipId__r.vlocity_cmt__RelationshipType__c = 'Auto-Remove' or vlocity_cmt__ProductRelationshipId__r.vlocity_cmt__RelationshipType__c = 'Auto-Add') and vlocity_cmt__ProductRelationshipId__r.vlocity_cmt__Product2Id__r.name like 'Caldaia%')

order by vlocity_cmt__EntityFilterId__c desc