Untitled query #17380

SQL

use simplewiki_p;

SELECT page_title, page_id, page_len, page_namespace, page_is_redirect, 
COUNT(DISTINCT rev_user) AS NumEditors, COUNT(rev_id) AS NumEdits 

FROM revision JOIN page ON rev_page = page_id 

WHERE LOWER(rev_user_text) NOT LIKE LOWER("%bot%") AND 
rev_user NOT LIKE "0" AND #remove users who have 0 = this indicates that they are not logged in, so they are just IP addresses (if included will distort the results)
#page_namespace = "0" AND 
page_is_redirect = "0" AND
Page_title LIKE ("%Portal%")

GROUP BY page_id 
ORDER BY RAND() 
LIMIT 1000;
SQL

Checking query status...
