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포장
백색
10EA
흑색
10EA
회색
10EA
핑크
10EA
보라색
10EA
모델명
팁굵기×전장(mm)
1판
M-A14
2×65
10EA
M-A14
2×110
10EA
모델명
두께(mm)×길이(m)
허용두께
0.01×1
±0.003
0.02×1
±0.003
0.03×1
±0.003
0.04×1
±0.005
0.05×1
±0.005
0.06×1
±0.005
0.07×1
±0.005
0.08×1
±0.005
0.09×1
±0.005
0.10×1
±0.006
0.11×1
±0.006
0.12×1
±0.006
0.13×1
±0.006
0.14×1
±0.006
0.15×1
±0.007
0.20×1
±0.008
0.25×1
±0.010
0.30×1
±0.012
0.35×1
±0.012
0.40×1
±0.013
0.45×1
±0.013
0.50×1
±0.015
0.60×1
±0.017
0.70×1
±0.017
0.80×1
±0.020
0.90×1
±0.025
1.00×1
±0.025
모델명
규격(cm)
중형
90×60
대형
110×60
모델명
핸들(mm)
벨트길이(mm)
벨트폭(mm)
작업범위(Ø)
중량(kg)
31335
300
425
12
90
0.5
31340
300
425
30
90
0.8
31345
300
760
30
135
0.8
31350
300
600
30
135
0.8
31355
300
425
27
90
0.8
31360
450
750
45
175
0.9
31365
450
1200
45
300
0.9
31370
450
750
45
135
1.0
모델명
규격(mm)
등차
매수
272MA
0.75~5.0
0.25
18
272MB
5.5~13.0
0.5
16
272MC
13.0~22.0
1.0
10
272ME
31.0~40.0
1.0
10
272MF
41.0~50.0
1.0
10
272MAA
0.1~1.0
0.1
10
모델명
규격
적용날
EL0100GT
2.6mm
B날용
EL0200GT
3.2mm
E날용
모델명
구성
전장(mm)
PHBS2065
6각 2.5, 3, 4, 5, 6 / [+]2
65
PTBS2065
홀형 별 T10, 15, 20, 25, 30 / [+]2
65
PHBS2110
6각 2.5, 3, 4, 5, 6 / [+]2
110
PTBS2110
홀형 별 T10, 15, 20, 25, 30 / [+]2
110
모델명
측정범위(mm)
최소눈금(mm)
513-514T
0.5
0.01
513-517T
0.8
0.01
513-503T
0.2
0.002
513-501T
0.14
0.001
모델명
규격(mm)
내경(mm)
CF14-20
14×20
7
CF14-25
14×25
7
CF14-30
14×30
7
CF14-35
14×35
7
CF14-40
14×40
7
CF14-45
14×45
7
CF14-50
14×50
7
CF14-55
14×55
7
CF14-60
14×60
7
CF14-65
14×65
7
CF14-70
14×70
7
CF14-75
14×75
7
CF14-80
14×80
7
CF14-90
14×90
7
CF14-100
14×100
7
CF16-20
16×20
8
CF16-25
16×25
8
CF16-30
16×30
8
CF16-35
16×35
8
CF16-40
16×40
8
CF16-45
16×45
8
CF16-50
16×50
8
CF16-55
16×55
8
CF16-60
16×60
8
CF16-65
16×65
8
CF16-70
16×70
8
CF16-75
16×75
8
CF16-80
16×80
8
CF16-90
16×90
8
CF16-100
16×100
8
CF18-20
18×20
9
CF18-25
18×25
9
CF18-30
18×30
9
CF18-35
18×35
9
CF18-40
18×40
9
CF18-45
18×45
9
CF18-50
18×50
9
CF18-55
18×55
9
CF18-60
18×60
9
CF18-65
18×65
9
CF18-70
18×70
9
CF18-75
18×75
9
CF18-80
18×80
9
CF18-90
18×90
9
CF18-100
18×100
9
CF20-20
20×20
10
CF20-25
20×25
10
CF20-30
20×30
10
CF20-35
20×35
10
CF20-40
20×40
10
CF20-45
20×45
10
CF20-50
20×50
10
CF20-55
20×55
10
CF20-60
20×60
10
CF20-65
20×65
10
CF20-70
20×70
10
CF20-75
20×75
10
CF20-80
20×80
10
CF20-90
20×90
10
CF20-100
20×100
10
CF20-125
20×125
10
CF22-25
22×25
11
CF22-30
22×30
11
CF22-35
22×35
11
CF22-40
22×40
11
CF22-45
22×45
11
CF22-50
22×50
11
CF22-55
22×55
11
CF22-60
22×60
11
CF22-65
22×65
11
CF22-70
22×70
11
CF22-75
22×75
11
CF22-80
22×80
11
CF22-90
22×90
11
CF22-100
22×100
11
CF22-125
22×125
11
CF25-25
25×25
13.5
CF25-30
25×30
13.5
CF25-35
25×35
13.5
CF25-40
25×40
13.5
CF25-45
25×45
13.5
CF25-50
25×50
13.5
CF25-55
25×55
13.5
CF25-60
25×60
13.5
CF25-65
25×65
13.5
CF25-70
25×70
13.5
CF25-80
25×80
13.5
CF25-90
25×90
13.5
CF25-100
25×100
13.5
CF25-125
25×125
13.5
CF25-150
25×150
13.5
CF27-25
27×25
13.5
CF27-30
27×30
13.5
CF27-35
27×35
13.5
CF27-40
27×40
13.5
CF27-45
27×45
13.5
CF27-50
27×50
13.5
CF27-55
27×55
13.5
CF27-60
27×60
13.5
CF27-65
27×65
13.5
CF27-70
27×70
13.5
CF27-75
27×75
13.5
CF27-80
27×80
13.5
CF27-90
27×90
13.5
CF27-100
27×100
13.5
CF27-125
27×125
13.5
CF27-150
27×150
13.5
CF30-25
30×25
16
CF30-30
30×30
16
CF30-35
30×35
16
CF30-40
30×40
16
CF30-45
30×45
16
CF30-50
30×50
16
CF30-55
30×55
16
CF30-60
30×60
16
CF30-65
30×65
16
CF30-70
30×70
16
CF30-75
30×75
16
CF30-80
30×80
16
CF30-90
30×90
16
CF30-100
30×100
16
CF30-125
30×125
16
CF30-150
30×150
16
CF30-175
30×175
16
CF30-200
30×200
16
CF35-40
35×40
19
CF35-45
35×45
19
CF35-50
35×50
19
CF35-55
35×55
19
CF35-60
35×60
19
CF35-65
35×65
19
CF35-70
35×70
19
CF35-75
35×75
19
CF35-80
35×80
19
CF35-90
35×90
19
CF35-100
35×100
19
CF35-125
35×125
19
CF35-150
35×150
19
CF35-175
35×175
19
CF35-200
35×200
19
CF40-40
40×40
22
CF40-50
40×50
22
CF40-60
40×60
22
CF40-70
40×70
22
CF40-80
40×80
22
CF40-90
40×90
22
CF40-100
40×100
22
CF40-125
40×125
22
CF40-150
40×150
22
CF40-175
40×175
22
CF40-200
40×200
22
CF40-250
40×250
22
CF50-50
50×50
27.5
CF50-60
50×60
27.5
CF50-70
50×70
27.5
CF50-80
50×80
27.5
CF50-90
50×90
27.5
CF50-100
50×100
27.5
CF50-125
50×125
27.5
CF50-150
50×150
27.5
CF50-175
50×175
27.5
CF50-200
50×200
27.5
CF50-250
50×250
27.5
CF50-300
50×300
27.5
CF60-60
60×60
33
CF60-70
60×70
33
CF60-80
60×80
33
CF60-90
60×90
33
CF60-100
60×100
33
CF60-125
60×125
33
CF60-150
60×150
33
CF60-175
60×175
33
CF60-200
60×200
33
CF60-250
60×250
33
CF60-300
60×300
33
모델명
규격(mm)
오지단피(SK-B03)
320
이지어깨토시
880
가죽오지토시장피(SK-14)
510
케블라이지
320
모델명
규격(mm)
전장(mm)
10×12
225
10×13
225
10×14
235
11×13
225
12×14
225
13×17
267
13×19
312
14×15
270
14×17
267
17×19
310
17×21
310
17×22
310
19×21
310
19×22
310
19×24
355
21×23
355
21×26
355
21×27
355
22×24
355
22×27
355
23×26
355
24×27
355
24×30
395
26×29
395
26×30
395
26×32
395
27×30
395
27×32
395
30×32
395
32×35
435
32×36
435
35×41
435
36×41
435
38×41
455
41×46
455
46×50
455
41×55
530
46×55
530
50×55
530
55×60
565
60×65
600
65×70
635
75×80
670
85×90
705
90×100
740