Untitled query #16951

SQL

USE simplewiki_p;
#DESCRIBE page;
SELECT a.page_id, b.page_id,
a.page_title, b.page_title,
a.page_len, b.page_len, 
a.page_namespace, b.page_name_space, 
a.page_is_redirect, b.page_is_redirect,
COUNT(DISTINCT rev_user) AS NumEditors, 
COUNT(rev_id) AS NumEdits
FROM page a OUTER JOIN page b ON a.page_id = b.page_id
JOIN revision ON rev_page = a.page_id 
WHERE LOWER(rev_user) NOT LIKE LOWER("%bot%") 
#AND a.page_is_redirect = "0" AND a.page_is_redirect = "1" 
AND a.page_namespace = "0" AND b.page_namespace="1" 
GROUP by a.page_id ORDER BY RAND() LIMIT 1000;
SQL

Checking query status...
