ckb Query Test

SQL

SELECT CONCAT( '[[User:',user_name,'|',user_name,']]' ) AS user_name,
                        date_format(user_registration, '%Y-%m-%d %H-%i-%S'),
                        user_editcount
                    FROM (
                        SELECT user_name, user_registration, user_editcount
                        FROM user
                        WHERE user_id IN (
                            SELECT DISTINCT actor_user
                            FROM recentchanges_userindex
                            JOIN actor_recentchanges ON actor_id = rc_actor
                            WHERE rc_timestamp > date_format( date_sub(NOW(), INTERVAL 30 DAY), '%Y%m%d%H%i%S' )
                            AND actor_user > 0
                            AND rc_bot = 0
                        )
                        AND user_registration IS NOT NULL
                        ORDER BY user_id
                        LIMIT 500
                    ) AS InnerQuery
                    ORDER BY user_registration
                    LIMIT 100
SQL

Checking query status...
