{{NUMBEROFARTICLES}} in fawiki

SQL

use fawiki_p;
select t1.rev_user_text, t1.iwlinks, sum(t2.freq) total
  from
  (
    select rev_user_text, iwlinks, count(*) freq
    from
    (
      select rev_user_text, rev_page, count(ll_lang) iwlinks
      from revision
      join page
        on rev_page = page_id
        and page_namespace = 0
      join langlinks
        on ll_from = rev_page
      where rev_parent_id = 0
      and rev_user <> 0
      and rev_user_text = 'Huji'
      group by rev_page
    ) t
    group by rev_user_text, iwlinks
  ) t1
  join
  (
    select rev_user_text, iwlinks, count(*) freq
    from
    (
      select rev_user_text, rev_page, count(ll_lang) iwlinks
      from revision
      join page
        on rev_page = page_id
        and page_namespace = 0
      join langlinks
        on ll_from = rev_page
      where rev_parent_id = 0
      and rev_user <> 0
      and rev_user_text = 'Huji'
      group by rev_page
    ) t
    group by rev_user_text, iwlinks
  ) t2
    on t2.rev_user_text = t1.rev_user_text
    and t2.iwlinks <= t1.iwlinks
  group by t1.rev_user_text, t1.iwlinks
SQL

Checking query status...
