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개씩 보기
모델명
규격(")
전장
중량(g)
3/8
3"(75mm)
80
3/8
5"(125mm)
150
3/8
8"(200mm)
195
1/2
3"(75mm)
210
1/2
5"(125mm)
230
1/2
10"(250mm)
440
3/4
4"(100mm)
600
3/4
6"(150mm)
700
3/4
8"(200mm)
880
3/4
10"(250mm)
1060
1
6"(150mm)
1170
1
8"(200mm)
1520
1
10"(250mm)
1880
1
16"(400mm)
3100
모델명
호칭
길이(mm)
대변(mm)
머리길이(mm)
M16
25
24
10
M16
30
24
10
M16
35
24
10
M16
40
24
10
M16
45
24
10
M16
50
24
10
M16
55
24
10
M16
60
24
10
M16
65
24
10
M16
70
24
10
M16
75
24
10
M16
80
24
10
M16
90
24
10
M16
100
24
10
M16
110
24
10
M16
120
24
10
M16
130
24
10
M16
140
24
10
M16
150
24
10
M16
160
24
10
M16
170
24
10
M16
180
24
10
M16
190
24
10
M16
200
24
10
M16
210
24
10
M16
220
24
10
M16
230
24
10
M16
240
24
10
M16
250
24
10
M18
40
27
12
M18
45
27
12
M18
50
27
12
M18
55
27
12
M18
60
27
12
M18
65
27
12
M18
70
27
12
M18
75
27
12
M18
80
27
12
M18
90
27
12
M18
100
27
12
M18
110
27
12
M18
120
27
12
M18
130
27
12
M18
140
27
12
M18
150
27
12
M18
160
27
12
M18
170
27
12
M18
180
27
12
M18
190
27
12
M20
35
30
13
M20
40
30
13
M20
45
30
13
M20
50
30
13
M20
55
30
13
M20
60
30
13
M20
65
30
13
M20
70
30
13
M20
75
30
13
M20
80
30
13
M20
90
30
13
M20
100
30
13
M20
110
30
13
M20
120
30
13
M20
130
30
13
M20
140
30
13
M20
150
30
13
M20
160
30
13
M20
170
30
13
M20
180
30
13
M20
190
30
13
M20
200
30
13
M20
210
30
13
M20
220
30
13
M20
230
30
13
M20
240
30
13
M20
250
30
13
M22
45
32
14
M22
50
32
14
M22
55
32
14
M22
60
32
14
M22
65
32
14
M22
70
32
14
M22
75
32
14
M22
80
32
14
M22
90
32
14
M22
100
32
14
M22
110
32
14
M22
120
32
14
M22
130
32
14
M22
140
32
14
M22
150
32
14
M22
160
32
14
M22
170
32
14
M22
180
32
14
M22
190
32
14
M22
200
32
14
M22
210
32
14
M22
220
32
14
M22
230
32
14
M22
240
32
14
M22
250
32
14
모델명
규격(")
D(mm)
L(mm)
중량(g)
E1203
3/4
44
75
470
E1204
3/4
44
100
550
E1205
3/4
44
125
690
E1207
3/4
44
175
900
E1210
3/4
44
250
1200
E1213
3/4
44
325
1460
모델명
규격(SQ)
비트규격
3/8
1/4"(6.35mm)
3/8
5/16"(8mm)
1/2
1/4"(6.35mm)
1/2
5/16"(8mm)
모델명
규격(")
L(mm)
중량(g)
U0606
3/8
50
130
U0808
1/2
52
180
U1212
3/4
94
590
U1616
1
136
1600
U2424
1 1/2
125
4070
U4040
2 1/2
200
12300
모델명
컷팅능력(mm)
피복사용범위(mm)
전장(mm)
KY-3103A
10.7
1.6, 2, 2.6, 3.2 (8, 10, 12, 14AWG)
168
KY-3103B
10.7
3, 3.6, 4.8 (10, 8, 4AWG)
168
KY-3103C
10.7
0.8, 1, 1.3, 1.6, 2, 2.6 (10, 12, 14, 16, 18, 20AWG)
168
모델명
라쳇체결(")
소켓체결(")
D(mm)
A(mm)
L(mm)
중량(g)
38
1/4
3/8
48
3/8
1/4
17
13
25.3
25
58
3/8
1/2
18.5
13
32
40
68
1/2
3/8
22
17
33.3
50
128
1/2
3/4
25
17
42
115
138
3/4
1/2
33
25
50
170
148
3/4
1
38
25
60
340
158
1
3/4
46.5
31
63
420
모델명
전압
천공능력(mm)
회전수(RPM)
중량(kg)
OCD-183KL II 20
18V (2.0Ah)
10
0~1000
1.5
OCD-183KL II 40
18V (4.0Ah)
10
0~1000
1.6