비교검색

전품목 주말특가 할인중.. (일부품목은 제외)

  • 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
상품정렬 : 인기도순  브랜드순  분류순  낮은가격순  높은가격순 14,277개의 상품이 검색되었습니다.
사진 상품정보 규격정보 판매가격
294,690
52,140
45,650
모델 용량 판매가
NF CONTACT CLEANER #2017 400 35,420
35,420
모델 규격 판매가
70 02 160 SB 6 36,300
70 02 180 SB 7 38,610
36,300
모델 전압 판매가
DCL281FZW (배터리X,충전기X) BL 18 175,120
175,120
모델 전압 판매가
DCL180Z (배터리X,충전기X) 18 76,670
DCL181FZWX (배터리X,충전기X) 18 88,550
DCL182ZW (배터리X,충전기X) 18 94,270

1.. more

76,670
모델 전압 판매가
DLS714Z (배터리X,충전기X) BL (7 1/2") 18 1,029,600
DLS713Z (배터리X,충전기X) (7 1/2") 18 865,260
1,029,600
모델 전압 판매가
DCO180Z (배터리X,충전기X) 18 154,220
DCO181Z (배터리X,충전기X) BL 18 287,870
154,220
모델 전압 판매가
DVP180Z (배터리X,충전기X) 18 496,870
496,870
모델 전압 판매가
DFR450Z (배터리X,충전기X) 18 315,040
DFR550Z (배터리X,충전기X) 18 344,630
315,040
모델 전압 판매가
DUR189Z (배터리X,충전기X) BL 18 307,670
DUR191LZX2 (배터리X,충전기X) BL -루프핸들 18 327,910
DUR192LZ (배터리X,충전기X) BL -루프핸들 18 222,860
307,670
모델 전압 판매가
DCG180Z (배터리X 충전기X) - 카트리지타입 18 299,200
DCG180ZB (배터리X,충전기X) - 소시지타입 18 394,240
299,200
모델 전압 판매가
DVC350Z (배터리X,충전기X) 18 262,460
DVC750LZ (배터리X,충전기X) BL 18 320,210
262,460
5,280
모델 전압 판매가
DML801 (배터리X,충전기X) 18 59,070
DML803 (배터리X,충전기X) 18 65,010
DML805 (배터리X,충전기X) 14.4/18V 200,640

4.. more

59,070
35,090
68,640
281,600
6,930