find suggested edits by now deleted users


Please login or register to vote for this query.

(click on this box to dismiss)

Ask Different

Q&A for power users of Apple hardware and software

/*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
order by creationdate desc

Enter Parameters

Switch to meta site
loading Hold tight while we fetch your results