USE arwiki_p;

select CONCAT('[[مستخدم:',actor_name,'|',actor_name,']]'), COUNT(*)

from logging

INNER JOIN actor on logging.log_actor = actor_id

where log_timestamp BETWEEN 20190101000000 AND 20191231235959

and log_type in ("block")

group by logging.log_actor

having COUNT(*)>1

ORDER BY COUNT(*) DESC

LIMIT 20;