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)
132 Al-Cu
9PCS
8, 10, 12, 14, 17, 19, 22, 24, 27
133 Al-Cu
11PCS
8, 10, 12, 14, 17, 19, 22, 24, 27, 30, 32
134 Al-Cu
13PCS
8, 10, 12, 13, 14, 16, 17, 19, 22, 24, 27, 30, 32
132 Be-Cu
9PCS
8, 10, 12, 14, 17, 19, 22, 24, 27
133 Be-Cu
11PCS
8, 10, 12, 14, 17, 19, 22, 24, 27, 30, 32
134 Be-Cu
13PCS
8, 10, 12, 13, 14, 16, 17, 19, 22, 24, 27, 30, 32
모델명
용도
5.6705
SUS용
5.6704
강관용
모델명
사용캇타
VKS-34N
VK-34N
VKS-42N
VK-42N
VKS-63N
VK-63N
모델명
약재중량(kg)
방사시간(sec)
방사거리(m)
중량(kg)
SW-250
2.5
12
4~5
4
SW-330
3.3
13
4~6
5
SW-450
4.5
16
4~6
6.73
SW-650
6.5
16
5~7
9.56
SW-2000
20
35
5~7
35.2
모델명
규격(mm)
PB-16
16
PB-22
22
PB-28
28
모델명
규격
최저가능규격
R값
CT-366A-4
1/4"
1/8"
9/16"
CT-366A-5
5/16"
3/16"
11/16"
CT-366A-6
3/8"
1/4"
15/16"
CT-366A-8
1/2"
3/8"
1-1/2"
모델명
D(mm)
d(mm)
H(mm)
Lm(mm)
M(mm)
RUB-C1
30
28
17
18
6
RUB-C2
35
30
25
24
8
RUB-C5
40
32
34
24
8
RUB-C6
42
38
24
24
8
RUB-C8
50
40
40
25
10
RUB-C10
60
50
45
25
10
RUB-C11
70
60
50
32
12
RUB-C12
80
70
50
32
12
RUB-C13
100
90
60
40
16
모델명
굵기(Ø)
전장(mm)
20
300
25
300
30
300
35
300
40
300
45
300
50
300
55
300
60
300
65
300
70
300
75
300
80
300
90
300
100
300
110
300
120
300
130
300
140
300
150
300
모델명
두께(mm)
폭(mm)
길이(M)
1.6
910
20
2.4
910
15
3.2
910
15
4.8
910
10
6.4
910
10
9.5
910
10