select category_id, category_name from ec_categories order by category_name select s.category_id, s.subcategory_id, category_name, subcategory_name from ec_categories c, ec_subcategories s where c.category_id=s.category_id order by s.category_id, s.subcategory_id select subcategory_id, subcategory_name from ec_subcategories where category_id=:category_id order by subcategory_name select subcategory_id from ec_subcategories where category_id=:category_id select subcategory_name from ec_subcategories where subcategory_id=:subcategory_id select subcategory_id from ec_subcategories where category_id=:category_id and subcategory_id in ([join $subcategory_list ","]) order by subcategory_name select subsubcategory_id from ec_subsubcategories where subcategory_id=:subcategory_id and subsubcategory_id in ([join $subsubcategory_list ","]) order by subsubcategory_name select picklist_item from ec_picklist_items where picklist_name='issue_type' order by sort_key select picklist_item from ec_picklist_items where picklist_name='info_used' order by sort_key select picklist_item from ec_picklist_items where picklist_name='interaction_type' order by sort_key