0

Please login or register to vote for this query.

(click on this box to dismiss)

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

select  hc.PostId as [Post Link]
from PostHistory as hc


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

where hc.PostHistoryTypeId=11
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

fork query

edited nov 15

created jan 21 16 anonymous