2018-07 website

From MediaWiki

Jump to: navigation, search

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') = '2018-07' 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') = '2018-07' 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') = '2018-07' 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') = '2018-07' GROUP BY referer |database=EcoReality}}

Share your opinion


blog comments powered by Disqus
Personal tools
Get our newsletter!
Name:
Email Address:

disturbance
entry points
help (off site)
Environmental jobs, green volunteering, good work! Powered by the wind! This server and other
EcoReality operations
are 100% wind powered.
Powered by Mac OS X Powered by Mac MediaWiki Powered by MariaDB Powered by Valentina Studio Pro