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)
나사산규격
6NS
6.5
0.6~6.5
3/8-24 UNF
10NS
10
1.5~10
3/8-24 UNF
10NS
10
1.5~10
1/2-20 UNF
13NS
13
1.5~13
3/8-24 UNF
13NS
13
1.5~13
1/2-20 UNF
모델명
사용탭규격
적용콜렛(포함)
최대속도
VTA 7-JT6
M2~M7
FC-10,FC-11
1500rpm
VTA 12-JT6
M3~M12
FC-20,FC-21
1000rpm
모델명
단수
A형태(M)
H형태(M)
보관높이(M)
중량(kg)
LS-43
4×3
1.6
3.3
1.1
11.4
LS-44
4×4
2.15
4.5
1.4
14
LS-45
4×5
2.75
5.7
1.64
16.3
LS-46
4×6
3.24
6.8
1.95
19.2
모델명
규격(mm)
작동압력
중량(kg)
HN25C SET
19~25
15~23kgf/㎠
1.9 + 25
HN120 SET
27~50
15~23kgf/㎠
2.9 + 25
모델명
파지범위(Ø)
C(mm)
적용콜렛
BT30-SK6-90 (TIN)
0.75~6.0
18
SK 6
BT30-SK10-60
1.75~10.0
27.5
SK 10
BT30-SK10-90 (TIN)
1.75~10.0
27.5
SK 10
BT30-SK16-90(TIN)
2.75~16.0
40
SK 16
BT40-SK6-90 (TIN)
0.75~6.0
18
SK 6
BT40-SK6-120 (TIN)
0.75~6.0
18
SK 6
BT40-SK10-90 (TIN)
1.75~10.0
27.5
SK 10
BT40-SK10-120(TIN)
1.75~10.0
27.5
SK 10
BT40-SK10-150 (TIN)
1.75~10.0
27.5
SK 10
BT40-SK16-90(TIN)
2.75~16.0
40
SK 16
BT40-SK16-120 (TIN)
2.75~16.0
40
SK 16
BT40-SK16-150 (TIN)
2.75~16.0
40
SK 16
BT40-SK25-90 (TIN)
16~25.4
55
SK 25
BT40-SK25-120 (TIN)
16~25.4
55
SK 25
BT50-SK10-165 (TIN)
1.75~10.0
27.5
SK 10
BT50-SK16-165(TIN)
2.75~16.0
40
SK 16
모델명
상판(폭×길이mm)
높이(최저~최고mm)
중량(kg)
SRS3-1200
300×1200
955~1230
9.15
SRS4-1200
400×1200
955~1230
11.05
SRS4-1500
400×1500
955~1230
12.05
SRS4-2000
400×2000
955~1230
13.9