Untitled query #7841

SQL

#SHOW DATABASES;

USE simplewiki_p;
#SHOW TABLES;
#DESCRIBE page;
#SELECT rev_page, page_title, rev_timestamp, rev_user, user_name FROM revision JOIN page ON rev_page=page_id JOIN user ON rev_user=user_id ORDER by rev_timestamp ASC limit 10
#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;
SELECT COUNT(rev_id) AS editcounts, page_tile FROM revision JOIN user ON rev_user=user_id JOIN page ON page_id=rev_page WHERE user_name="Auntof6" and page_namespace="0" GROUP BY rev_page ORDER BY editcounts DESC LIMIT 10;
SQL

Checking query status...
