select count(*) from acs_enum_values v where v.attribute_id = :attribute_id select v.enum_value from acs_enum_values v where v.attribute_id = :attribute_id order by v.sort_order select a.pretty_name as attribute_pretty_name from acs_attributes a where a.attribute_id = :attribute_id