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)
구성
55166
2, 2.5, 3, 4, 5, 6
150
6P
55168
2, 2.5, 3, 4, 5, 6, 8, 10
150
8P
55166
2, 2.5, 3, 4, 5, 6
228
6P
55168
2, 2.5, 3, 4, 5, 6, 8, 10
228
8P
모델명
작업범위(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
모델명
탭핑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
모델명
단수
보관높이(cm)
사용높이(cm)
중량(kg)
SU-GN3
3
91
77
8.2
SU-GN4
4
120
100
10.6
모델명
구성(P)
셋트규격
타입
7AFH-1
7P
1.5, 2, 2.5, 3, 4, 5, 6
미리(mm)
6AFB-1
6P
3, 4, 5, 6, [+]2, [-]5
미리(mm)
모델명
측정범위(N.m)
사각부(")
중량(kg)
BEM-TT50
5~50
3/8
2.8
BEM-TT220
22~220
1/2
3
모델명
외경(Ø)
내경(Ø)
KM20-6
20
6
KM20-8
20
8
KM20-10
20
10
KM20-12
20
12
KM20-16
20
16
KM32-6
32
6
KM32-8
32
8
KM32-10
32
10
KM32-12
32
12
KM32-16
32
16
KM32-20
32
20
KM32-25
32
25
KM42-6
42
6
KM42-8
42
8
KM42-10
42
10
KM42-12
42
12
KM42-16
42
16
KM42-20
42
20
KM42-25
42
25
KM42-32
42
32
모델명
사용범위(Ø)
KW-451
900
KW-901
1800
모델명
노즐기장(mm)
형태
PA500-L
500
일반형, 하측
PA800-L
800
일반형, 하측
PA1000-L
1000
일반형, 하측
모델명
규격(mm)
사각부
SH0912X7W
7
9×12
SH0912X8W
8
9×12
SH0912X9W
9
9×12
SH0912X10W
10
9×12
SH0912X11W
11
9×12
SH0912X12W
12
9×12
SH0912X13W
13
9×12
SH0912X14W
14
9×12
SH0912X15W
15
9×12
SH0912X16W
16
9×12
SH0912X17W
17
9×12
SH0912X18W
18
9×12
SH0912X19W
19
9×12
SH1418X13W
13
14×18
SH1418X14W
14
14×18
SH1418X15W
15
14×18
SH1418X16W
16
14×18
SH1418X17W
17
14×18
SH1418X18W
18
14×18
SH1418X19W
19
14×18
SH1418X21W
21
14×18
SH1418X22W
22
14×18
SH1418X24W
24
14×18
SH1418X27W
27
14×18
SH1418X30W
30
14×18
SH1418X32W
32
14×18
SH1418X34W
34
14×18
SH1418X36W
36
14×18
SH1418X38W
38
14×18
SH1418X41W
41
14×18
모델명
D(Ø)
D1(Ø)
W(Ø)
ZKN8-2
2
3
2.5
ZKN8-3
3
4
3.2
ZKN8-4
4
5
4.0
ZKN8-5
5
5.5
4.5
ZKN8-6
6
6
4.5
ZKN8-8
8
6.2
5.0
ZKN12-3
3
4
3.2
ZKN12-4
4
5
4.0
ZKN12-5
5
5.5
4.5
ZKN12-6
6
6
4.5
ZKN12-8
8
6.2
5.0
ZKN12-10
10
7
5.5
ZKN12-12
12
8.5
6.5
ZKN16-3
3
4
3.2
ZKN16-4
4
5
4.0
ZKN16-5
5
5.5
4.5
ZKN16-6
6
6
4.5
ZKN16-8
8
6.2
5.0
ZKN16-10
10
7
5.5
ZKN16-12
12
8.5
6.5
ZKN16-14
14
10.5
8.0
ZKN16-16
16
12.5
10.0
ZKN16-18
18
14
11.0
ZKN16-20
20
15
12.0
ZKN24-8
8
6.2
5.0
ZKN24-10
10
7
5.5
ZKN24-12
12
8.5
6.5
ZKN24-14
14
10.5
8.0
ZKN24-16
16
12.5
10.0
ZKN24-18
18
14
11.0
ZKN24-20
20
15
12.0
ZKN24-22
22
17
13.0
ZKN24-24
24
19
15.0
ZKN38-18
18
14
11.0
ZKN38-20
20
15
12.0
ZKN38-22
22
17
13.0
ZKN38-24
24
19
15.0
ZKN38-27
27
20
15.0
ZKN38-30
30
23
17.0
ZKN38-33
33
25
19.0
ZKN38-36
36
28
21.0
ZKN38-38
38
28
21.0
ZKN65-36
36
28
21
ZKN65-39
39
30
23
ZKN65-42
42
32
26
ZKN65-45
45
35
26
ZKN65-48
48
38
29
ZKN65-52
52
42
32
ZKN65-56
56
44
35
ZKN65-60
60
46
35
ZKN65-64
64
48
38
ZKN65-65
65
50
38
ZKN65-68
68
52
41
ZKN65-72
72
55
41
ZKN65-80
80
58
46
ZKN65-100
100
60
46
모델명
높이(mm)
HG-4
1200
HG-5
1500
HG-6
1800
HG-7
2100
HG-8
2400
HG-10
3000
HG-12
3600
HG-13
3900
모델명
규격(mm)
L1(mm)
L2(mm)
SB 369
2.5
18
111
SB 369
12
45
247
모델명
규격(mm)
SM-HMH06
6
SM-HMH08
8
SM-HMH10
10
SM-HMH12
12
SM-HMH14
14