Block logs of 2014 in FaWP

SQL

USE fawiki_p;
SELECT log_user_text, log_title, log_params
FROM logging
WHERE log_type='block' AND log_params <> ''
AND log_timestamp > '20140101' AND log_timestamp < '20150101'
AND log_params NOT LIKE 'in%nit%' -- I don't care about infinite/indefinite blocks
AND log_user <> 427882 -- I don't care about blocks by AbuseFilter
AND log_title NOT REGEXP '[0-9]+\.[0-9]+\.' -- no IP blocks
AND
(log_params LIKE '%year%' OR log_params LIKE '%month%' OR log_params LIKE '%week%' OR log_params LIKE '%day%')
ORDER BY log_user_text, log_params;
SQL

Checking query status...
