Untitled query #85175

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

SQL

SELECT actor_name AS user, COUNT(DISTINCT rev_id) AS edits
FROM revision
JOIN actor ON (rev_actor = actor_id)
JOIN page ON (rev_page = page_id)
JOIN user_groups ON (actor_user = ug_user)
WHERE page_title LIKE "مراجعة_الزملاء/%"
AND ug_group = "reviewer"
AND rev_timestamp >= DATE_SUB(NOW(), INTERVAL 12 MONTH)
GROUP BY actor_name
ORDER BY edits 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...