Q&A about the site for administrators, end users, developers and designers for Craft CMS
SELECT c.CreationDate, c.Id as [Comment Link] FROM Comments as c LEFT OUTER JOIN Comments as t ON t.PostId = c.PostId WHERE t.TEXT LIKE ##threadneedle:string## AND c.TEXT LIKE ##needle:string## ORDER BY c.CreationDate DESC