3704ݿ
select SortName,SortStyle,SortURL,sortID ,(select count (*) from Aspcms_NewsSort as a where a.ParentID=b.sortID) as subcount,SortFolder from Aspcms_NewsSort as b where SortStatus and ParentID=0 order by SortOrder asc