SELECT log_timestamp, log_id, log_action, actor_name, REPLACE(log_title, '_', ' ') AS log_title, user_editcount, comment_text, log_params

FROM logging

JOIN user ON user_name = REPLACE(log_title, "_", " ")

JOIN actor_logging ON log_actor = actor_id

JOIN comment_logging ON log_comment_id = comment_id

WHERE log_type = "block"

  AND user_editcount >= 1 AND user_editcount < 100

  AND (comment_text LIKE "%attack%" OR comment_text LIKE "%harass%" OR comment_text LIKE "%racis%" OR comment_text LIKE "%civil%" 

      OR comment_text LIKE "%sexis%" OR comment_text LIKE "%bigot%" OR comment_text LIKE "%WP:NPA%" OR comment_text LIKE "%insult%"

      OR comment_text LIKE "%slur%" OR comment_text LIKE "%stereotyp%" OR comment_text LIKE "%bully%" OR comment_text LIKE "%WP:PA%"

      OR comment_text LIKE "%WP:NOPA%" OR comment_text LIKE "%gravedanc%" OR comment_text LIKE "%aspersion%"

      OR comment_text LIKE "%WP:HA%" OR comment_text LIKE "%hound%" OR comment_text LIKE "%following%" OR comment_text LIKE "%outing%"

      OR comment_text LIKE "%dox%" OR comment_text LIKE "%offwiki%" OR comment_text LIKE "%off-wiki%" OR comment_text LIKE "%personaliz%"

      OR comment_text LIKE "%personalis%")

​

UNION

​

SELECT '99999999999999', NULL, 'currently blocked', NULL, user_name, user_editcount, NULL, NULL

FROM ipblocks_ipindex

JOIN user ON user_id = ipb_user

WHERE user_editcount >= 1 AND user_editcount < 100

​

ORDER BY log_title ASC, log_timestamp ASC;