SQL
AخA
use trwiki_p;
select CONCAT('[[Kullanıcı:',user_name,'|',user_name,']]'), COUNT(*)
from logging
inner join user
on user.user_id = logging.log_actor
where log_timestamp BETWEEN 20190101000000 AND 201981228000000
and log_action = "approve-i"
and log_namespace = 0
group by logging.log_actor
having COUNT(*)>1
ORDER BY COUNT(*) DESC
LIMIT 100;
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.