• 브랜드관
  • 브랜드소식
  • 이벤트
  • HTR 패키지
  • 당일배송
  • 퀵서비스
  • A/S 규정
  • 회원 혜택 안내
  • HTR GOLF STUDIO
  • 자유카드 결제안내
  • 상품권 사용안내
  • 입점/제휴 문의
  • 1:1문의
  • FAQ
  • 공지사항
    • 온라인[배송문의]1800-6981
    • 매장[상품문의]1599-1872
    고객센터
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(103 line)
>>> /home/newsofttown/public_html.v3/front/product/product_list.php(84 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 ( CASE WHEN stockcnt > 0 THEN 1 ELSE 2 END ) , a.seq DESC LIMIT 0 , 50) AS subp JOIN igear_product AS a USING(seq)