id_, year_, plan_type_, quarter_, month_, week_, start_time_, end_time_, hour_, plan_status_, memo_, sn_, is_dele_, create_by_, create_org_id_, create_time_, update_org_id_, update_by_, update_time_, last_time_ SELECT * FROM (SELECT p.* FROM biz_exam_plan p LEFT JOIN biz_exam_general_plan g on p.id_ = p.general_plan_id_ where p.is_dele_ = '0' and g.is_dele_='0' ) s ${ew.customSqlSegment}