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 mandag,
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 lordag,
CAST(SUM(DATE_FORMAT(ipb_timestamp,'%w')=0) AS INTEGER) AS sondag,
COUNT(*) AS Totalt FROM ipblocks
#WHERE ipb_user != 0 
WHERE ipb_timestamp >= "20170120"
GROUP BY timme
#COMPUTE SUM(mandag), SUM(tisdag), SUM(onsdag), SUM(torsdag), SUM(fredag), SUM(lordag), SUM(sondag);
#ORDER BY timme
LIMIT 300
SQL

Checking query status...
