SELECT `id`, `name` FROM `series` ORDER BY `id` ASC

SELECT `ipaddress` FROM `ban` WHERE `ipaddress` LIKE '38.%' AND `expires` > 1265686860 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` > 1265686860