비교검색


  • 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
상품정렬 : 인기도순  브랜드순  분류순  낮은가격순  높은가격순 141개의 상품이 검색되었습니다.
사진 상품정보 규격정보 판매가격
모델 규격 판매가
98 0.1~3.2 16,170
98-R 0.1~3.2 18,150
16,170
모델 규격 판매가
25744 4.0 20,570
25751 4.2 22,330
25762 4.5 22,330

16.. more

20,570
21,010
모델 규격 판매가
- 25 6,600
- 30 6,710
- 35 8,470

1.. more

6,600
모델 규격 판매가
D5401012 1.2 7,700
D5401015 1.5 7,700
D5401018 1.8 7,700

22.. more

7,700
모델 규격 판매가
GP5D2030K 3.0 26,070
GP5D2040K 4.0 26,070
GP5D2050K 5.0 27,500

15.. more

26,070
23,430
모델 규격 판매가
- 3.0 4,290
- 3.2 4,510
- 4.0 4,730

3.. more

4,290
9,900
모델 규격 판매가
DV304010 1.0 12,980
DV304015 1.5 12,210
DV304020 2.0 13,090

10.. more

12,980
모델 규격 판매가
2608585694 6 4,400
2608585695 7 4,730
2608585696 8 4,290

16.. more

4,400
모델 규격 판매가
CD-SL 1.5*5*100L 1.5 431,200
CD-SL 2.5*8*100L 2.5 571,670
CD-SL 3.0*8*100L 3.0 571,670

4.. more

431,200
13,090
모델 규격 판매가
AQDEXZ0200 2.0 38,940
AQDEXZ0250 2.5 38,940
AQDEXZ0270 2.7 38,940

37.. more

38,940
모델 규격 판매가
GP3D1013K 1.3 16,390
GP3D1020K 2.0 14,960
GP3D1024K 2.4 14,960

47.. more

14,960
19,140
25,630
모델 규격 판매가
2608900600 3 4,070
2608900604 4 4,070
2608900606 5 4,070

16.. more

4,070
모델 규격 판매가
- 1.0 7,590
- 1.5 6,930
- 2.0 7,920

3.. more

7,590
모델 규격 판매가
- 1.0 4,400
- 1.5 4,620
- 2.0 4,400

6.. more

4,400

1 2 3 4 5 6 7 8