Untitled query #67166

SQL

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
                                rc_timestamp IS NOT NULL
                )

                ORDER BY
                      user_id
                LIMIT 200
        ) AS InnerQuery
ORDER BY user_registration
SQL

Checking query status...
