This query is marked as a draft This query has been published by MZMcBride.

SQL

AخA
 
SELECT
  user_id,
  user_name,
  user_registration,
  user_editcount
FROM
  (
    SELECT
      user_id,
      user_name,
      user_registration,
      user_editcount
    FROM
      user
    WHERE
      user_id IN (
        SELECT
          DISTINCT actor_user
        FROM
          actor_recentchanges
        WHERE
          actor_user > 0
      )
      AND user_registration IS NOT NULL
    ORDER BY
      user_id
    LIMIT
      5000
  ) AS InnerQuery
ORDER BY
  user_registration
LIMIT
  2000
By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.
Submit Query
All SQL code is licensed under CC0 License.

Checking query status...