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_expiry > DATE_FORMAT(DATE_ADD(NOW(), INTERVAL 30 DAY), '%Y%m%d%H%i%s')

    AND ipb_expiry != 'infinity'

    AND comment_text NOT LIKE '%blocked proxy%'

    AND comment_text NOT LIKE '%anonblock%'

    AND comment_text NOT LIKE '%Anonblock%'

    AND comment_text NOT LIKE '%ange block%'

    AND comment_text NOT LIKE '%angeblock%'

    AND comment_text NOT LIKE '%chool block%'

    AND comment_text NOT LIKE '%choolblock%'

    AND comment_text NOT LIKE '%heckUser block%'

    AND comment_text NOT LIKE '%Public Wi-Fi block%'

    AND ipb_range_start != ipb_range_end

    AND ipb_address NOT LIKE '%/64'

ORDER BY ipb_id DESC

LIMIT 100