Untitled query #34941

SQL

use arwiki_p;
SELECT DISTINCT rev_user_text, COUNT(DISTINCT rev_id) AS Numer_of_Editedarticles, COUNT(rev_timestamp) AS Number_of_Edits,
SUM(rev_len) AS Size_of_Edits  FROM revision
JOIN page ON page_id = rev_page
 WHERE page_namespace = 0
 AND rev_user_text NOT IN
(SELECT pl_title FROM pagelinks WHERE pl_from = 3002292)
AND rev_user_text NOT IN 
(SELECT user_name FROM user_groups 
INNER JOIN user ON user_id = ug_user 
WHERE ug_group = 'bot')
GROUP BY rev_user_text
ORDER BY Size_of_Edits DESC
LIMIT 50;
SQL

Checking query status...
