most active Dagbani Wikipedia editors in the recent week

Fork of most active Dagbani Wikipedia editors in the recent week by Masssly

This query is marked as a draft This query has been published by EWikiLearner.

SQL

SET @start_time = '20220101'; -- 1 Jan 2022
SET @end_time = '20221001'; -- 1 Oct 2022
SET @cx_tag_id = (
    SELECT ctd_id
    FROM change_tag_def
    WHERE ctd_name = 'contenttranslation'
);
WITH SELECT ROW_NUMBER() OVER (ORDER BY sl DESC) rank, actor_name, sl FROM
(SELECT actor_name, user_id, COUNT(*) sl FROM revision
JOIN actor ON rev_actor = actor_id
JOIN `user` ON actor_user = user_id
WHERE rev_timestamp > DATE_FORMAT(NOW() - INTERVAL 7 DAY, '%Y%m%d%H%i%s')
GROUP BY actor_name
) aaa
WHERE NOT EXISTS (SELECT * FROM user_groups WHERE ug_user = user_id AND ug_group = 'bot')
ORDER BY sl DESC

SQL

Checking query status...