Untitled query #82543

SQL

select distinct log_id, 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_userindex as l1
       inner join (
          select distinct log_namespace, log_title
          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 utf8_unicode_ci
       ) l2 on l1.log_namespace div 2 = l2.log_namespace div 2 and l1.log_title = l2.log_title
       inner join comment_logging on l1.log_comment_id = comment_id
       inner join actor_logging on l1.log_actor = actor_id
          where l1.log_timestamp > '20240502000000'
          and l1.log_type='delete'
    -- group by log_id
          order by l1.log_timestamp desc
          ;
SQL

Checking query status...
