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)
300×110×0.7
330×110×0.7
360×110×0.7
390×110×0.7
450×110×0.5
600×110×0.5
750×110×0.5
900×110×0.5
모델명
BPM
전장(mm)
중량(kg)
치즐샹크(Ø)
DCH-24
4000
164
0.8
10
전용 다가네
모델명
사용범위
KY-116
0.25, 0.32, 0.4, 0.5, 0.65, 0.8, 1, 1.3mm
KYP-117
0.5~6㎟
KF-228(KYP-228)
0.8~2.6mm
모델명
볼트굵기-피치(mm)
코일기장
2.5-0.45
1.5D
3-0.5
1.5D
4-0.7
1.5D
5-0.8
1.5D
6-1.0
1.5D
8-1.25
1.5D
10-1.25
1.5D
10-1.5
1.5D
12-1.25
1.5D
12-1.5
1.5D
12-1.75
1.5D
14-1.5
1.5D
14-2.0
1.5D
16-2.0
1.5D
20-2.5
1.5D
24-3.0
1.5D
30-3.5
1.5D
10-32
1.5D
18-2.5
1.5D
모델명
규격(g)
테두리색
300
빨강
350
파랑
400
하늘
450
초록
500
검정
모델명
적용칼날
S101(DC-76)
커터S날(A)
S402(DC-91)
커터S날(A)
S102(DC-102)
커터S날(A)
모델명
규격(mm)
전장(mm)
SH-08
8
570
SH-10
10
570
SH-12
12
570
모델명
사용범위(㎣)
GT-101A
0.5, 1.2, 1.6, 2
GT-102B
1, 1.6, 2, 2.6, 3.2
모델명
규격(볼트굵기×피치)
기장
2-0.4
2.5D
3-0.5
2.5D
4-0.7
2.5D
5-0.8
2.5D
6-1.0
2.5D
8-1.25
2.5D
10-1.25
2.5D
10-1.5
2.5D
12-1.5
2.5D
12-1.75
2.5D
14-2.0
2.5D
16-2.0
2.5D
20-2.5
2.5D
24-3.0
2.5D
모델명
볼트굵기-피치(mm)
50061
M2-0.4
50089
M3-0.5
50125
M4-0.7
50156
M5-0.8
50188
M6-1.0
50250
M8-1.25
50281
M10-1.25
50281
M10-1.5
50375
M12-1.5
50375
M12-1.75
50438
M14-1.5 / 2.0
50500
M16-2.0
50591
M18-2.5
50591
M20-2.5
50750
M24-3.0
51000
M30-3.5