Users with most edits in article namespace on pawiki (2018)

This query is marked as a draft This query has been published by Nivas10798.

SQL

WITH Edits AS (SELECT
   DISTINCT actor_name,
   COUNT(rev_id) AS edit_counts
FROM
   revision
JOIN
   actor
   ON rev_actor = actor_id
JOIN 
   user
   ON actor_user = user_id
JOIN
   user_groups
   ON ug_user = user_id
JOIN 
   page
   ON rev_page = page_id

WHERE
   YEAR(rev_timestamp) = 2018
   AND NOT actor_user IS NULL
   AND page_namespace = 0

GROUP BY
               actor_name)
SELECT * FROM Edits
ORDER BY edit_counts DESC

By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.

Submit Query Stop Query

All SQL code is licensed under CC0 License.

SQL

Checking query status...