My hammers


Please login or register to vote for this query.

(click on this box to dismiss)

Motor Vehicle Maintenance and Repair Meta

Q&A about the site for mechanics and DIY enthusiast owners of cars, trucks, and motorcycles

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 main site
loading Hold tight while we fetch your results