비교검색


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
상품정렬 : 인기도순  브랜드순  분류순  낮은가격순  높은가격순 0개의 상품이 검색되었습니다.
사진 상품정보 규격정보 판매가격
검색된 상품이 없습니다.
추천 카테고리(분류) 및 검색어
  • 관련 카테고리 :