SELECT Id, vlocity_cmt__EntityFilterId__c,vlocity_cmt__EntityFilterId__r.Name,vlocity_cmt__Index__c,vlocity_cmt__Type__c,vlocity_cmt__FieldName__c,vlocity_cmt__Operator__c,vlocity_cmt__Value__c

from 	vlocity_cmt__EntityFilterCondition__c

where vlocity_cmt__EntityFilterId__c in (select vlocity_cmt__EntityFilterId__c from vlocity_cmt__RuleAction__c )

order by vlocity_cmt__EntityFilterId__r.Id desc