0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for linguists, etymologists, and serious English language enthusiasts

select distinct top 100  
       uc.id as [Comment Link]
     , pv.userdisplayname [potential userid]
from comments uc 
inner join comments pv on pv.postid = uc.postid 
                      and pv.id < uc.id
left outer join users u on u.id = pv.userid
where uc.text like '@H2CO3 %' -- collate sql_latin1_general_cp1_ci_ai
and u.id is null


select text
     , JSON_Value(ph.text,concat('$.Voters[', num.value , '].Id')) [potential userid] 
from posthistory ph
, string_split('0,1,2,3,4', ',') num
where posthistorytypeid = 10 
and ph.text like '%H2CO3%'
and JSON_Value(ph.text,concat('$.Voters[', num.value , '].DisplayName'))  = 'H2CO3'

view current version

edited jun 23 18

created jun 23 18 rene