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 'AND GI.cate_num<100000000 AND GI.goods_num=G.goods_num AND GI.brd_num=B.brd_num ' at line 5
SELECT B.brand_num as brd_num, BM.brd_kname, count(B.brand_num) as B_CNT From
T1_Goods.Brand_mother as BM,
T1_Goods.Brand as B,
T1_Goods.Goods_info as GI,
(SELECT goods_num FROM T1_Goods.Goods WHERE goods_view='V' GROUP BY goods_num) as G WHERE GI.cate_num>= AND GI.cate_num<100000000 AND GI.goods_num=G.goods_num AND GI.brd_num=B.brd_num AND BM.brand_num=B.brand_num GROUP BY B.brand_num ORDER BY B_CNT DESC
리스트로 보기
사진으로 보기
20개씩 보기
30개씩 보기
50개씩 보기
100개씩 보기
모델명
규격
1/2B"~3/4B"
1B"~2B"
2B"~3B"
모델명
규격(mm)
가공깊이(mm)
전장(mm)
12
25
50
13
25
50
14
25
50
15
25
50
16
25
50
17
25
50
18
25
50
19
25
50
20
25
50
22
25
50
23
25
50
24
25
50
25
25
50
26
25
50
27
25
50
28
25
50
30
25
50
모델명
규격(mm)
75×3T
75×4T
75×5T
75×6T
75×8T
75×10T
100×3T
100×4T
100×5T
100×7T
100×10T
125×3T
125×4T
125×6T
125×8T
150×3T
150×4T
150×6T
모델명
규격(mm)
A(mm)
L1(mm)
SM-3TS
T10
65
125
SM-3TS
T15
65
125
SM-3TS
T20
65
125
SM-3TS
T25
90
180
SM-3TS
T27
90
180
SM-3TS
T30
90
180
SM-3TS
T45
125
250
SM-3TS
T50
125
250
모델명
내경(Ø)
L(mm)
C(mm)
적용콜렛
BT30-C12-55
12
55
30
-
BT30-C20-70
20
70
54
NK20, KM20
BT30-C25-75
25
75
62
-
BT30-C32-100
32
100
69
NK32, KM32
BT40-C12-65
12
65
30
-
BT40-C12-90
12
90
30
-
BT40-C16-90
16
90
45
-
BT40-C20-70
20
70
54
NK20, KM20
BT40-C20-90
20
90
54
NK20, KM20
BT40-C25-70
25
70
62
-
BT40-C25-120
25
120
62
-
BT40-C32-85
32
85
72
NK32, KM32
BT40-C32-105
32
105
72
NK32, KM32
BT40-C32-120
32
120
72
NK32, KM32
BT50-C12-105
12
105
30
-
BT50-C16-135
16
135
45
-
BT50-C20-135
20
135
54
NK20, KM20
BT50-C25-135
25
135
62
-
BT50-C32-90
32
90
75
NK32, KM32
BT50-C32-105
32
105
75
NK32, KM32
BT50-C32-135
32
135
75
NK32, KM32
BT50-C32-165
32
165
75
NK32, KM32
BT50-C42-95
42
95
95
NK42, KM42
BT50-C42-105
42
105
95
NK42, KM42
BT50-C42-120
42
120
95
NK42, KM42
BT50-C42-135
42
135
95
NK42, KM42
BT50-C42-165
42
165
95
NK42, KM42
모델명
사용범위(mm)
23488
3~42
23493
3~35
모델명
규격(SQ)
능력(mm)
토크(N.m)
전장(mm)
중량(kg)
비고
KP-1498-VG
1/2
14
678
116
1.2
숏타입
KP-1493-VG
1/2
16
1085
179
1.9