Unknown column 'stockcnt' in 'order clause' <<< [RuntimeError - Query] >>>>>> /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(113 line) >>> /home/newsofttown/public_html.v3/front/product/product_list.php(90 line) 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.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) |