select user_class_id, user_class_name from ec_user_classes order by user_class_name select field_identifier, field_name, column_type from ec_custom_product_fields where active_p = 't' select template_name from ec_templates where template_id=:template_id select field_identifier, field_name, column_type from ec_custom_product_fields where active_p = 't' select user_class_id, user_class_name from ec_user_classes order by user_class_name