select e.epf_id, l.epf_label from extra_product_fields e join extra_field_labels l where e.epf_status and e.epf_advanced_search and e.epf_uses_value_list and (!e.epf_multi_select) and (e.epf_id = l.epf_id) and (l.languages_id = 4) and l.epf_active_for_language order by e.epf_order