1

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.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

fork query

edited jul 26 13

created jul 26 13 jon.doe11527