Untitled query #70131

SQL

/* عدد حالات المنع */
use arwiki_p;
SET @start_date = '20221201000000';
SET @end_date = '20230101000000';
SET @rank=0;
SET @cumule_Edit=0;
SELECT @cumule_Edit:=@cumule_Edit+COUNT(*) AS "التراكمي", s.* 
FROM (
  	select CONCAT('[[مستخدم:',actor_name,'|',actor_name,']]') AS "المستخدم", COUNT(*) AS "عدد حالات المنع" 
		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
 		 @cumule_Edit:=@cumule_Edit+COUNT(*)
	LIMIT 50
 ) s;
SQL

Checking query status...
