postgresql7.2 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 left outer join pinds_blog_categories c using (category_id) where e.package_id = :package_id and draft_p = 'f' and deleted_p = 'f' order by entry_date desc,entry_id desc limit $num_posts