Untitled query #16601

SQL

USE eswiki_p;
#SHOW TABLES;
#DESCRIBE page;
#SELECT rev_page FROM revision ORDER by rev_timestamp DESC 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"; # counts amount of times that a revision in the
# revisions table shows up with that rev_user

# This puts everything that has the same rev_user together (like a groupby) and then it counts:

SELECT COUNT(rev_id) FROM revision GROUP by rev_user LIMIT 10;

# This selects and counts revision and gives a name to it (editcounts) and then groups users, ordering by the editcounts
# that I assigned

SELECT COUNT(rev_id) AS editcounts FROM revision GROUP by rev_user ORDER BY editcounts DESC LIMIT 10;
SQL

Checking query status...
