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

SQL

select actor_name, COUNT(*)
    from logging
    INNER JOIN actor ON actor.actor_id = logging.log_actor
    where log_timestamp BETWEEN 20221231000000 AND 20230165000000
    and log_action = "approve"
    and log_namespace = 0
 
    and actor_name Not IN (SELECT user_name FROM user_groups INNER JOIN user ON user_id = ug_user WHERE ug_group = 'bot') 
    and ucase (actor_name) not like ucase (_utf8"%BOT") COLLATE utf8_general_ci
    and actor_name not like _utf8"بوت %" collate utf8_general_ci
 
    group by logging.log_actor
    having COUNT(*)>1
    ORDER BY COUNT(*) DESC
	LIMIT 10;

SQL

Checking query status...