أكثر 5 مستخدمين مراجعة للمقالات|ويكيبيديا:مستخدمو الأسبوع الأكثر نشاطا

SQL

SELECT a.actor_name,
       SUM(CASE WHEN r.rev_timestamp BETWEEN 20221128000000 and 20221205000000 THEN 1 ELSE 0 END) AS q_editcount,
       COUNT(r.rev_id) AS user_editcount
FROM revision r
INNER JOIN actor a ON r.rev_actor = a.actor_id
INNER JOIN comment_revision cr ON r.rev_comment_id = cr.comment_id
WHERE r.rev_timestamp >= 20000000000000
  AND cr.comment_text NOT LIKE UPPER(_UTF8"%[[ميدياويكي:Gadget-Cat-a-lot|تعديل تصنيفات]]%") COLLATE utf8_general_ci
  AND cr.comment_text NOT LIKE UPPER(_UTF8"%[[Project:أوب|أوب]]%") COLLATE utf8_general_ci
  AND cr.comment_text NOT LIKE UPPER(_UTF8"%[[ويكيبيديا:أوب|أوب]]%") COLLATE utf8_general_ci
  AND UPPER(a.actor_name) NOT LIKE UPPER("%BOT") COLLATE utf8_general_ci
  AND a.actor_name NOT LIKE "%بوت%" COLLATE utf8_general_ci
  AND a.actor_name NOT IN (SELECT ug.user_name
                           FROM user_groups ug
                           INNER JOIN user u ON ug.user_id = u.ug_user
                           WHERE ug.ug_group = "bot")
GROUP BY a.actor_name
ORDER BY q_editcount DESC
LIMIT 20;

SQL

Checking query status...