0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for professional and enthusiast programmers

SELECT P.CreationDate, P.Id AS [Post Link], P.Body 
FROM Comments C, Posts P
Where (
  P.PostTypeId = 1 AND
  C.Text LIKE '%##Keyword##%' AND
  C.PostId = P.Id AND
  ISNULL(P.AnswerCount,0) = 0  AND
  P.ClosedDate IS NULL AND
  P.Score < 3
  )
ORDER BY P.CreationDate ASC

fork query

edited jul 27 13

created jul 26 13 jon.doe11527