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개씩 보기
모델명
절단능력(mm)
비고
SM-GL02
3~10
텅스텐카바이드휠
SM-GL03
3~10
텅스텐카바이드휠
모델명
노즐기장(mm)
MADA-0
24
MADA-100
100
MADA-200
200
MADA-300
300
모델명
측정범위(N.m)
최소눈금(N.m)
중량(kg)
DTT-150N
7.5~150
0.1
3.44
DTT-500N
25~500
0.1
4.06
모델명
규격(mm)
내경(mm)
CF14-20
14×20
7
CF14-25
14×25
7
CF14-30
14×30
7
CF14-35
14×35
7
CF14-40
14×40
7
CF14-45
14×45
7
CF14-50
14×50
7
CF14-55
14×55
7
CF14-60
14×60
7
CF14-65
14×65
7
CF14-70
14×70
7
CF14-75
14×75
7
CF14-80
14×80
7
CF14-90
14×90
7
CF14-100
14×100
7
CF16-20
16×20
8
CF16-25
16×25
8
CF16-30
16×30
8
CF16-35
16×35
8
CF16-40
16×40
8
CF16-45
16×45
8
CF16-50
16×50
8
CF16-55
16×55
8
CF16-60
16×60
8
CF16-65
16×65
8
CF16-70
16×70
8
CF16-75
16×75
8
CF16-80
16×80
8
CF16-90
16×90
8
CF16-100
16×100
8
CF18-20
18×20
9
CF18-25
18×25
9
CF18-30
18×30
9
CF18-35
18×35
9
CF18-40
18×40
9
CF18-45
18×45
9
CF18-50
18×50
9
CF18-55
18×55
9
CF18-60
18×60
9
CF18-65
18×65
9
CF18-70
18×70
9
CF18-75
18×75
9
CF18-80
18×80
9
CF18-90
18×90
9
CF18-100
18×100
9
CF20-20
20×20
10
CF20-25
20×25
10
CF20-30
20×30
10
CF20-35
20×35
10
CF20-40
20×40
10
CF20-45
20×45
10
CF20-50
20×50
10
CF20-55
20×55
10
CF20-60
20×60
10
CF20-65
20×65
10
CF20-70
20×70
10
CF20-75
20×75
10
CF20-80
20×80
10
CF20-90
20×90
10
CF20-100
20×100
10
CF20-125
20×125
10
CF22-25
22×25
11
CF22-30
22×30
11
CF22-35
22×35
11
CF22-40
22×40
11
CF22-45
22×45
11
CF22-50
22×50
11
CF22-55
22×55
11
CF22-60
22×60
11
CF22-65
22×65
11
CF22-70
22×70
11
CF22-75
22×75
11
CF22-80
22×80
11
CF22-90
22×90
11
CF22-100
22×100
11
CF22-125
22×125
11
CF25-25
25×25
13.5
CF25-30
25×30
13.5
CF25-35
25×35
13.5
CF25-40
25×40
13.5
CF25-45
25×45
13.5
CF25-50
25×50
13.5
CF25-55
25×55
13.5
CF25-60
25×60
13.5
CF25-65
25×65
13.5
CF25-70
25×70
13.5
CF25-80
25×80
13.5
CF25-90
25×90
13.5
CF25-100
25×100
13.5
CF25-125
25×125
13.5
CF25-150
25×150
13.5
CF27-25
27×25
13.5
CF27-30
27×30
13.5
CF27-35
27×35
13.5
CF27-40
27×40
13.5
CF27-45
27×45
13.5
CF27-50
27×50
13.5
CF27-55
27×55
13.5
CF27-60
27×60
13.5
CF27-65
27×65
13.5
CF27-70
27×70
13.5
CF27-75
27×75
13.5
CF27-80
27×80
13.5
CF27-90
27×90
13.5
CF27-100
27×100
13.5
CF27-125
27×125
13.5
CF27-150
27×150
13.5
CF30-25
30×25
16
CF30-30
30×30
16
CF30-35
30×35
16
CF30-40
30×40
16
CF30-45
30×45
16
CF30-50
30×50
16
CF30-55
30×55
16
CF30-60
30×60
16
CF30-65
30×65
16
CF30-70
30×70
16
CF30-75
30×75
16
CF30-80
30×80
16
CF30-90
30×90
16
CF30-100
30×100
16
CF30-125
30×125
16
CF30-150
30×150
16
CF30-175
30×175
16
CF30-200
30×200
16
CF35-40
35×40
19
CF35-45
35×45
19
CF35-50
35×50
19
CF35-55
35×55
19
CF35-60
35×60
19
CF35-65
35×65
19
CF35-70
35×70
19
CF35-75
35×75
19
CF35-80
35×80
19
CF35-90
35×90
19
CF35-100
35×100
19
CF35-125
35×125
19
CF35-150
35×150
19
CF35-175
35×175
19
CF35-200
35×200
19
CF40-40
40×40
22
CF40-50
40×50
22
CF40-60
40×60
22
CF40-70
40×70
22
CF40-80
40×80
22
CF40-90
40×90
22
CF40-100
40×100
22
CF40-125
40×125
22
CF40-150
40×150
22
CF40-175
40×175
22
CF40-200
40×200
22
CF40-250
40×250
22
CF50-50
50×50
27.5
CF50-60
50×60
27.5
CF50-70
50×70
27.5
CF50-80
50×80
27.5
CF50-90
50×90
27.5
CF50-100
50×100
27.5
CF50-125
50×125
27.5
CF50-150
50×150
27.5
CF50-175
50×175
27.5
CF50-200
50×200
27.5
CF50-250
50×250
27.5
CF50-300
50×300
27.5
CF60-60
60×60
33
CF60-70
60×70
33
CF60-80
60×80
33
CF60-90
60×90
33
CF60-100
60×100
33
CF60-125
60×125
33
CF60-150
60×150
33
CF60-175
60×175
33
CF60-200
60×200
33
CF60-250
60×250
33
CF60-300
60×300
33
모델명
규격(mm)
구성
009-1
1.5, 2, 2.5, 3, 4, 5, 6
7P
009-2
2.5, 3, 4, 5, 6, 8
6P
009-3
3, 4, 5, 6, 8, 10
6P
모델명
적용규격(mm)
C-2500
Ø35~Ø250
C-3500
Ø35~Ø350
C-4500
Ø35~Ø450
C-2500-0.5T용 칼날
모델명
노즐기장(mm)
형태
SA10-H
30
일반형, 상측
SA100-H
100
일반형, 상측
SA200-H
200
일반형, 상측
SA300-H
300
일반형, 상측
SA10-L
30
일반형, 하측
SA100-L
100
일반형, 하측
SA200-L
200
일반형, 하측
SA300-L
300
일반형, 하측
SA10-V
30
일반형, 밸브
SA100-V
100
일반형, 밸브
SA200-V
200
일반형, 밸브
SA300-V
300
일반형, 밸브
모델명
규격(mm)
RH8D
5.5
RH8D
6
RH8D
7
RH8D
8
RH8D
10
RH8D
11
RH8D
12
RH8D
13
RH10D
8
RH10D
10
RH10D
11
RH10D
12
RH10D
13
RH10D
14
RH10D
16
RH10D
17
RH10D
18
RH10D
19
RH10D
21
RH10D
22
RH12D
8
RH12D
10
RH12D
11
RH12D
12
RH12D
13
RH12D
14
RH12D
16
RH12D
17
RH12D
18
RH12D
19
RH12D
21
RH12D
22
RH15D
12
RH15D
13
RH15D
14
RH15D
16
RH15D
17
RH15D
18
RH15D
19
RH15D
21
RH15D
22
RH15D
24
RH15D
27
RH15D
30
RH19D
14
RH19D
17
RH19D
18
RH19D
19
RH19D
21
RH19D
22
RH19D
24
RH19D
27
RH19D
30
RH19D
32
RH19D
34
RH19D
36
RH19D
41
RH22D
19
RH22D
22
RH22D
24
RH22D
27
RH22D
30
RH22D
32
RH22D
34
RH22D
36
RH22D
41
RH22D
46
모델명
규격(mm)
두께L(mm)
B(mm)
1포장
MSW
M10
10
5
100EA
MSW
M12
10
6
100EA
MSW
M14
10
6
100EA
MSW
M16
10
8
100EA
MSW
M18
10
10
100EA
MSW
M20
12
10
100EA
MSW
M22
12
12
100EA
MSW
M24
12
14
100EA
MSW
M26
12
14
100EA
MSW
M27
12
14
100EA
MSW
M30
12
17
100EA
MSW
M33
12
17
100EA
MSW
M36
18
17
50EA
MSW
M38
18
17
10EA
MSW
M40
18
17
10EA
MSW
M42
18
17
30EA
모델명
규격(mm)
전장(mm)
LB-2.5
2.5
115
LB-3
3
130
LB-4
4
145
LB-5
5
165
LB-6
6
190
LB-8
8
210
LB-10
10
240
모델명
규격(mm)
적용
CD-N
Ø15
보루방, 일반드릴용
CD-N
Ø20
보루방, 일반드릴용
CD-N
Ø25
보루방, 일반드릴용
CD-N
Ø30
보루방, 일반드릴용
CD-N
Ø35
보루방, 일반드릴용
CD-N
Ø40
보루방, 일반드릴용
CD-N
Ø45
보루방, 일반드릴용
CD-N
Ø50
보루방, 일반드릴용
모델명
최대(kg)
최소눈금(g)
SW-1(2)
2
0.5
SW-1(2)
2
1
SW-1(5)
5
2
SW-1(10)
10
5
SW-1(20)
20
10
SW-1(30)
30
10
모델명
드릴능력(mm)
마력
모터(kw)
중량(kg)
HN-360
13
삼상 1/2HP
0.4×4P
80
HN-400
23
삼상 1/2HP
0.4×4P
88
HN-450
30
삼상 1HP
0.75×4P
140
모델명
규격(")
L1(mm)
L2(mm)
18204
1/16
14.2
76
18205
5/64
15.5
81
18206
3/32
16.8
86
18207
7/64
17.8
90
18208
1/8
19
95
18209
9/64
20
100
18210
5/32
21
105
18212
3/16
24
114
18214
7/32
26
124
18216
1/4
28
133
18220
5/16
32
152
18224
3/8
35
171
18228
7/16
38
191
18232
1/2
41
210
18236
9/16
44
229
18240
5/8
48
248
18248
3/4
54
286
18256
7/8
60
324