Users by editcount

SQL

use arwiki_p;
SELECT SQL_SMALL_RESULT
        CONCAT(
               '[[User:',user_name,'|',user_name,']]'
              ) AS user_name
        ,user_registration
        ,user_editcount
        FROM
              (
                   SELECT  user_name,user_registration,user_editcount
                   FROM    user
                   WHERE   user_name IN
                   (
                        SELECT DISTINCT rc_user_text
                        FROM    recentchanges
                        WHERE   rc_timestamp>date_format(date_sub(NOW(),INTERVAL 30 DAY),'%Y%m%d%H%i%S')
                        AND     rc_user_text NOT REGEXP '^[0-9]{1,3}\\.[0-9]'
                        AND     rc_user_text NOT REGEXP '\\:.+\\:'
                   )
                   AND user_registration IS NOT NULL
                   ORDER BY user_id
                   LIMIT 250
              ) AS InnerQuery
        ORDER BY user_registration
        LIMIT 200;
SQL

Checking query status...
