From MediaWiki

These stats take several minutes to run, and so are not available until we figure out how to make them faster.

Click on the arrows in any column header to sort by that column.

by Week

1. tag:mysql|

SELECT

   WEEK(time_stamp) AS Week,
   FORMAT(SUM(bytes), 0) AS Bytes

FROM web_log WHERE DATE_FORMAT(time_stamp, '%Y-%m') = '2019-01' GROUP BY WEEK(time_stamp, 3) WITH ROLLUP |database=EcoReality}}

by Page

1. tag:mysql|

SELECT

   request_uri AS Page,
   FORMAT(SUM(bytes), 0) AS Bytes

FROM web_log WHERE DATE_FORMAT(time_stamp, '%Y-%m') = '2019-01' GROUP BY request_uri |database=EcoReality}}

by Client

1. tag:mysql|

SELECT

   remote_host AS Client,
   FORMAT(SUM(bytes), 0) AS Bytes

FROM web_log WHERE DATE_FORMAT(time_stamp, '%Y-%m') = '2019-01' GROUP BY remote_host |database=EcoReality}}

by Referer

1. tag:mysql|

SELECT

   referer AS Referer,
   FORMAT(SUM(bytes), 0) AS Bytes

FROM web_log WHERE DATE_FORMAT(time_stamp, '%Y-%m') = '2019-01' GROUP BY referer |database=EcoReality}}