Unanswered questions with comment linking to Crusade

1

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.Tags 
FROM Comments C, Posts P
Where (
  C.Text LIKE '%http://chat.stackexchange.com/rooms/9141%' AND
  C.PostId = P.Id AND
  ISNULL(P.AnswerCount,0) = 0  AND
  P.ClosedDate IS NULL
  )
ORDER BY P.CreationDate ASC

Enter Parameters

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