Find posts by history event type

0

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): https://meta.stackexchange.com/a/327323/398063

Science Fiction and Fantasy

Q&A for science fiction and fantasy enthusiasts

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

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