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);
*/


# 171
select * from logging
where log_type like "protect"
and MONTH(log_timestamp) in (10) 
  and YEAR(log_timestamp) = 2023 limit 10;
  
  
select * from protected_titles_compat limit 10 ;

SELECT logging.*,
       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 
WHERE logging.log_type LIKE 'protect'
AND MONTH(logging.log_timestamp) = 10
AND YEAR(logging.log_timestamp) = 2023;
SQL

Checking query status...
