SQL
x
/* عدد حالات المنع */
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;
By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.
All SQL code is licensed under CC0 License.