SQL
AخA
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
;
By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.
All SQL code is licensed under CC0 License.