SQL
AخA
use arwiki_p;
select
CONCAT(actor_name),
COUNT(*)
from
logging_userindex
INNER JOIN actor ON log_actor = actor.actor_id
where
log_timestamp BETWEEN 20210301000000
and 20210307000000
and actor_name NOT LIKE ucase ("%BOT") COLLATE utf8_general_ci
and actor_name NOT LIKE ("%New_user_message")
and actor_name NOT LIKE ucase ("%بوت") COLLATE utf8_general_ci
and log_action = "approve-i"
and log_namespace = 0
group by actor_name
having COUNT(*) > 1
ORDER BY COUNT(*) DESC
LIMIT 50;
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.