消息MySQL Query Error
SQLSELECT g.goods_id, g.goods_name, g.goods_name_style,g.goods_brief, g.market_price,g.is_best,g.is_new,g.is_hot,g.shop_price AS org_price, g.promote_price, IFNULL(mp.user_price, g.shop_price * '1') AS shop_price, promote_start_date, promote_end_date, g.goods_brief, g.goods_thumb, goods_img, b.brand_name FROM `dilongcc`.`ecs_goods` AS g LEFT JOIN `dilongcc`.`ecs_brand` AS b ON b.brand_id = g.brand_id LEFT JOIN `dilongcc`.`ecs_member_price` AS mp ON mp.goods_id = g.goods_id AND mp.user_rank = '' WHERE g.is_on_sale = 1 AND g.is_alone_sale = 1 AND g.is_delete = 0 0 AND is_best = 1 AND (g.cat_id IN ('3') OR g.goods_id IN ('') ) ORDER BY g.sort_order, g.last_update DESC LIMIT 4
错误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 '0 AND is_best = 1 AND (g.cat_id IN ('3') OR g.goods_id IN ('') ) ORDER BY g.so' at line 1
代码1064