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)
길이(cm)
MT175
12.5
75
MT275
25
75
MT1300
12.5
300
MT2300
25
300
모델명
작업범위(mm)
소비전력(W)
중량(kg)
5.6712
Ø20~Ø200
1100
9.4
5.6713
Ø75~Ø360
1400
13.2
모델명
T(mm)
D1(mm)
D2(mm)
L1(mm)
L2(mm)
SM-UTBS12-T25
T25
5
28
74
82
SM-UTBS12-T27
T27
5.5
28
74
82
SM-UTBS12-T30
T30
6
28
74
82
SM-UTBS12-T40
T40
7.5
28
74
82
SM-UTBS12-T45
T45
8.5
28
74
82
SM-UTBS12-T50
T50
9.5
28
74
82
SM-UTBS12-T55
T55
12
28
74
82
SM-UTBS12-T60
T60
14
28
74
82
SM-UTBS12-T70
T70
16
28
74
82
모델명
A×B(mm)
C(mm)
GZ16K
160×80
17.5×6.8
GZ20K
200×100
17.5×6.8
GZ25K
250×120
24.5×9.5
GZ30K
300×140
28×11
GZ40K
400×120
28×11
모델명
규격
구성(mm)
132 Al-Cu
9PCS
8, 10, 12, 14, 17, 19, 22, 24, 27
133 Al-Cu
11PCS
8, 10, 12, 14, 17, 19, 22, 24, 27, 30, 32
134 Al-Cu
13PCS
8, 10, 12, 13, 14, 16, 17, 19, 22, 24, 27, 30, 32
132 Be-Cu
9PCS
8, 10, 12, 14, 17, 19, 22, 24, 27
133 Be-Cu
11PCS
8, 10, 12, 14, 17, 19, 22, 24, 27, 30, 32
134 Be-Cu
13PCS
8, 10, 12, 13, 14, 16, 17, 19, 22, 24, 27, 30, 32
모델명
규격(mm)
전장(mm)
5
110
6
110
7
110
8
110
9
110
10
110
5
150
6
150
8
150
10
150
모델명
A×B(mm)
C×D(mm)
E(mm)
중량(kg)
KR30-2K
300×85
29×9
230~390
1.82
KR60-2K
600×85
29×9
230~730
2.4
KR80-2K
800×85
29×9
230~930
2.8
KR100-2K
1000×85
29×9
230~1130
3.28
KR125-2K
1250×85
29×9
230~1355
3.64
KR150-2K
1500×85
29×9
230~1610
4.12
KR200-2K
2000×85
29×9
230~2080
5.08
KR250-2K
2500×85
29×9
230~2580
6.04
모델명
규격(mm)
전장(mm)
QCBS08
8
80
QCBS10
10
80
QCBS12
12
80
QCBS13
13
80
QCBS14
14
80
QCBS17
17
80
QCBS19
19
80
모델명
A×B(mm)
C×D(mm)
중량(kg)
EHZ30-2K
300×100
19.5×9.5
1.25
EHZ60-2K
600×100
19.5×9.5
1.67