Untitled query #17030

SQL

USE huwiki_p;
#Select * FROM revision limit 10;
#SELECT DISTINCT COUNT (rev_user) AS distincteditors, page_title FROM revision JOIN user ON rev_user = user_id JOIN page ON page_id = rev_page WHERE page_namespace = "0" AND rev_user_text NOT LIKE "%bot%" AND rev_user_text NOT LIKE "%BOT%" AND  rev_user_text NOT LIKE "%Bot%" AND rev_user_text NOT LIKE "%BoT%" AND rev_user_text NOT LIKE "%bo T%" AND page_is_redirect = "0" GROUP BY rev_page ORDER BY usercounts DESC LIMIT 50;
SELECT COUNT(DISTINCT rev_user) AS usercounts, page_title FROM revision JOIN page ON rev_page = page_id JOIN user ON rev_user = user_id WHERE 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 "%bo T%" AND page_namespace = "0" AND page_is_redirect = "0" GROUP BY rev_page ORDER BY usercounts DESC;
SQL

Checking query status...
