find suggested edits by now deleted users

1

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
    , 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) > 1
or 
userid is not null
or userdisplayname is not null) */
order by id, row, creationdate desc

Enter Parameters

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