×ÊÑ¶ÁÐ±í ³ÇÊÐ×ÊÑ¶ Ç§Ç§ÎÊ ÖÐ¹úÉú»îÃÅ»§Íø

Select top 25 CONVERT(varchar,(select Operate_Time from Operate_T AS aa where Operate_Type=0 and Operate_Object_Type=50 and aa.Operate_Object_Id=a.Article_Id),23) AS PostTime ,(select top 1 Picture_Image from Picture_T AS ab where Picture_Object_Type=2 and ab.Picture_Object_Id=a.Article_Id ORDER BY Picture_Id Desc) as Image ,(select top 1 Picture_SmallImage from Picture_T AS ab where Picture_Object_Type=2 and ab.Picture_Object_Id=a.Article_Id ORDER BY Picture_Id Desc) as SmallImage ,case when (Article_Prefix!=0 and Article_Prefix is not null) then (select Enumeration_Name from Enumeration_T AS b where Article_Prefix=b.Enumeration_Id) end as Prefix_Name ,a.* from Article_T as a where CONTAINS(Article_Cate,'''0~1~18''') order by PostTime desc