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개씩 보기
모델명
구성(P)
셋트규격
타입
7FMH-1
7P
1.5~6
미리(mm)
7FMH-2
7P
2.5~10
미리(mm)
7FSH-1
7P
1/16~7/32
인치(inch)
모델명
노즐기장(mm)
BA-601-0
24
BA-601-1
100
BA-601-2
200
BA-601-3
300
모델명
증폭
입력,출력
최대출력토크
31010
3.5배
1/2",3/4"
800N.m
31020
3.6배
3/4", 1"
1800N.m
모델명
규격
적용날
EL0100GT
2.6mm
B날용
EL0200GT
3.2mm
E날용
모델명
규격(mm)
구성
009-1
1.5, 2, 2.5, 3, 4, 5, 6
7P
009-2
2.5, 3, 4, 5, 6, 8
6P
009-3
3, 4, 5, 6, 8, 10
6P
모델명
규격(mm)
TC1200A
1200
TC1500A
1500
TC1800A
1800
모델명
노즐기장(mm)
ADP-0
24
ADP-100
100
ADP-200
200
ADP-300
300
모델명
규격(mm)
내경(mm)
CF14-20
14×20
7
CF14-25
14×25
7
CF14-30
14×30
7
CF14-35
14×35
7
CF14-40
14×40
7
CF14-45
14×45
7
CF14-50
14×50
7
CF14-55
14×55
7
CF14-60
14×60
7
CF14-65
14×65
7
CF14-70
14×70
7
CF14-75
14×75
7
CF14-80
14×80
7
CF14-90
14×90
7
CF14-100
14×100
7
CF16-20
16×20
8
CF16-25
16×25
8
CF16-30
16×30
8
CF16-35
16×35
8
CF16-40
16×40
8
CF16-45
16×45
8
CF16-50
16×50
8
CF16-55
16×55
8
CF16-60
16×60
8
CF16-65
16×65
8
CF16-70
16×70
8
CF16-75
16×75
8
CF16-80
16×80
8
CF16-90
16×90
8
CF16-100
16×100
8
CF18-20
18×20
9
CF18-25
18×25
9
CF18-30
18×30
9
CF18-35
18×35
9
CF18-40
18×40
9
CF18-45
18×45
9
CF18-50
18×50
9
CF18-55
18×55
9
CF18-60
18×60
9
CF18-65
18×65
9
CF18-70
18×70
9
CF18-75
18×75
9
CF18-80
18×80
9
CF18-90
18×90
9
CF18-100
18×100
9
CF20-20
20×20
10
CF20-25
20×25
10
CF20-30
20×30
10
CF20-35
20×35
10
CF20-40
20×40
10
CF20-45
20×45
10
CF20-50
20×50
10
CF20-55
20×55
10
CF20-60
20×60
10
CF20-65
20×65
10
CF20-70
20×70
10
CF20-75
20×75
10
CF20-80
20×80
10
CF20-90
20×90
10
CF20-100
20×100
10
CF20-125
20×125
10
CF22-25
22×25
11
CF22-30
22×30
11
CF22-35
22×35
11
CF22-40
22×40
11
CF22-45
22×45
11
CF22-50
22×50
11
CF22-55
22×55
11
CF22-60
22×60
11
CF22-65
22×65
11
CF22-70
22×70
11
CF22-75
22×75
11
CF22-80
22×80
11
CF22-90
22×90
11
CF22-100
22×100
11
CF22-125
22×125
11
CF25-25
25×25
13.5
CF25-30
25×30
13.5
CF25-35
25×35
13.5
CF25-40
25×40
13.5
CF25-45
25×45
13.5
CF25-50
25×50
13.5
CF25-55
25×55
13.5
CF25-60
25×60
13.5
CF25-65
25×65
13.5
CF25-70
25×70
13.5
CF25-80
25×80
13.5
CF25-90
25×90
13.5
CF25-100
25×100
13.5
CF25-125
25×125
13.5
CF25-150
25×150
13.5
CF27-25
27×25
13.5
CF27-30
27×30
13.5
CF27-35
27×35
13.5
CF27-40
27×40
13.5
CF27-45
27×45
13.5
CF27-50
27×50
13.5
CF27-55
27×55
13.5
CF27-60
27×60
13.5
CF27-65
27×65
13.5
CF27-70
27×70
13.5
CF27-75
27×75
13.5
CF27-80
27×80
13.5
CF27-90
27×90
13.5
CF27-100
27×100
13.5
CF27-125
27×125
13.5
CF27-150
27×150
13.5
CF30-25
30×25
16
CF30-30
30×30
16
CF30-35
30×35
16
CF30-40
30×40
16
CF30-45
30×45
16
CF30-50
30×50
16
CF30-55
30×55
16
CF30-60
30×60
16
CF30-65
30×65
16
CF30-70
30×70
16
CF30-75
30×75
16
CF30-80
30×80
16
CF30-90
30×90
16
CF30-100
30×100
16
CF30-125
30×125
16
CF30-150
30×150
16
CF30-175
30×175
16
CF30-200
30×200
16
CF35-40
35×40
19
CF35-45
35×45
19
CF35-50
35×50
19
CF35-55
35×55
19
CF35-60
35×60
19
CF35-65
35×65
19
CF35-70
35×70
19
CF35-75
35×75
19
CF35-80
35×80
19
CF35-90
35×90
19
CF35-100
35×100
19
CF35-125
35×125
19
CF35-150
35×150
19
CF35-175
35×175
19
CF35-200
35×200
19
CF40-40
40×40
22
CF40-50
40×50
22
CF40-60
40×60
22
CF40-70
40×70
22
CF40-80
40×80
22
CF40-90
40×90
22
CF40-100
40×100
22
CF40-125
40×125
22
CF40-150
40×150
22
CF40-175
40×175
22
CF40-200
40×200
22
CF40-250
40×250
22
CF50-50
50×50
27.5
CF50-60
50×60
27.5
CF50-70
50×70
27.5
CF50-80
50×80
27.5
CF50-90
50×90
27.5
CF50-100
50×100
27.5
CF50-125
50×125
27.5
CF50-150
50×150
27.5
CF50-175
50×175
27.5
CF50-200
50×200
27.5
CF50-250
50×250
27.5
CF50-300
50×300
27.5
CF60-60
60×60
33
CF60-70
60×70
33
CF60-80
60×80
33
CF60-90
60×90
33
CF60-100
60×100
33
CF60-125
60×125
33
CF60-150
60×150
33
CF60-175
60×175
33
CF60-200
60×200
33
CF60-250
60×250
33
CF60-300
60×300
33
모델명
규격(mm)
오지단피(SK-B03)
320
이지어깨토시
880
가죽오지토시장피(SK-14)
510
케블라이지
320
모델명
규격(mm)
전장(mm)
LB-2.5
2.5
115
LB-3
3
130
LB-4
4
145
LB-5
5
165
LB-6
6
190
LB-8
8
210
LB-10
10
240
모델명
규격(mm)
SM-CDL05
5
SM-CDL06
6
SM-CDL08
8
SM-CDL10
10
SM-CDL12
12
SM-CDL15
15
SM-CDL16
16
SM-CDL18
18
SM-CDL20
20
SM-CDL22
22
SM-CDL25
25
SM-CDL28
28
SM-CDL30
30
SM-CDL32
32
SM-CDL35
35
SM-CDL40
40
SM-CDL45
45
SM-CDL50
50
SM-CDL55
55
SM-CDL65
65
SM-CDL68
68
SM-CDL76
76
SM-CDL102
102
SM-CDL105
105
모델명
노즐기장(mm)
형태
PA10-H
30
일반형, 상측
PA100-H
100
일반형, 상측
PA200-H
200
일반형, 상측
PA300-H
300
일반형, 상측
PA10-L
30
일반형, 하측
PA100-L
100
일반형, 하측
PA200-L
200
일반형, 하측
PA300-L
300
일반형, 하측
PA10-V
30
일반형, 밸브
PA100-V
100
일반형, 밸브
PA200-V
200
일반형, 밸브
PA300-V
300
일반형, 밸브
모델명
규격(mm)
두께L(mm)
B(mm)
1포장
MSW
M10
10
5
100EA
MSW
M12
10
6
100EA
MSW
M14
10
6
100EA
MSW
M16
10
8
100EA
MSW
M18
10
10
100EA
MSW
M20
12
10
100EA
MSW
M22
12
12
100EA
MSW
M24
12
14
100EA
MSW
M26
12
14
100EA
MSW
M27
12
14
100EA
MSW
M30
12
17
100EA
MSW
M33
12
17
100EA
MSW
M36
18
17
50EA
MSW
M38
18
17
10EA
MSW
M40
18
17
10EA
MSW
M42
18
17
30EA
모델명
규격(")
L1(mm)
L2(mm)
18204
1/16
14.2
76
18205
5/64
15.5
81
18206
3/32
16.8
86
18207
7/64
17.8
90
18208
1/8
19
95
18209
9/64
20
100
18210
5/32
21
105
18212
3/16
24
114
18214
7/32
26
124
18216
1/4
28
133
18220
5/16
32
152
18224
3/8
35
171
18228
7/16
38
191
18232
1/2
41
210
18236
9/16
44
229
18240
5/8
48
248
18248
3/4
54
286
18256
7/8
60
324