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개씩 보기
모델명
규격(")
피치(P)
3/16
24
1/4
20
1/4
28
5/16
18
3/8
16
1/2
12
1/2
13
1/2
20
5/8
11
3/4
10
모델명
D(Ø)
D1(Ø)
W(Ø)
ZKN8-2
2
3
2.5
ZKN8-3
3
4
3.2
ZKN8-4
4
5
4.0
ZKN8-5
5
5.5
4.5
ZKN8-6
6
6
4.5
ZKN8-8
8
6.2
5.0
ZKN12-3
3
4
3.2
ZKN12-4
4
5
4.0
ZKN12-5
5
5.5
4.5
ZKN12-6
6
6
4.5
ZKN12-8
8
6.2
5.0
ZKN12-10
10
7
5.5
ZKN12-12
12
8.5
6.5
ZKN16-3
3
4
3.2
ZKN16-4
4
5
4.0
ZKN16-5
5
5.5
4.5
ZKN16-6
6
6
4.5
ZKN16-8
8
6.2
5.0
ZKN16-10
10
7
5.5
ZKN16-12
12
8.5
6.5
ZKN16-14
14
10.5
8.0
ZKN16-16
16
12.5
10.0
ZKN16-18
18
14
11.0
ZKN16-20
20
15
12.0
ZKN24-8
8
6.2
5.0
ZKN24-10
10
7
5.5
ZKN24-12
12
8.5
6.5
ZKN24-14
14
10.5
8.0
ZKN24-16
16
12.5
10.0
ZKN24-18
18
14
11.0
ZKN24-20
20
15
12.0
ZKN24-22
22
17
13.0
ZKN24-24
24
19
15.0
ZKN38-18
18
14
11.0
ZKN38-20
20
15
12.0
ZKN38-22
22
17
13.0
ZKN38-24
24
19
15.0
ZKN38-27
27
20
15.0
ZKN38-30
30
23
17.0
ZKN38-33
33
25
19.0
ZKN38-36
36
28
21.0
ZKN38-38
38
28
21.0
ZKN65-36
36
28
21
ZKN65-39
39
30
23
ZKN65-42
42
32
26
ZKN65-45
45
35
26
ZKN65-48
48
38
29
ZKN65-52
52
42
32
ZKN65-56
56
44
35
ZKN65-60
60
46
35
ZKN65-64
64
48
38
ZKN65-65
65
50
38
ZKN65-68
68
52
41
ZKN65-72
72
55
41
ZKN65-80
80
58
46
ZKN65-100
100
60
46
모델명
구성(P)
구성(mm)
4p
10, 12, 13, 14
7p
8, 10, 12, 13, 14, 17, 19
9P
8, 9, 10, 11, 12, 13, 14, 17, 19
12p
8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19
모델명
품명
적용모델
31738
습식노즐
WD0655
29848
자동차용 노즐
WD0655
31723
틈새용 노즐
WD0655
31733
다용도노즐
WD0655
72937
자동차용 노즐
WD1255, WD1685
72912
습식노즐
WD1255, WD1685
54558
분리형 송풍기용 노즐
WD1685
모델명
적용모델
KV-2S, 3SC, 3SN
KV-5S, 5F
KV-15S, 15SB
KV-103, 105F
KV-12S, 12SB
모델명
D(mm)
D1(mm)
최대RPM
최대하중(kg)
2BP60
44
66
5000
400
3BP60
56
78.5
5000
400
4BP60
78
100
4500
800
5BP60
98
125
3200
1600
6BP60
118
154
2500
2500
모델명
외경×내경
재질
SM-BCB4
4"×5/8"
BS
SM-BCB4S
4"×5/8"
스텐레스
모델명
규격
012330M
3/8"×30P
012419M
1/2"×19P
모델명
외경(")×날수(T)×내경(mm)
팁두께
305(12")×80×25.4
2.4T
355(14")×80×25.4
2.4T
모델명
규격(")
전장(mm)
철선(Ø)
동선(Ø)
피아노선(Ø)
중량(g)
PP-170
7
170
2.2
3.0
2
210
PP-195
8
195
2.8
3.5
2
285
PP-215
9
215
3.4
4
2
385
모델명
규격(mm)
20
22
25
28
30
32
35
38
40
42
45
50
55
모델명
규격
털길이
2"
3호
3"
3호
4"
3호