Orphans with incoming links

SQL

SELECT
  DAYOFWEEK(revision_userindex.rev_timestamp) AS dow,
  HOUR(revision_userindex.rev_timestamp) AS hour,
  COUNT(DISTINCT rev_id) AS edits
FROM
  revision_userindex
  LEFT JOIN actor_logging ON actor_logging.actor_id = revision_userindex.rev_actor
  LEFT JOIN logging_userindex ON revision_userindex.rev_actor = logging_userindex.log_actor
WHERE
  actor_logging.actor_name = "Khánh Snake"
  AND (
    logging_userindex.log_type LIKE "patrol"
    AND logging_userindex.log_action IN ("patrol", "autopatrol")
  )
GROUP BY
  dow,
  hour
ORDER BY
  dow ASC,
  hour ASC;
SQL

Checking query status...
