SELECT

CONCAT("[[مستخدم:",actor_name,"|",actor_name,"]]") AS "المستخدم",

SUM(CASE WHEN rev_timestamp BETWEEN 20240203000000 AND 20240803000000 THEN 1 ELSE 0 END) AS recent_user_editcount,

COUNT(rev_id) AS user_editcount

FROM revision

    /*INNER JOIN user ON  user_id=rev_user /* ربط جدول المستخدمين بجدول الأفعال*/

    INNER JOIN actor on rev_actor = actor_id

​

    WHERE rev_timestamp >= 20240000000000

GROUP BY actor_name

ORDER BY recent_user_editcount DESC

LIMIT 100;