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)
75×3T
75×4T
75×5T
75×6T
75×8T
75×10T
100×3T
100×4T
100×5T
100×7T
100×10T
125×3T
125×4T
125×6T
125×8T
150×3T
150×4T
150×6T
모델명
측정범위(kgf.cm)
측정범위(N.m)
최대벌림(mm)
전장(mm)
중량(kg)
BEM-60AH
612.2
3~60
27
428
1.19
BEM-135AH
1378
6.8~135
30
525
1.4
BEM-200AH
2041
10~200
41
650
1.6
모델명
규격
L1(mm)
L2(mm)
A(mm)
362TR
T7H
60
164
23
362TR
T8H
60
164
23
362TR
T9H
60
171
30
362TR
T10H
80
191
30
362TR
T15H
80
191
30
362TR
T20H
100
211
30
362TR
T25H
100
211
30
362TR
T27H
115
233
36
362TR
T30H
115
233
36
362TR
T40H
230
254
41
모델명
내경(Ø)
L(mm)
C(mm)
적용콜렛
BT30-C12-55
12
55
30
-
BT30-C20-70
20
70
54
NK20, KM20
BT30-C25-75
25
75
62
-
BT30-C32-100
32
100
69
NK32, KM32
BT40-C12-65
12
65
30
-
BT40-C12-90
12
90
30
-
BT40-C16-90
16
90
45
-
BT40-C20-70
20
70
54
NK20, KM20
BT40-C20-90
20
90
54
NK20, KM20
BT40-C25-70
25
70
62
-
BT40-C25-120
25
120
62
-
BT40-C32-85
32
85
72
NK32, KM32
BT40-C32-105
32
105
72
NK32, KM32
BT40-C32-120
32
120
72
NK32, KM32
BT50-C12-105
12
105
30
-
BT50-C16-135
16
135
45
-
BT50-C20-135
20
135
54
NK20, KM20
BT50-C25-135
25
135
62
-
BT50-C32-90
32
90
75
NK32, KM32
BT50-C32-105
32
105
75
NK32, KM32
BT50-C32-135
32
135
75
NK32, KM32
BT50-C32-165
32
165
75
NK32, KM32
BT50-C42-95
42
95
95
NK42, KM42
BT50-C42-105
42
105
95
NK42, KM42
BT50-C42-120
42
120
95
NK42, KM42
BT50-C42-135
42
135
95
NK42, KM42
BT50-C42-165
42
165
95
NK42, KM42
모델명
사용범위(mm)
23488
3~42
23493
3~35
모델명
전압(V)
1판
LR03 UP(AAA)
1.5
2EA
LR03 UP(AAA)
1.5
4EA
LR6 UP (AA)
1.5
2EA
LR6 UP (AA)
1.5
4EA
모델명
가로(mm)
세로(mm)
높이(mm)
Y-280
290
150
105
Y-350
360
150
110
Y-410
420
155
120
Y-530
540
210
190
모델명
날장(mm)
전장(mm)
DG-102
180
400
DG-103
210
455
DG-104
250
520
모델명
외경×두께(mm)
75×0.5T
75×0.8T
75×1.0T
75×1.2T
75×1.5T
75×2.0T
75×2.5T
75×3.0T
100×0.5T
100×0.8T
100×1.0T
100×1.2T
100×1.5T
100×2.0T
100×2.5T
100×3.0T
100×3.5T
100×4.0T
100×4.5T
100×5.0T
100×6.0T
125×0.5T
125×1.0T
125×1.5T
125×2.0T
125×3.0T
125×4.0T
150×1.0T
150×2.0T
150×3.0T
150×4.0T
모델명
내경(Ø)×외경(Ø)×길이(m)
중량(kg)
6×8×90
2.2
8×11×90
3.7
9×12×90
4
10×13×90
5
12×15×90
6
모델명
차광도
케이스
J-29B
#1.7
유
J-29B
#1.7
무