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

SQL

SELECT
actor_name,
 COUNT(rev_id) AS q_editcount,
    COUNT(rev_id) AS user_editcount    
    FROM user INNER JOIN revision
    INNER JOIN actor ON revision.rev_actor = actor.actor_id
    INNER JOIN comment_revision on revision.rev_comment_id = comment_id
WHERE rev_timestamp BETWEEN 20221128000000 and 20221205000000
    and comment_text not like ucase (_utf8"%[[ميدياويكي:Gadget-Cat-a-lot|تعديل تصنيفات]]%")  collate utf8_general_ci 
    and comment_text not like ucase (_utf8"%[[Project:أوب|أوب]]%") collate utf8_general_ci 
    and comment_text not like ucase (_utf8"%[[ويكيبيديا:أوب|أوب]]%") collate utf8_general_ci 
     and ucase(actor_name) not like ucase("%BOT") COLLATE utf8_general_ci
  and actor_name not like "%بوت%" collate utf8_general_ci
  and actor_name Not IN (SELECT user_name
                         FROM user_groups
                                  INNER JOIN user ON user_id = ug_user
                         WHERE ug_group = "bot")
    GROUP BY user_name
    ORDER BY q_editcount DESC
LIMIT 20;

SQL

Checking query status...