Untitled query #77774

This query is marked as a draft This query has been published by لوقا.
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 
  #CASE WHEN comment_text LIKE '%غير مقبول%' THEN 'quantum block' ELSE 'not quantum block' END AS quantum_block 
from 
  logging 
  inner join actor on actor.actor_name = logging.log_title 
  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 
  and comment_text not LIKE '%غير مقبول%'
group by 
  log_action, 
  MONTH(log_timestamp), 
  if(actor_user IS NULL, 'ip', 'user'), 
  #quantum_block,
  duration_type;

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 
  #CASE WHEN comment_text LIKE '%غير مقبول%' THEN 'quantum block' ELSE 'not quantum block' END AS quantum_block 
from 
  logging 
  inner join actor on actor.actor_name = logging.log_title 
  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 
  #and comment_text not LIKE '%غير مقبول%'
group by 
  log_action, 
  MONTH(log_timestamp), 
  if(actor_user IS NULL, 'ip', 'user'), 
  #quantum_block,
  duration_type;
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.
SQL

Checking query status...
