Untitled query #82543

SQL

select DATE_FORMAT(l1.log_timestamp, '%Y-%m-%d %H:%i:%s') as 'timestamp', actor_name as 'actor', l1.log_action as 'action', CONCAT('[[{{namespace name|', l1.log_namespace, '}}:', REPLACE(l1.log_title, '_', ' '), ']]') as page_title, comment_text
       from logging_logindex as l1
       inner join (
          select distinct log_namespace, log_title
          from logging_logindex
          inner join comment_logging on log_comment_id = comment_id
          where log_timestamp > '20240502000000'
          and log_type = 'delete'
          and comment_text like '%x3%' collate utf8_unicode_ci
       ) l2 on l1.log_namespace div 2 = l2.log_namespace div 2 and l1.log_title = l2.log_title
       inner join actor on l1.log_actor = actor_id
       inner join comment_logging on l1.log_comment_id = comment_id
       where l1.log_timestamp > '20240502000000'
       and l1.log_type = 'delete'
       group by l1.log_id
       order by l1.log_timestamp desc;
SQL

Checking query status...
