Untitled query #42771

SQL

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

#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...
