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)
L1(mm)
L2(mm)
A(mm)
334
2
126
100
80
334
2
175
150
80
334
2.5
126
100
80
334
2.5
175
150
80
334
3
126
100
80
334
3
176
150
80
334
4
126
100
80
334
4
176
150
80
334
5
132
100
100
334
5
182
150
100
334
5
232
200
100
334
6
132
100
100
334
6
182
150
100
334
6
232
200
100
334
7
232
200
100
334
8
132
100
100
334
8
182
150
100
334
8
232
200
100
334
10
138
100
120
334
10
238
200
100
334
12
238
200
120
모델명
규격(mm)
12980
6
12978
9
12981
12
12979
15
12982
19
12983
25
12984
32
12985
38
모델명
비고
PH-20
8Ø 호스용
PH-30
10Ø 호스용
PH-40
16Ø 호스용
모델명
측정범위(kgf.cm)
최소단위(kgf.cm)
사각부mm(")
전장(mm)
15DB4-S
2~15
0.2
6.35(1/4)
205
30DB4-S
3~30
0.5
6.35(1/4)
205
DB60M5-S(60DB4-S)
7~60
1
6.35(1/4)
205
DB120M5-S(120DB4-S)
14~120
2
6.35(1/4)
205
DB250M5-S(230DB3-S)
35~250
5
9.5(3/8)
245
DB500M-S(450DB3-S)
50~500
5
9.5(3/8)
320
DB1000M-S(900DB3-S)
100~1,000
10
12.7(1/2)
400
DB2000M-S(1800DB3-S)
200~2,000
20
12.7(1/2)
500
DB2800M5-S(2800DB3-S)
350~2,800
50
19(3/4)
690
DB4200M-S(4200DB2-S)
400~4,200
50
19(3/4)
890
DBE5600M-S(5600DBE2-S)
500~5,600
50
19(3/4)
1100
DBE8500M-S(8500DBE2-S)
1,000~8,500
100
25.4(1)
1360
DBE10000M-S(10000DBE2-S)
1,000~10,000
100
25.4(1)
1490
DBE14000M-S(14000DBE2-S)
2,000~14,000
200
25.4(1)
1740
DBE21000M-S(21000DBE2-S)
2,000~21,000
200
25.4(1)
2140
모델명
비고
AH-12
호스용 8Ø
AH-13
호스용 10Ø
AH-14
호스용 13Ø
모델명
측정범위(N.m)
눈금(N.m)
전장(mm)
중량(kg)
DTC-N10REV
1~10
0.01
314
0.8
DTC-N50REV
5~50
0.1
342
0.9
DTC-N100REV
10~100
0.1
386
1.1
DTC-N200REV
20~200
0.1
404
1.25
DTC-N300REV
30~300
0.01
535
1.8
DTC-N500REV
50~500
0.01
1063
4.2
DTC-N1000REV
100~1000
0.01
1417
7.6
모델명
규격(Ø)
높이
470
500
470
600
470
700
모델명
규격(mm)
L1(mm)
L2(mm)
A(mm)
PB 1207.4-150
4
150
18
92
PB 1207.5-150
5
150
18
92
PB 1207.6-150
6
150
20
117
PB 1207.8-150
8
150
20
117
PB 1207.10-200
10
200
22
119
PB 1208.4-150
4
150
18
92
PB 1208.5-150
5
150
18
92
PB 1208.6-150
6
150
20
117
PB 1208.8-150
8
150
20
117
PB 1208.10-200
10
200
22
119
모델명
실길이(m)
비고
20
20
크로바
15
크로바
모델명
비고
PH-20
8Ø 호스용
PH-30
10Ø 호스용
PH-40
16Ø 호스용