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)
12701
30
163
12702
38
163
12703
45
163
12704
70
163
모델명
바퀴(")
비고
적용모델
13
두발용
WB-2
16
외발용
WB-1
모델명
규격(")
1/8
3/16
1/4
5/16
3/8
1/2
5/8
3/4
7/8
1
모델명
외경(Ø)
내경(Ø)
NK20-6
20
6
NK20-8
20
8
NK20-10
20
10
NK20-12
20
12
NK20-16
20
16
NK32-6
32
6
NK32-8
32
8
NK32-10
32
10
NK32-12
32
12
NK32-16
32
16
NK32-20
32
20
NK32-25
32
25
NK42-8
42
8
NK42-10
42
10
NK42-12
42
12
NK42-16
42
16
NK42-20
42
20
NK42-32
42
32
모델명
구성
SS, AA, OO, 2A, 7
SS, SSH, AA, 7, 2A, 5A, 2, 3C, TS, GG, OO, 5, 3
모델명
측정범위(cNm)
최소눈금(cNm)
전장(mm)
중량(kg)
BEM-TD50CN
5~50
0.1
203
0.26
BEM-TD200CN
10~200
0.1
203
0.26
BEM-TD400CN
20~400
0.1
203
0.26
모델명
규격
구성(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
모델명
전압
1판
HR6 20R(AA)
1.2V / 2000mAh
4EA
HR03 80R(AAA)
1.2V / 800mAh
4EA
모델명
길이×폭×두께(mm)
입도
NNW-800
210×65×30
800#
NNW-1000
210×65×30
1000#
NNW-1200
210×65×30
1200#
모델명
폭(mm)×길이(M)
색상
40×30
청색
40×30
녹색
모델명
탭핑M
탭핑U
탭핑P
적용탭콜렛
BT30-Z8-90
M2~8
U1/8~1/4
-
ZKN 8
BT30-Z12-105
M3~12
U1/8~1/2
P1/8
ZKN 12
BT40-Z8-90
M2~8
U1/8~1/4
-
ZKN 8
BT40-Z12-90
M3~12
U1/8~1/2
P1/8
ZKN 12
BT40-Z12-130
M3~12
U1/8~1/2
P1/8
ZKN 12
BT40-Z16-109
M3~20
U1/8~5/8
P1/8~3/8
ZKN 16
BT40-Z24-100
M8~24
U1/2~1
P1/4~5/8
ZKN 24
BT40-Z24-187
M8~24
U1/2~1
P1/4~5/8
ZKN 24
BT40-Z38-140
M18~38
U3/4~1 3/8
P3/8~1
ZKN 38
BT50-Z8-105
M2~8
U1/8~1/4
-
ZKN 8
BT50-Z12-130
M3~12
U1/8~1/2
P1/8
ZKN 12
BT50-Z12-175
M3~12
U1/8~1/2
P1/8
ZKN 12
BT50-Z12-220
M3~12
U1/8~1/2
P1/8
ZKN 12
BT50-Z16-135
M3~20
U1/8~5/8
P1/8~3/8
ZKN 16
BT50-Z24-142
M8~24
U1/2~1
P1/4~5/8
ZKN 24
BT50-Z24-187
M8~24
U1/2~1
P1/4~5/8
ZKN 24
BT50-Z38-175
M18~38
U3/4~1 3/8
P3/8~1
ZKN 38
BT50-Z65-160
M36~100
U1~3 3/8
P1~3 1/4
ZKN 65
모델명
구성(P)
구성(mm)
4p
10, 12, 13, 14
7p
8, 10, 12, 13, 14, 17, 19
9P
8, 9, 10, 11, 12, 13, 14, 17, 19
12p
8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19
모델명
적용모델
31713
WD0655
83727
WD1255, WD1685
모델명
적용 퀵체인지 홀더 No.
쟈콥스테이퍼
DT35-6BD
HA 40-T35
JT-6
DT45-6BD
HA 50-T45
JT-6
모델명
날장(mm)
적용모델
3101
150
3100
3103
210
3102
3105
240
3104