id_, type_id_, title_, keyword_, memo_, sn_, memo_2, is_dele_, create_by_, create_org_id_, create_time_, update_by_, update_time_, version_, last_time_ SELECT s.*, t.name_ AS typeName FROM exam_material_info s LEFT JOIN exam_material_type t ON t.id_ = s.type_id_ ${ew.customSqlSegment} WHERE AND s.IS_DELE_ = '0'