not static mode childquery:select sortorder, cat1.catname as parentname,cat1.cat as parentcode, cat1.rescount as parentcount, specialcase, staticlink, icon from cat as cat1 where cat1.site='hh' AND parentcat='0' order by sortorder |
not static mode childquery:select sortorder, cat1.catname as parentname,cat1.cat as parentcode, cat1.rescount as parentcount, specialcase, staticlink, icon from cat as cat1 where cat1.site='hh' AND parentcat='0' order by sortorder |