Untitled query #42771

SQL

USE lawiki_p;
SELECT * FROM revision LIMIT 10;
# SELECT DISTINCT rev_page FROM revision;
# SELECT rev_page,
COUNT (DISTINCT rev_actor) AS u
FROM revision
GROUP BY rev_page
LIMIT 10;



#COUNT (DISTINCT rev_actor) AS u FROM revision
#GROUP BY rev_page;

#COUNT(DISTINCT rev_actor) FROM revision
#GROUP BY rev_actor
#LIMIT 10;

# COUNT(rev_id) AS editcounts FROM revision GROUP by rev_actor ORDER BY editcounts DESC LIMIT 10;
# SELECT COUNT (DISTINCT rev_page) AS pages, COUNT(DISTINCT rev_actor) AS authorcount FROM revision;

# SELECT COUNT(DISTINCT rev_actor) AS usercounts, COUNT(rev_id) editcounts FROM revision 
# JOIN page ON page_id = rev_page group by rev_page LIMIT 10;
SQL

Checking query status...
