Protected questions


Please login or register to vote for this query.

(click on this box to dismiss)


Q&A for Bitcoin crypto-currency enthusiasts

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

Switch sites:
loading Hold tight while we fetch your results