sql=select SortName,SortType,SortURL,sortID,(select count (*) from AspCms_Sort as a where a.ParentID=b.sortID) as subcount,SortFolder,SortFileName,GroupID,Exclusive from AspCms_Sort as b where LanguageID=1 and SortStatus=1 and ParentID={aspcms:topsortid} order by SortOrder asc