Minhas Perguntas fechadas como Ampla Demais

0

Please login or register to vote for this query.

(click on this box to dismiss)

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.

Stack Overflow em Português

Perguntas e respostas para programadores profissionais e entusiastas

SELECT TOP 10000
  answer.Id as [Post Link],*
FROM 
  Posts answer 
JOIN 
  Posts p
ON
  answer.ParentId = p.Id
  join PostHistory ph on ph.PostId = p.Id
join PostTypes pt on p.PostTypeId = pt.Id
  where ph.CreationDate =
( select max(ph.CreationDate) from PostHistory ph
  join CloseReasonTypes crt on crt.Id = ph.Comment
  join PostHistoryTypes 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
  p.ClosedDate IS NOT NULL
ORDER BY
  p.ClosedDate
DESC

Enter Parameters

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