970901 mp1 # of DAB pages

SQL

SELECT
  user_name,
  MAX(iwlinks) AS h_index
FROM
(
  SELECT
    t1.rev_user,
    t1.iwlinks,
    SUM(t2.freq) AS total
  FROM
  (
    SELECT
      rev_user,
      iwlinks,
      COUNT(*) AS freq
    FROM
    (
      SELECT
        rev_user,
        rev_page,
        COUNT(ll_lang) AS 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,
      iwlinks
  ) t1
  JOIN
  (
    SELECT
      rev_user,
      iwlinks,
      COUNT(*) AS freq
    FROM
    (
      SELECT
        rev_user,
        rev_page,
        COUNT(ll_lang) AS 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, iwlinks
  ) t2
    ON t2.rev_user = t1.rev_user
    AND t2.iwlinks >= t1.iwlinks
  GROUP BY
    t1.rev_user,
    t1.iwlinks
) h
JOIN user
  ON rev_user = user_id
LEFT JOIN user_groups
  ON ug_user = rev_user
  AND ug_group = 'bot'
WHERE
  total >= iwlinks
  AND iwlinks > 5
  AND ug_user IS NULL
GROUP BY rev_user
ORDER BY h_index DESC
SQL

Checking query status...
