تقرير اليوم

This query is marked as a draft This query has been published by ASammour.
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(*) as "عدد المستخدمين المسجلين الذين قاموا بتعديل واحد على الأقل"
from user
where user_registration between SUBDATE(NOW(),1) and NOW()
and user_editcount> 1;

select Count(Distinct rev_user) as "عدد المستخدمين الذين قاموا بالتعديل"
from revision
where rev_timestamp between SUBDATE(NOW(),1) and NOW();*/
/*
select user_name as "قائمة المستخدمين الجدد"
from user
where user_registration between SUBDATE(NOW(),1) and NOW();

select count(*) as "عدد المقالات الجديدة"
from page
inner join revision
on page_id = rev_page
where page_namespace = 0
and page_is_redirect = 0
and rev_timestamp between SUBDATE(NOW(),1) and NOW()
and rev_parent_id = 0;

select count(*) as "عدد القوالب الجديدة"
from page
inner join revision
on page_id = rev_page
where page_namespace = 10
and page_is_redirect = 0
and rev_timestamp between SUBDATE(NOW(),1) and NOW()
and rev_parent_id = 0;


select count(*) as "عدد التصنيفات الجديدة"
from page
inner join revision
on page_id = rev_page
where page_namespace = 14
and page_is_redirect = 0
and rev_timestamp between SUBDATE(NOW(),1) and NOW()
and rev_parent_id = 0;
*/
select log_title as "عدد الصور الجديدة"
from logging
where log_timestamp between SUBDATE(NOW(),1) and NOW()
and log_type = "upload";
By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.
Submit Query Stop Query
All SQL code is licensed under CC0 License.
SQL

Checking query status...
