Untitled query #38555

This query is marked as a draft This query has been published by جار الله.

SQL

use arwiki_p;
SELECT
  creations_ns0.user,
  first_edit.timestamp as first_edit

From (
    SELECT actor_name as user,
      min(rev_timestamp) as timestamp
    FROM revision
    INNER JOIN actor ON revision.rev_actor = actor.actor_id
    GROUP BY
      actor_name
  ) as first_edit ON creations_ns0.user = first_edit.user
WHERE creations_ns0.user NOT IN (SELECT user_name FROM user_groups INNER JOIN user ON user_id = ug_user WHERE ug_group = 'bot')
GROUP BY
  creations_ns0.user
ORDER BY
  article_creations DESC
LIMIT
  500;

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...