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개씩 보기
모델명
사이즈
색상
370
M
회색
370
L
회색
265
M
파란색
265
L
파란색
모델명
능력
회전
5.5/5HP
사각
5.5/5HP
모델명
볼트굵기-피치(mm)
코일기장
2.5-0.45
1D
3-0.5
1D
4-0.7
1D
5-0.8
1D
6-1.0
1D
8-1.25
1D
10-1.5
1D
12-1.25
1D
12-1.5
1D
12-1.75
1D
14-1.5
1D
14-2.0
1D
16-2.0
1D
20-2.5
1D
30-3.5
1D
모델명
규격(볼트굵기×피치)
기장
2-0.4
2D
3-0.5
2D
4-0.7
2D
5-0.8
2D
6-1.0
2D
8-1.25
2D
10-1.25
2D
10-1.5
2D
12-1.5
2D
12-1.75
2D
14-1.5
2D
14-2.0
2D
16-2.0
2D
18-2.5
2D
20-2.5
2D
24-3.0
2D
모델명
적용칼날
S101(DC-76)
커터S날(A)
S402(DC-91)
커터S날(A)
S102(DC-102)
커터S날(A)
모델명
볼트굵기-피치(mm)
3-0.5
4-0.7
5-0.8
6-1.0
8-1.25
10-1.25
10-1.5
12-1.75
14-2.0
모델명
비고
1포장
반코팅40g
국내산
100켤레
반코팅40g
수입산
100켤레