Untitled query #70134

SQL

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 "عدد المستخدمين الجدد"
/* select user_name as "قائمة المستخدمين الجدد" */
from user
where user_registration between @start_date and @end_date;
/* group by user_registration;
SQL

Checking query status...
