Untitled query #75613

SQL

select concat("{{مس|",user_name,"}}") as "اسم المستخدم", user_editcount as "عدد التعديلات", ug_group as "الصلاحية"
from user
inner join user_groups
on ug_user = user_id
where (ug_group like "editor" or ug_group like "autoreview"   or ug_group like "bot" or ug_group like "uploader")
and user_id not in (select distinct rev_user from revision where rev_timestamp like "2023%" and rev_user <> 0)
and user_id not in (select distinct rev_user from revision where rev_timestamp like "2022%" and rev_user <> 0);
SQL

Checking query status...
