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개씩 보기
모델명
규격
내경(Ø)
외경(Ø)
중량(kg)
비고
3/16(5)×2T/S(1B)×100M
4.8
11.9
23
적+녹
5/16(8)×2T/S(1B)×100M
7.9
14.5
33
적+녹
5/16(8)×2T/S(1B)×100M
7.9
14.5
33
황+녹
모델명
규격
용량(ton)
TAC-50
50×50×6T
20
TAC-75
75×75×10T
30
TAC-100
100×100×13T
50
모델명
내경(Ø)
L(mm)
C(mm)
적용콜렛
BT30-C12-55
12
55
30
-
BT30-C20-70
20
70
54
NK20, KM20
BT30-C25-75
25
75
62
-
BT30-C32-100
32
100
69
NK32, KM32
BT40-C12-65
12
65
30
-
BT40-C12-90
12
90
30
-
BT40-C16-90
16
90
45
-
BT40-C20-70
20
70
54
NK20, KM20
BT40-C20-90
20
90
54
NK20, KM20
BT40-C25-70
25
70
62
-
BT40-C25-120
25
120
62
-
BT40-C32-85
32
85
72
NK32, KM32
BT40-C32-105
32
105
72
NK32, KM32
BT40-C32-120
32
120
72
NK32, KM32
BT50-C12-105
12
105
30
-
BT50-C16-135
16
135
45
-
BT50-C20-135
20
135
54
NK20, KM20
BT50-C25-135
25
135
62
-
BT50-C32-90
32
90
75
NK32, KM32
BT50-C32-105
32
105
75
NK32, KM32
BT50-C32-135
32
135
75
NK32, KM32
BT50-C32-165
32
165
75
NK32, KM32
BT50-C42-95
42
95
95
NK42, KM42
BT50-C42-105
42
105
95
NK42, KM42
BT50-C42-120
42
120
95
NK42, KM42
BT50-C42-135
42
135
95
NK42, KM42
BT50-C42-165
42
165
95
NK42, KM42
모델명
규격(mm)
A(mm)
L1(mm)
SM-3TS
T10
65
125
SM-3TS
T15
65
125
SM-3TS
T20
65
125
SM-3TS
T25
90
180
SM-3TS
T27
90
180
SM-3TS
T30
90
180
SM-3TS
T45
125
250
SM-3TS
T50
125
250
모델명
L×W×H(mm)
칼날
비고
L-18BWD
150×27×51
LB-10BWH/2장 내장
오토락
L-19BWD
150×27×51
LB-10BWH/2장 내장
나사잠금식
모델명
적용모델
AT08-90
VAT-1408, 708, 1608, 1908
AT16-90
VAT-1416, 716, 1616, 1916
AT20-90
VAT-1420, 720, 1620, 1920
AT22-90
VAT-1422, 722, 1622, 1922
AT24-90
VAT-1424, 724, 1624, 1924
모델명
규격
전장(mm)
최대벌림(mm)
중량(g)
SM-G05
5"
130
13
190
SM-G08
8"
200
25
220
SM-G10
10"
250
47
390
SM-G12
12"
300
50
590
SM-G16
16"
400
105
1190
모델명
규격(ton)
빔규격(최소~최대)
중량(kg)
0.5
75~125
6
1
75~125
10.5
2
100~150
20
3
100~150
33
5
125~175
42
모델명
베이스(mm)
흡착력(kgf)
중량(kg)
PH-3100
30×40×35
32
0.5
PH-2040
50×60×55
80
1.7
PH-4016
50×70×55
100
2.45
모델명
사용범위(mm)
23488
3~42
23493
3~35