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개씩 보기
모델명
규격(")
D(mm)
A(mm)
L(mm)
d(mm)
중량(g)
206
1/4
12.5
9
50
8
EX-20-100
1/4
12.5
9
100
8
55
207
1/4
12.5
9
150
8
70
305
3/8
18
13
75
10.5
70
EX30-125
3/8
18
13
125
10.5
100
306
3/8
18
13
150
10.5
120
EX30-250
3/8
18
13
250
10.5
180
320
1/2
24
16
75
14.5
135
EX40-125
1/2
24
16
125
14.5
195
321
1/2
24
16
150
14.5
407
1/2
24
16
250
14.5
350
420
1/2
24
16
600
14
750
EX60-075
3/4
36
25
75
25
315
EX60-125
3/4
36
25
125
22
500
610
3/4
36
25
200
22
800
611
3/4
36
25
400
22
1570
612
1
46
31
150
25
870
모델명
굵기(mm)
전장(mm)
705-1
8
90
705-2
8
100
모델명
규격(mm)
날장(mm)
전장(mm)
1
12
34
1.1
14
36
1.2
16
38
1.3
16
38
1.4
18
40
1.5
18
40
1.6
20
43
1.7
20
43
1.8
22
46
1.9
22
46
2
24
49
2.1
24
49
2.2
27
53
2.3
27
53
2.4
30
57
2.5
30
57
2.6
30
57
2.7
33
61
2.8
33
61
2.9
33
61
3
33
61
3.1
36
65
3.2
36
65
3.3
36
65
3.4
39
70
3.5
39
70
3.6
39
70
3.7
39
70
3.8
43
75
3.9
43
75
4
43
75
4.1
43
75
4.2
43
75
4.3
47
75
4.4
47
80
4.5
47
80
4.6
47
80
4.7
47
80
4.8
52
86
4.9
52
86
5
52
86
5.1
52
86
5.2
52
86
5.3
52
86
5.4
57
93
5.5
57
93
5.6
57
93
5.7
57
93
5.8
57
93
5.9
57
93
6
57
93
6.1
63
101
6.2
63
101
6.3
63
101
6.4
63
101
6.5
63
101
6.6
63
101
6.7
63
101
6.8
69
109
6.9
69
109
7
69
109
7.1
69
109
7.2
69
109
7.3
69
109
7.4
69
109
7.5
69
109
7.6
75
117
7.7
75
117
7.8
75
117
7.9
75
117
8
75
117
8.1
75
117
8.2
75
117
8.3
75
117
모델명
규격(")
D(mm)
H(mm)
T(mm)
L(mm)
중량(g)
비고
371
1/2
45
35
20.5
270
490
471
3/4
61
52.9
31.9
500
1690
571
1
64
59.9
31.9
755
4500
572
1
64
59.9
31.9
755
헤드만
모델명
측정범위(mm)
최소눈금(mm)
BD-293-025(NA293-025S)
0~25
0.001
BD-293-050(NA293-050S)
25~50
0.001
BD-293-075(NA293-075S)
50~75
0.001
BD-293-100(NA293-100S)
75~100
0.001
모델명
규격(mm)
전장(mm)
T-SGW-08F
8
92
T-SGW-09F
9
94
T-SGW-10F
10
94
T-SGW-11F
11
104
T-SGW-12F
12
104
T-SGW-13F
13
105
T-SGW-14F
14
114
T-SGW-15F
15
120
T-SGW-16F
16
120
T-SGW-17F
17
124
T-SGW-18F
18
138
T-SGW-19F
19
138
모델명
전압
능력(mm)
회전수(RPM)
중량(kg)
DDF483RFE
18V/3.0Ah
13
0~500/1700
1.3
DDF483RTE
18V/5.0Ah
13
0~500/1700
1.3
모델명
규격
중량(kg)
타입
3206M-6각
3/8"×21P
2.1
6각
3206M-12각
3/8"×21P
2.1
12각
모델명
구성(P)
구성(mm)
RM700
7p
8, 10, 12, 13, 14, 17, 19
RM110
11p
8, 10, 12, 13, 14, 15, 16, 17, 18, 19, 21
모델명
폭×길이
형태
색상
SM-PT5075W
50mm×7.5M
삼각
백색
SM-PF5075W
50mm×7.5M
주걱
백색
SM-PD5075W
50mm×7.5M
환봉
백색
SM-PT5010W
50mm×10M
삼각
백색
SM-PF5010W
50mm×10M
주걱
백색
SM-PD5010W
50mm×10M
환봉
백색
SM-PT5075O
50mm×7.5M
삼각
오렌지
SM-PF5075O
50mm×7.5M
주걱
오렌지
SM-PD5075O
50mm×7.5M
환봉
오렌지
SM-PT5010O
50mm×10M
삼각
오렌지
SM-PF5010O
50mm×10M
주걱
오렌지
SM-PD5010O
50mm×10M
환봉
오렌지
SM-PB386
청색