SELECT c.CreationDate as [Comment Date], p.Id AS [Post Li...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow

Q&A for professional and enthusiast programmers

-- comments of a notorious troll in MSE
-- Use this query to see how much shit this thing has said
SELECT 
  c.CreationDate as [Comment Date], 
  p.Id AS [Post Link], 
  c.Text AS Comment 
FROM Posts p INNER JOIN Comments c ON c.PostId=p.Id
WHERE c.UserId=85695
      AND
      c.Text LIKE '%solo%'
ORDER BY c.CreationDate DESC

Enter Parameters

Options:
Switch to meta site
loading Hold tight while we fetch your results