Current length of articles by User:AbDaryaee

SQL

use fawiki_p;
select
  user_name,
  str_to_date(left(min(rev_timestamp), 8), '%Y%m%d'),
  sum(if(page_len between 0 and 2048, 1, 0)),
  sum(if(page_len between 2048 and 15 * 1024, 1, 0)),
  sum(if(page_len between 15 * 1024 and 70 * 1024, 1, 0)),
  sum(if(page_len > 70 * 1024, 1, 0)), count(rev_first) tot
from revision_userindex r
join (
  select
    min(rev_id) as rev_first,
    rev_page
  from revision_userindex
  where rev_user = 719350 -- AbDaryaee
  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
where
  page_namespace = 0
  and page_is_redirect = 0
  and rev_user = 719350 -- AbDaryaee
group by rev_user
order by tot
SQL

Checking query status...
