تقرير اليوم

SQL

use arwiki_p;
/*select count(*) as "عدد التعديلات"
from revision
where rev_timestamp between SUBDATE(NOW(),1) and NOW();*/


/*select count(*) as "إنشاء الصفحات"
from revision
where rev_timestamp between SUBDATE(NOW(),1) and NOW()
and rev_parent_id = 0;*/


select count(*) as "المجهولون"
from revision
where rev_timestamp between SUBDATE(NOW(),1) and NOW()
and rev_user= 0;


select count(*) as "المحررون"
from revision
where rev_timestamp between SUBDATE(NOW(),1) and NOW()
and rev_user in (select ug_user from user_groups where ug_user = rev_user and ug_group = "editor");

select count(*) as "المراجعون تلقائيا"
from revision
where rev_timestamp between SUBDATE(NOW(),1) and NOW()
and rev_user in (select ug_user from user_groups where ug_user = rev_user and ug_group = "autoreview");

select count(*) as "البوتات"
from revision
where rev_timestamp between SUBDATE(NOW(),1) and NOW()
and rev_user in (select ug_user from user_groups where ug_user = rev_user and ug_group = "bot");


select count(*) as "غير ذلك"
from revision
where rev_timestamp between SUBDATE(NOW(),1) and NOW()
and rev_user not in (select ug_user from user_groups where ug_user = rev_user and ug_group = "bot")
and rev_user not in (select ug_user from user_groups where ug_user = rev_user and ug_group = "autoreview")
and rev_user not in (select ug_user from user_groups where ug_user = rev_user and ug_group = "editor");
SQL

Checking query status...
