การแก้ไขโดยชุมชนนับอันดับตามผู้ใช้ ไม่จำเป็นต้องใช้ตารางทั้งหมด
Community Edits Count Rank by User.It is not neccessary to use all the tables.
 PostHistoryTypes:  Id [ number]  Name [ text] 
WITH RankedUsers AS (SELECT RANK() OVER (ORDER BY COUNT(DISTINCT ph.PostId) DESC) AS Rank, ph.UserId, COUNT(DISTINCT ph.PostId) AS EditCount FROM PostHistory AS ph JOIN Posts AS p ON ph.PostId = p.Id AND ph.UserId != p.OwnerUserId WHERE PostHistoryTypeId IN (4, 5) GROUP BY ph.UserId) SELECT Rank, UserId AS "user_link", EditCount FROM RankedUsers WHERE Rank < 100 OR UserId = '##UserId##' ORDER BY Rank