Untitled query #29892

Fork of Edits on the “Insomnia” article between 9 PM and 7 AM by Arkanosis

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

SQL

USE frwiki_p;
SELECT DATE(rev_timestamp), COUNT(time), (SUM(time) - MAX(time)) / COUNT(time) AS mean_time FROM
  (SELECT rev_timestamp, TIMESTAMPDIFF(MINUTE, @previous, rev_timestamp) AS time, @previous := rev_timestamp
   FROM (SELECT @previous := 0) AS _, revision
   JOIN page ON page_id = rev_page
   WHERE page_namespace = 0
   AND page_title = 'Insomnie'
   ORDER BY rev_timestamp) AS timestamps
WHERE (HOUR(rev_timestamp) > 19 OR HOUR(rev_timestamp) < 5)
GROUP BY DATE(rev_timestamp) HAVING COUNT(time) > 1
ORDER BY rev_timestamp

SQL

Checking query status...