MySQL Error[1054]: Unknown column 'g.cate_id_' in 'where clause'
MySQL Query:SELECT COUNT(*) as c FROM ecm_goods g LEFT JOIN ecm_goods_spec gs ON g.default_spec = gs.spec_id LEFT JOIN ecm_store s ON g.store_id = s.store_id LEFT JOIN (select goods_id, sum(stock) total_stock from ecm_goods_spec group by goods_id) st ON st.goods_id = g.goods_id LEFT JOIN ecm_goods_statistics gst ON g.goods_id = gst.goods_id WHERE g.cate_id_ = '177' AND g.if_check = 1 AND g.if_show = 1 AND g.closed = 0 AND gs.spec_id IS NOT NULL AND s.store_id IS NOT NULL
Wrong File: /eccore/model/mysql.php[419]

Error File: /eccore/model/mysql.php at 266 line.