id_, org_id_, org_name_, name_, type_, number_, unit_, operate_type_, warehouse_location_, is_dele_, create_by_, create_org_id_, create_time_, update_by_, update_org_id_, update_time_, last_time_ SELECT s.* FROM ( SELECT d.*, e.name_ AS indexName FROM biz_training_data d LEFT JOIN biz_exam_index_data e ON e.id_ = d.index_id_ WHERE e.is_dele_ = '0' and d.is_dele_ = '0' ) s ${ew.customSqlSegment}