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

SQL

SELECT actor_name, COUNT(*) 
    FROM revision r
    INNER JOIN actor ON r.rev_actor = actor.actor_id
    INNER JOIN page p on r.rev_page = p.page_id
    WHERE p.page_namespace=0
    and p.page_is_redirect=0
    and r.rev_timestamp between 20221231000000 and 20230165000000
    #and r.rev_timestamp between 20221128000000 and 20221205000000
    and r.rev_parent_id=0
    #AND p.page_id not in (select log_page from logging where log_type like "delete" AND logging.log_timestamp between 20191014000000 and 20191021000000)
     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 actor_name
    having COUNT(*) > 1
    ORDER BY COUNT(*) DESC
    LIMIT 50;

SQL

Checking query status...