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

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

SELECT `name`, `urlcode` FROM `quotes` WHERE `visible`=1 ORDER BY `id` ASC

SELECT `title`, `urlcode` FROM `playlist` WHERE `title` != '' AND `youtube` IS NOT NULL AND `youtube` != '' ORDER BY `id` ASC