Untitled query #42073

SQL

USE arwiki_p;
SELECT
CONCAT("[[مستخدم:",actor_name,"|",actor_name,"]]") AS "المستخدم",
SUM(CASE WHEN rev_timestamp BETWEEN 20200208000000 AND 20200209000000 THEN 1 ELSE 0 END) AS recent_user_editcount1,
SUM(CASE WHEN rev_timestamp BETWEEN 20200209000000 AND 20200210000000 THEN 1 ELSE 0 END) AS recent_user_editcount2,
COUNT(rev_id) AS user_editcount
FROM recentchanges_userindex
INNER JOIN actor ON actor.actor_id = rc_actor
GROUP BY actor_name
ORDER BY recent_user_editcount1 DESC;
SQL

Checking query status...
