Untitled query #25343

SQL

USE itwiki_p;
SELECT page_id, page_title, page_namespace,
COUNT(DISTINCT rev_user) AS U, COUNT(rev_id) AS E,
               page_len AS L, rev_id, rev_page, rev_user, user_name 
FROM revision JOIN page ON rev_page = page_id 
JOIN user ON rev_user= user_id
WHERE page_is_redirect = 0     AND page_namespace = 0       
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 page_id ORDER BY RAND() LIMIT 10;
SQL

Checking query status...
