Untitled query #58544

SQL

SELECT * FROM ipblocks 
LIMIT 10

/*
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('[[',IF(page_namespace=10,'Mall:',IF(page_namespace=14,':Kategori:','')),page_title,']]') AS artikel FROM page WHERE
*/
/*SELECT page_title FROM page WHERE
page_title LIKE '%ß%'
AND page_is_redirect = 1
AND (page_namespace = 0 OR page_namespace = -10 OR page_namespace = -14)
ORDER BY page_namespace, page_title
*/
SQL

Checking query status...
