select top 5 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 5 info.InfoID from (select top 5 info.topindex,info.updatedate,info.infoid from FD_U_Article info where info.CategoryId=230 and info.State=0 order by info.TopIndex desc,info.UpdateDate desc union (select top 5 info.topindex,info.updatedate,info.infoid from FD_InfoCategoryExt infoExt INNER JOIN FD_U_Article info ON (infoExt.InfoID =info.InfoID and infoExt.InfoTypeID=4) where infoExt.CategoryId=230 and info.State=0 order by info.TopIndex desc,info.UpdateDate desc)) as info order by info.TopIndex desc,info.UpdateDate desc) order by info.TopIndex desc,info.UpdateDate desc