Untitled query #58544

SQL

/*
SELECT CONCAT('[[:Kategori:',log_title,']]') AS kategori, log_timestamp AS raderingstid, actor_name FROM logging JOIN actor ON log_actor=actor_id JOIN comment ON log_comment_id=comment_id WHERE 
*/
SELECT CONCAT('{{mall|',log_title,'}}') AS mall, log_timestamp AS raderingstid FROM logging JOIN actor ON log_actor=actor_id JOIN comment ON log_comment_id=comment_id WHERE 
log_type = 'delete'
AND log_action = 'delete'
AND log_title LIKE '%stub%'
AND log_namespace = 10
AND log_timestamp > '20240401T000000Z'
ORDER BY log_timestamp DESC
SQL

Checking query status...
