SQL
AخA
use arwiki_p;
select CONCAT('[[مستخدم:',user_name,'|',user_name,']]'), COUNT(*)
from logging
inner join user
on user.user_id = logging.log_user
where log_timestamp BETWEEN 201900415000000 AND 20190422000000
and log_action = "approve"
and log_namespace = 0
group by logging.log_user
having COUNT(*)>1
ORDER BY COUNT(*) DESC
LIMIT 20;
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.