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 '&& cate_index<100000000)) AND (brd_num="18") GROUP BY G.goods_num ORDE' at line 16 |
SELECT G.goods_num, G.cate_num, GC.cate_name, goods_level, ntB.brd_num, ntG.goods_name as goods_name, if(brd_group>0,(SELECT brd_name FROM NT_admin.Brand WHERE brd_num=ntB.brd_group),brd_name) as brd_name, trim(if(ntGP.gs_model="-","",ntGP.gs_model)) as gs_model, ntGP.gs_num, ntGP.gs_sort, gs_view, gs_bprice, gs_uint, gs_margin, gs_stock, count(G.goods_num) as gCnt, sum(gs_sint) as stock, TNS_Price(ntGP.gs_num) as goods_price FROM Goods as G left join Goods_Category as GC using(cate_num) left join NT_admin.Goods as ntG using(goods_num) left join NT_admin.Brand as ntB using(brd_num) left join NT_admin.Goods_price as ntGP using(goods_num) left join NT_admin.Goods_stock as ntGS using(gs_num) WHERE ntG.goods_num>3 AND cate_view="V" AND brd_view="V" AND gs_view!="H" AND goods_view!="H" AND gs_bprice>=1 AND ((cate_index>= && cate_index<100000000)) AND (brd_num="18") GROUP BY G.goods_num ORDER BY goods_level DESC, stock DESC, goods_num DESC, gs_sort ASC |
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 '&& cate_index<100000000 GROUP BY goods_level ORDER BY goods_level DESC' at line 6 |
SELECT goods_num, goods_level From Goods_Category as GC left join Goods as G using(cate_num) left join NT_admin.Goods as ntG using(goods_num) WHERE cate_index>= && cate_index<100000000 GROUP BY goods_level ORDER BY goods_level DESC |
사진 | 상품정보 | 규격정보 | 판매가격 |
---|---|---|---|
검색된 상품이 없습니다.추천 카테고리(분류) 및 검색어
|