find suggested edits by now deleted users

1

Please login or register to vote for this query.

(click on this box to dismiss)

Materials Modeling Meta

Q&A for materials modelers and data scientists

;with data as (
select 
      id
    , postid
    , creationdate
    , comment
    , row_number() over (partition by id order by postid) [row]
    , rd.value
from posthistory
cross apply string_split(comment, ' ') rd
where posthistorytypeid = 24
and  charindex('|', comment) = 0

)

select *
into #sugedt
from data

select 
       row
     , value
     , id
     , postid
     , comment
into #sugprop
from #sugedt
-- left outer join users u on u.id = value and row=3
where row = 3

select sp.*
     , concat('site://q/', postid, '|', 'Link') [Link]
from #sugprop sp
left outer join users u on u.id = sp.value
where u.id is null

Enter Parameters

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