Untitled query #70775

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

SQL

SELECT
  user_name,
  user_registration,
  user_editcount
FROM
  (
    SELECT
      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
      2000
  ) 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 Stop Query

All SQL code is licensed under CC0 License.

SQL

Checking query status...