تقرير اليوم

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")
and rev_user not 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 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");*/

/*select count(*) as "عدد المستخدمين المسجلين"
from user
where user_registration between SUBDATE(NOW(),1) and NOW();
*/

select count(rev_id) as "عدد المستخدمين المسجلين الذين قاموا بتعديل واحد على الأقل"
from user
inner join revision
on rev_user = user_id 
where user_registration between SUBDATE(NOW(),1) and NOW();
SQL

Checking query status...
