select id,catname,parentpath,parentpathnames,titlebartext,breadcrumbtext,catpath,cat_active from category where parentid= order by catname asc