Calculate the h-index for fawiki editors

SQL

use fawiki_p;
select rev_user_text, max(iwlinks) as h_index
from
(
  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
      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
      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
) h
where
  total >= iwlinks
  and iwlinks > 5
group by rev_user_text
SQL

Checking query status...
