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)' )