‌ - Quarry

SQL

select actor_name as name, COUNT(*) as score
    from logging
    INNER JOIN actor ON actor.actor_id = logging.log_actor
    where log_timestamp BETWEEN 20240819000000 AND 20240827000000
    and log_action = "approve"
    and log_namespace = 0

    and actor_name Not IN (SELECT user_name FROM user_groups INNER JOIN user ON user_id = ug_user WHERE ug_group = 'bot')
     and ucase(actor_name) not like ucase("%BOT") COLLATE utf8mb4_general_ci
  and actor_name not like "%بوت%" collate utf8mb4_general_ci
and actor_name not in (SELECT replace(lt_title, "_", " ")
     FROM pagelinks
     inner join linktarget ON lt_id = pl_target_id
     WHERE pagelinks.pl_from = 7352181
       AND lt_namespace = 2)
    group by logging.log_actor
    having COUNT(*)>1
    ORDER BY score DESC,name
	LIMIT 10;
SQL

Checking query status...
