Utenti di Wikipedia in italiano con più contributi

SQL

/* SET @itwikiuserpage = ( SELECT GROUP_CONCAT(TO_BASE64(user_name)) AS u
          FROM user
          RIGHT JOIN page -- Check that a local userpage exists as well
          ON page_namespace = 2
          AND REPLACE(page_title, '_', ' ') = user_name
          AND user_editcount > 200 ); */
SELECT user_name, user_editcount
FROM user u
JOIN centralauth_p.globaluser gu
ON u.user_name = gu.gu_name
AND gu.gu_locked = 0
WHERE u.user_editcount >= @min
AND u.user_editcount <= @max
AND u.user_id NOT IN (
  SELECT ipb_user
  FROM ipblocks
  WHERE ipb_user > 0
)
AND u.user_id NOT IN (
  SELECT ug_user
  FROM user_groups
  WHERE ug_group = "bot"
)
AND u.user_name NOT RLIKE '.*[Bb]ot.*';

SQL

Checking query status...