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개씩 보기
모델명
사이즈
1포장
프로그립 1000
S
10켤레
프로그립 1000
M
10켤레
프로그립 1000
L
10켤레
모델명
구성(P)
셋트구성
TLS-9ZD
9p
1/16, 5/64, 3/32, 1/8, 5/32, 3/16, 1/4, 5/16, 3/8
TLS-13ZD
13p
0.05, 1/16, 5/64, 3/32, 7/64, 1/8, 9/64, 5/32, 3/16, 1/4, 5/16, 3/8
모델명
인선직경(Ø)
절삭길이(mm)
전장(mm)
SA-1ML6 DC
6
16
162
SA-3ML6 DC
9.5
19
169
SA-5ML6 DC
12.7
25
175
모델명
사이즈
색상
1박스
XL
백색
24EA
XL
주황
24EA
모델명
색상
사이즈
SI-121
보라/진회색
L
SI-121
오렌지/흑색
L
SI-121
오렌지/흑색
XL
SI-121
오렌지/흑색
XXL
모델명
노즐규격
비고
BT600
517
BT700
517
BT470, 520 표준품
모델명
규격(mm)
길이(M)
중량(kg)
8
150
4.5
10
150
6.2
12
100
14
150
12
16
150
15.5
모델명
단수
크기(mm)
중량(kg)
ML-500H
2
610×548×623
11
ML-730H
3
610×687×816
15.5
ML-730HS
3+난간
610×687×1500
22
ML-960H
4
610×993×968
20
ML-960HS
4+난간
610×993×1695
25
모델명
규격(mm)
날장(mm)
전장(mm)
샹크(Ø)
DPPA01010
1.0
8
38
3
DPPA01011
1.1
9
42
3
DPPA01012
1.2
10
42
3
DPPA01013
1.3
10
42
3
DPPA01014
1.4
11
42
3
DPPA01015
1.5
11
42
3
DPPA01016
1.6
12
42
3
DPPA01017
1.7
12
42
3
DPPA01018
1.8
13
42
3
DPPA01019
1.9
13
42
3
DPPA01020
2.0
17
50
3
DPPA01021
2.1
17
50
3
DPPA01022
2.2
17
50
3
DPPA01023
2.3
17
50
3
DPPA01024
2.4
17
50
3
DPPA01025
2.5
17
50
3
DPPA01026
2.6
17
50
3
DPPA01027
2.7
17
50
3
DPPA01028
2.8
17
50
3
DPPA01029
2.9
17
50
3
DPPA01030
3.0
20
50
4
DPPA01031
3.1
20
55
4
DPPA01032
3.2
20
55
4
DPPA01033
3.3
20
55
4
DPPA01034
3.4
20
55
4
DPPA01035
3.5
20
55
4
DPPA01036
3.6
25
55
4
DPPA01037
3.7
25
55
4
DPPA01038
3.8
25
55
4
DPPA01039
3.9
25
55
4
DPPA01040
4.0
25
55
4
DPPA01041
4.1
25
55
4
DPPA01042
4.2
32
62
5
DPPA01043
4.3
32
62
5
DPPA01044
4.4
32
62
5
DPPA01045
4.5
32
62
5
DPPA01046
4.6
32
62
5
DPPA01047
4.7
32
62
5
DPPA01048
4.8
32
62
5
DPPA01049
4.9
32
62
5
DPPA01050
5.0
32
62
5
DPPA01051
5.1
32
62
5
DPPA01052
5.2
36
66
6
DPPA01053
5.3
36
66
6
DPPA01054
5.4
36
66
6
DPPA01055
5.5
36
66
6
DPPA01056
5.6
36
66
6
DPPA01057
5.7
36
66
6
DPPA01058
5.8
36
66
6
DPPA01059
5.9
36
66
6
DPPA01060
6.0
36
66
6
DPPA01061
6.1
36
66
6
DPPA01062
6.2
42
74
7
DPPA01063
6.3
42
74
7
DPPA01064
6.4
42
74
7
DPPA01065
6.5
42
74
7
DPPA01066
6.6
42
74
7
DPPA01067
6.7
42
74
7
DPPA01068
6.8
42
74
7
DPPA01069
6.9
42
74
7
DPPA01070
7.0
42
74
7
DPPA01071
7.1
42
74
7
DPPA01072
7.2
46
79
8
DPPA01073
7.3
46
79
8
DPPA01074
7.4
46
79
8
DPPA01075
7.5
46
79
8
DPPA01076
7.6
46
79
8
DPPA01077
7.7
46
79
8
DPPA01078
7.8
46
79
8
DPPA01079
7.9
46
79
8
DPPA01080
8.0
46
79
8
DPPA01081
8.1
46
79
8
DPPA01082
8.2
50
84
9
DPPA01083
8.3
50
84
9
DPPA01084
8.4
50
84
9
DPPA01085
8.5
50
84
9
DPPA01086
8.6
50
84
9
DPPA01087
8.7
50
84
9
DPPA01088
8.8
50
84
9
DPPA01089
8.9
50
84
9
DPPA01090
9.0
50
84
9
DPPA01091
9.1
50
84
9
DPPA01092
9.2
53
89
10
DPPA01093
9.3
53
89
10
DPPA01094
9.4
53
89
10
DPPA01095
9.5
53
89
10
DPPA01096
9.6
53
89
10
DPPA01097
9.7
53
89
10
DPPA01098
9.8
53
89
10
DPPA01099
9.9
53
89
10
DPPA01100
10.0
53
89
10
DPPA01101
10.1
53
89
10
DPPA01102
10.2
55
95
11
DPPA01103
10.3
55
95
11
DPPA01104
10.4
55
95
11
DPPA01105
10.5
55
95
11
DPPA01106
10.6
55
95
11
DPPA01107
10.7
55
95
11
DPPA01108
10.8
55
95
11
DPPA01109
10.9
55
95
11
DPPA01110
11.0
55
95
11
DPPA01111
11.1
55
95
11
DPPA01112
11.2
62
102
12
DPPA01113
11.3
62
102
12
DPPA01114
11.4
62
102
12
DPPA01115
11.5
62
102
12
DPPA01116
11.6
62
102
12
DPPA01117
11.7
62
102
12
DPPA01118
11.8
62
102
12
DPPA01119
11.9
62
102
12
DPPA01120
12.0
62
102
12
DPPA01121
12.1
62
102
12
DPPA01122
12.2
62
102
13
DPPA01123
12.3
62
102
13
DPPA01124
12.4
62
102
13
DPPA01125
12.5
62
102
13
DPPA01126
12.6
62
102
13
DPPA01127
12.7
62
102
13
DPPA01128
12.8
62
102
13
DPPA01129
12.9
62
102
13
DPPA01130
13.0
62
102
13
DPPA01131
13.1
62
102
13
DPPA01132
13.2
64
107
14
DPPA01133
13.3
64
107
14
DPPA01135
13.5
64
107
14
DPPA01137
13.7
64
107
14
DPPA01138
13.8
64
107
14
DPPA01140
14.0
64
107
14
DPPA01141
14.1
64
107
14
DPPA01142
14.2
67
111
15
DPPA01143
14.3
67
111
15
DPPA01144
14.4
67
111
15
DPPA01145
14.5
67
111
15
DPPA01146
14.6
67
111
15
DPPA01147
14.7
67
111
15
모델명
사용범위(Ø)
CC900
60~900
CC1800
60~1800
모델명
규격-피치(mm)
샹크(mm)
날장(mm)
전장(mm)
T1827202
M3×0.5
4
11
120
T1827242
M4×0.7
5
13
120
T1827282
M5×0.8
5.5
16
120
T1827312
M6×1.0
6
19
120
T1827362
M8×1.25
6.2
22
120
T1827422
M10×1.5
7
24
120
T1827432
M10×1.25
7
24
120
T1827502
M12×1.75
8.5
29
120
T1827512
M12×1.5
8.5
29
120
T1827522
M12×1.25
8.5
29
120
T1827542
M14×2.0
10.5
30
120
T1827522
M14×1.5
10.5
30
120
T1827602
M16×2.0
12.5
32
120
T1827612
M16×1.5
12.5
32
120
모델명
허용하중(kg)
테이블(mm)
높이(mm)
무게(kg)
MT-30S
250
815×500
290~890
66
MT-50S
450
815×500
290~890
78