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개씩 보기
모델명
팁굵기×날장(mm)
굵기(mm)
980
P2×100
6
980
P2×150
6
980
P3×150
8
모델명
규격
적용날
EL0100GT
2.6mm
B날용
EL0200GT
3.2mm
E날용
모델명
규격(mm)
오지단피(SK-B03)
320
이지어깨토시
880
가죽오지토시장피(SK-14)
510
케블라이지
320
모델명
탱크용량(ℓ)
압력비율
호스(M)
중량(kg)
UD-30Q
30
50:1
5
15
904001 (헤드)
30
50:1
5
모델명
제원
상종
ALEM-1530B-3
1.5SQ×3C×30m
3상
ALEM-1550B-3
1.5SQ×3C×50m
3상
ALEM-430B
4SQ×3C×30m
3상
모델명
규격(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
모델명
구성
비고
290
[+]#1,2,3×[-]6
353
강력 [+]#1, #2, 3 / [-]6×2
플렉시블 샤프트
370
[-]4.5×[+]1, [-]6×[+]2
T형
417
[-]4.5, [+]1, [-]6×[+]2, [+]3 / 6각 2.5, 3, 4, 5
옵셋형 7본조
415
[-]6×[+]2
옵셋형
모델명
규격(mm)
두께L(mm)
B(mm)
1포장
MSW
M10
10
5
100EA
MSW
M12
10
6
100EA
MSW
M14
10
6
100EA
MSW
M16
10
8
100EA
MSW
M18
10
10
100EA
MSW
M20
12
10
100EA
MSW
M22
12
12
100EA
MSW
M24
12
14
100EA
MSW
M26
12
14
100EA
MSW
M27
12
14
100EA
MSW
M30
12
17
100EA
MSW
M33
12
17
100EA
MSW
M36
18
17
50EA
MSW
M38
18
17
10EA
MSW
M40
18
17
10EA
MSW
M42
18
17
30EA
모델명
구성품
비고
SM-RBS3
미니라쳇 1/4"×105mm, 비트 [+]2, [-]6
스트레이트
SM-RBS3B
미니라쳇 1/4"×105mm, 비트 [+]2, [-]6
벤드 업 헤드