Q&A for users of Linux, FreeBSD and other Un*x-like operating systems
SELECT TOP 100 c.Id AS [Comment Link], c.Text, c.CreationDate, p.Title AS [Post Title], p.Id AS [Post Link] FROM Comments c JOIN Posts p ON p.Id = c.PostId WHERE c.Text LIKE '%stack%' AND c.Text LIKE '%deal%' ORDER BY c.CreationDate DESC