Untitled query #16559

SQL

USE svwiki_p;
SELECT SUBSTR(ipb_timestamp,9,2) AS timme, 
SUM(DATE_FORMAT(ipb_timestamp,'%w')=1) AS måndag,
SUM(DATE_FORMAT(ipb_timestamp,'%w')=2) AS tisdag,
SUM(DATE_FORMAT(ipb_timestamp,'%w')=3) AS onsdag,
SUM(DATE_FORMAT(ipb_timestamp,'%w')=4) AS torsdag,
SUM(DATE_FORMAT(ipb_timestamp,'%w')=5) AS fredag,
SUM(DATE_FORMAT(ipb_timestamp,'%w')=6) AS lördag,
SUM(DATE_FORMAT(ipb_timestamp,'%w')=0) AS söndag,
COUNT(*) AS Totalt FROM ipblocks
#WHERE ipb_user != 0 
WHERE ipb_timestamp >= "20170120"
GROUP BY ROLLUP(timme) 
#ORDER BY timme
LIMIT 300
SQL

Checking query status...
