Untitled query #29881

SQL

USE arwiki_p;
SELECT CONCAT("[[مستخدم:",user_name,"|",user_name,"]]") AS user_name, SUM(CAST(rev.rev_len as signed)-CAST(parent.rev_len as signed)) AS byte_count, COUNT(rev.rev_id) as edit_count
FROM user
JOIN revision rev
ON user_id = rev.rev_user
JOIN revision parent
ON rev.rev_parent_id = parent.rev_id
JOIN page
ON page_id = parent.rev_page
WHERE page_namespace = 0
and rev.rev_comment not like "%رجوع%"
and rev.rev_comment not like "%استرجاع%"
AND rev.rev_timestamp between 20180401000000 and 20180727000000
AND parent.rev_timestamp between 20180401000000 and 20180727000000
and rev.rev_user_text in ('رهف نضال', 'فاطمه نادر شكوكاني', 'Ethar mohammad alrifai', 'Sara mohammad985', 'روان مصطفى عبدالله', 'Israa abu hafith', 'Yasmeeen ali', 'Shahed mryan', 'Reham Ana', 'نور الجغبير', 'براء بجالي', 'اسيل امجد معايعه', 'براءه عطيه', 'Doha ahmad9811', 'Haneennaser', 'شيما***', 'Amany Alaraaby', 'حنين نسور', 'Mahayosef', 'Sabre jamal', 'Noor faisel', 'Riham alkhwaja', 'Haneen al nsour', 'Diala selawy', 'Sarah Esaaf Haddad', 'Israasartawi', 'Amal khalid', 'اية هيثم', 'Danya 229', 'Aya haitham', 'Buthinah alali', 'Reem Arar', 'Malakaldaja', 'مصعب', 'Haya hani', 'Mona dalabe7', 'سندس منصور')
GROUP BY user_name
having byte_count > 0
ORDER BY byte_count DESC;
SQL

Checking query status...
