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

/*select top 100
       concat('site://suggested-edits/',id,'|', 'link') [Link]
     , *
from suggestededits
where owneruserid is not null
and owneruserid not in (select id from users)
or owneruserid = -1

select top 10  *
from posthistory
where posthistorytypeid = 5
and userid = -1
*/


select top 1000
      postid [Post Link]
    , creationdate
    , userid
    , userdisplayname
    , comment
    -- , string_split(comment, ' ')
from posthistory
where posthistorytypeid = 24
and ( charindex('|', comment) > 1
or 
userid is not null
or userdisplayname is not null)
order by creationdate desc

Enter Parameters

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