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 actor.*, if(actor_user == 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;
SQL

Checking query status...
