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)
소비전력(W)
중량(kg)
EXACT 170E
Ø15~170
1100
5.7
EXACT-220E
Ø15~220
1100
6
EXACT-280PRO
Ø40~280
2500
15.5
EXACT 360
Ø75~360
2500
17.5
EXACT 460
Ø100~460
2500
17.7
모델명
굵기(Ø)
전장(mm)
두형
재질
261-1006
4
100
[+]
Al-Cu
260-1012
4
100
[-]
Al-Cu
261-1010
6
150
[+]
Al-Cu
260-1020
6
150
[-]
Al-Cu
261-1012
8
200
[+]
Al-Cu
260-1026
8
200
[-]
Al-Cu
261-1006 Be-Cu
4
100
[+]
Be-Cu
260-1012 Be-Cu
4
100
[-]
Be-Cu
260-1020 Be-Cu
6
150
[-]
Be-Cu
모델명
규격(mm)
외경(D1)
외경(D2)
전장(mm)
7
11
19
28
8
12
19
28
10
14.5
19
28
11
16
19
30
12
17
19
30
13
18.5
20
30
14
20
19
30
17
23.5
21
32
19
26
23
32
모델명
규격
구성(mm)
5pcs
3, 5, 6, 8, 10
8pcs
3, 4, 5, 6, 8, 10, 12, 14
14pcs
3, 4, 5, 6, 8, 10, 11, 13, 14, 16, 18, 19, 22, 25
모델명
측정범위(lux)
분해능(lux)
중량(g)
AR813
1~100000
1
116.5
AR823
1~100000
1
209
AR833
0.01~50000
0.01~1
116.5
모델명
사용범위(mm)
중량(kg)
캇타날
97212(15-SI)
5~28
0.6
E-1525
29963
5~35
E-1525
31803
6~65
E-1525
모델명
규격(mm)
D1(mm)
D2(mm)
L1(mm)
L(mm)
d(mm)
중량(g)
4S-08L
8
12.3
22
9
83
7
95
4S-09L
9
13.5
22
9
83
7
100
4S-10L
10
15
22
10
83
8
110
4S-11L
11
16.2
22
10
83
9
115
4S-12L
12
17.5
22
11
83
10
125
4S-13L
13
18.8
22
11
83
10
135
4S-14L
14
20
22
12
83
11
145
4S-15L
15
21
22
12
83
11
165
4S-16L
16
23
22
12
83
14
170
4S-17L
17
24
23
16
83
14
175
4S-18L
18
25
23
16
83
15
190
4S-19L
19
26
24
18
83
17
215
4S-20L
20
28
26
18
83
16
225
4S-21L
21
29
26
18
83
18
240
4S-22L
22
30
26
18
83
18
270
4S-23L
23
32
28
18
83
20
295
4S-24L
24
33
28
18
83
20
330
4S-25L
25
34
28
18
83
22
350
4S-26L
26
35
30
20
83
22
375
4S-27L
27
36
30
20
83
22
395
4S-28L
28
38
31
21
83
22
425
4S-29L
29
39
31
21
83
22
480
4S-30L
30
40
34
22
83
25
490
4S-32L
32
43
35
22
83
25
510
모델명
굵기(mm)
전장(mm)
712-1
8
100
712-2
10
120
712-3
12
120
모델명
굵기×기장
1박스(PCS)
FS32V1
2.1Ø×32mm
16000
FS38V1
2.1Ø×38mm
16000
FS45V1
2.1Ø×45mm
16000
FS50V1
2.1Ø×50mm
12000
FS50V5
2.5Ø×50mm
9000
FS57V5
2.5Ø×57mm
9000
FS64V5
2.5Ø×64mm
9000
FS70V5
2.5Ø×70mm
6000
FS75V9
2.9Ø×75mm
5000
FS83W1
3.1Ø×83mm
4000
FS90W1
3.1Ø×90mm
4000
FS100W1
3.1Ø×100mm
2250
모델명
규격(mm)
D1(mm)
D2(mm)
L1(mm)
L(mm)
4D-08
8
12.3
22
9
35
4D-09
9
13.5
22
9
35
4D-10
10
15
22
10
35
4D-11
11
16.2
22
10
35
4D-12
12
17.5
22
10
35
4D-13
13
18.8
22
10
35
4D-14
14
20
22
12
35
4D-15
15
22
22
12
35
4D-16
16
23
23
12
36
4D-17
17
24
23
13
37
4D-18
18
25
23
13
37
4D-19
19
26
24
14
38
4D-20
20
28
25
14
38
4D-21
21
29
25
15
39
4D-22
22
30
26
15
40
4D-23
23
32
27
16
41
4D-24
24
33
28
17
41
4D-25
25
34
28
19
43.5
4D-26
26
35
28
19
43.5
4D-27
27
36
19
19
43.5
4D-28
28
38
30
19
43.5
4D-29
29
39
31
19
43.5
4D-30
30
40
32
21
47
4D-32
32
43
34.5
21
47
4D-36
36
52
모델명
규격
A(mm)
B(mm)
1/4"
222
69
5/16"
220
85
3/8"
222
76
1/2"
226
102
5/8"
242
102
3/4"
238
117
1"
227
90
모델명
사용범위(SQ)
전장(mm)
UD-030I
2, 5.5
250
UD-030N-3
1.25, 2, 5.5
240