Closed questions with highest view count

0

Please login or register to vote for this query.

(click on this box to dismiss)

Questions that have been closed (not protected), along with their close reasons, ordered by their view count.

Stack Overflow

Q&A for programmers

SELECT
  q.ViewCount AS Views,
  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]
FROM Posts q
INNER JOIN PostHistory h ON q.Id = h.PostId
WHERE h.PostHistoryTypeId = 10
  AND q.ViewCount >= 10000
  AND q.ClosedDate IS NOT NULL
ORDER BY q.ViewCount DESC

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results