مستخدمون غير نشطين

SQL

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

SQL

Checking query status...