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.* from logging
inner join actor on actor_id = logging.log_title
where log_type like "block"
and MONTH(log_timestamp) in (9,10)  and YEAR(log_timestamp) = 2023;
SQL

Checking query status...
