Untitled query #16559

SQL

USE svwiki_p;
SELECT SUBSTR(ipb_timestamp,9,2) AS Timme, 
CAST(SUM(DATE_FORMAT(ipb_timestamp,'%w')=1) AS INTEGER) AS Måndag,
CAST(SUM(DATE_FORMAT(ipb_timestamp,'%w')=2) AS INTEGER) AS Tisdag,
CAST(SUM(DATE_FORMAT(ipb_timestamp,'%w')=3) AS INTEGER) AS Onsdag,
CAST(SUM(DATE_FORMAT(ipb_timestamp,'%w')=4) AS INTEGER) AS Torsdag,
CAST(SUM(DATE_FORMAT(ipb_timestamp,'%w')=5) AS INTEGER) AS Fredag,
CAST(SUM(DATE_FORMAT(ipb_timestamp,'%w')=6) AS INTEGER) AS Lördag,
CAST(SUM(DATE_FORMAT(ipb_timestamp,'%w')=0) AS INTEGER) AS Söndag,
COUNT(*) AS Totalt FROM ipblocks
WHERE ipb_timestamp >= "201701231900"
GROUP BY Timme
ORDER BY Timme;

SELECT COUNT(*) AS Totalt FROM ipblocks 
WHERE ipb_timestamp >= "201701231900";
SQL

Checking query status...
