Forgotten articles

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 change_tag ON change_tag.ct_rev_id = revision_userindex.rev_id
  LEFT JOIN change_tag_def ON change_tag.ct_tag_id = change_tag_def.ctd_id
  LEFT JOIN logging_userindex ON revision_userindex.rev_actor = logging_userindex.log_actor
WHERE
  revision_userindex.rev_actor = 1634431
  AND (
    change_tag_def.ctd_name IN ("mw-rollback", "mw-undo")
    OR 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...
