Select A.ArticleID,A.ArticleIDMD5,A.ArticleClassID,A.ArticleTitle
,A.ArticleSummary,Substring(ArticleTextContent,1,100) as ArticleSummaryCut
,Convert(varchar(10),A.ArticleDate,120) as ArticleDate
,A.ArticleURL,A.ArticleTags,A.ArticleThumbnail
,A.ArticleThumbnailSmall
,A.ArticleViewTimes
,A.ArticlePublicTime
,A.IsSetTop,A.SetTopTime,A.HaveSon,A.LastCommentTime
,ISNULL(B.ArticleClassName,'') as ArticleClassName
From ArticleList A
Left Join ArticleClassList B On A.ArticleClassID=B.ArticleClassID
Where IsShow=1 and IsDelete =0
And Contains(A.*,'城市复苏')
Order by ArticleDate DESC
城市复苏 的检索结果 0 个