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)
중량(kg)
SRS3-1200
300×1200
955~1230
9.15
SRS4-1200
400×1200
955~1230
11.05
SRS4-1500
400×1500
955~1230
12.05
SRS4-2000
400×2000
955~1230
13.9
모델명
규격(")
전장(mm)
T6HE366
3/8×7/16
185
T6HE374
7/16×1/2
210
T6HE382
1/2×9/16
240
T6HE392
5/8×3/4
275
T6HE404
13/16×7/8
315
T6HE412
15/16×1
360
모델명
전장(mm)
적용모델
3199
210
3198
3077
210
3080
모델명
규격
적용모델
4" 카본캡
DG-100B, H / EBS-30 / MBC-03
함마드릴용
PHD-38, 25 / D-13,16 / CS-7C
7" 카본캡
DGS-180B,C / NHC-14D
D-23
D-20, PG-125
모델명
D(Ø)
D1(Ø)
W(Ø)
ZKN8-2
2
3
2.5
ZKN8-3
3
4
3.2
ZKN8-4
4
5
4.0
ZKN8-5
5
5.5
4.5
ZKN8-6
6
6
4.5
ZKN8-8
8
6.2
5.0
ZKN12-3
3
4
3.2
ZKN12-4
4
5
4.0
ZKN12-5
5
5.5
4.5
ZKN12-6
6
6
4.5
ZKN12-8
8
6.2
5.0
ZKN12-10
10
7
5.5
ZKN12-12
12
8.5
6.5
ZKN16-3
3
4
3.2
ZKN16-4
4
5
4.0
ZKN16-5
5
5.5
4.5
ZKN16-6
6
6
4.5
ZKN16-8
8
6.2
5.0
ZKN16-10
10
7
5.5
ZKN16-12
12
8.5
6.5
ZKN16-14
14
10.5
8.0
ZKN16-16
16
12.5
10.0
ZKN16-18
18
14
11.0
ZKN16-20
20
15
12.0
ZKN24-8
8
6.2
5.0
ZKN24-10
10
7
5.5
ZKN24-12
12
8.5
6.5
ZKN24-14
14
10.5
8.0
ZKN24-16
16
12.5
10.0
ZKN24-18
18
14
11.0
ZKN24-20
20
15
12.0
ZKN24-22
22
17
13.0
ZKN24-24
24
19
15.0
ZKN38-18
18
14
11.0
ZKN38-20
20
15
12.0
ZKN38-22
22
17
13.0
ZKN38-24
24
19
15.0
ZKN38-27
27
20
15.0
ZKN38-30
30
23
17.0
ZKN38-33
33
25
19.0
ZKN38-36
36
28
21.0
ZKN38-38
38
28
21.0
ZKN65-36
36
28
21
ZKN65-39
39
30
23
ZKN65-42
42
32
26
ZKN65-45
45
35
26
ZKN65-48
48
38
29
ZKN65-52
52
42
32
ZKN65-56
56
44
35
ZKN65-60
60
46
35
ZKN65-64
64
48
38
ZKN65-65
65
50
38
ZKN65-68
68
52
41
ZKN65-72
72
55
41
ZKN65-80
80
58
46
ZKN65-100
100
60
46
모델명
단수
보관높이(m)
사용높이(m)
중량(kg)
7M
7
2.1
1.97
5.36
8M
8
2.4
2.26
6.26
10M
10
3
2.9
7.74
모델명
날장(mm)
적용모델
RS-130-1
130
RS-130
RS-180-1
180
RS-180
KM-180-1
180
KM-180
KS-180-1
180
KS-180
AF-150-1
150
AF-150
F-15-1
150
F-15
모델명
적용모델
048
GDR 14.4V
223
GWS 6-100, GWS 6-100S
252
GWS 7-100
171
GWS 20-180
GPO 12CE
290
GSB 10RE,13RE
222
GSB 16RE
525
GBH 2-22RE,26RE
079
GBH 4-32DFR
245
GBH 5-38X,GSH 388,GSH 5
144
GBH 5-40, GSH 5CE
225
GBH 5DCE
277
GSH 11E, DE, 10C, DC
239
GST 54E, 65E
925
GST 75BE
912
GST 85PBE, GGS 27, 27L
941
GST 135BCE
346
GKS 190
917
GSA 1100E
H53
GHG 500-2
398
GHO 10-82
149
GMR 1
199
GEX 125-1AE, GSS 230
438
GDS 18E
904
GSR 12VE-2, 14.4VE, 18VE
모델명
측정범위(mm)
눈금(mm)
측정깊이(mm)
측정자
G-20
0~10
0.01
20
Ø20 (메탈)
G-30
0~10
0.01
20
Ø30 (메탈)
모델명
콜렛사이즈(Ø)
수량(PCS)
ER11SET
1.0~7.0
13
ER16SET
1.0~10.0
10
ER20SET
2.0~13
12
ER25SET
2.0~16
15
ER32SET
3.0~20
18
모델명
규격(폭x길이x높이mm)
플래폼(폭x길이mm)
HUS-10
1450 x 1900 x 2160
1300 x 1750
HUS-20
1450 x 1900 x 4160
1300 x 1750
HUS-30
1450 x 1900 x 6160
1300 x 1750
HUS-40
1450 x 1900 x 8160
1300 x 1750
HUS-50
1450 x 1900 x 10160
1300 x 1750
모델명
규격(mm)
L(mm)
A(mm)
B(mm)
8×9
237
17.8
19.6
10×11
294
21
22.8
12×13
323
24.2
25.8
14×15
369
27.4
29
17×19
410
34
35.8
모델명
날장(mm)
적용모델
PE-210B
210
PEC-210
PE-240B
240
PEC-240
PE-270B
270
PEC-270
PE-300B
300
PEC-300
PE-350B
350
PEC-350
모델명
적용모델
GA4030
5740NB
N5900B
2414NBH
HM0810, HM0810T
6904VH
6906
6910
9227CB
TW0200
TW0350
모델명
탭퍼
사용범위
나사규격
중량(kg)
VBHU-207
NT40
Ø5~250
5/8"-11W
4.9
VBHU-208
NT50
Ø5~250
1"-8W
7.6
모델명
내경(mm)
길이(m)
8
100
9.5
100
13
100
16
100
19
50
25
50
모델명
규격(")
전장(mm)
3/8×7/16
126
7/16×1/2
135
1/2×9/16
152
9/16×5/8
157
5/8×3/4
180
3/4×7/8
210