Untitled query #20542

SQL

USE arwiki_p;
SELECT rev_user_text AS  المستخدم, COUNT(rev_id) AS عدد_التعديلات FROM revision
JOIN page on page_id = rev_page 
WHERE rev_timestamp > 20170726000000 
AND rev_timestamp < 20170726235959
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...
