Untitled query #82543

SQL

select l1.log_id, l1.log_namespace, l1.log_title, count(*) as c 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 mod(log_namespace, 2) = 0
          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 log_comment_id = comment_id
          where log_timestamp > '20240502000000'
          and log_type='delete'
          
   group by log_id having c>1
          ;
SQL

Checking query status...
