Untitled query #77781

SQL

/**
جميع الحمايه المنع خلال شهر ٩ و ١٠
**/
/*

select count(*) as "count" from logging
where log_type like "protect"
and MONTH(log_timestamp) in (9,10)  and YEAR(log_timestamp) = 2023;
*/

/**
جميع عمليات الحمايه خلال شهر ٩ و ١٠
حسب نوع الحمايه (الغاء حمايه - حمايه - تجديد حمايه)
**/

/*
select count(*) as "count",log_action,MONTH(log_timestamp) as "month" from logging
where log_type like "protect"
and MONTH(log_timestamp) in (9,10)  and YEAR(log_timestamp) = 2023
group by log_action,MONTH(log_timestamp);
*/

/**
جميع عمليات الحمايه خلال شهر ٩ و ١٠
حسب نوع الحمايه (الغاء حمايه - حمايه - تجديد حمايه)
مع نوع الحمايه 
=================================
يحتوي هذا الاستعلام علي نسبه خطا بسيطه بسبب ان جدول 
protected_titles_compat
يحفظ الصفحات المحميه في الوقت الحالي فقط 
=================================
**/


select count(*) as "count",log_action,MONTH(log_timestamp) as "month", 
 CASE
           WHEN protected_titles_compat.pt_expiry = 'infinity' THEN 'infinity'
           ELSE 'not infinity'
       END AS protection_status

from logging
LEFT JOIN protected_titles_compat ON logging.log_title = protected_titles_compat.pt_title and logging.log_namespace = protected_titles_compat.pt_namespace
WHERE logging.log_type LIKE 'protect'
and MONTH(log_timestamp) in (9,10)  and YEAR(log_timestamp) = 2023
# to hide lokasBot logs
and log_actor not in (3532199)
group by log_action,MONTH(log_timestamp),protection_status;
SQL

Checking query status...
