select count(entry_id) from pinds_blog_entries e where package_id = :package_id 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 and $date_clause and draft_p = 'f' and deleted_p = 'f' select * from pinds_blog_categories where package_id = :package_id