0

Please login or register to vote for this query.

(click on this box to dismiss)

https://meta.stackexchange.com/questions/281536/is-there-a-way-to-compare-a-suggested-edit-with-rejected-and-edited-result

Q&A about the site for those committed to a vegan or vegetarian lifestyle and anyone interested in learning more

select top 100 
       len(se.text) - len(ph.text)  
       , (select count(*) from string_split(se.text, ' ')) 
     , se.text
     , ph.text
     , se.postid as [Post Link]
    -- , ph.userid as [User Link]
from suggestededits se
inner join suggestededitvotes sev on sev.suggestededitid = se.id
inner join posthistory ph on ph.postid = se.postid
inner join reviewtasks rt on rt.suggestededitid = se.id
inner join ReviewTaskResults rtr on rtr.Id = rt.CompletedByReviewTaskId
where sev.votetypeid =3 -- reject
and sev.userid = -1 -- reject / edit or OP rejected
and ph.posthistorytypeid = 5 -- edit body
and ph.creationdate between sev.creationdate and dateadd(n, 30, sev.creationdate)
-- and rt.id = rt.CompletedByReviewTaskId 
and RejectionReasonId in (109 , 9)
and se.text is not null
order by CompletedByReviewTaskId

select 
 distinct votetypeid
 from suggestededitvotes

view current version

edited jul 21 18

created jul 21 18 rene