protection escalation in hewiki

SQL

use hewiki_p;
select la.log_title, la.log_timestamp, lb.log_timestamp 
from logging la 
	inner join logging lb 
    on 
    la.log_action=lb.log_action and 
    la.log_type=lb.log_type and
    la.log_title=lb.log_title and
    la.log_namespace=lb.log_namespace
    where 
    la.log_type='protect' and la.log_action='protect'
    and la.log_timestamp<lb.log_timestamp and la.log_timestamp>20180101000000
    and TIMESTAMPDIFF(DAY, la.log_timestamp,lb.log_timestamp)<7 
    and la.log_params like '%edit=autoconfirmed%' 
    and lb.log_params not like '%edit=autopatrol%'
    and la.log_namespace=0 group by la.log_title;
SQL

Checking query status...
