use dewiki_p;

select user_name, user_editcount from user

where user_id in (select actor_user from actor, logging 

                  where log_actor = actor_id

                  and `log_type` = 'newusers' /* exclude proxy registrations */

                  AND `log_action` = 'create' /* only include self-created users, exclude attached and proxy-registered users */

                  and substr(log_timestamp,1,4)="2020")

order by user_editcount desc, user_registration desc