2

Please login or register to vote for this query.

(click on this box to dismiss)

If a question was closed multiple times, it will be shown more than once in the results of this query

Q&A about the site for builders and users of networked sensors and control devices in the contexts of smart homes, industry automation, or environmental sensors

---If a question was closed multiple times, it will be shown more than once in the results of this query
SELECT 
  CASE 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'
    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.Id AS [Post Link], 
  'site://posts/' + CAST(q.Id AS varchar)+'/revisions' AS [Revision History],
  a.Id AS [Post Link],
  q.Score, a.Score, q.ViewCount, q.Tags
FROM Posts q INNER JOIN Posts a ON a.ParentId=q.Id
  INNER JOIN PostHistory ph ON  ph.PostId=q.Id
WHERE (q.ClosedDate IS NOT NULL) AND (a.OwnerUserId=##userId##) AND (ph.PostHistoryTypeId=10)
ORDER BY q.Id DESC

fork query

edited oct 24

created oct 24 Martin20528