use arwiki_p;

SET @start_date = '20221201000000';

SET @end_date = '20230101000000';

​

select count(*) as "عدد عمليات الحذف"

from logging

where log_timestamp between @start_date and @end_date

and log_type = "delete";

​

select count(*) as "عدد حالات المنع"

from logging

where log_timestamp between @start_date and @end_date

and log_type = "block";

​

select count(*) as "عدد المستخدمين الجدد"

from logging

where log_timestamp between @start_date and @end_date

and log_type = "view";

​

​