select object_type from contact_searches where search_id = :search_id select var_list from contact_search_conditions where type = 'group' and search_id = :search_id select lam.attribute_id, a.pretty_name from ams_list_attribute_map lam, ams_lists l, ams_attributes a where lam.list_id = l.list_id and lam.attribute_id = a.attribute_id $search_for_clause order by pretty_name asc select 1 from contact_search_extend_map where search_id = :search_id and attribute_id = :attribute_id