Tag wiki edit count

0

Please login or register to vote for this query.

(click on this box to dismiss)

Rank the users who have edited the most tag-wiki entries

Stack Overflow

Q&A for professional and enthusiast programmers

SELECT
  COUNT (DISTINCT ph.PostId) AS [Edits]
FROM
  PostHistory AS ph
  LEFT OUTER JOIN Posts AS p
    ON ph.PostId = p.Id
WHERE
      p.PostTypeId = 5 -- TagWiki
  AND LEN(RTRIM(ph.Text)) > 0
  AND ph.UserId = ##UserId##

Enter Parameters

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