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 # any time in year 2018
    and TIMESTAMPDIFF(DAY, la.log_timestamp,lb.log_timestamp)<7 # two protection in difference of less than a week
    and la.log_params like '%edit=autoconfirmed%' # first one is weak
    and lb.log_params not like '%edit=autopatrol%' # second is stronger
    and la.log_namespace=0 #main NS
    group by la.log_title;
SQL

Checking query status...
