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