Untitled query #16602

SQL

USE afwiki_p;

#SHOW TABLES;

SELECT rev_page, page_title,page_len, page_namespace, page_is_redirect,
COUNT(DISTINCT rev_user) AS usercounts, COUNT(rev_id) editcounts 
FROM revision JOIN page ON page_id = rev_page 
WHERE page_namespace = "1"
group by page_id 
ORDER BY RAND()
SELECT COUNT(rev_id) AS editcounts, rev_user, user_name, user_registration 
FROM revision JOIN user ON user_id = rev_user 
WHERE user_name NOT LIKE "%bot%" AND user_name NOT LIKE "%Bot%" 
GROUP by rev_user ORDER BY editcounts DESC LIMIT 10;

LIMIT 100;
SQL

Checking query status...
