Untitled query #16587

SQL

USE simplewiki_p;
#DESCRIBE revision;
#DESCRIBE page;
#SELECT rev_page FROM revision ORDER by rev_timestamp ASC limit 10;
#SELECT page_id FROM page LIMIT 10;
#SELECT rev_page, page_title, rev_timestamp FROM revision JOIN page ON rev_page = page_id ORDER by rev_timestamp ASC limit 10
#SELECT * FROM user limit 10;

#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) FROM revision WHERE rev_user = "66249";
SELECT COUNT(rev_id), rev_user FROM revision GROUP by rev_user LIMIT 10;
#SELECT COUNT(rev_id) AS editcounts FROM revision GROUP by rev_user ORDER BY editcounts DESC LIMIT 10;
SQL

Checking query status...
