Users with the most edits of old posts in 2017

0

Please login or register to vote for this query.

(click on this box to dismiss)

TeX - LaTeX

Q&A for users of TeX, LaTeX, ConTeXt, and related typesetting system

-- Reference: https://meta.stackexchange.com/questions/2677/database-schema-documentation-for-the-public-data-dump-and-sede/2678#2678

SELECT 
  a.UserId AS [User Link]
  , COUNT(a.PostId) AS "Count"
  , a.UserId as "UserId"
FROM 
  PostHistory a
  INNER JOIN Posts b
  ON a.PostId = b.id
WHERE 
  a.PostHistoryTypeId = 5 -- Edit Body
  AND b.CreationDate < '2014-01-01'
  AND a.CreationDate >= '2017-01-01'
GROUP BY a.UserId
ORDER BY COUNT(a.PostId) DESC;

Enter Parameters

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