Untitled query #58544

SQL

/*
SELECT LEFT(log_timestamp,8) 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
*/

SELECT page_namespace, CONCAT('[[',page_title,']]') AS artikel FROM page WHERE
page_title LIKE '%ß%'
AND page_is_redirect = 0
AND (page_namespace = 0 OR page_namespace = 4 OR page_namespace = 10 OR page_namespace = 14)
ORDER BY page_namespace, page_title
SQL

Checking query status...
