Untitled query #88382

SQL

SELECT DISTINCT
    actor_name AS "اسم المستخدم",
    COUNT(rev_id) AS "عدد التعديلات"
FROM
    revision_userindex
JOIN
    actor ON revision_userindex.rev_actor = actor.actor_id
JOIN
    user_groups ON actor.actor_user = user_groups.ug_user
WHERE
    rev_timestamp > DATE_FORMAT(DATE_SUB(NOW(), INTERVAL 15 DAY), '%Y%m%d%H%i%s')
    AND user_groups.ug_group IN ('autoreviewer', 'editor') -- المجموعات المحددة
GROUP BY
    actor_name
ORDER BY
    COUNT(rev_id) DESC
LIMIT 500; -- حد أقصى لعدد النتائج
SQL

Checking query status...
