Unanswered questions with a keyword in comment


Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow

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

Enter Parameters

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