Untitled query #85175

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)
AND actor_user IN (
    SELECT actor_id
    FROM actor
    JOIN logging ON log_title = actor_name
    WHERE log_type = 'rights'
    AND log_action = 'rights'
    AND log_params LIKE '%"reviewer"%'
    AND log_timestamp <= DATE_SUB(NOW(), INTERVAL 12 MONTH)
)
GROUP BY actor_name
ORDER BY edits DESC;
SQL

Checking query status...
