Find posts by history event type


Please login or register to vote for this query.

(click on this box to dismiss)

The various events' IDs can be found in the PostHistoryType database, or in this Meta answer if you want it sorted by who can trigger them (mod powers, CM powers, anyone, etc):


Q&A for people interested in governments, policies, and political processes

DECLARE @HistoryEventType int = ##HistoryEventType##

SELECT ph.PostId as [Post Link], pht.Name
FROM PostHistory ph JOIN PostHistoryTypes pht ON ph.PostHistoryTypeId = pht.Id
WHERE ph.PostHistoryTypeId=@HistoryEventType

Enter Parameters

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