Untitled query #17569

SQL

USE svwiki_p;

SELECT SUBSTRING('JanFebMarAprMajJunJulAugSepOktNovDec',SUBSTRING(log_timestamp,5,2)*3-2,3) AS månad, COUNT(*)/16 AS antal_blockeringar FROM logging WHERE
log_type = 'block'
AND log_timestamp > '20200101000000'
AND log_timestamp < '20210101000000'
GROUP BY månad
ORDER BY månad

/*
SELECT log_type, SUBSTRING(log_timestamp,1,8) AS dag, COUNT(*) AS antal FROM logging INNER JOIN actor on log_actor=actor_id WHERE
log_timestamp >= '20191230000000' AND log_timestamp < '20210104000000'
AND (log_type = 'create' OR log_type = 'delete')
AND log_namespace = 0
GROUP BY log_type, dag
ORDER BY dag
*/
SQL

Checking query status...
