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개씩 보기
모델명
외경×홀구경
표면입도
EY-200P
2"×9.6mm
#60/80, #80/100
EY-415C
4"×16mm
#35/40
EY-715CR
7"×22mm
#35/40
모델명
팁굵기×전장(mm)
수량
MG-RS165
#1×65
2EA
MG-RS265
#2×65
2EA
MG-RS2110
#2×110
2EA
MG-RS2150
#2×150
2EA
모델명
전장(mm)
적용범위(SQ)
KH-1M
195
1.25, 2
KH-15A
250
JIS 1.25, 2, 5.5, 8 / DIN 1.5, 2, 6, 10
KH-18
270
JIS 5.5, 8, 14 / DIN 6, 10, 16
KH-19
280
JIS 1~2, 5.5, 8, 14 / DIN 1~2, 6, 10, 16
KH-22
365
JIS 5.5, 8, 14, 22 / DIN 6, 10, 16, 25
SB-38C
365
JIS 5.5, 8, 14, 22, 38 / DIN 6, 10, 16, 25, 35
모델명
내경(mm)
길이(m)
SHF-301
2" (50)
10
SHF-301
2.5" (65)
10
SHF-301
3" (75)
10
SHF-301
4" (100)
10
SHF-301
5" (125)
10
SHF-301
6" (150)
10
SHF-301
8" (200)
10
SHF-301
10" (250)
10
SHF-301
12" (300)
10
모델명
셋트구성
구성
LHS-7
1.5~6
7p
LHS-9
1.5~10
9P
모델명
용량(ton)
양정M×줄수
로드체인(Ø×pitch)
중량(kg)
YA-50
0.5
1.2×1
4.3Ø×1
2.8
YA-80
0.8
1.5×1
5.6Ø×1
6
YA-100
1
1.5×1
5.6Ø×1
6.2
YA-160
1.6
1.5×1
7.1Ø×1
9.2
YA-320
3.2
1.5×1
9.0Ø×1
15.5
모델명
규격(")
최대벌림(mm)
중량(kg)
YDRV-100
4
140
20
YDRV-125
5
165
36
YDRV-150
6
190
45
YDRV-200
8
200
60
YDRV-250
10
266
80
모델명
측정범위(℃)
TC5020
40, 43, 46, 49, 54
TC5025
60, 66, 71, 77, 82
TC5030
88, 93, 99, 104, 110
TC5035
116, 121, 127, 132, 138
TC5045
171, 177, 182, 188, 193
모델명
규격
죠최대벌림(mm)
YMV-F150
6"
115
YMV-F200
8"
160
YMV-F250
10"
200
모델명
규격
전장(mm)
103-5
5mm
28
103-5.5
5.5mm
28
103-6
6mm
28
103-7
7mm
28
103-8
8mm
28
103-9
9mm
28
103-10
10mm
32
103-11
11mm
32
103-12
12mm
32
103-13
13mm
32
103-14
14mm
32
103-15
15mm
32
103-16
16mm
32
103-17
17mm
32
103-19
19mm
32
103-20
20mm
32
103-1002
5/16"
32
103-1004
3/8"
32
103-1006
7/16"
32
103-1008
1/2"
32
103-1010
9/16"
32
103-1012
5/8"
35
103-1014
11/16"
35
103-1016
3/4"
35
103-1018
13/16"
35
103-1020
7/8"
35
103-1022
15/16"
35