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 '\' cart_num \' && CG.user_num in (0,0) && CG.user_num>0 && gs_view!="H" ' at line 21 |
SELECT cg_num, CG.user_num, goods_int, CG.gs_num, trim(gs_model) as gs_model, gs_big, gs_trans, gs_view, gs_stock, gs_margin, gs_uint, GU1.gu_name as gu_name1, GU2.gu_name as gu_name2, gs_sint, goods_num, goods_name, if(brd_group>0,(SELECT brd_name FROM NT_admin.Brand WHERE brd_num=B.brd_group),brd_name) as brd_name, gs_bprice, (SELECT com_num FROM NT_admin.Goods_priceSupply WHERE gs_num=ntGP.gs_num && gs_bprice=ntGP.gs_bprice LIMIT 1) as supply_company, if(gs_stock=0 || gs_view in ("H","D"),0,if(goods_price>0,(goods_price*1.1),TNS_Price(ntGP.gs_num))) as gs_price, ce_date, ce_comment, if(CG.goods_price>0,1,0) as est_price, TNS_Price(ntGP.gs_num) as original_price From Cart_goods as CG left join NT_admin.Goods_price as ntGP using(gs_num) left join NT_admin.Goods_stock as ntGS using(gs_num) left join NT_admin.Goods as ntG using(goods_num) left join NT_admin.Brand as B using(brd_num) left join NT_admin.Goods_unit as GU1 on GU1.gu_num=ntG.goods_unit left join NT_admin.Goods_unit as GU2 on GU2.gu_num=ntGP.gu_num left join Cart_estimate as CE using(cg_num) WHERE cart_num=\' cart_num \' && CG.user_num in (0,0) && CG.user_num>0 && gs_view!="H" ORDER BY brd_name ASC, goods_num ASC, gs_sort ASC |