Untitled query #58544

SQL

SELECT *, SUBSTRING(page_title,1,5) FROM externallinks JOIN page ON el_from=page_id WHERE
el_to_domain_index LIKE 'http://org.runeberg.'
AND page_namespace=0
LIMIT 100
/*
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...
