Suggested edits which are possibly affected by rollback bug

0

Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow

Q&A for professional and enthusiast programmers

SELECT e.postid AS [Post Link], e.approvaldate
  FROM suggestededits AS e
  
  -- edited tags by edit suggester
  INNER JOIN posthistory AS th
    ON e.postid = th.postid AND e.approvaldate = th.creationdate 
    AND th.posthistorytypeid = 6 -- 'edited tags'
  -- RevisionGUID doesn't work; the suggested edit contains the GUID of the revision *before* the edit
  
  -- no other edits by edit suggester
  LEFT OUTER JOIN posthistory AS h
    ON e.postid = h.postid AND e.approvaldate = h.creationdate
    AND e.owneruserid = h.userid
    AND h.posthistorytypeid IN (4, 5) -- 'edited title' & 'edited body'
  
  -- review task result
  INNER JOIN reviewtasks AS t
    ON t.suggestededitid = e.id    
  INNER JOIN reviewtaskresults AS r
    ON r.reviewtaskid = t.id
    AND r.reviewtaskresulttypeid = 5 -- 'edit', which is 'improve & edit'
  
  WHERE h.id IS NULL
    AND e.approvaldate >= '2016-12-01'

Enter Parameters

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