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개씩 보기
모델명
규격
구성
21XSB-S10
1/2"
T10, 15, 20, 25, 27, 30, 40, 45, 50, 55
83XSB-S9
3/8"
T10, 15, 20, 25, 27, 30, 40, 45, 50
모델명
규격(mm)
샹크(Ø)
전장(mm)
날장(mm)
EQ758060
6
8
60
15
EQ758070
7
10
65
20
EQ758080
8
10
65
20
EQ758090
9
12
75
25
EQ758100
10
12
75
25
EQ758110
11
12
80
30
EQ758120
12
12
80
30
EQ758130
13
16
90
35
EQ758140
14
16
90
35
EQ758150
15
16
95
40
EQ758160
16
16
95
40
EQ758170
17
16
95
40
EQ758180
18
20
105
40
EQ758190
19
20
110
45
EQ758200
20
20
110
45
EQ758210
21
20
110
45
EQ758220
22
20
110
45
EQ758230
23
20
110
45
EQ758240
24
25
120
50
EQ758250
25
25
120
50
EQ758260
26
25
120
50
EQ758270
27
25
125
55
EQ758280
28
25
125
55
EQ758300
30
25
125
55
EQ758320
32
32
145
60
EQ758350
35
32
145
60
EQ758390
39
32
150
65
EQ758400
40
32
150
65
EQ758420
42
42
155
65
EQ758440
44
42
155
65
EQ758460
46
42
160
70
EQ758500
50
42
160
70
모델명
홀규격
베이스(mm)
흡착력(kgf)
HT2116GT(NF-6160)
M5×0.8
30×40×35
32
HT4316GT(MG-6161)
M8×1.25
50×60×55
80
모델명
굵기×날장(mm)
3775K
6×100
3775K
6×150
3775K
6×200
모델명
규격(")
전장(mm)
절단능력(mm)
중량(g)
03 01 160SB
6
160
Ø2.0
187
03 01 180SB
7
180
Ø2.2
216
03 01 200SB
8
200
Ø2.5
276
모델명
규격
폭(mm)
전장(mm)
1"
25
440
1 1/2"
38
450
2"
50
450
2 1/2"
63
450
3"
75
460
모델명
전장(mm)
팁굵기(Ø)
사용범위(Ø)
44 31 J02
140
0.9
8~13
44 31 J22
180
1.8
19~60
44 31 J32
195
2.3
40~100
44 31 J42
310
3.2
85~140