0

Please login or register to vote for this query.

(click on this box to dismiss)

Questions that have been closed for being primarily opinion-based.

Q&A for people organizing, marketing or licensing open source development projects

SELECT DISTINCT
  Q.Id AS [Post Link],
  IIF(Q.ClosedDate IS NULL, 'open', 'closed') AS [State],
  Q.Score AS [Score],
  Q.AnswerCount AS [Answers],
  Q.CreationDate AS [Asked]
FROM
  Posts AS Q
  INNER JOIN PostHistory PH ON (Q.Id = PH.PostId)
WHERE 
  Q.PostTypeId = 1 AND
  PH.PostHistoryTypeId = 10 AND
  PH.Comment = 105
ORDER BY
  Q.Score DESC

fork query

edited jul 14 15 Gilles

created nov 18 13 acheong87