My hammers


Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow

Q&A for professional and enthusiast programmers

select p.Id as [Post Link],
       case when p.ClosedDate is null then 'no' else '' end as Closed,
       case when p.DeletionDate is null then 'no' else '' end as Deleted,
from PostHistory ph
     left join Posts p on ph.PostId = p.ID
where ph.Text like '%BindingReason":{"GoldTagBadge%'
  and ph.UserId=1974224
  group by p.Id, p.ClosedDate, p.DeletionDate
  order by Deleted, Closed desc, p.ClosedDate desc

Enter Parameters

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