Invalid query:  SELECT B.*, A.SMZ_CTRT_YMD AS CTRT_START_YMD, IFNULL(A.CMCN_YMD, A.CMCN_SCD_YMD)  AS CTRT_END_YMD, A.CTRT_KND_CD AS CTRT_KIND, A.CTRT_MTH_CD
							, A.CTRT_TRGT_NM AS BIZ_CONT, A.FRST_SMZ_CTRT_AMT AS FIRST_CTRT_AMT, A.SMZ_CTRT_TOTT_AMT AS CTRT_AMT, A.SMZ_CTRT_YMD AS CTRT_YMD, A.CTRT_TY_DTS_CD AS CTRT_TYPE_NM
							, IFNULL(A.SMZ_CTRT_YMD,A.BGCS_YMD) AS START_WORK_YMD, A.CMCN_YMD AS COMPLT_YMD, A.PVCN_RSON_CD AS CTRT_RSN
							, IF(IFNULL(C.BID_SCD_AMT,0)=0, IFNULL(C.BID_PRY_AMT,0), C.BID_SCD_AMT) AS SCHD_AMT, C.SBD_RT AS SUCC_BID_RATE
							FROM `N_CTRT_LIST` AS B LEFT JOIN `TFC1250M` AS A ON B.CTRT_ACCT_BOOK_MNG_NO=A.CTRT_LDGR_MNG_NO
							LEFT JOIN `TFC1710L` AS C ON B.CTRT_ACCT_BOOK_MNG_NO = C.CTRT_LDGR_MNG_NO
							WHERE A.CTRT_LDGR_MNG_NO='202400312994'