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)
D(mm)
L1(mm)
L(mm)
4AH-05L
5
25
10
150
4AH-06L
6
25
10
150
4AH-08L
8
25
15
150
4AH-10L
10
25
15
150
4AH-12L
12
25
20
150
4AH-14L
14
25
20
150
4AH-17L
17
28
20
150
4AH-19L
19
28
20
150
모델명
S(mm)
D1(mm)
D2(mm)
L1(mm)
L2(mm)
SM-UIHS12-H6
6
8
28
74
82
SM-UIHS12-H7
7
9
28
74
82
SM-UIHS12-H8
8
10.5
28
74
82
SM-UIHS12-H9
9
11.5
28
74
82
SM-UIHS12-H10
10
12.5
28
74
82
SM-UIHS12-H12
12
15
28
74
82
SM-UIHS12-H14
14
17.5
28
74
82
SM-UIHS12-H16
16
20
28
74
82
SM-UIHS12-H19
19
23
28
74
82
SM-UIHS12-H21
21
23.8
28
74
82
모델명
A(mm)
중량(kg)
PMC-15
Ø110×227
0.85
PMC-60
Ø110×674
1.3