use arwiki_p;

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 "2019%" and rev_user <> 0)

and user_id not in (select distinct rev_user from revision where rev_timestamp like "2018%" and rev_user <> 0);