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)
단수
HD-2
570
2
HD-3
790
3
HD-4
1070
4
HD-5
1460
5
모델명
규격(mm)
외경(D1)
외경(D2)
전장(mm)
4
6.7
12
50
4.5
7.3
12
50
5
8
12
50
5.5
8.6
12
50
6
9.2
12
50
7
10.8
12
50
8
12
12
50
9
13.2
12
50
10
14.7
12.5
50
11
16
13
50
12
17
13.5
50
13
18
14
50
14
19.7
14.5
50
모델명
사용핀
중량(kg)
IN160
30~160
3.4
IN220
30~220
3.5
모델명
테이퍼
TAP 능력
SDT24-2
MT2
M4~M14, U3/16~U1/2, P1/8~P1/4
SDT24-3
MT3
M4~M24, U3/16~U7/8, P1/8~P1/2
SDT24-4
MT4
M4~M24, U3/16~U7/8, P1/8~P1/2
SDT33-4
MT4
M6~M33, U5/16~U1 1/4, P1/8~P1
SDT33-5
MT5
M6~M33, U5/16~U1 1/4, P1/8~P1
모델명
규격(mm)
D1(mm)
D2(mm)
전장(mm)
T6JC549
9
17
13.4
28
T6JC557
10
17
14.6
28
T6JC573
12
16
17
28
T6JC590
14
18
20
28
T6JC603
15
18
22
28
모델명
굵기×기장
1갑
가스카트리지
적용모델
CP719V6
2.6Ø×19mm
1000발
1본
GS638E
CP722V6
2.6Ø×22mm
1000발
1본
GS638E
CP725V6
2.6Ø×25mm
1000발
1본
GS638E
모델명
능력(Ø)
크기(D×L)
적용모델
FC-10
2.5~4.5
16×11
VTA 7-JT6
FC-11
4.5~6.5
16×11
VTA 7-JT6
FC-20
4.5~7.5
21.5×13
VTA 12-JT6
FC-21
7.5~10
21.5×13
VTA 12-JT6
모델명
상판(폭×길이mm)
높이(최저~최고mm)
중량(kg)
SU-3016
300×1600
520~710
8.7
SU-4016
400×1600
520~710
10.55
모델명
측정범위(LUX)
오차범위
크기(mm)
비고
BO-813A
1~100,000
±4%
116×64×30
센서 일체형
BO-823
1~100,000
±3%
151×83×26
센서 분리형
모델명
간격(mm)
C(Ø)
전장(mm)
BER-11-0.5-1
1
11.5
18
BER-11-1-1.5
1
11.5
18
BER-11-1.5-2
1
11.5
18
BER-11-2-2.5
1
11.5
18
BER-11-2.5-3
1
11.5
18
BER-11-3-3.5
1
11.5
18
BER-11-3.5-4
1
11.5
18
BER-11-4-4.5
1
11.5
18
BER-11-4.5-5
1
11.5
18
BER-11-5-5.5
1
11.5
18
BER-11-5.5-6
1
11.5
18
BER-11-6-6.5
1
11.5
18
BER-11-6.5-7
1
11.5
18
BER-16-0.5-1
1
17
27
BER-16-1.5-2
1
17
27
BER-16-2-3
1
17
27
BER-16-3-4
1
17
27
BER-16-4-5
1
17
27
BER-16-5-6
1
17
27
BER-16-6-7
1
17
27
BER-16-7-8
1
17
27
BER-16-8-9
1
17
27
BER-16-9-10
1
17
27
BER-20-0.5-1
1
21
31
BER-20-1-2
1
21
31
BER-20-2-3
1
21
31
BER-20-3-4
1
21
31
BER-20-4-5
1
21
31
BER-20-5-6
1
21
31
BER-20-6-7
1
21
31
BER-20-7-8
1
21
31
BER-20-8-9
1
21
31
BER-20-9-10
1
21
31
BER-20-10-11
1
21
31
BER-20-11-12
1
21
31
BER-20-12-13
1
21
31
BER-25-1-2
1
26
35
BER-25-2-3
1
26
35
BER-25-3-4
1
26
35
BER-25-4-5
1
26
35
BER-25-5-6
1
26
35
BER-25-6-7
1
26
35
BER-25-7-8
1
26
35
BER-25-8-9
1
26
35
BER-25-9-10
1
26
35
BER-25-10-11
1
26
35
BER-25-11-12
1
26
35
BER-25-12-13
1
26
35
BER-25-13-14
1
26
35
BER-25-14-15
1
26
35
BER-25-15-16
1
26
35
BER-32-1-2
1
33
40
BER-32-2-3
1
33
40
BER-32-3-4
1
33
40
BER-32-4-5
1
33
40
BER-32-5-6
1
33
40
BER-32-6-7
1
33
40
BER-32-7-8
1
33
40
BER-32-8-9
1
33
40
BER-32-9-10
1
33
40
BER-32-10-11
1
33
40
BER-32-11-12
1
33
40
BER-32-12-13
1
33
40
BER-32-13-14
1
33
40
BER-32-14-15
1
33
40
BER-32-15-16
1
33
40
BER-32-16-17
1
33
40
BER-32-17-18
1
33
40
BER-32-18-19
1
33
40
BER-32-19-20
1
33
40
모델명
연장높이(M)
축장높이(M)
폭(mm)
중량(kg)
SU-D1
5.2
3.1
40
12
SU-D3
6.9
4.1
40
17
SU-D5
8.9
5.1
43.5
21