<br> SELECT f.field_id as field_id,
                            t.name as field_type,
                            f.table_prefix as table_prefix,
                            f.field_name as field_name,
                            f.elem_type as elem_type,
                            f.elem_name as elem_name,
                            f.source_type as source_type,
                            f.source as source,
                            f.label as label
                        FROM (search_fields as f 
                            RIGHT JOIN search_field_map as m
                            ON f.field_id = m.p_field) 
                            JOIN search_field_types as t
                            ON t.field_type_id = f.p_field_type
                        WHERE m.p_search_type = 1
                        AND m.p_property_class = 
                        ORDER BY m.ordered <br>