ID_, USER_ID_, USER_ACCOUNT_, USER_NAME_, USER_PHONE_, PARTICIPATION_DATE_, COMPANY_ID_, COMPANY_NAME_, COMPANY_CODE_, NOTICE_ID_, NOTICE_TITLE_, NOTICE_TYPE_, STATUS_, REMARKS_, IS_DELE_, CREATE_BY_, CREATE_NAME_, CREATE_DEPT_ID_, CREATE_DEPT_NAME_, CREATE_ORG_ID_, CREATE_ORG_NAME_, CREATE_TIME_, UPDATE_BY_, UPDATE_NAME_, UPDATE_DEPT_ID_, UPDATE_DEPT_NAME_, UPDATE_ORG_ID_, UPDATE_ORG_NAME_, UPDATE_TIME_, LAST_TIME_, VERSION_, TENANT_ID_ select * from biz_user_participation ${ew.customSqlSegment} select * from biz_user_participation ${ew.customSqlSegment} SELECT b.*,a.ID_ as 'winNoticeId' FROM biz_win_bidding_notice a LEFT JOIN biz_user_participation b ON a.NOTICE_ID_ = b.NOTICE_ID_ AND a.VENDOR_ID_= b.COMPANY_ID_ WHERE a.PROCURE_TYPE_ != 5 AND a.IS_DELE_ = '0' AND b.IS_DELE_ = '0' AND b.STATUS_ = 1 AND b.PRICE_ > 0 AND b.REFUND_REGISTRATION_ORDER_ID_ is null