MySQL Error[1064]: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '∨der=desc desc limit 0,20' at line 5
MySQL Query:select g.*,gs.*,gsp.*,ifnull(e.enum,0) as enum from sky_goods g left join sky_goods_statistics gs on g.goods_id=gs.goods_id
inner join sky_store ss on g.store_id=ss.store_id
left join sky_goods_spec gsp on gsp.spec_id=g.default_spec
left join (select count(*) as enum,goods_id from sky_order_goods ) e on e.goods_id=g.goods_id where 1=1 and g.status=2 and g.if_show=1 and g.closed=0 and ss.state=1 and g.presale=0 and g.bidding=0 and g.is_wholesales=0
and exists (select goods_id,area_code from sky_goods_salesarea where goods_id=g.goods_id and area_code='ms') and (g.cate_id='1302' or g.cate_id_1='1302' or g.cate_id_2='1302' or g.cate_id_3='1302' or g.cate_id_4='1302') order by g.add_time desc,enum∨der=desc desc limit 0,20
Wrong File: /eccore/model/mysql.php[508]

  • Error File: /eccore/model/mysql.php at 286 line.