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
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.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