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)
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
40
42
43
45
48
49
50
52
55
56
60
61
62
64
65
70
72
75
77
80
84
90
95
100
105
108
110
115
116
120
모델명
전장(m)
직경(mm)
사용안전중량(kg)
파열하중(kg)
FP515
15
5.4
270
700
FP520
20
5.4
270
700
FP530
30
5.4
270
700
FP550
50
5.4
270
700
FP5100
100
5.4
270
700
FP715
15
7
300
850
FP720
20
7
300
850
FP730
30
7
300
850
FP750
50
7
300
850
FP7100
100
7
300
850
모델명
용량(ℓ)
가로×세로×높이(mm)
중량(kg)
HP-0702
4
195×195×460
1.6
HP-0701
6
195×195×550
1.7
HP-0703
8
195×195×630
1.8
모델명
규격(mm)
L1(mm)
L2(mm)
AW0150
1.5
14
45
AW0200
2
16
50
AW0250
2.5
18
56
AW0300
3
20
63
AW0400
4
23
72
AW0500
5
28
80
AW0600
6
32
90
AW0700
7
34
95
AW0800
8
36
100
AW1000
10
40
112
AW1200
12
45
125
AW1400
14
56
140
AW1600
16
63
157
AW1700
17
63
160
AW1900
19
70
180
AW2100
21
75
198
AW2200
22
80
200
AW2400
24
90
224
AW2600
26
100
250
AW2700
27
100
250
AW3200
32
125
315
AW3600
36
140
355
AW4100
41
160
400
AW4600
46
180
440
모델명
품명
규격(mm)
포장단위
20K신재마대
450×700
100EA
40K신재마대
500×700
100EA
40K신재마대
550×860
100EA
80K신재마대
680×1000
100EA
100K신재마대
750×1100
100EA
모델명
흡착력
규격
KE-1B
8N
Ø10×30mm
KE-2B
28N
Ø20×40mm
KE-3B
180N
Ø30×40mm
KE-4B
400N
Ø40×40mm
KE-5B
600N
Ø50×50mm
KE-6B
1100N
Ø60×60mm
KE-7B
1500N
Ø70×60mm
KE-8B
2000N
Ø80×60mm
KE-9B
3300N
Ø90×60mm
KE-2D
18N
Ø20×25mm
KE-3E
80N
Ø30×25mm
KE-4E
220N
Ø40×25mm
KE-2R
5N
Ø20×25mm
KE-3RA
30N
Ø30×25mm
KE-4RA
110N
Ø40×25mm
모델명
굵기×기장
1박스(PCS)
적용모델
FS45V1
2.1Ø×45mm
14000
CN55
FS45V5
2.5Ø×45mm
9000
CN55, CN70
FS50V1
2.1Ø×50mm
10500
CN55
FS50V5
2.5Ø×50mm
9000
CN55, CN70, CN80, NV-65A
FS57V5
2.5Ø×57mm
9000
CN55, CN70, CN80, NV-65A
FS65V5
2.5Ø×64mm
9000
CN70, CN80, CN100, NV-65A
FS65V9
2.9Ø×64mm
5000
CN80, CN100
FS70V5
2.5Ø×70mm
6000
CN70, CN80, CN100, NV-65A
FS75V9
2.9Ø×75mm
5000
CN80, CN100, NV-83A
FS83W1
3.1Ø×83mm
4000
CN80, CN100, NV-83A
FS90W1
3.1Ø×90mm
4000
CN100
FS100W1
3.1Ø×100mm
2250
CN100
NS45V1
2.1Ø×45mm
14000
CN450S
NS50V1
2.1Ø×50mm
10500
CN450S
모델명
가로(mm)
세로(mm)
높이(mm)
T-320
320
125
85
T-360
370
210
90
T-410
420
210
105
모델명
날장(mm)
전장(mm)
중량(g)
A-1000
180
725
760
A-2000
180
725
760
A-3000
180
700
830
A1000,A2000 전용날
모델명
규격(mm)
외경(D1)
외경(D2)
전장(mm)
중량(g)
17
33
50
60
19
37
50
60
520
21
38
50
60
550
22
39
50
60
23
41
50
60
24
42
50
60
570
25
43
50
60
26
44
50
60
580
27
45
50
60
580
28
47
50
60
590
29
48
50
60
600
30
49
50
62
620
31
50
50
62
32
52
52
63
660
33
53
53
63
680
34
54
54
63
710
35
56
52
63
710
36
57
53
67
730
37
58
54
67
38
59
54
67
740
40
62
54
67
750
41
64
54
70
930
42
63
54
70
960
43
65
54
70
980
45
68
54
70
44
67
54
70
46
69
54
70
1210
47
71
54
70
48
72
54
70
1260
49
73
54
70
50
74
54
70
1370
52
77
54
82
1430
54
79
54
82
1550
55
81
55
87
1620
56
83
57
87
1650
57
83
57
87
1670
58
84
57
87
1750
60
87
60
91
1900
62
89
60
91
63
91
60
91
2000
65
93
65
95
2400
68
97
65
95
70
99
70
100
2500
75
106
70
105
2800
80
112
80
105
2900
85
118
86
110
3200
90
124
86
110
3800
95
130
90
110
4200
모델명
길이(M)
폭(mm)
중량(g)
LP19-55
5.5
19
240
LP25-55
5.5
25
300
LP25-75
7.5
25
405
모델명
나사규격(PT)
외경(Ø)
1/4
11
1/4
13
3/8
8
3/8
9.5
3/8
11
3/8
13
1/8
8
1/8
9.5
1/8
13
1/8
11
1/4
8
1/4
9.5
3/8
16
1/2
8
1/2
9.5
1/2
11
1/2
13
1/2
16
모델명
구성(P)
셋트구성
셋트규격
비고
SB 369 S9
9p
1.5~10
1.5, 2, 2.5, 3, 4, 5, 6, 8, 10
SB 369 S9B
9p
1.5~10
1.5, 2, 2.5, 3, 4, 5, 6, 8, 10
흑색
SB 369 H7
7p
1.5~6
1.5, 2, 2.5, 3, 4, 5, 6
SB 369 H9
9p
1.5~10
1.5, 2, 2.5, 3, 4, 5, 6. 8, 10
SB 369 KH9
9p
1.5~10
숏
모델명
외경(mm)
내경MT
K20-MT1
20
MT1
K20-MT2
20
MT2
K32-MT1
32
MT1
K32-MT2
32
MT2
K32-MT3
32
MT3
K42-MT1
42
MT1
K42-MT2
42
MT2
K42-MT3
42
MT3
K42-MT4
42
MT4
모델명
규격
외경×두께×내경(mm)
1박스
RAG-2
4"
100×6×16
50EA
RAG-2
7"
180×6×22
10EA