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개씩 보기
모델명
규격
소
3/4"×3/8"
대
3/4"×3/4"
모델명
컷팅능력(mm)
피복사용범위(mm)
전장(mm)
KY-3103A
10.7
1.6, 2, 2.6, 3.2 (8, 10, 12, 14AWG)
168
KY-3103B
10.7
3, 3.6, 4.8 (10, 8, 4AWG)
168
KY-3103C
10.7
0.8, 1, 1.3, 1.6, 2, 2.6 (10, 12, 14, 16, 18, 20AWG)
168
모델명
규격
항복점(N/㎟)
인장강도(N/㎟)
1박스
CR-13V
2.0Ø
440
500
20kg
CR-13V
2.6Ø
440
500
20kg
CR-13V
3.2Ø
440
500
20kg
CR-13V
4Ø
440
500
20kg
CR-13V
5.0Ø
440
500
20kg
모델명
규격(mm)
전장(mm)
LT-6
T6
50
LT-7
T7
50
LT-8
T8
52
LT-9
T9
54
LT-10
T10
56
LT-15
T15
58
LT-20
T20
64
LT-25
T25
66
LT-30
T30
76
모델명
전장(mm)
SM-OS8
195
SM-OS9
210
모델명
규격
비고
3"
PP-3A용
5"
PP-5B용
모델명
규격(mm)
FT-7
T7
FT-8
T8
FT-9
T9
FT-10
T10
FT-15
T15
FT-20
T20
모델명
규격
벨트길이(mm)
작업범위(Ø)
SM-BW9
9"
540
25~110
SM-BW11
11"
840
40~220
SM-BW12
12"
720
40~240
모델명
케이블사양
ARCA-2520
WCT 25SQ×20M
ARCA-2530
WCT 25SQ×30M
ARCA-3510
WCT 35SQ×10M
ARCA-3530
WCT 35SQ×30M
ARCA-5030
WCT 50SQ×30M
ARCA-7010
WCT 70SQ×10M
ARCA-7015
WCT 70SQ×15M
ARCA-7020
WCT 70SQ×20M
ARCA-7025
WCT 70SQ×25M
ARCA-7030
WCT 70SQ×30M
모델명
측정범위(mm)
최소눈금(mm)
NA192-300S
0~300
0.01
NA192-600S
0~600
0.01