Untitled query #14707

SQL

USE arwiki_p;
SELECT
CONCAT("[[مستخدم:",user_name,"|",user_name,"]]") AS "المستخدم",DATE_FORMAT(user_registration, "%Y-%m-%d") as registration_date,
SUM(CASE WHEN rev_timestamp BETWEEN 20161101000000 AND 20161201000000 THEN 1 ELSE 0 END) AS recent_user_editcount,
COUNT(rev_id) AS user_editcount
FROM user INNER JOIN revision
ON revision.rev_user = user.user_id
WHERE rev_timestamp >= 20000000000000
and  user_id not in (select ug_user from user_groups)
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_editcount > 500
GROUP BY user_name
having COUNT(*)>1
ORDER BY recent_user_editcount DESC;
SQL

Checking query status...
