database-reports: oldest_active (test) - user_editcount > 0

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 user_registration IS NOT NULL
    ORDER BY 
      user_id 
    LIMIT 
      250
  ) AS InnerQuery
WHERE user_editcount > 0
ORDER BY 
  user_registration 
LIMIT 
  200
SQL

Checking query status...
