Untitled query #42901

SQL

USE yiwiki_p;
#SELECT * FROM page WHERE page_namespace = 0
#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 revision JOIN page ON rev_page = page_id limit 10
#SELECT COUNT(DISTINCT rev_actor), rev_page, FROM revision GROUP by rev_page;
#SELECT COUNT(DISTINCT rev_actor), rev_page, page_title 
#FROM revision JOIN page ON rev_page = page_id
#GROUP by rev_page;
#SELECT COUNT(distinct rev_id), rev_page, page_title
#FROM revision JOIN page on rev_page = page_id
#GROUP by rev_id limit 5;
SELECT COUNT(rev_id) AS editcounts, page_title 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...
