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;
SQL

Checking query status...
