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

Fork of database-reports: oldest_active (test) by TheresNoTime-WMF

This query is marked as a draft This query has been published by TheresNoTime-WMF.

SQL

SELECT 
  SQL_SMALL_RESULT 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, 
          actor 
        WHERE 
          rc_timestamp > date_format(
            date_sub(NOW(), INTERVAL 30 DAY), 
            '%Y%m%d%H%i%S'
          ) 
          AND actor_user > 0
      )
      AND user_editcount > 0
      AND user_registration IS NOT NULL
    ORDER BY 
      user_id 
    LIMIT 
      250
  ) AS InnerQuery 
ORDER BY 
  user_registration 
LIMIT 
  200

SQL

Checking query status...