A magyar Wikipédia mérete

SQL

use huwiki_p;
/*SELECT COUNT(*), ll_from
	FROM langlinks
    GROUP BY 2
    ORDER BY 1 DESC
    LIMIT 100;*/

select sum(cnt=0 or cnt is null) 0_edits, sum(cnt>0 and cnt<=10) 1_10_edits, sum(cnt>10 and cnt<=100) 11_100_edits, sum(cnt>100) 101_plus_edits from user join user_groups on ug_group = 'sysop' and ug_user = user_id left join (select rev_user_text user, count(*) cnt from page straight_join revision on rev_page = page_id where page_namespace = 8 and page_title rlike '^.*\.(css|js)$' group 
by rev_user_text) edits on user = user_name;
SQL

Checking query status...
