Q&A for professional and enthusiast programmers
SELECT Comments.CreationDate, Comments.Id as [Comment Link] FROM Comments WHERE EXISTS (SELECT 1 FROM Comments as t where t.PostId = Comments.PostId AND t.TEXT LIKE ##threadneedle:string## ) AND Comments.TEXT LIKE ##needle:string## ORDER BY Comments.CreationDate DESC