-
로그인 해주세요
1분만에 회원가입
-
고객님
무엇을 찾으세요?
-
-
인기 검색어
- #KATANA SIGNATURE V20 드라이버
- #드라이버
- #4번 아이언
- #요넥스 아이언
- #x포지드 아이언
- #오지오
- #타이틀리스트 바퀴형
- #혼마블렉 드라이버
- #젝시오
- #타이틀리스트
-
Unknown column 'stockcnt' in 'order clause'
>>> /home/newsofttown/public_html.v3/lib/functions/igear_dbms_mysql.php(281 line)
>>> /home/newsofttown/public_html.v3/lib/functions/igear_dbms_mysql.php(318 line)
>>> /home/newsofttown/public_html.v3/front/product/product_paginglist.exec.php(106 line)
>>> /home/newsofttown/public_html.v3/front/product/product_list.php(90 line)
<<< [RuntimeError - Query] >>>SELECT a.seq , a.chargeflag , a.transuseflag , a.transpricefreelimit , a.productnm , a.walletpayflag , a.walletpaytype , a.walletpayrange , a.wallet_cash , a.wallet_cash_perc , a.pricerepword ,
a.thumb_img,
a.imgnm1 ,
a.imgnm2 ,
a.imgnm3 ,
a.imgnm4 ,
a.imgnm5 ,
a.imgnm6 ,
a.imgnm7 ,
a.addimage ,
a.basisinnerprice,
if('4' = '99' , a.addimage , imgnm4) as applyimage ,
if('4' = '99' , 99 , '4') as is_addimage ,
a.customprice , a.sellprice , a.vip_sellprice , a.b2b_sellprice , a.basissupplyprice , a.barcode , a.barcodetype , a.goodsdesc , a.prtcode , a.pricestruc , a.defaultoptflag , a.stockflag , a.regdate , a.is_stockordering , a.soldoutflag , a.tstockamt, a.layerimg, a.layerimg_date_s, a.layerimg_date_e , reviewcnt, a.bs_ordqty FROM (SELECT a.seq as seq FROM igear_product AS a WHERE 1 AND (a.mviewctrl = '1' OR (a.mviewctrl = '3' AND a.viewctrl <> '3')) ORDER BY a.seq DESC , ( CASE WHEN stockcnt > 0 THEN 1 ELSE 2 END ) LIMIT 0 , 50) AS subp JOIN igear_product AS a USING(seq)