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

氢能社会 的检索结果 27 个