A Database Error Occurred

Error Number: 1146

Table 'BMH.GBL_GOODS_PRICE' doesn't exist

select /* 134(1) > ems_new_global > goods_m > get_brand_hotItem > 브랜드 상세_인기상품 brand_code=b81297 / EN */ SUB.* , EGD.EGOODS_DEAL_MST_NO -- e굿딜 코드 , @STREET_PRICE := FC_CURRENCY_AMT('USD', SUB.STREET_PRICE_ORG) , FORMAT(@STREET_PRICE, 2) AS STREET_PRICE -- 정상가 , @SELLING_PRICE := FC_CURRENCY_AMT('USD', SUB.SELLING_PRICE_ORG) , FORMAT(@SELLING_PRICE, 2) AS SELLING_PRICE -- 판매가 , @GOODS_COUPON := FC_GOODS_COUPON(SUB.GOODS_CODE) AS COUPON -- 쿠폰율 , @DISCOUNT_RATE := ((1 - (@SELLING_PRICE/@STREET_PRICE))*100) , round(@DISCOUNT_RATE, 0) as DISCOUNT_RATE -- 세일율 , ifnull(GG.NAME, SUB.NAME) as GOODS_NAME from (select /* eroundmall > goods_m > get_brand_hotItem > eroundmall 브랜드 상세_인기상품 */ G.CODE as GOODS_CODE -- 상품코드 , G.NAME -- 상품명 , @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 , I.IMG_URL as IMG_URL -- 상품 타이틀이미지 , if(P.STREET_PRICE < @price, @price, P.STREET_PRICE) as STREET_PRICE_ORG , @price as SELLING_PRICE_ORG 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 P.GOODS_CODE = G.CODE AND G.GOODS_PRICE_CONTRACT_CODE = P.CODE inner join DAT_GOODS_IMAGE I on I.GOODS_CODE = G.CODE and I.`TYPE` = 'TITLE' inner join TEMP_CATEGORY_LIST CL on G.CATEGORY_CODE = CL.CATEGORY_CD_4 inner join DAT_CATEGORY C on CL.CATEGORY_CD_1 = C.CODE and C.WEB_DISP_YN = 'Y' and C.DISP_YN='N' inner join DAT_BRAND b on b.CODE = G.BRAND_CODE and b.AVAIL_FLAG = 'Y' and b.WEB_DISP_YN = 'Y' 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 DAT_GOODS_SORT_SCORE SORT on SORT.GOODS_CD = G.CODE where 1 = 1 and G.GOODS_STATE_CODE = '02' and G.BRAND_CODE = 'b81297' group by G.CODE order by SORT.GOODS_SORT_SCORE desc, G.CODE desc limit 8) SUB left join DAT_EGOODS_DEAL_MST EGD on EGD.GOODS_CODE = SUB.GOODS_CODE and now() between EGD.BEGIN_DT and EGD.END_DT left join GBL_GOODS GG on SUB.GOODS_CODE = GG.CODE and GG.LANG = 'EN'

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

Line Number: 1511