비교검색


  • 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
상품정렬 : 인기도순  브랜드순  분류순  낮은가격순  높은가격순 15개의 상품이 검색되었습니다.
사진 상품정보 규격정보 판매가격
모델 규격 판매가
SH-30W 1 7,920
SH-36W 2 11,000
SH-37W 2.5 12,210

1.. more

7,920
10,120
모델 두경 판매가
KP-6 55 61,160
KP-8 59 71,390
61,160
모델 두경 판매가
THOR-T3000 50 29,150
THOR-T3001 50 27,500
THOR-T4000 68 32,450

1.. more

29,150
모델 두경 판매가
AH-11G 43 40,920
AH-13G 46 43,560
AH-15G 47 46,530
40,920
모델 두경 판매가
OHW-2LT 37 16,940
OHW-3LT 42 20,900
OHW-4LT 47 27,610

2.. more

16,940
모델 두경 판매가
ZM-5E 36 38,940
ZM-5E-4 36 36,850
ZM-5G 36 53,130
38,940
모델 두경 판매가
OHW-2 (300MM) 37 16,170
OHW-3 (360MM) 42 20,020
OHW-4 (440MM) 47 26,510

5.. more

47,850
모델 두경 판매가
OHW-2G 37 27,500
OHW-3G 42 32,230
OHW-4G 47 35,420

3.. more

102,520
모델 규격 판매가
YGL-68S 8 15,180
YGL-68M 10 19,030
YGL-68L 12 23,650

1.. more

15,180
모델 규격 판매가
B-SH02 2 8,690
B-SH03 3 11,220
B-SH04 4 12,760

4.. more

8,690
모델 규격 판매가
YGL-60SS 6 24,200
YGL-60S 8 28,600
YGL-60M 10 32,560

2.. more

28,600
모델 규격 판매가
- 2 7,810
- 3 10,890
- 4 12,650

3.. more

7,810
모델 규격 판매가
- 2 7,700
- 3 10,010
- 4 11,770

3.. more

10,010
모델 두경 판매가
800-80 80 306,350
306,350