instruction: Minhas Perguntas fechadas como Ampla Demais. People keep closing old questions I answered that obviously I think are good questions, or at least salvageable. Since I get no notification of such closing, I created this query.
response: SELECT answer.Id AS "post_link", * FROM Posts AS answer JOIN Posts AS p ON answer.ParentId = p.Id JOIN PostHistory AS ph ON ph.PostId = p.Id JOIN PostTypes AS pt ON p.PostTypeId = pt.Id WHERE ph.CreationDate = (SELECT MAX(ph.CreationDate) FROM PostHistory AS ph JOIN CloseReasonTypes AS crt ON crt.Id = ph.Comment JOIN PostHistoryTypes AS pht ON ph.PostHistoryTypeId = pht.Id WHERE ph.PostId = p.Id AND pht.Name = 'Post Closed') AND answer.PostTypeId = 2 AND answer.OwnerUserId = '##UserId##' AND NOT p.ClosedDate IS NULL ORDER BY p.ClosedDate DESC LIMIT 10000