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)
146-1002
5.5×7
90
146-1004
6×7
92
146-1006
6×8
94
146-1008
7×9
96
146-1010
8×9
98
146-1012
8×10
100
146-1014
9×10
105
146-1016
9×11
110
146-1018
10×11
115
146-1020
10×12
120
146-1022
10×13
122
146-1024
10×14
124
146-1026
11×13
126
146-1028
12×13
128
146-1030
12×14
130
146-1032
13×17
140
146-1034
14×15
143
146-1036
14×17
150
146-1038
16×17
157
146-1040
16×18
163
146-1042
17×19
170
146-1044
17×21
173
146-1046
17×22
176
146-1048
18×19
179
146-1050
19×21
182
146-1052
19×22
185
146-1054
19×24
190
146-1056
20×22
195
146-1058
21×23
200
146-1060
21×26
205
146-1062
22×24
210
146-1064
22×27
215
146-1066
23×26
220
146-1068
24×26
225
146-1070
24×27
230
146-1072
24×30
233
146-1074
25×28
236
146-1076
26×29
240
146-1078
26×32
243
146-1080
27×29
246
146-1082
27×30
250
146-1084
27×32
255
146-1086
29×32
260
146-1088
30×32
265
146-1090
30×36
270
146-1092
32×34
270
146-1094
32×36
300
146-1096
34×36
300
146-1098
36×38
330
146-1100
36×41
330
146-1102
38×40
330
146-1104
41×46
355
146-1106
46×50
370
146-1108
50×55
385
146-1110
50×60
400
146-1112
55×60
415
146-1114
60×65
435
65×70
65×75
70×80
75×80
모델명
규격(mm)
D(mm)
전장(mm)
E12
16
78
E18
22
78
E10
14
78
모델명
사용범위(mm)
SM-PC224
36
SM-PC225
42
SM-PC226
63
모델명
규격(LBS)
중량(kg)
재질
191-1004
2
1
Al-Cu
191-1006
3
1.4
Al-Cu
191-1010
4
1.8
Al-Cu
191-1004
2
1
Be-Cu
모델명
구성(mm)
전장(mm)
HBH306
3, 4, 5, 6, 8, 10
75
HBH306L
3, 4, 5, 6, 8, 10
125
모델명
작업범위(mm)
중량(kg)
적용날
32870
20~50
3.1
F3S
32880
60~100
9.1
F229S
모델명
폭(mm)
전장(mm)
중량(g)
206-1002
30
345
300
206-1004
30
445
440
206-1006
35
500
580
206-1008
50
500
910
206-1010
60
560
1330
모델명
A×B(mm)
C×D(mm)
중량(kg)
HKL20
200×110
20×5
0.32
HKL30
300×110
20×5
0.46
HKL80
800×110
20×5
0.86
HKL100
1000×110
20×5
1