oracle8.1.6 select * from ( select entry_id, to_char(entry_date, 'YYYY-MM-DD') as entry_date, title, c.name as category, content, to_char(posted_date , 'HH24:MI') as posted_time_pretty 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, posted_date desc ) where rownum <= $num_posts