A Database Error Occurred

Error Number: 1146

Table 'BMH.GBL_GOODS_PRICE' doesn't exist

select /* 134(1) > ems_new_global > goods_m > get_goods_price_by_search > 상품 가격정보 가져오기 - Cloud-Search */ G.CODE , @price := case when mcgp.GBL_PRC_GB = 'GBL_PRC_1' then ifnull(gpc.SELLING_PRICE, P.SELLING_PRICE) when mcgp.GBL_PRC_GB = 'GBL_PRC_2' then ifnull(gpc.SELLING_PRICE2, P.SELLING_PRICE) else P.SELLING_PRICE end as price , @STREET_PRICE := FC_CURRENCY_AMT('KRW', if(P.STREET_PRICE < @price, @price, P.STREET_PRICE)) -- , FORMAT(@STREET_PRICE, 0) AS STREET_PRICE -- 정상가 , @SELLING_PRICE := FC_CURRENCY_AMT('KRW', @price) /* 2019.10.24 검색시 보여주는 가격 변경. 시중가 -> 판매가(view 변수가 STREET_PRICE 라 STREET_PRICE 그대로 사용) */ , FORMAT(@SELLING_PRICE, 0) AS STREET_PRICE -- 판매가 , @GOODS_COUPON := FC_GOODS_COUPON(P.GOODS_CODE) AS COUPON -- 쿠폰율 , @COUPON_SALE_PRICE := floor(@SELLING_PRICE * (@GOODS_COUPON/100)) , FORMAT(@SELLING_PRICE - @COUPON_SALE_PRICE, 0) AS SELLING_PRICE -- 판매가 , @DISCOUNT_RATE := ((1 - (@SELLING_PRICE/@STREET_PRICE))*100) , round(/*@DISCOUNT_RATE +*/ @GOODS_COUPON, 0) as DISCOUNT_RATE -- 세일율 , ifnull(GG.NAME, G.NAME) as NAME , if(B.DISP_NAME_ENG!='', ifnull(B.DISP_NAME_ENG, B.NAME_ENG), NAME_ENG) as BRAND_NAME from DAT_GOODS G inner join DAT_VENDOR_SUBVENDOR vs on vs.CODE = G.VENDOR_SUBVENDOR_CODE inner join DAT_VENDOR_CONTRACT vc on vc.CODE = vs.VENDOR_CONTRACT_CODE inner join DAT_GOODS_PRICE_CONTRACT P on G.CODE = P.GOODS_CODE and P.CODE = (select max(CODE) from DAT_GOODS_PRICE_CONTRACT where GOODS_CODE = G.CODE) inner join DAT_BRAND B on G.BRAND_CODE = B.CODE left join MAP_VENDOR_CONTRACT_N_GBL_PRC mcgp on mcgp.VENDOR_CONTRACT_CODE = vc.CODE left join GBL_GOODS_PRICE gpr on gpr.GOODS_CODE = G.CODE and gpr.SELLER_COMPANY_CODE = mcgp.SELLER_COMPANY_CODE left join GBL_GOODS_PRICE_CONTRACT gpc on gpc.CODE = gpr.GBL_GOODS_PRICE_CONTRACT_CODE left join GBL_GOODS GG on G.CODE = GG.CODE and GG.LANG = 'EN' where G.CODE in (126390005,126390004,126389997,126389994,126388776,126386692,126386085,126386077,126372767,126372764,126371207,126371206,126371201,126371197,126371004,126370935,126370597,126370594,126370590,126370583,126370579,126370566,126370554,126370540,126370538,126370535,126370533,126370520,126370514,126370510,126370491,126358639,126355123,126354346,126354142,126354101,126353537,126353535,126353533,126353532,126322347,126319960,126269233,126269217,126256225,126236510,126230845,126229222,126229158,126229061,126225559,126219610,126219335,126219314,126207508,126207491,126187596,126186217,126182869,126182860)

Filename: /webservice_root/ems_new_global/models/goods_m.php

Line Number: 2398