'111' CODE,
t.NAME,
t.lable,
t.type,
t.required,
t.query_code,
field( t.NAME, 'major', 'birthday', 'tel', 'm_2', 'formal', 'NAME' ) AS seq,
t.OPTIONS
FROM
form_field t
INNER JOIN (
SELECT NAME ,CODE
FROM class a
WHERE
is_del = '0'
AND type = 2
AND EXISTS ( SELECT NULL FROM class WHERE CODE IN ( 'draft.hire', 'basic' ) AND type = '0' AND a.parent_id = id )
GROUP BY
a.CODE,
a.NAME
) up ON up.CODE = t.CODE
WHERE
t.NAME IN ( 'major', 'birthday', 'tel', 'm_2', 'formal', 'NAME' )
ORDER BY
field( t.NAME, 'major', 'birthday', 'tel', 'm_2', 'formal', 'NAME' )
