عدد عمليات الحذف والمنع حسب المستخدم

SQL

/* أكثر الإداريين حذفًا*/
use arwiki_p;
SET @start_date = '20221201000000';
SET @end_date = '20230101000000';
SET @rank=0;
SET @cumule_Edit=0;
/*SELECT @rank:=@rank+1 AS "المركز", s.* */
SELECT @cumule_Edit:=@cumule_Edit + COUNT AS "تراكم", s.*
FROM (
  	select CONCAT('[[مستخدم:',actor_name,'|',actor_name,']]'), COUNT(*)
	from logging
	INNER JOIN actor on logging.log_actor = actor_id
	where log_timestamp between @start_date and @end_date	
	and log_type in ("delete")
	group by logging.log_actor
	having COUNT(*)>0
	ORDER BY COUNT(*) DESC
	LIMIT 50
) s;
/* أكثر الإداريين منعًا*/
SET @rank=0;

SELECT @rank:=@rank+1 AS "المركز", s.*
FROM (
  	select CONCAT('[[مستخدم:',actor_name,'|',actor_name,']]'), COUNT(*)
		from logging
		INNER JOIN actor on logging.log_actor = actor_id
		where log_timestamp between @start_date and @end_date
		and log_type in ("block")
		group by logging.log_actor
		having COUNT(*)>0
		ORDER BY COUNT(*) DESC
	LIMIT 50
 ) s;
SQL

Checking query status...
