SELECT CASE WHEN log_params LIKE '%sitewide";b:1%' THEN 'sitewide' ELSE 'partial' END AS 'scope',

       log_timestamp,

       log_title,

       log_params,

       actor_name,

       comment_text

FROM logging

JOIN actor_logging ON actor_id = log_actor

JOIN comment_logging ON comment_id = log_comment_id

WHERE log_type = 'block' AND log_action = 'block'

  AND (comment_text LIKE '%3RR%'

       OR comment_text LIKE '%:EW%'

       OR comment_text LIKE '%dit_war%'

       OR comment_text LIKE '%evert%')

ORDER BY log_id DESC

LIMIT 1000;