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개씩 보기
모델명
규격
L(mm)
중량(g)
122-1002
3/8"
75
80
122-1004
3/8"
150
160
122-1006
1/2"
100
225
122-1008
1/2"
125
230
122-1010
1/2"
200
445
122-1012
1/2"
250
455
122-1014
3/4"
200
870
122-1016
1"
200
1410
모델명
작업범위(mm)
중량(kg)
비고
31642(152)
6~66
0.9
31647(152-P)
10~63
0.9
31657(154-P)
50~110
1.4
31667(156-P)
110~160
1.9
32078
10~26
주름관 전용
모델명
규격(mm)
전장(mm)
재질
166-1.5
1.5
38
Al-Cu
166-2
2
38
Al-Cu
166-2.5
2.5
38
Al-Cu
166-3
3
59
Al-Cu
166-4
4
65
Al-Cu
166-5
5
79
Al-Cu
166-6
6
85
Al-Cu
166-8
8
92
Al-Cu
166-10
10
110
Al-Cu
166-12
12
130
Al-Cu
166-14
14
150
Al-Cu
166-1.5
1.5
38
Be-Cu
166-10
10
110
Be-Cu
모델명
규격(mm)
D1(mm)
D2(mm)
전장(mm)
T6JC395
4.5
12
7.4
23
T6JC409
5
12
8
23
T6JC417
5.5
12
8.5
23
T6JC425
6
12
9.4
23
T6JC433
7
12
11
23
T6JC441
8
11
12
23
T6JD120
9
12
13
23
T6JD146
10
12.5
14.5
23
모델명
규격(mm)
전장(mm)
180A-1417
14×17
280
180A-1719
17×19
310
180A-2224
22×24
365
180A-2427
24×27
380
180A-2730
27×30
400
180A-3032
30×32
400
180A-3236
32×36
180A-3641
36×41
모델명
규격(mm)
D1(mm)
D2(mm)
L1(mm)
L(mm)
d(mm)
중량(g)
3S-06
6
9.3
17
5
26
4.5
20
3S-07
7
10.7
17
5
26
5
20
3S-08
8
11.7
17
6
26
7
20
3S-09
9
13.2
17
6
26
7
25
3S-10
10
14.7
17
7
26
8
30
3S-11
11
15.7
17
8
26
9
30
3S-12
12
17
18
8
26
10
35
3S-13
13
18.5
18
9
27
10
35
3S-14
14
19.5
18
9
27
11
45
3S-15
15
21
18
10
29
11
50
3S-16
16
22
19
10
29
14
50
3S-17
17
23
21
11
30
14
70
3S-18
18
24.5
21
12
32
15
70
3S-19
19
26
21
13
32
16
75
모델명
규격(g)
전장(mm)
191-1002(Al-Cu)
450
310
191-1004(Al-Cu)
1000
400
191-1006(Al-Cu)
1400
400
191-1008(Al-Cu)
1500
400
191-1010(Al-Cu)
1800
400
191-1012(Al-Cu)
2000
400
191-1014(Al-Cu)
5LB(2200)
400
191-1016(Al-Cu)
2500
900
191-1018(Al-Cu)
2700
900
191-1020(Al-Cu)
3000
900
191-1022(Al-Cu)
3600
900
191-1024(Al-Cu)
4000
900
191-1026(Al-Cu)
10LB(4500)
900
191-1028(Al-Cu)
5000
900
191-1030(Al-Cu)
5400
900
191-1032(Al-Cu)
6400
900
191-1034(Al-Cu)
7200
900
191-1036(Al-Cu)
8000
900
191-1038(Al-Cu)
8200
900
191-1040(Al-Cu)
9100
900
191-1042(Al-Cu)
9900
900