select widget, widget from cm_form_widgets select a.pretty_name as attribute_name_pretty, t.pretty_name as content_type_pretty, t.object_type as content_type, a.attribute_name from acs_attributes a, acs_object_types t where a.object_type = t.object_type and a.attribute_id = :attribute_id select widget as registered_widget, is_required from cm_attribute_widgets where attribute_id = :attribute_id