Close stats for top dup-hammer users

0

Please login or register to vote for this query.

(click on this box to dismiss)

Gardening and Landscaping

Q&A for gardeners and landscapers

select  hc.PostId as [Post Link], hr.Id as Reopened
from PostHistory as hc
inner join PostHistory hr on hr.PostId=hc.PostId  and hr.PostHistoryTypeId=11
---inner join Posts p on p.PostTypeId=1 and hc.PostId = p.Id

cross join string_split('0,1,2,3,4,5',',') 

where hc.PostHistoryTypeId=10
and hc.Comment like '101%'
and hc.Text like '%BindingReason":{"GoldTagBadge%'
and JSON_value(hc.text, '$.Voters['+value+'].Id') is not null
and JSON_value(hc.text, '$.Voters['+value+'].Id') = '##userid:int##'

order by hc.CreationDate desc

Enter Parameters

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