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
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; 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...