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)
전장(mm)
108-19
19
60
108-21
21
60
108-22
22
60
108-24
24
60
108-26
26
60
108-27
27
60
108-29
29
60
108-30
30
60
108-32
32
60
108-34
34
70
108-35
35
70
108-36
36
70
108-38
38
70
108-41
41
70
108-46
46
80
108-50
50
80
108-52
52
90
108-55
55
90
108-58
58
90
108-60
60
90
108-65
65
90
108-70
70
90
108-75
75
90
108-80
80
90
모델명
구성
셋트규격(mm)
212H-5CN
6P
1.5, 2, 2.5, 3, 4, 5
212H-6CN
7P
1.5, 2, 2.5, 3, 4, 5, 6
212H-8CN
8P
1.5, 2, 2.5, 3, 4, 5, 6, 8
212H-10CN
9P
1.5, 2, 2.5, 3, 4, 5, 6, 8, 10
모델명
소비전력(W)
타격수(SPM)
중량(kg)
BDB823A
1800
33000
5.2
BDB825
1800
28000
5.5
모델명
규격
죠최대벌림(mm)
크기(A×B)mm
무게(kg)
3"
90
270×90
4.1
4"
100
330×100
5.5
5"
130
380×130
7.2
6"
165
430×150
8.8
8"
245
530×205
28
모델명
굵기(mm)
전장(mm)
비고
803
26
235
슬림형
804
30
235
측면 날형
804 BENT
30
235
구부러진 형
모델명
전장(mm)
날장(mm)
중량(g)
VS-7Z
180
48
212
VS-8Z
200
54
220
VS-9Z
227
60
257
모델명
규격(mm)
SM-VB06
6
SM-VB08
8
SM-VB10
10
SM-VB12
12
SM-VB14
14
SM-VB18
18
SM-VB20
20
SM-VB22
22
SM-VB25
25
SM-VB32
32
SM-VB35
35
SM-VB40
40