Untitled query #17569

SQL

USE svwiki_p;

SELECT log_timestamp, log_action, CONCAT('[[',log_title,']]') AS artikel, actor_name FROM logging INNER JOIN actor ON log_actor=actor_id WHERE
log_action = 'delete'
AND log_title LIKE '%(ö_i%'
AND NOT actor_name LIKE 'Lsj%'
ORDER BY log_timestamp DESC

/*
SELECT * FROM recentchanges WHERE
rc_timestamp > '20210204060000'
ORDER BY rc_timestamp DESC
LIMIT 1000
*/

/*
SELECT SUBSTRING('JanFebMarAprMajJunJulAugSepOktNovDec',SUBSTRING(log_timestamp,5,2)*3-2,3) AS månad, COUNT(*)/16 AS antal_blockeringar FROM logging WHERE
log_type = 'block'
AND log_timestamp > '20050101000000'
AND log_timestamp < '20220101000000'
GROUP BY månad
ORDER BY SUBSTRING(log_timestamp,5,2)
*/

/*
SELECT log_type, SUBSTRING(log_timestamp,1,8) AS dag, COUNT(*) AS antal FROM logging INNER JOIN actor on log_actor=actor_id WHERE
log_timestamp >= '20191230000000' AND log_timestamp < '20210104000000'
AND (log_type = 'create' OR log_type = 'delete')
AND log_namespace = 0
GROUP BY log_type, dag
ORDER BY dag
*/
SQL

Checking query status...
