errorUnknown column 'goods.icon' in 'order clause'
querySELECT goods.goodsno, goods.catno, goods.sale_per, trans.regdt, goods.konvini_price, goods.price as pricekr, goods.totstock, trans.content, trans.goodsnm, trans.lang_code, brand.brand, goods.status_JP, goods.status, konvini_price AS consumerprice, ifnull(( SELECT floor(goods.konvini_price *(100-dcperc)/100) FROM tb_dcprice AS dcprice INNER JOIN tb_dcprice_goods AS dc_goods ON dcprice.dcid=dc_goods.dcid WHERE curdate() between dcprice.sday AND dcprice.eday AND dcprice.status != 'delete' AND country = 'JP' AND dc_goods.goodsno = goods.goodsno LIMIT 1 ),goods.konvini_price) price, brand.brandno, goods_opt.opt1, goods_opt.imgno FROM new_tb_goods AS goods INNER JOIN tb_brand AS brand ON goods.brand = brand.brand INNER JOIN new_tb_goods_trans AS trans ON goods.goodsno = trans.goodsno LEFT JOIN new_tb_goods_opt AS goods_opt ON goods.goodsno = goods_opt.goodsno LEFT JOIN new_tb_code AS new_code ON goods_opt.opt2 = new_code.konvini_code where brand.bstatus = 'active' and goods.status_JP in ('selling', 'soldout') and goods.catno like '1503%' and ts & 1 in (1) and trans.lang_code = 'JP' group by goods.goodsno, goods_opt.imgno order by goods.icon desc, goods.goodsno DESC limit 0,30
fileC:\Users\Administrator\Documents\Repository\konvini\index.php (line:61)
C:\Users\Administrator\Documents\Repository\konvini\apps\product\list.php (line:725)
C:\Users\Administrator\Documents\Repository\konvini\lib\class.page.php (line:261)
C:\Users\Administrator\Documents\Repository\konvini\lib\class.page.php (line:110)