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)
D1(mm)
D2(mm)
L1(mm)
L(mm)
d(mm)
중량(g)
3S-06
6
9.3
17
5
26
4.5
20
3S-07
7
10.7
17
5
26
5
20
3S-08
8
11.7
17
6
26
7
20
3S-09
9
13.2
17
6
26
7
25
3S-10
10
14.7
17
7
26
8
30
3S-11
11
15.7
17
8
26
9
30
3S-12
12
17
18
8
26
10
35
3S-13
13
18.5
18
9
27
10
35
3S-14
14
19.5
18
9
27
11
45
3S-15
15
21
18
10
29
11
50
3S-16
16
22
19
10
29
14
50
3S-17
17
23
21
11
30
14
70
3S-18
18
24.5
21
12
32
15
70
3S-19
19
26
21
13
32
16
75
모델명
사용범위(mm)
나사산규격
구성
BDA-10H
1.5~10
1/2-20 UNF
드릴척 10mm+비트 6.35
BDA-13H
1.5~13
1/2-20 UNF
드릴척 13mm+비트 6.35
BDA-13S
1.5~13
1/2-20 UNF
드릴척 13mm+SDS PLUS
모델명
규격(mm)
1.5
2
2.5
3
4
5
6
8
10
12
16
모델명
측정범위(lux)
분해능(lux)
중량(g)
AR813
1~100000
1
116.5
AR823
1~100000
1
209
AR833
0.01~50000
0.01~1
116.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
모델명
규격(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)
6P
3, 4, 5, 5.5, 6, 8
9P
3, 4, 5, 5.5, 6, 8, 10, 11, 12
12P
3, 4, 5, 5.5, 6, 8, 9, 10, 11, 12, 14, 16
12P
3, 4, 5, 6, 8, 9, 10, 11, 12, 14, 16, 19
15P
3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 14, 16, 19, 22, 25
모델명
굵기×기장
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
모델명
외경(Ø)
내경(Ø)
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
모델명
규격(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)
705-1
8
90
705-2
8
100