oracle8.1.6 select * from (select entry_id, to_char(entry_date, 'YYYY-MM-DD HH24:MI:SS') as entry_date_ansi, title, c.name as category, content from pinds_blog_entries e, pinds_blog_categories c where e.category_id = c.category_id(+) and e.package_id = :package_id and draft_p = 'f' and deleted_p = 'f' order by entry_date desc ) where rownum <= $num_posts