1

Please login or register to vote for this query.

(click on this box to dismiss)

This does not work because PendingFlags only has pending close votes, not votes that succeeded.

Q&A for professional and enthusiast programmers

SELECT  
  q.Score AS Score,
  q.Id AS [Post Link],
  CASE h.Comment
    WHEN '1' THEN 'Exact Duplicate'
    WHEN '2' THEN 'Off-topic'
    WHEN '3' THEN 'Subjective and argumentative'
    WHEN '4' THEN 'Not a real question'
    WHEN '7' THEN 'Too localized'
    WHEN '10' THEN 'General reference'
    WHEN '20' THEN 'Noise or pointless (Meta sites only)'
    WHEN '101' THEN 'Duplicate'
    WHEN '102' THEN 'Off-topic'
    WHEN '103' THEN 'Unclear what you''re asking'
    WHEN '104' THEN 'Too broad'
    WHEN '105' THEN 'Primarily opinion-based'
  END AS [Close Reason],
  q.ClosedDate
FROM Posts q
INNER JOIN PostHistory h ON q.Id = h.PostId
WHERE h.PostHistoryTypeId = 10
  AND q.Score >= 10
  AND q.ClosedDate IS NOT NULL
ORDER BY q.Score DESC

view current version

edited jan 31 14 phenry

created dec 3 11 Mark Trapp