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)
중량(kg)
7.0040
10~42
1.04
7.0045
10~60
2.15
7.0060
60~115
7.1
모델명
규격
길이(m)
500A
4
500A
6
500A
8
500A
10
500A
15
500A
20
500A
30
모델명
단수
전장(mm)
중량(kg)
BWS-3
3
890
6.2
BWS-4
4
1080
7.3
BWS-5
5
1360
8.7
BWS-6
6
1640
10.0
모델명
외경×내경(mm)
길이(M)
권취방법
RGA-610SM
11×6
10
SK 스프링
RGA-615SM
11×6
15
SK 스프링
RGA-620SM
11×6
20
SK 스프링
RGA-810SM
16×8
10
SK 스프링
RGA-815SM
16×8
15
SK 스프링
모델명
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
모델명
사이즈
전압
S-901HAE
250mm
30,000V
S-901HAE
260mm
30,000V
S-901HAE
270mm
30,000V
S-901HAE
280mm
30,000V
모델명
품명
중량(kg)
DCS355N
충전 만능 캇타
1.06
DCF620N
충전 자동 매거진
1.08
DCS374N
충전 밴드소
5.6
DCP580N
충전 대패
2.5