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개씩 보기
모델명
외경(Ø)
내경(Ø)
NK20-6
20
6
NK20-8
20
8
NK20-10
20
10
NK20-12
20
12
NK20-16
20
16
NK32-6
32
6
NK32-8
32
8
NK32-10
32
10
NK32-12
32
12
NK32-16
32
16
NK32-20
32
20
NK32-25
32
25
NK42-8
42
8
NK42-10
42
10
NK42-12
42
12
NK42-16
42
16
NK42-20
42
20
NK42-32
42
32
모델명
밝기(lm)
충전시간
사용시간
SP-300R1
800/1300
3시간
2시간 30분
SP-300R2
800/1300
6시간
5시간 30분
모델명
허용하중(ton)
길이×넓이×높이(mm)
바퀴수
중량(kg)
SRE-6D
6
300×215×105
4
13
SRE-8D
8
400×215×105
6
19
SRE-12D
12
500×215×105
8
24
SRE-15D
15
400×305×108
9
27
SRE-20D
20
500×305×108
12
36
모델명
탭핑M
탭핑U
탭핑P
적용탭콜렛
BT30-Z8-90
M2~8
U1/8~1/4
-
ZKN 8
BT30-Z12-105
M3~12
U1/8~1/2
P1/8
ZKN 12
BT40-Z8-90
M2~8
U1/8~1/4
-
ZKN 8
BT40-Z12-90
M3~12
U1/8~1/2
P1/8
ZKN 12
BT40-Z12-130
M3~12
U1/8~1/2
P1/8
ZKN 12
BT40-Z16-109
M3~20
U1/8~5/8
P1/8~3/8
ZKN 16
BT40-Z24-100
M8~24
U1/2~1
P1/4~5/8
ZKN 24
BT40-Z24-187
M8~24
U1/2~1
P1/4~5/8
ZKN 24
BT40-Z38-140
M18~38
U3/4~1 3/8
P3/8~1
ZKN 38
BT50-Z8-105
M2~8
U1/8~1/4
-
ZKN 8
BT50-Z12-130
M3~12
U1/8~1/2
P1/8
ZKN 12
BT50-Z12-175
M3~12
U1/8~1/2
P1/8
ZKN 12
BT50-Z12-220
M3~12
U1/8~1/2
P1/8
ZKN 12
BT50-Z16-135
M3~20
U1/8~5/8
P1/8~3/8
ZKN 16
BT50-Z24-142
M8~24
U1/2~1
P1/4~5/8
ZKN 24
BT50-Z24-187
M8~24
U1/2~1
P1/4~5/8
ZKN 24
BT50-Z38-175
M18~38
U3/4~1 3/8
P3/8~1
ZKN 38
BT50-Z65-160
M36~100
U1~3 3/8
P1~3 1/4
ZKN 65
모델명
규격(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
모델명
적용 퀵체인지 홀더 No.
쟈콥스테이퍼
DT35-6BD
HA 40-T35
JT-6
DT45-6BD
HA 50-T45
JT-6
모델명
구성(P)
구성(mm)
4p
10, 12, 13, 14
7p
8, 10, 12, 13, 14, 17, 19
9P
8, 9, 10, 11, 12, 13, 14, 17, 19
12p
8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19
모델명
내경(mm)
외경(mm)
길이(m)
상용압력(kgf/㎠)
8
14
100
50
9.5
16
100
50
13
20
100
45
16
24
100
40
19
29
50
35
25
35
50
30
모델명
인선직경(Ø)
절삭길이(mm)
전장(mm)
SM-1M D/C
6
12.7
50
SM-2M D/C
6
19
50
SM-3M D/C
6
25
50
SM-4M D/C
9.5
16
63
SM-5M D/C
12.7
22
69
SM-6M D/C
16
25
73