Untitled query #25614

SQL

USE simplewiki_p;

SELECT page_title, page_id,
COUNT(DISTINCT rev_user) AS editors, 
COUNT(rev_id) AS edits, 
COUNT(rev_timestamp) AS date 
FROM revision JOIN page ON rev_page = page_id
WHERE page_namespace = "0" AND page_is_redirect = "FALSE"
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 "%BOt%" AND rev_user_text NOT LIKE "%BoT%"
AND rev_user_text NOT LIKE "%bOT%" AND rev_user_text NOT LIKE "%BOT%"
GROUP BY page_id 
ORDER BY RAND() LIMIT 10;
SQL

Checking query status...
