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개씩 보기
모델명
D(Ø)
적용척내경
MC20-MT1
20
C20
MC20-MT2
20
C20
MC32-MT1
32
C32
MC32-MT2
32
C32
MC32-MT3
32
C32
MC42-MT1
42
C42
MC42-MT2
42
C42
MC42-MT3
42
C42
MC42-MT4
42
C42
모델명
높이(mm)
HG-4
1200
HG-5
1500
HG-6
1800
HG-7
2100
HG-8
2400
HG-10
3000
HG-12
3600
HG-13
3900
모델명
규격(mm)
재료크기
1/16"(1.6mm)
6.4×60
3/32"(2.4mm)
6.4×60
1/8"(3.2mm)
6.4×60
5/16"(7.9mm)
11×76
모델명
굵기×기장
1박스(PCS)
적용모델
FC50V5
2.5Ø×50mm
9000
CN55, CN70, CN80, NV-65A
FC57V5
2.5Ø×57mm
9000
CN55, CN70, CN80, NV-65A
FC65V5
2.5Ø×65mm
9000
CN70, CN80, CN100, NV-65A
FC70V5
2.5Ø×70mm
6000
CN70, CN80, CN100, NV-65A
FC75V9
2.9Ø×75mm
5000
CN80, CN100, NV-83A
FC83W1
3.1Ø×83mm
4000
CN80, CN100, NV-83A
FC90W1
3.1Ø×90mm
4000
CN100
FC100W1
3.1Øx100mm
2250
CN100
NC50V1
2.1Ø×50mm
10500
CN450S
모델명
제품번호
측정범위(m/s)
습도
410-1
0560 4101
0.4~20
410-2
0560 4102
0.4~20
0~100
모델명
외경(mm)
내경MT
TC20-MT1
20
MT1
TC20-MT2
20
MT2
TC32-MT1
32
MT1
TC32-MT2
32
MT2
TC32-MT3
32
MT3
TC42-MT1
42
MT1
TC42-MT2
42
MT2
TC42-MT3
42
MT3
TC42-MT4
42
MT4
모델명
높이(mm)
A(mm)
B(mm)
C(mm)
D(mm)
중량(kg)
SSA-163(FG-163)
300
420
620
200
300
4.5
SSA-266(FG-266)
600
420
620
200
300
7.3
SSA-369(FG-369)
900
420
620
200
300
10.4
FG-4612
1200
420
620
200
300
모델명
규격
구성(mm)
HPS7P
7P
1.5, 2, 2.5, 3, 4, 5
HPS8P
8P
3, 4, 5, 6, 7, 8
HPS10P
10P
5, 6, 8, 10, 12, 16, 20, 25, 30
모델명
굵기×기장(mm)
적용타정기
1박스
R3125-AT
3.05×25
JN-45R
7200
R3132-AT
3.05×32
JN-45R
7200
R3138-AT
3.05×38
JN-45R
7200
모델명
제품번호
측정온도(℃)
품명
115i
0560 1115
-40~150
클램프 온도계
905i
0560 1905
-50~150
온도계
805i
0560 1805
-30~250
적외선온도계