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)
중량(g)
12627
(35)42
180
380
12628
(42)50
240
710
12629
(49)58
260
900
모델명
구성(mm)
전장(mm)
SM-HBS75
2.5, 3, 4, 5, 6
75
SM-HBS110
2.5, 3, 4, 5, 6
110
모델명
범위(mm)
정밀도(mm)
비고
2050S-60
20
0.01
러그형
2050S-19
20
0.01
러그형
2050SB-19
20
0.01
플래트백형
2052S
30
0.01
러그형
모델명
규격(mm)
전장(mm)
22
155
24
165
27
175
30
185
32
185
34
200
36
205
38
215
40
225
41
225
42
225
44
235
45
235
46
235
48
250
50
250
55
265
60
274
63
298
65
298
70
320
75
326
80
350
85
355
90
380
95
390
100
410
105
420
110
445
115
450
120
480
125
130
520
135
140
520
145
150
565
155
160
585
모델명
날장(mm)
전장(mm)
GOLD-265
265
599
GOLD-300
300
634
GOLD-330
330
666
모델명
규격(mm)
전장(mm)
S07-65L
7
65
S08-65L
8
65
S09-65L
9
65
S10-65L
10
65
S11-65L
11
65
S12-65L
12
65
S13-65L
13
65
S14-65L
14
65
S07-100L
7
100
S08-100L
8
100
S09-100L
9
100
S10-100L
10
100
S11-100L
11
100
S12-100L
12
100
S13-100L
13
100
S14-100L
14
100
S07-150L
7
150
S08-150L
8
150
S09-150L
9
150
S10-150L
10
150
S11-150L
11
150
S12-150L
12
150
S13-150L
13
150
S14-150L
14
150
모델명
규격(")
전장(mm)
1/4
93
3/8
116
7/16
131
1/2
147
9/16
168
5/8
189
11/16
207
3/4
230
7/8
280
15/16
309
1
332
1 1/4
418
1 3/8
461
1 7/16
486
1 1/2
486
모델명
날장(mm)
전장(mm)
중량(g)
톱니간격(mm)
TH-8
150
344
160
4
TH-8
180
408
190
4
TH-8
210
468
230
4
TH-9
200
439
235
4
TH-9
240
527
290
4
TH-9
270
580
330
4
THC-2002
300
630
400
4
THS-2002
300
636
378
4
모델명
규격
전장(mm)
1판
EA-3410
T10
75
5EA
EA-3415
T15
75
5EA
EA-3420
T20
75
5EA
EA-3425
T25
75
5EA
EA-3430
T30
75
5EA
모델명
날장(mm)
톱니간격(mm)
절단폭(mm)
톱날두께(mm)
교환톱날
F-140
140
3.25
1.1
1.2
F-140B
F-180
180
3.25
1.1
1.2
F-180B
F-210
210
3.75
1.15
1.25
F-210B
F-250
250
3.75
1.2
1.3
F-250B
F-270
270
3.75
1.25
1.35
F-270B
F-300
300
4.0
1.3
1.4
F-300B
모델명
구성
전장(mm)
SM-TBS75C
T10, T15, T20, T25, T30
75
SM-TBS110C
T10, T15, T20, T25, T30
110