Untitled query #77310

SQL

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

Checking query status...
