Untitled query #34093

SQL

USE simplewiki_p;
SELECT COUNT(DISTINCT rev_user) AS usercounts, page_title, page_len,
COUNT(rev_id) AS editcounts
FROM revision JOIN page ON page_id = rev_page
JOIN user ON user_id = rev_user 
JOIN redirect ON rd_from = page_id
WHERE #rd_from = page_id AND
user_name NOT LIKE "%bot%" AND user_name NOT LIKE "%Bot%"
AND user_name NOT LIKE "%bOt%" AND user_name NOT LIKE "%boT%"
AND user_name NOT LIKE "%BOt%" AND user_name NOT LIKE "%BoT%"
AND user_name NOT LIKE "%bOT%" AND user_name NOT LIKE "%BOT%" 
GROUP BY rev_page ORDER BY usercounts LIMIT 10;
SQL

Checking query status...
