Select top 5 a.ID,a.Title,a.Link,a.Content,a.AddTime, b.Content AS bContent FROM Content a LEFT JOIN FieldContent b ON a.ID = b.ContentID Where a.ItemIDS = '109' And b.Content <> '' And a.FSID = -2 And ((a.PubType = 0) OR (a.PubType = 1 And a.PubDate < getdate())) And ((a.DueType = 0) OR (a.DueType = 1 And a.DueDate > getdate())) And a.IsDelete = 0 And a.IsDraft = 0 Order By a.AddTime DESC
temp
最新推荐文章于 2022-08-21 23:53:19 发布