Q&A for professional and enthusiast programmers
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