SQL
AخA
SELECT
*
FROM
ipblocks
LEFT JOIN comment ON (ipblocks.ipb_reason_id = comment.comment_id)
WHERE
ipb_user IS NULL
-- AND ipb_address NOT LIKE '%:%' -- exclude IPv6
AND ipb_address LIKE '%.0.0/16'
AND ipb_expiry >= DATE_FORMAT(NOW(), "%Y%m%d%H%i%s"))
LIMIT 1
By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.
All SQL code is licensed under CC0 License.