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)
토크(N.m)
전장(mm)
중량(kg)
비고
MI-17MG
16
588
179
2.6
MI-17MSG
16
588
157
2.3
숏타입
모델명
측정범위(mm)
최소표시(mm)
정도(mm)
측정력(N)
적용카운터
D-5
5
0.01
0.01
0.5
C-500/C-700
D-5S
5
0.001
0.002
0.5
C-500/C-700
모델명
구성(mm)
규격
SM-UIHS38-9P
5, 6, 8, 10, 11, 12, 13, 14, 15
3/8"×9P
SM-UIHS12-9P
8, 9, 10, 12, 13, 14, 16, 17, 19
1/2"×9P
모델명
규격(SQ)
능력(mm)
최대토크(N.m)
중량(kg)
UD-1015JHB
1/2
16
900
2.1
UD-1077JHB
3/4
24
1800
3.7
모델명
거울크기
전장(mm)
건전지
SM-876L
2"×3-1/4"
876
CR2032×2EA
SM-870L
3"
870
CR2032×1EA
모델명
용량(kg)
와이어(Ø×M)
속도(m/min)
중량(kg)
DU-900
250
6.3×4(1)
10
21
DU-901
500
6.3×4(1)
5
23
DU-902
1000
6.3×4(2)
2.5
30
모델명
가로×세로×높이(mm)
중량(kg)
0급(㎛)
No.121-1
300×300×80
27
4
No.121-2
450×300×80
41
4
No.121-3
500×500×80
75
4
No.121-4
600×450×100
81
5
No.121-5
600×600×120
135
5
No.121-6
750×500×120
141
5
No.121-7
900×600×130
300
6
No.121-8
1000×750×150
340
6
No.121-9
1000×1000×180
450
7
No.121-10
1200×900×180
800
7
No.121-11
1500×1000×200
900
8
No.121-12
2000×1000×250
1500
9
No.121-13
2000×1500×250
2000
10
No.121-14
2400×1200×250
2000
10
No.121-15
3000×1500×300
4000
12