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

SQL

AخA
 
use commonswiki_p;
select
  user_name,
  user_editcount,
  ifnull(
    (
      SELECT
        revactor_timestamp
      from
        revision_actor_temp
        inner join actor_revision on revactor_actor = actor_id
      WHERE
        actor_name = user_name
        AND revactor_timestamp > '20200120000000'
      order by
        revactor_timestamp desc
      LIMIT
        1
    ), ifnull(
      (
        SELECT
          revactor_timestamp
        from
          revision_actor_temp
          inner join actor_revision on revactor_actor = actor_id
        WHERE
          actor_name = user_name
          AND revactor_timestamp > '20190101000000'
        order by
          revactor_timestamp desc
        LIMIT
          1
      ),(
        SELECT
          revactor_timestamp
        from
          revision_actor_temp
          inner join actor_revision on revactor_actor = actor_id
        WHERE
          actor_name = user_name
        order by
          revactor_timestamp desc
        LIMIT
          1
      )
    )
  ) 'last edit', groups, reg
from
  (
    select
      user_name,
      user_editcount,
      GROUP_CONCAT(ug1.ug_group SEPARATOR ", ") "groups",
      substr(user_registration, 1, 4) "reg"
    from
      user
      left join user_groups ug1 on ug1.ug_user = user_id
      left join user_groups ug2 on ug2.ug_user = user_id
      and ug2.ug_group = 'bot'
    where
      user_editcount >= 10000
      and ug2.ug_user is null
    group by
      1,
      2,
      4
    order by
      null
  ) t
order by
  user_editcount desc;
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...