oracle8.1.6
select entry_id,
acs_object.name(apm_package.parent_id(e.package_id)) as parent_name,
(select site_node.url(site_nodes.node_id)
from site_nodes
where site_nodes.object_id = e.package_id) as base_url,
title,
content,
p.first_names as poster_first_names,
p.last_name as poster_last_name,
to_char(posted_date , 'HH24:MI') as posted_time_pretty,
from pinds_blog_entries e,
acs_objects o,
persons p
where e.entry_id = o.object_id
and p.person_id = o.creation_user
and package_id = :package_id
and $date_clause
and draft_p = 'f'
and deleted_p = 'f'
order by entry_date desc, posted_date desc
update na_items set deleted_p = '1' where item_id = :delete_id