Untitled query #42073

SQL

USE arwiki_p;
SELECT CONCAT(user_name) AS "المستخدم", SUM(CASE WHEN rev_timestamp BETWEEN 20200209000000 AND 20200210000000 THEN 1 ELSE 0 END) AS recent_user_editcount,
    COUNT(rev_id) AS user_editcount
    FROM user INNER JOIN revision_userindex ON revision_userindex.rev_id = user.user_id
    WHERE rev_timestamp >= 20000000000000
    and ucase (user_name) not like ucase (_utf8"%BOT") COLLATE utf8_general_ci
    and user_name not like _utf8"بوت %" collate utf8_general_ci
    and user_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 recent_user_editcount DESC
    LIMIT  50;
SQL

Checking query status...
