Untitled query #70131

SQL

/* عدد حالات المنع */
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
	LIMIT 50
 ) s;
SQL

Checking query status...
