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