select package_id from pinds_blog_entries where entry_id = :entry_id select name, short_name from pinds_blog_categories where package_id = :package_id order by lower(name)