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

SQL

select
  actor_name,
  COUNT(*)
from
  logging
  INNER JOIN actor ON log_actor = actor.actor_id
where
  log_timestamp BETWEEN 20221231000000 and 20230165000000
  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")
  and log_action = "approve-i"
  and log_namespace = 0
group by actor_name
having COUNT(*) > 1
ORDER BY COUNT(*) DESC
LIMIT 50;

SQL

Checking query status...