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
لوقا
.
Toggle Highlighting
SQL
# https://ar.wikipedia.org/w/index.php?title=%D9%88%D9%8A%D9%83%D9%8A%D8%A8%D9%8A%D8%AF%D9%8A%D8%A7:%D8%A5%D8%AD%D8%B5%D8%A7%D8%A1%D8%A7%D8%AA_%D8%A7%D9%84%D8%B4%D9%87%D8%B1&oldid=59981404 SET @start_date = '20221101000000'; SET @end_date = '20221130235959'; # عدد عمليات المنع يشمل فعل المنع فقط لا يشمل التغير مده المنع او الغاء المنع select count(*) as "block count" from logging where log_type= "block" and log_action = "block" and log_timestamp between @start_date and @end_date; # عدد عمليات الحذف يشمل فعل الحذف فقط لا يشمل باقي العمليات مثل الاستراجاع او الاخفاء ..... select count(*) as "delete_count" from logging where log_type= "delete" and log_action = "delete" and log_timestamp between @start_date and @end_date; # عدد المستخدمين الجدد يشمل المستخدمين الذي تم انشاءها بشكل الي او المستخدمين الذي انشاء وفعل الحساب عبر الايميل # نوع الحساب autocreate byemail create create2 select count(*) as "newusers_count" from logging where log_type= "newusers" and log_timestamp between @start_date and @end_date; # يقوم بحساب التعديلات المحذوفه والظاهرة # todo: need some fix here SELECT COUNT(*) as "edit_live_count" FROM revision WHERE rev_timestamp between @start_date and @end_date; SELECT COUNT(*) as "edit_deleted_count" FROM archive WHERE ar_timestamp between @start_date and @end_date; /* select count(*),log_action from logging where log_type= "newusers" and log_timestamp between @start_date and @end_date group by log_action */
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...