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

Role-playing Games

Q&A for gamemasters and players of tabletop, paper-and-pencil role-playing games

--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 to meta site
loading Hold tight while we fetch your results