ID_, NOTICE_ID_, NOTICE_CODE_, NOTICE_TYPE_, WIN_NOTICE_ID_, CONTR_CODE_, CONTR_NAME_, CONTR_METHOD_, THREE_CONTRACT_ID, MAT_COMPANY_ID_, MAT_COMPANY_CODE_, MAT_COMPANY_NAME_, MAT_COMPANY_USER_ID_, MAT_COMPANY_USER_NAME_, MAT_COMPANY_USER_PHONE_, VENDOR_ID_, VENDOR_CODE_, VENDOR_NAME_, VENDOR_TAX_NUMBER_, VENDOR_USER_ID_, VENDOR_USER_NAME_, VENDOR_USER_PHONE_, SIGN_DATA_, PAY_METHOD_, MAT_COMPANY_CHECKER_ID_, MAT_COMPANY_CHECKER_NAME_, CONTRACT_AMOUNT_, CONTRACT_START_DATE_, CONTRACT_END_DATE_, TREATY_CONTENTS_, URL_, STATUS_, GENER_TYPE_, AGENCY_CONTRCT_ID_, 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_contract ${ew.customSqlSegment} SELECT VENDOR_ID_,VENDOR_CODE_,VENDOR_NAME_,VENDOR_TAX_NUMBER_ FROM biz_contract ${ew.customSqlSegment} GROUP BY VENDOR_ID_ SELECT COUNT(0) FROM biz_win_bidding_notice_detaile a LEFT JOIN biz_win_bidding_notice b ON a.WIN_NOTICE_ID_ = b.ID_ LEFT JOIN (SELECT ct.*,con.STATUS_ FROM biz_contract_item ct LEFT JOIN biz_contract con ON ct.CONTRACT_ID_ = con.ID_ WHERE con.IS_DELE_ = '0') c ON c.WIN_NOTICE_DETAIL_ID_ = a.ID_ WHERE b.IS_DELE_ = '0' AND a.NOTICE_ID_ = #{noticeId} AND b.VENDOR_ID_ = #{vendorId} AND (c.STATUS_ != 3 OR c.STATUS_ is null)