select top 10 info.IsHtml,info.Type,info.Link,info.HtmlMakePath,info.HtmlMakeFileName,info.InfoID,info.Title,info.CategoryID,info.Image,info.Hits,info.TopIndex,info.UpdateDate,info.CreateDate,info.IsHot,info.IsElite,info.Target from FD_U_Article info where info.infoid in(select top 10 info.InfoID from (select top 10 info.hits,info.infoid from FD_U_Article info where info.CategoryId=63 and info.State=0 order by info.hits desc union (select top 10 info.hits,info.infoid from FD_InfoCategoryExt infoExt INNER JOIN FD_U_Article info ON (infoExt.InfoID =info.InfoID and infoExt.InfoTypeID=4) where infoExt.CategoryId=63 and info.State=0 order by info.hits desc)) as info order by info.hits desc) order by info.hits desc
