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('USD', if(P.STREET_PRICE < @price, @price, P.STREET_PRICE)) -- , FORMAT(@STREET_PRICE, 2) AS STREET_PRICE -- 정상가 , @SELLING_PRICE := FC_CURRENCY_AMT('USD', @price) /* 2019.10.24 검색시 보여주는 가격 변경. 시중가 -> 판매가(view 변수가 STREET_PRICE 라 STREET_PRICE 그대로 사용) */ , FORMAT(@SELLING_PRICE, 2) AS STREET_PRICE -- 판매가 , @GOODS_COUPON := FC_GOODS_COUPON(P.GOODS_CODE) AS COUPON -- 쿠폰율 , @COUPON_SALE_PRICE := round(@SELLING_PRICE * (@GOODS_COUPON/100),2) , FORMAT(@SELLING_PRICE - @COUPON_SALE_PRICE, 2) 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 (127709759,126598210,126598206,126598193,126598190,126598183,126018885,124855836,124855682,124619917,124473925,122070904,122070867,122070864,122070860,122070841,122070840,122070838,122070835,122070832,122070831,122070828,122070826,122070825,122070823,122070820,122070819,122070817,122070816,122070813,122070811,122070810,122070806,122070804,122070802,122070799,122070796,122070791,122070788,122070786,122070785,122070784,122070783,122070782,122070780,122070779,122070775,122070772,122070762,122070757,122070753,122070748,122070743,122070733,122070730,122070727,122070724,122070723,122070720,122070719)

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

Line Number: 2398