Untitled query #60011

This query is marked as a draft This query has been published by Muhammed taha.

SQL

SELECT
    rc_actor,
    COUNT(*) AS total,
    SUM(
      CASE
        WHEN day = 1 THEN 0
        WHEN day = 7 THEN 0
        ELSE 1
      END
    ) AS weekdays,
    COUNT(DISTINCT day) AS dist_days,
    COUNT(DISTINCT hour) AS dist_hours
  FROM
    (
      SELECT
        rc_actor,
        DAYOFWEEK(rc_timestamp) AS day,
        HOUR(rc_timestamp) AS hour
      FROM
        recentchanges_userindex AS recentchanges
      WHERE
        rc_ip IS NULL
        AND rc_bot = 0
        AND rc_type = 0 -- mw.edit (excludes mw.log, mw.categorize, etc)
    ) AS q
  GROUP BY
    rc_actor

By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.

Submit Query Stop Query

All SQL code is licensed under CC0 License.

SQL

Checking query status...