Untitled query #20542

SQL

USE arwiki_p;
SELECT rev_user_text AS  المستخدم, CONCAT ('مجموع_عدد_التعديلات: ',COUNT(rev_id)) AS عدد_التعديلات FROM revision
JOIN page on page_id = rev_page 
WHERE rev_timestamp > 20160101000000 
AND rev_timestamp < 20160731235959
AND rev_user_text NOT IN (SELECT user_name FROM user_groups 
INNER JOIN user ON user_id = ug_user 
WHERE ug_group = 'bot')
AND rev_user_text IN (SELECT user_name FROM user_groups 
INNER JOIN user ON user_id = ug_user 
WHERE ug_group = 'sysop')
GROUP BY rev_user_text
ORDER BY COUNT(rev_id) DESC;
SQL

Checking query status...
