Q&A about the site for administrators, end users, developers and designers for Craft CMS
select top ##NumberOfComments## c.CreationDate, c.Text, c.Id as [Comment Link], c.PostId as [Post Link] from Comments c where Text like '%##keyword1##%' and c.CreationDate >= '2018-08-15' ORDER BY c.CreationDate desc