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)
나사산규격
잠금장치
10HA3/8
10
1~10
3/8-24
무
13HA1/2
13
2~13
1/2-20
무
10HL3/8
10
1~10
3/8-24
유
10HL1/2
10
1~10
1/2-20
유
13HL3/8
13
1.5~13
3/8-24
유
13HL1/2
13
1.5~13
1/2-20
유
모델명
단수
가로×세로×높이(mm)
하중(kg)
중량(kg)
SLB03G
3단
479×706×661
100
3.7
SLB02G
2단
모델명
두경(mm)
두장(mm)
전장(mm)
중량(kg)
SH-09SM
36
95
280
0.9
OHW-2SM
37
105
280
0.9
모델명
테이퍼
TAP 능력
SDT24-2
MT2
M4~M14, U3/16~U1/2, P1/8~P1/4
SDT24-3
MT3
M4~M24, U3/16~U7/8, P1/8~P1/2
SDT24-4
MT4
M4~M24, U3/16~U7/8, P1/8~P1/2
SDT33-4
MT4
M6~M33, U5/16~U1 1/4, P1/8~P1
SDT33-5
MT5
M6~M33, U5/16~U1 1/4, P1/8~P1
모델명
단수
높이(cm)
W(cm)
D(cm)
중량(kg)
UF-02
2단
52
43
56
3
UF-03
3단
80
43
77
4.3
모델명
소비전력(W)
회전수(RPM)
중량(kg)
비고
GA4030
720
11000
1.4
슬라이드 스위치
GA4031
720
11000
1.4
후면토글 스위치
모델명
능력(")
사용펌프
스트로크(mm)
중량(kg)
TPB-2
2
THPA-1B, 전동 1/2HP
255
40
TPB-3
3
THPA-1C, 전동 1/2HP
280
114
TPB-4
4
THPA-1C, 전동 1HP
300
130
모델명
능력(Ø)
크기(D×L)
적용모델
FC-10
2.5~4.5
16×11
VTA 7-JT6
FC-11
4.5~6.5
16×11
VTA 7-JT6
FC-20
4.5~7.5
21.5×13
VTA 12-JT6
FC-21
7.5~10
21.5×13
VTA 12-JT6
모델명
두경(mm)
두장(mm)
전장(mm)
중량(kg)
CO-05
25
73
300
0.32
CO-10
30
88
320
0.54
CO-15
35
97
330
0.77
CO-20
38
110
350
1
CO-30
45
121
360
1.5
CO-40
50
134
450
2.1
모델명
팁굵기
적용모델
19Ø
JY-22200
22Ø
JY-22300
27Ø
JY-22500
모델명
간격(mm)
C(Ø)
전장(mm)
BER-11-0.5-1
1
11.5
18
BER-11-1-1.5
1
11.5
18
BER-11-1.5-2
1
11.5
18
BER-11-2-2.5
1
11.5
18
BER-11-2.5-3
1
11.5
18
BER-11-3-3.5
1
11.5
18
BER-11-3.5-4
1
11.5
18
BER-11-4-4.5
1
11.5
18
BER-11-4.5-5
1
11.5
18
BER-11-5-5.5
1
11.5
18
BER-11-5.5-6
1
11.5
18
BER-11-6-6.5
1
11.5
18
BER-11-6.5-7
1
11.5
18
BER-16-0.5-1
1
17
27
BER-16-1.5-2
1
17
27
BER-16-2-3
1
17
27
BER-16-3-4
1
17
27
BER-16-4-5
1
17
27
BER-16-5-6
1
17
27
BER-16-6-7
1
17
27
BER-16-7-8
1
17
27
BER-16-8-9
1
17
27
BER-16-9-10
1
17
27
BER-20-0.5-1
1
21
31
BER-20-1-2
1
21
31
BER-20-2-3
1
21
31
BER-20-3-4
1
21
31
BER-20-4-5
1
21
31
BER-20-5-6
1
21
31
BER-20-6-7
1
21
31
BER-20-7-8
1
21
31
BER-20-8-9
1
21
31
BER-20-9-10
1
21
31
BER-20-10-11
1
21
31
BER-20-11-12
1
21
31
BER-20-12-13
1
21
31
BER-25-1-2
1
26
35
BER-25-2-3
1
26
35
BER-25-3-4
1
26
35
BER-25-4-5
1
26
35
BER-25-5-6
1
26
35
BER-25-6-7
1
26
35
BER-25-7-8
1
26
35
BER-25-8-9
1
26
35
BER-25-9-10
1
26
35
BER-25-10-11
1
26
35
BER-25-11-12
1
26
35
BER-25-12-13
1
26
35
BER-25-13-14
1
26
35
BER-25-14-15
1
26
35
BER-25-15-16
1
26
35
BER-32-1-2
1
33
40
BER-32-2-3
1
33
40
BER-32-3-4
1
33
40
BER-32-4-5
1
33
40
BER-32-5-6
1
33
40
BER-32-6-7
1
33
40
BER-32-7-8
1
33
40
BER-32-8-9
1
33
40
BER-32-9-10
1
33
40
BER-32-10-11
1
33
40
BER-32-11-12
1
33
40
BER-32-12-13
1
33
40
BER-32-13-14
1
33
40
BER-32-14-15
1
33
40
BER-32-15-16
1
33
40
BER-32-16-17
1
33
40
BER-32-17-18
1
33
40
BER-32-18-19
1
33
40
BER-32-19-20
1
33
40