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개씩 보기
모델명
L(mm)
A×B×T(mm)
PITCH
TB14-100
100
25×9×14
2.0P
TB14-125
125
25×9×14
2.0P
TB14-150
150
25×9×14
2.0P
TB14-200
200
25×9×14
2.0P
모델명
규격(mm)
날장(mm)
TR-2
2
100
TR-2.5
2.5
110
TR-3
3
126
TR-4
4
130
TR-5
5
147
TR-6
6
170
TR-8
8
185
TR-10
10
200
모델명
적용모델
CB325
9553NB
CB303A
5740B,9227,2107
CB105A
HM0810
CB415A
6904
CB100A
6906
CB153A
6910
CB440
DTW251,DDF456
CB430
DGA402
CB459/460
GA4030, GA4031
모델명
사용범위
SYS-6000
5C
SYS-7000
7C
모델명
사용범위(mm)
CT-127
4~15
CT-128
3~22
CT-129
3~28
CT-105
3~35
CT-107
5~50
CT-312
7~41
CT-206
10~66
모델명
L(mm)
규격
SB14-100
100
M14×2.0P
SB14-125
125
M14×2.0P
SB14-150
150
M14×2.0P
SB14-175
175
M14×2.0P
SB14-200
200
M14×2.0P
SB14-250
250
M14×2.0P
SB14-300
300
M14×2.0P
모델명
규격(mm)
1박스(PCS)
JPN50D-H
50
2000
JPN65D-H
65
2000
JPN75D-H
75
2000
JPN83D-H
83
2000
JPN90D-H
90
2000
모델명
인선직경(Ø)
절삭길이(mm)
SA-52M
4
12.7
SA-53M
5
12.7
SC-53M
5
12.7
SD-53M
5
4
SF-53M
5
12.7
SG-53M
5
12.7
SL-53M
5
12.7
SM-53M
5
12.7
모델명
사용볼트
A×B×C×L(mm)
T(mm)
TN-14
M14×2.0P
25×9×18×32
15.5
TN-16
M16×2.0P
28×10×20×36
17.5
TN-18
M18×2.5P
32×12×24×40
19.5
TN-20
M20×2.5P
34×14×28×45
21.5
TN-22
M22×2.5P
40×16×30×50
23.5
TN-24
M24×3.0P
44×17×35×55
27.5