SELECT cp.mb_id, cp.mb_point, cp.mb_today_login, cp.mb_datetime,cp.CP_TYPE, cp.CP_NAME, cp.CP_OWNER, IFNULL(cp.B_REG_NO, '없음') AS B_REG_NO, cp.C_REG_NO, cp.ZIP_CODE, cp.ADDR1, cp.ADDR2, cp.ADDR3, cp.ADDR4, cp.HP_URL, cp.MGR_NAME, cp.MGR_HP, cp.MGR_TEL, cp.MGR_FAX, cp.MGR_EMAIL, cp.UPDATE_DATE, cp.nm1, cp.nm2, cp.nm3, cp.nm4, cp.nm5, ph.MB_ID, ph.PH_FILE_NO, ph.if_saveedFile, ph.PH_SIDO, ph.PH_M2, ph.PH_FLAT, ph.PH_KK, (SELECT REG_YN FROM CO_BOOKMARK WHERE GUBUN = 'GS' AND MB_ID = '' AND PH_GUBUN = 'PHOTO' AND CO_ID = ph.mb_id AND PH_FILE_NO = ph.PH_FILE_NO) AS GS_YN, (SELECT REG_YN FROM CO_BOOKMARK WHERE GUBUN = 'SD' AND MB_ID = '' AND PH_GUBUN = 'PHOTO' AND CO_ID = ph.mb_id AND PH_FILE_NO = ph.PH_FILE_NO) AS SD_YN, (SELECT PH_DESC FROM COMPANY_PHOTOINFO WHERE PH_GUBUN = 'LOGO' AND MB_ID = cp.MB_ID) AS PH_DESC, (SELECT if_saveedFile FROM tbImageFile WHERE if_id = '' and if_table = 'builder_logo') AS logoFile, ph.PH_BEDROOM_NO, ph.PH_BATHROOM_NO, (SELECT SUM( CASE RATING WHEN 'SP001' THEN 100 WHEN 'SP002' THEN 80 WHEN 'SP003' THEN 60 WHEN 'SP004' THEN 40 WHEN 'SP005' THEN 20 ELSE 0 END)/COUNT(*) FROM CO_BOOKMARK WHERE GUBUN = 'SD' AND CO_ID = cp.MB_ID AND RATING IS NOT NULL ) AS AVG_RATING FROM (SELECT co.mb_id, co.mb_point, co.mb_today_login, co.mb_datetime, co.CP_TYPE, co.CP_NAME, co.CP_OWNER, co.B_REG_NO, co.C_REG_NO, co.ZIP_CODE, co.ADDR1, co.ADDR2, co.ADDR3, co.ADDR4, co.HP_URL, co.MGR_NAME, co.MGR_HP, co.MGR_TEL, co.MGR_FAX, co.MGR_EMAIL, co.UPDATE_DATE, kk.nm1, kk.nm2, kk.nm3, kk.nm4, kk.nm5 FROM (SELECT gm.mb_id, gm.mb_point, gm.mb_today_login, gm.mb_datetime, co.CP_TYPE, co.CP_NAME, co.CP_OWNER, co.B_REG_NO, co.C_REG_NO, co.ZIP_CODE, (select name from JUSOINFO where code = co.ADDR1) AS ADDR1, (select name from JUSOINFO where code = co.ADDR2) AS ADDR2, (select name from JUSOINFO where code = co.ADDR3) AS ADDR3, co.ADDR4, co.HP_URL, co.MGR_NAME, co.MGR_HP, co.MGR_TEL, co.MGR_FAX, co.MGR_EMAIL, co.UPDATE_DATE FROM g4_member gm, COMPANY co /*company에 등록된 회사만 나오도록 처리*/ WHERE gm.mb_id = '' AND gm.mb_id = co.MB_ID ) co LEFT JOIN (SELECT CE.MB_ID, (SELECT NAME FROM CODEINFO WHERE CODE = CE.BD_CODE_01) AS nm1, (SELECT NAME FROM CODEINFO WHERE CODE = CE.BD_CODE_02) AS nm2, (SELECT NAME FROM CODEINFO WHERE CODE = CE.BD_CODE_03) AS nm3, (SELECT NAME FROM CODEINFO WHERE CODE = CE.BD_CODE_04) AS nm4, (SELECT NAME FROM CODEINFO WHERE CODE = CE.BD_CODE_05) AS nm5 FROM COMPANY_ETC CE WHERE CE.MB_ID = '' AND CE.BD_GUBUN = 'KK') kk ON co.mb_id = kk.MB_ID ) cp, (SELECT cp.MB_ID, cp.PH_GUBUN, cp.PH_FILE_NO, cp.PH_DESC, ti.if_saveedFile, cp.PH_SIDO, cp.PH_M2, cp.PH_FLAT, cp.PH_KK, cp.PH_BEDROOM_NO, cp.PH_BATHROOM_NO FROM (SELECT if_id, if_nFileNo-1 AS nFileNo, if_saveedFile FROM tbImageFile WHERE if_id = '' AND if_table = 'builder_constPhoto' AND if_nFileNo = +1 ) ti, (SELECT cp.MB_ID, cp.PH_GUBUN, cp.PH_FILE_NO, cp.PH_DESC, (SELECT NAME FROM CODEINFO WHERE CODE = cp.PH_SIDO) AS PH_SIDO, cp.PH_M2, cp.PH_FLAT, (SELECT NAME FROM CODEINFO WHERE CODE = cp.PH_KK_CODE) AS PH_KK, cp.PH_BEDROOM_NO, cp.PH_BATHROOM_NO FROM COMPANY_PHOTOINFO cp WHERE cp.MB_ID = '' AND cp.PH_GUBUN = 'PHOTO' AND cp.PH_FILE_NO = ) cp WHERE ti.if_id = cp.MB_ID AND ti.nFileNo = cp.PH_FILE_NO ) ph WHERE cp.mb_id = ph.MB_ID

1064 : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') cp WHERE ti.if_id = cp.MB_ID AND ti.nFile' at line 57

error file : /topbuilder/pages/ask/ask_photo_detail.php