SELECT ipb_id, ipb_timestamp, user_name, ipb_address, ipb_expiry, /*ipb_range_start, ipb_range_end,*/

    ipb_anon_only, ipb_create_account, ipb_block_email, ipb_allow_usertalk, comment_text

FROM ipblocks

LEFT JOIN actor ON ipb_by_actor = actor_id

LEFT JOIN user ON actor_user = user_id

LEFT JOIN comment ON ipb_reason_id = comment_id

WHERE ipb_user = 0

    AND ipb_auto = 0

    AND ipb_anon_only = 0

    AND ipb_expiry > DATE_FORMAT(DATE_ADD(NOW(), INTERVAL 30 DAY), '%Y%m%d%H%i%s')

    AND (comment_text LIKE '%anonblock%'

        OR comment_text LIKE '%Anonblock%'

        OR comment_text LIKE '%ange block%'

        OR comment_text LIKE '%chool block%'

        OR comment_text LIKE '%choolblock%')

    AND ipb_range_start != ipb_range_end

ORDER BY ipb_id DESC

LIMIT 100