nlwiki indefinite/infinite blocked IPs

SQL

SELECT ipblocks_ipindex.ipb_address, ipblocks_ipindex.ipb_timestamp, comment.comment_text AS ipb_reason, actor.actor_name
FROM ipblocks_ipindex
JOIN actor ON ipblocks_ipindex.ipb_by_actor = actor.actor_id
JOIN comment ON ipblocks_ipindex.ipb_reason_id = comment.comment_id
WHERE ipblocks_ipindex.ipb_expiry = 'infinity'
  AND actor.actor_name != 'RonaldB'
  AND ipblocks_ipindex.ipb_user is null
  AND (
    ipblocks_ipindex.ipb_address NOT LIKE '%/%'
    OR CAST(SUBSTRING_INDEX(ipblocks_ipindex.ipb_address, '/', -1) AS UNSIGNED) < 24
  )
ORDER BY ipblocks_ipindex.ipb_timestamp ASC;

SQL

Checking query status...