Untitled query #16929

SQL

USE simplewiki_p;
DESCRIBE page;
#SELECT page_title, page_id, COUNT(DISTINCT rev_user) AS NumEditors, COUNT(rev_id) AS NumEdits, page_len, page_is_redirect FROM revision JOIN page ON rev_page = page_id WHERE rev_user NOT LIKE "%bot%" AND rev_user NOT LIKE "%Bot%" AND rev_user NOT LIKE "%bOt%"AND rev_user NOT LIKE "%boT%"AND rev_user NOT LIKE "%BOt%" AND rev_user NOT LIKE "%BoT%" AND rev_user NOT LIKE "%bOT%" AND rev_user NOT LIKE "%BOT%" and page_namespace = "0" GROUP by page_id #ORDER BY RAND() LIMIT 1000;
SQL

Checking query status...
