Toggle navigation
Home
New Query
Recent Queries
Discuss
Database tables
Database names
MediaWiki
Wikibase
Replicas browser and optimizer
Login
History
Fork
This query is marked as a draft
This query has been published
by
ASammour
.
Toggle Highlighting
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 count(*) 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
.
Checking query status...