Diako1971 - Quarry

SQL

use fawiki_p;
select user_name, str_to_date(left(min(rev_timestamp), 8), '%Y%m%d'),
sum(if(rev_len between 0 and 2048, 1, 0)), sum(if(rev_len between 2048 and 15 * 1024, 1, 0)),
sum(if(rev_len between 15 * 1024 and 70 * 1024, 1, 0)), sum(if(rev_len > 70 * 1024, 1, 0)),
count(rev_first) tot 
from revision r
join (select min(rev_id) rev_first, rev_page from revision group by rev_page) f
on r.rev_id = f.rev_first
join page
on page_id = r.rev_page
join user
on rev_user = user_id
left join user_groups
on rev_user = ug_user and ug_group = 'bot'
where rev_user > 0
and ug_group is null
and page_namespace = 0
and page_is_redirect = 0
-- 
and user_name = 'Diako1971'
and page_title = 'مقاومت_فرانسه'
-- 
group by rev_user
order by tot desc
limit 200;
SQL

Checking query status...
