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)
L(mm)
24M32
32
60
86
75
24M33
33
60
86
75
24M34
34
60
86
75
2422M35
35
60
86
75
24M36
36
64
86
80
24M37
37
64
86
80
2424M38
38
64
86
80
24M39
39
70
86
80
24M40
40
70
86
80
2426M41
41
70
86
80
24M42
42
70
86
80
2427M43
43(1 11/16")
75
86
80
24M44
44
75
86
80
24M45
45
75
86
80
2429M46
46
75
86
80
24M47
47
75
86
80
24M48
48
80
86
82
2431M49
49
80
86
82
24M50
50
80
86
82
2432M51
51
80
86
82
24M52
52
80
86
82
2434M54
54
86
86
89
24M55
55
86
86
89
24M56
56
86
86
92
2436M57
57
86
86
92
24M58
58
92
86
92
2437M59
59
92
86
92
24M60
60
92
86
92
24M61
61
96
86
96
2439M62
62
96
86
96
2441M65
65
100
86
96
2442M67
67
100
86
101
2444M70
70
105
86
101
2446M73
73
109
86
105
2447M75
75
109
86
105
2448M76
76
115
86
110
24M77
77
115
86
110
24M80
80
115
86
110
24M85
85
121
86
116
2454M86
86
127
86
116
24M90
90
130
86
118
2460M95
95
135
127
118
2463M100
100
140
127
125
2466M105
105
150
127
125
2469M110
110
155
127
137
24M115
115
160
127
137
24M120
120
165
127
145
24M125
125
170
127
145
2482M130
130
180
127
158
모델명
배율(배)
비고
BD-L38A
3, 8
미니탁상형
BD-L38B
3, 8
검사용
모델명
규격
구성
자루
경화형
3P
2", 3", 4"
PVC
유연형
3P
2", 4", 6"
PVC
모델명
규격
자루
2"
고무
3"
고무
4"
고무
모델명
배율
크기(mm)
중량(g)
1976
7배
150×75×60
128
2004
10배
150×75×60
165
모델명
규격(mm)
KS-150
150
KS-300
300
KS-600
600
KS-1000
1000
모델명
규격(mm)
전장(mm)
3TS-05
5
75
3TS-06
6
75
3TS-08
8
75
3TS-10
10
75
모델명
전장(mm)
적용캇타날
SM-S300
300
18mm
SM-S600
600
18mm
SM-S1000
1000
18mm
모델명
규격
구성(mm)
21LB-S4
1/2"×4P
5, 6, 8, 10
21LB-S7
1/2"×7P
5, 6, 8, 10, 12, 14, 17