Unprotections by user

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

Philosophy Meta

Q&A about the site for those interested in the study of the fundamental nature of knowledge, reality, and existence

--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 = 20
Group by ph.UserId
;

Enter Parameters

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