Q&A about the site for administrators, end users, developers and designers for Craft CMS
SELECT p.id as [Post Link] FROM Posts p JOIN Comments c ON c.PostId = p.Id WHERE DATEDIFF(day, p.LastEditDate, c.CreationDate) >= 0 AND c.Text LIKE '%##KeywordsInComment##%' ORDER by p.LastEditDate DESC