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)
정밀도(mm)
105-103
500~600
0.01
105-104
600~700
0.01
105-105
700~800
0.01
105-107
900~1,000
0.01
105-408
1,000~1,100
0.01
105-409
1,100~1,200
0.01
105-410
1,200~1,300
0.01
105-411
1,300~1,400
0.01
105-412
1,400~1,500
0.01
105-418
1,000~1,200
0.01
105-413
1,500~1,600
0.01
105-414
1,600~1,700
0.01
105-415
1,700~1,800
0.01
105-419
1,200~1,400
0.01
105-416
1,800~1,900
0.01
105-420
1,400~1,600
0.01
105-421
1,600~1,800
0.01
105-422
1,800~2,000
0.01
모델명
1포장
다후다각반
10EA
치마각반
10EA
모델명
규격(mm)
D1(mm)
D2(mm)
L(mm)
24M32L
32
60
86
140
24M33L
33
60
86
140
24M34L
34
60
86
140
2422M35L
35
60
86
140
24M36L
36
64
86
140
24M37L
37
64
86
140
2424M38L
38
64
86
140
24M39L
39
70
86
140
24M40L
40
70
86
140
2426M41L
41
70
86
140
24M42L
42
70
86
140
2427M43L
43
75
86
140
24M44L
44
75
86
140
24M45L
45
75
86
140
2429M46L
46
75
86
140
24M47L
47
75
86
140
24M48L
48
80
86
140
2431M49L
49
80
86
140
24M50L
50
80
86
140
2432M51L
51
80
86
140
24M52L
52
80
86
140
2434M54L
54
86
86
140
24M55L
55
86
86
140
24M56L
56
86
86
140
2436M57L
57
86
86
140
24M58L
58
92
86
140
2437M59L
59
92
86
140
24M60L
60
92
86
140
24M61L
61
96
86
140
2439M62L
62
96
86
140
2441M65L
65
100
86
140
2442M67L
67
100
86
140
2444M70L
70
105
86
140
2446M73L
73
109
86
140
2447M75L
75
109
86
140
2448M76L
76
115
86
140
24M77L
77
115
86
140
24M80L
80
115
86
140
24M85L
85
121
86
140
2454M86L
86
127
86
140
24M90L
90
130
86
140
2460M95L
95
135
127
150
2463M100L
100
140
127
150
2466M105L
105
150
127
150
2469M110L
110
155
127
160
24M115L
115
160
127
160
24M120L
120
165
127
170
24M125L
125
170
127
180
2482M130L
130
180
127
185
2462L
3 7/8"
모델명
규격(")
D(mm)
H(mm)
T(mm)
L(mm)
RH31F
3/8
35
33.4
22.6
250
RH41F
1/2
35
37.4
22.6
280
모델명
규격
절단두께(mm)
#0
5~10
#1
10~15
#2
15~30
#3
30~40
#4
40~50
#5
50~100
#6
100~150
#7
150~250
#8
250~300
모델명
볼트규격
L(mm)
W(mm)
H(mm)
CPSC125-20
M20
125
50
22
CPSC160-24
M24
160
60
28
CPSC200-20
M20
200
65
32
CPSC200-24
M24
200
65
32
CPSC250-24
M24
250
70
32
CPSC315-30
M30
315
80
50
모델명
L(mm)
A×B×T(mm)
PITCH
CTB22-350
350
40×15×22
M22×2.5P
CTB22-400
400
40×15×22
M22×2.5P
모델명
홀규격(mm)
비고
7001-10
Ø8
58Ø 톱니형 앤빌
7002-10
Ø8
58Ø 평면 앤빌
7007-10
Ø8
90Ø 사각 앤빌
모델명
용도
적용모델
CBN
HSS연마
VDG-30
SDC
초경연마
VDG-30
모델명
작업범위(kgf.cm)
최소눈금(kgf.cm)
중량(kg)
Limit swith
A225C7
50~225
2.5
1
미부착
A450C7
100~500
5
1.5
미부착
A900C7
200~900
10
2
미부착
A1800C
400~1800
20
3.3
미부착
ACLS250M(A225C7LS)
50~225
2.5
1.2
부착
ACLS500M3
100~500
5
1.7
부착
ACLS1000M2
200~900
10
2.2
부착
A1800CLS
400~1800
20
3.5
부착
AC500M2
AC250M3
50~250
2.5