select name,
  vlocity_cmt__SpecificationSubType__c,
   (select vlocity_cmt__PricingElementId__r.vlocity_cmt__PricingVariableId__r.name, 
   vlocity_cmt__PricingElementId__r.vlocity_cmt__DisplayText__c
   from vlocity_cmt__ProductPriceListEntries__r  
   where vlocity_cmt__PriceListName__c='South Africa - Residential'  and vlocity_cmt__IsOverride__c=false
   ORDER BY vlocity_cmt__ProductId__r.name) 
from product2 
where name IN 
('DStv Internet Router (Model MF286C)'
)