비교검색


  • 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 '&& GC.cate_index<100000000 GROUP BY GC2.cate_num ORDER BY GC2.cate_ind' at line 7
    SELECT
    GC2.cate_num, GC2.cate_name, GC2.cate_index From
    NT_admin.Goods as ntG
    left join Goods as G using(goods_num)
    left join Goods_Category as GC using(cate_num)
    left join Goods_Category as GC2 on GC2.cate_index=truncate(GC.cate_index,-4)
    WHERE ntG.brd_num="" && GC.cate_index>= && GC.cate_index<100000000
    GROUP BY GC2.cate_num
    ORDER BY GC2.cate_index ASC
상품정렬 : 인기도순  브랜드순  분류순  낮은가격순  높은가격순 95개의 상품이 검색되었습니다.
사진 상품정보 규격정보 판매가격
58,080
66,770
124,190
66,770
248,490
106,920
222,750
517,990
191,400
140,690
775,830
880,990
590,370
모델 굵기×전장 판매가
FS50V5 2.5×50 52,470
FS57V5 2.5×57 60,060
FS65V5 2.5×64 68,640

5.. more

52,470
모델 굵기×전장 판매가
FC50V5 2.5×50 50,490
FC57V5 2.5×57 57,970
FC65V5 2.5×65 66,220

5.. more

50,490

1 2 3 4 5