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)
D1(mm)
D2(mm)
L1(mm)
L(mm)
4D-08
8
12.3
22
9
35
4D-09
9
13.5
22
9
35
4D-10
10
15
22
10
35
4D-11
11
16.2
22
10
35
4D-12
12
17.5
22
10
35
4D-13
13
18.8
22
10
35
4D-14
14
20
22
12
35
4D-15
15
22
22
12
35
4D-16
16
23
23
12
36
4D-17
17
24
23
13
37
4D-18
18
25
23
13
37
4D-19
19
26
24
14
38
4D-20
20
28
25
14
38
4D-21
21
29
25
15
39
4D-22
22
30
26
15
40
4D-23
23
32
27
16
41
4D-24
24
33
28
17
41
4D-25
25
34
28
19
43.5
4D-26
26
35
28
19
43.5
4D-27
27
36
19
19
43.5
4D-28
28
38
30
19
43.5
4D-29
29
39
31
19
43.5
4D-30
30
40
32
21
47
4D-32
32
43
34.5
21
47
4D-36
36
52
모델명
규격
A(mm)
B(mm)
1/4"
222
69
5/16"
220
85
3/8"
222
76
1/2"
226
102
5/8"
242
102
3/4"
238
117
1"
227
90
모델명
굵기×기장
적용모델
비고
FAP27V5
2.5Ø×27mm
CN-650M
6000발
FAP32V5
2.5Ø×32mm
CN-650M
FAP38V5
2.5Ø×38mm
CN-650M
모델명
사용못길이(mm)
못굵기(mm)
H×L×W(mm)
중량(kg)
JN2190
65~90
2.9~3.3
356×505×123
3.9
FN21/90
50~90
2.9~3.3
339×500×114
3.6