కొత్త వాడుకరులు reg.users/name/edit count so far

SQL

use tewiki_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)="2023")
order by user_editcount desc, user_registration desc

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)="2022")
order by user_editcount desc, user_registration desc

SQL

Checking query status...