Untitled query #77310

SQL

SELECT
  actor_name AS name,
  COUNT(log_id) AS score
FROM logging
INNER JOIN actor ON log_actor = actor_id
WHERE log_type = "review"
  AND log_action IN ('approve', 'approve-ia', 'approve-a', 'approve2-i', 'approve-i', 'approve2', 'unapprove', 'unapprove2')
  AND ucase(actor_name) NOT LIKE ucase("%BOT") COLLATE utf8mb4_general_ci
  AND actor_name NOT LIKE "%بوت%" COLLATE utf8mb4_general_ci
  AND actor_id NOT IN ("2579643")
  AND actor_user != 137877
  AND actor_name NOT IN (SELECT user_name
                         FROM user_groups
                         INNER JOIN user ON user_id = ug_user
                         WHERE ug_group = "bot")
GROUP BY actor_name
ORDER BY score DESC, actor_name
LIMIT 100;
SQL

Checking query status...
