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개씩 보기
모델명
외경×길이
적용모델
비고
38Ø×2.5M
BY-782, 783, 784, 785, BF584A-3
셋트
38Ø×4.5M
BY-782, 783, 784, 785, BF584A-3
셋트
38Ø×1M
BY-782, 783, 784, 785, BF584A-3
1m단위
호스만
38Ø×5M
BY-782, 783, 784, 785, BF584A-3
모델명
규격(mm)
날장(mm)
전장(mm)
1
19
34
1.1
20
36
1.2
21
38
1.3
22
40
1.4
23
42
1.5
24
44
1.6
25
46
1.7
26
48
1.8
27
50
1.9
28
52
2
29
55
2.1
30
56
2.2
31
57
2.3
33
58
2.4
34
61
2.5
35
62
2.6
36
63
2.7
37
64
2.8
39
67
2.9
40
68
3
41
69
3.1
42
70
3.2
42
71
3.3
43
72
3.4
44
73
3.5
45
75
3.6
48
76
3.7
49
77
3.8
50
78
3.9
51
79
4
54
83
4.1
54
83
4.2
54
83
4.3
54
83
4.4
56
86
4.5
57
87
4.6
58
88
4.7
59
89
4.8
59
89
4.9
60
90
5
61
91
5.1
62
92
5.2
64
95
5.3
64
95
5.4
64
95
5.5
64
95
5.6
67
98
5.7
67
98
5.8
67
98
5.9
67
98
6
70
102
6.1
70
102
6.2
70
102
6.3
70
102
6.4
73
105
6.5
73
105
6.6
73
105
6.7
73
105
6.8
73
105
6.9
74
106
7
75
107
7.1
75
108
7.2
75
108
7.3
76
109
7.4
77
110
7.5
78
111
7.6
78
111
7.7
79
112
7.8
80
113
7.9
81
114
8
81
114
모델명
소비전력(W)
회전수(RPM)
중량(kg)
비고
GBM 6RE-KC
350
0~4000
1.1
키척타입
GBM 6RE-KLC
350
0~4000
1.1
키레스척
모델명
적용모델
DG-100B, MBC-03, EBS-30
DG-100BM
DG-100BV
ACT-100SN 신형
ACT-100M
DG-150C
DGS-180C
DGJ-180FA, DG-180FB, DG-230FB
PG-6
PG-604
PG-125
PD-6K2, PD-6KB
PDS1-10R, PDS2-10
PD-6CA
PD-10C
DV-10F
PD-13
D-13, D-16
D-23
DH-32A
DMV-13
DMV-570, DV-13, DMV-650P
PHD-38
PHD-3800
KH-6500
NHC-14D (단자타입), NHC-14S
DC-355
CS-7CA
CS-9A
CS-15B
LCS-350L,400L
PP-3A
RT-12
UB-03A
PIW-13
DP-7000
DS-7000
ET-8
BR-20
KI-550K DIY
WA-3500
WA-5000
HC-14K,HC-355
모델명
절단깊이(mm)
적용기종
GDE 125EA-S
25
GWS 750-125
GDE 125EA-T
25
GWS 15-125 CISTH, GWS 17-125 INOX
GDE 115/125FC-T
25
GWS 15-125 CISTH, GWS 17-125 INOX
GDE 230FC-S
60
GWS 20-230
GDE 230FC-T
60
GWS 24-230 LVI