select count(entry_id)
from pinds_blog_entries e
where package_id = :package_id
[ad_decode $date_clause "" "" "and $date_clause"]
and draft_p = 'f'
and deleted_p = 'f'
select count(entry_id)
from pinds_blog_entries e,
acs_objects o
where e.package_id = :package_id
and o.object_id = e.entry_id
and o.creation_user = :blog_user_id
[ad_decode $date_clause "" "" "and $date_clause"]
and draft_p = 'f'
and deleted_p = 'f'
select *
from pinds_blog_categories
where package_id = :package_id