Untitled query #25611

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
#JOIN user ON user_id = rev_user
#WHERE page_namespace = "0" AND page_is_redirect = "FALSE"
#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%" AND user_name NOT LIKE "%BOT%"
GROUP BY page_id ORDER BY RAND() LIMIT 10;
SQL

Checking query status...
