Untitled query #77774

SQL

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

/*
select count(*) as "count" from logging
where log_type like "block"
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 "block"
and MONTH(log_timestamp) in (9,10)  and YEAR(log_timestamp) = 2023
group by log_action,MONTH(log_timestamp);
*/

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

/*
select count(*) as "count",log_action,MONTH(log_timestamp) as "month", if(actor_user IS NULL,'ip','user') as "user_type" from logging
inner join actor on actor.actor_name = logging.log_title
where log_type like "block"
and MONTH(log_timestamp) in (9,10)  and YEAR(log_timestamp) = 2023
group by log_action,MONTH(log_timestamp),if(actor_user IS NULL,'ip','user');

*/

/**
جميع عمليات المنع خلال شهر ٩ و ١٠
حسب نوع المنع (الغاء منع - منع - تجديد منع)
مع توع المستخدم تم التعامل معه
مع نوع المنع دائما او غير دائم 
**/
select 
  count(*) as "count", 
  log_action, 
  MONTH(log_timestamp) as "month", 
  if(actor_user IS NULL, 'ip', 'user') as "user_type", 
  CASE WHEN log_params LIKE '%infinity%' THEN 'infinity' ELSE 'not infinity' END AS duration_type 
from 
  logging 
  inner join actor on actor.actor_name = logging.log_title 
where 
  log_type like "block" 
  and MONTH(log_timestamp) in (9, 10) 
  and YEAR(log_timestamp) = 2023 
group by 
  log_action, 
  MONTH(log_timestamp), 
  if(actor_user IS NULL, 'ip', 'user'), 
  duration_type;


select 
  CASE WHEN comment_text LIKE '%غير مقبول%' THEN 'quantum block' ELSE 'not quantum block' END AS quantum_block 
from logging
inner join  comment on comment.comment_id = logging.log_comment_id
where log_type like "block"
and MONTH(log_timestamp) in (9,10)  and YEAR(log_timestamp) = 2023;
SQL

Checking query status...
