SELECT dcs.pcatid,dcs.plabel,dcs.catid,dcs.label FROM def_cat_site dcs WHERE dcs.siteid='sgshops' AND dcs.pcatid = '0' ORDER BY dcs.pcatid, dcs.catid