Close stats for top dup-hammer users

0

Please login or register to vote for this query.

(click on this box to dismiss)

Cognitive Sciences Meta

Q&A about the site for practitioners, researchers, and students in cognitive science, psychology, neuroscience, and psychiatry

select top 10 hc.Id as [Post Link]
--from PostHistory hc
from Posts as hc
left join PostHistory hr on hr.PostId=hc.Id  and hr.PostHistoryTypeId=11
where hr.PostHistoryTypeId=10
and hr.Comment like '101%'
and hr.Text like '%BindingReason":{"GoldTagBadge%'
---and JSON_value(hr.text, '$.Voters['+ hr.value + '].Id') is not null
---and JSON_value(hr.text, '$.Voters['+ hr.value + '].Id') = '##userid:int##'

Enter Parameters

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