Untitled query #16917

SQL

#USE simplewiki_p;
#SELECT COUNT(rev_id) AS editcounts, rev_user, user_name, user_registration, MAX(rev_timestamp) AS maxtime, MIN(rev_timestamp) AS mintime
#FROM revision JOIN user ON user_id = rev_user
#JOIN page ON page_id  = rev_page
#WHERE user_name NOT LIKE "%bot%" AND user_name NOT LIKE "%Bot%" AND page_namespace = "0"
#GROUP by rev_user
#LIMIT 10000;
USE simplewiki_p;
SELECT rev_page, COUNT(DISTINCT (rev_user)) AS U, COUNT (rev_id) AS E, page_length AS L
FROM revision
#WHERE page_is_redirect = "0"
JOIN page ON page_id = rev_page
GROUP by rev_page
LIMIT 10;
#SHOW TABLES
SQL

Checking query status...
