select entry_id, to_char(entry_date, 'YYYY-MM-DD') as entry_date_pretty, title, title_url, content, content_format from pinds_blog_entries where package_id = :package_id and draft_p = 't' and deleted_p = 'f' order by entry_date desc, posted_date desc