SELECT ph.UserId AS [User Link], COUNT(ph.UserId) AS Pro...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Selects all user IDs who have ever protected questions and counts how many questions they have protected

Meta Stack Exchange

Q&A for meta-discussion of the Stack Exchange family of Q&A websites

--Selects all user IDs who have ever protected questions and counts how many questions they have protected

SELECT ph.UserId AS [User Link], COUNT(ph.UserId) AS Protect_by_user
  FROM PostHistory ph
  WHERE ph.PostHistoryTypeId = 19
Group by ph.UserId
;

Enter Parameters

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