Untitled query #58544

SQL

SELECT LEFT(log_timestamp,6) AS Datum, COUNT(*) AS Antal FROM logging WHERE 
log_action = 'block'
AND log_timestamp > '20220101000000'
AND log_timestamp < '20230101000000'
GROUP BY Datum
ORDER BY Datum
/*
SELECT FLOOR(DATEDIFF(CONCAT(LEFT(log_timestamp,4),'/',MID(log_timestamp,5,2),'/',MID(log_timestamp,7,2)), '2022/01/03')/7)+1 AS Vecka, COUNT(*) AS antal FROM logging WHERE
log_action = 'block'
AND log_timestamp > '20220103000000'
AND log_timestamp < '20230102000000'
GROUP BY Vecka
ORDER BY Vecka
*/

/*
SELECT   CONCAT(MID(log_timestamp,3,2),MID(log_timestamp,5,2)) AS Månad, COUNT(*) AS Antal FROM logging WHERE
log_action = 'block'
AND log_timestamp > '20200101000000'
AND log_timestamp < '20230801000000'
GROUP BY Månad
ORDER BY Månad
*/
SQL

Checking query status...
