Protected questions

0

Please login or register to vote for this query.

(click on this box to dismiss)

Android Enthusiasts Meta

Q&A about the site for enthusiasts and power users of the Android operating system

SELECT DISTINCT(p1.PostId) AS [Post Link]
  FROM PostHistory AS p1
  LEFT OUTER JOIN PostHistory AS p2
    ON p1.PostId = p2.PostId
   AND p2.PostHistoryTypeId = 20 -- unprotect
   AND p2.CreationDate > p1.CreationDate
  WHERE p1.PostHistoryTypeId = 19 -- protect

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results