Fork of
Who edits zh:WP:VPP most?
by WhitePhosphorus
This query is marked as a draft
This query has been published
by WhitePhosphorus.
SQL
AخA
USE zhwiki_p;
SELECT actor_name, COUNT(*)
FROM revision
JOIN revision_actor_temp ON revactor_rev = rev_id
JOIN actor ON actor_id = revactor_actor
LEFT JOIN ipblocks ON ipb_user = actor_user
WHERE rev_page = 284591
AND TIMESTAMPDIFF(DAY, rev_timestamp, CURRENT_TIMESTAMP) <= 31
AND NOT ISNULL(actor_user)
AND LOWER(actor_name) NOT LIKE "%bot"
AND (ISNULL(ipb_expiry) OR ipb_expiry <> "infinity")
GROUP BY actor_user
ORDER BY COUNT(*) DESC;
By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.
All SQL code is licensed under CC0 License.