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|', log_namespace, '}}:', REPLACE(l1.log_title, '_', ' '), ']]') as page_title, comment_text
       from logging_userindex as l1
       inner join (
          select distinct log_page
          from logging
          inner join comment_logging on log_comment_id = comment_id
          where log_timestamp > '20240502000000'
          and log_type = 'delete'
          and comment_text like '%x3%' collate utf8mb4_unicode_ci
       ) l2 on l1.log_page = l2.log_page
       inner join actor on l1.log_actor = actor_id
       inner join comment_logging on l1.log_comment_id = comment_id
       where log_timestamp > '20240502000000'
       and log_type = 'delete'
       order by log_timestamp desc
SQL

Checking query status...
