비교검색


  • 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
상품정렬 : 인기도순  브랜드순  분류순  낮은가격순  높은가격순 94개의 상품이 검색되었습니다.
사진 상품정보 규격정보 판매가격
모델 PT 판매가
SH-25 호스용 5/16(8A) 7,920
SM-22 1/4 8,140
SM-23 3/8 8,690

2.. more

7,920
1,210
모델 PT 판매가
HSM22 (SM20) 1/4 7,040
HSM23 (SM30) 3/8 8,360
HSM24 (SM40) 1/2 9,790

3.. more

7,040
모델 호스내경 판매가
HSH22 8 7,040
HSH23 10 8,360
HSH24 12 9,790
7,040
모델 PT 판매가
MHM22-S ZNDC 1/4 9,020
MHM23-S ZNDC 3/8 9,020
MHM24-S ZNDC 1/2 10,120
9,020
모델 호스내경 판매가
MHH22-S ZNDC 9 9,020
MHH23-S ZNDC 9.5 9,020
MHH24-S ZNDC 15 9,790
9,020
모델 호스내경 판매가
HSN21(SN8) 8 7,040
HSN23(SN10) 10 8,360
HSN24(SN12) 12 9,790
7,040
모델 PT 판매가
JCA-20 1/4 7,480
7,480
모델 호스내경 판매가
MCH22-S ZNDC 9 4,840
MCH23-S ZNDC 9.5 4,840
MCH24-S ZNDC 15 6,270
4,840
모델 PT 판매가
MCM22-S ZNDC 1/4 4,950
MCM23-S ZNDC 3/8 5,830
MCM24-S ZNDC 1/2 7,370
4,950
모델 호스내경 판매가
HH22(SH20) 8 9,680
HH23(SH30) 10 10,890
HH24(SH40) 13 12,320
9,680
3,630
12,650
모델 PT 판매가
200-20SM 1/4 10,010
200-30SM 3/8 9,900
200-40SM 1/2 11,990
10,010
모델 호스내경 판매가
200-20SH 8 9,680
200-30SH 10 10,890
200-40SH 13 11,990
9,680
모델 PT 판매가
MLY 22 1/4 5,610
MLW 22 1/4 7,370
5,610
모델 호스내경 판매가
CN S21 8 1,430
CN S23 10 1,430
CN S24 12 1,870
1,430
모델 호스내경 판매가
HN S21 8 2,310
HN S23 10 2,530
HN S24 12 2,860
2,310
모델 호스내경 판매가
CN21(PN8) 8 5,060
CN23(PN10) 10 7,700
CN24(PN12) 12 4,620
5,060
모델 호스내경 판매가
HN21(SN8) 8 9,680
HN23(SN10) 10 10,890
HN24(SN12) 12 12,320
9,680

1 2 3 4 5