faelist equivalent

SQL

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;
SQL

Checking query status...
