Answers on closed questions by a specific user (with close reasons)


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

Internet of Things Meta

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

SELECT q.Id AS [Post Link], a.Id AS [Post Link],
  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'
  AS [Close Reason],
  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)

Enter Parameters

Switch to main site
loading Hold tight while we fetch your results