SELECT `ipaddress` FROM `ban` WHERE `ipaddress` LIKE '38.%' AND `expires` > 1268341886 ORDER BY `timestamp` DESC

SELECT `useragent` FROM `ban` WHERE `useragent` != '' ORDER BY `timestamp` DESC

SELECT `notice` FROM `ban` WHERE (`country`='' OR `areacode`='' OR `zipcode`='') AND `expires` > 1268341886