비교검색


  • 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
상품정렬 : 인기도순  브랜드순  분류순  낮은가격순  높은가격순 63개의 상품이 검색되었습니다.
사진 상품정보 규격정보 판매가격
모델 용량 판매가
SM-AS1L 1 3,630
SM-AS1.5L 1.5 4,180
SM-AS2L 2 4,180

1.. more

3,630
모델 용량 판매가
YP-50 1 12,210
YP-150 1 12,210
노즐 2,420

1.. more

12,210
모델 용량 판매가
INDUSTRY ergo 1000 1 34,430
INDUSTRY ergo 1500 1.5 36,850
INDUSTRY ergo 2000 2 39,270

1.. more

34,430
1,540
모델 용량 판매가
SM-BS15L 15 30,030
SM-BS12L 12 28,820
SM-BS16L 16 32,230
30,030
59,620
모델 용량 판매가
SM-CSS8L 8 23,760
SM-CSS10L 10 25,190
SM-CSS12L 12 27,170
23,760
모델 용량 판매가
SW파워5000 20 276,210
SW파워3000 20 201,300
SW파워1000 12 198,660
276,210
19,140
모델 용량 판매가
HP-20191 1.0 11,880
HP-20192 1.5 12,430
HP-20193 2.0 12,870
11,880
모델 용량 판매가
LN104(3.7V) 4 61,930
61,930
모델 용량 판매가
DEW1904-14 14 62,150
62,150
4,950
1,540
3,850
모델 용량 판매가
KS-PK6 6 203,940
킹덤G 20 174,570
킹덤G2 20 187,990

4.. more

223,630
모델 용량 판매가
US-201 20 174,570
174,570
모델 용량 판매가
IK FOAM 1.5 1.5 47,630
IK FOAM Pro 2 1.9 52,470
IK FOAM Pro 2 PLUS 1.9 63,360

1.. more

47,630
모델 용량 판매가
DIA-5200 2 78,650
DIA-8740 4 84,810
DIA-8655 5 116,380
78,650
22,330

1 2 3 4