Dupe Hammer Accuracy

0

Please login or register to vote for this query.

(click on this box to dismiss)

Reverse Engineering Meta

Q&A about the site for researchers and developers who explore the principles of a system through analysis of its structure, function, and operation

select top 100 hc.UserId [User Link], count(*) HammerClosed, 
  count(hr.Id) Reopened,
  count(he.Id) Reclosed,
  Round(count(hr.Id)*100.0/count(*),2) PctError
from PostHistory hc
left join PostHistory hr on hr.PostId=hc.PostId and hr.CreationDate > hc.CreationDate and hr.PostHistoryTypeId=11
left join PostHistory he on hr.PostId=he.PostId 
  and he.CreationDate > hr.CreationDate 
  and he.PostHistoryTypeId=10
  -- and he.Comment like '101%'
  and he.comment in (1,101)
  and he.Text like '%BindingReason":{"GoldTagBadge%'
where hc.PostHistoryTypeId=10
-- and hc.Comment like '101%'
and hc.comment in (1,101)
and hc.Text like '%BindingReason":{"GoldTagBadge%'
---and hc.CreationDate > 356
group by hc.UserId
order by count(*) desc

Enter Parameters

Options:
Switch to main site
loading Hold tight while we fetch your results