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]
  FROM suggestededits AS e
  
  INNER JOIN posthistory AS th
    ON e.postid = th.postid AND e.approvaldate = th.creationdate    
  -- RevisionGUID doesn't work; the suggested edit contains the GUID of the revision *before* the edit
  
  LEFT OUTER JOIN posthistory AS h
    ON e.postid = h.postid AND e.approvaldate = h.creationdate
    AND h.posthistorytypeid IN (4, 5)
  
  
  WHERE th.posthistorytypeid = 6
    --AND h.id IS NULL
    AND e.approvaldate >= '2016-12-01'
    AND e.postid = 40356855

Enter Parameters

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