Untitled query #88384

SQL

SELECT DISTINCT
    CONCAT("نقاش المستخدم:", actor_name) 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
LEFT JOIN
    (SELECT ug_user FROM user_groups WHERE ug_group = 'bot') AS bots
    ON actor.actor_user = bots.ug_user
WHERE
    rev_timestamp > DATE_FORMAT(DATE_SUB(NOW(), INTERVAL 50 DAY), '%Y%m%d%H%i%s')
    AND bots.ug_user IS NULL -- استثناء البوتات
    AND user_groups.ug_group IN ('autoreviewer', 'editor') -- المجموعات المحددة
GROUP BY
    actor_name
ORDER BY
    COUNT(rev_id) DESC
LIMIT 500; -- حد أقصى لعدد النتائج
SQL

Checking query status...
