Untitled query #58544

SQL

/*
SELECT log_timestamp, log_action, log_title, actor_name, comment_text FROM logging JOIN actor ON log_actor=actor_id JOIN comment ON log_comment_id=comment_id WHERE
*/
/*
SELECT actor_name, COUNT(*) AS antal FROM logging JOIN actor on log_actor=actor_id WHERE
log_timestamp > '19200101000000'
AND log_action = 'delete'
AND log_namespace = 10
AND log_title LIKE '%stub%'
GROUP BY actor_name
*/
/*
ORDER BY log_timestamp DESC
*/

SELECT lt_title AS mall, COUNT(*) AS antal_artiklar from templatelinks JOIN page ON tl_from=page_id JOIN linktarget ON tl_target_id = lt_id WHERE
lt_namespace = 10
AND page_namespace = 0
AND lt_title LIKE '%stub%'
AND NOT lt_title LIKE 'XRobotskapad%'
GROUP BY lt_title
ORDER BY antal_artiklar DESC, mall

/*
SELECT RAND();
SELECT page_id, page_title FROM page JOIN categorylinks on page_title=cl_to WHERE 
page_namespace = 0
AND page_is_redirect = 0
AND page_random >= RAND()
ORDER BY page_random
LIMIT 1
*/

/*
SELECT * FROM logging WHERE
log_action = 'block'
AND log_timestamp > '20220814000000'
AND log_params LIKE '%"sitewide";b:0;%'
*/

/*SELECT ipb_timestamp, ipb_expiry, ipb_address, page_title, comment_text, actor_name  FROM ipblocks JOIN comment ON ipb_reason_id=comment_id JOIN actor ON ipb_by_actor=actor_id JOIN ipblocks_restrictions ON ir_ipb_id=ipb_id JOIN page on page_id=ir_value
WHERE ipb_sitewide = 0
AND ipb_timestamp > '20220914000000'
ORDER BY ipb_timestamp DESC
*/

/*
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...
