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)
T7
45
T8
45
T9
45
T10
45
T15
45
T20
45
T25
45
T27
45
T30
45
T40
45
모델명
규격
6"
8"
10"
12"
18"
24"
모델명
규격(")
전장(mm)
중량(g)
재질
147-1002
1/4×5/16
90
30
147-1004
5/16×3/8
100
40
147-1006
3/8×7/16
110
55
147-1008
3/8×1/2
115
60
147-1010
7/16×1/2
120
78
147-1012
1/2×9/16
130
80
147-1014
9/16×5/8
150
105
147-1016
5/8×11/16
160
130
147-1018
5/8×3/4
165
135
147-1020
11/16×3/4
170
145
147-1022
3/4×13/16
180
185
147-1024
3/4×7/8
185
200
147-1026
13/16×7/8
190
215
147-1028
7/8×15/16
210
270
147-1030
15/16×1
220
305
147-1032
1×1 1/16
230
355
147-1034
1 1/16× 1 1/8
235
380
147-1036
1 1/8× 1 3/16
245
480
147-1038
1 3/16×1 1/4
250
525
147-1012
1/2×9/16
130
80
Be-Bronze
147-1016
5/8×11/16
160
130
Be-Bronze
모델명
규격(mm)
전장(mm)
M05
76
M06
76
M08
76
M10
76
M12
76
모델명
흡착력(kgf)
사용길이(mm)
A-500L
35
500
A-300L
25
300
모델명
규격(mm)
DC-150S
150
DC-200S
200
DC-250S
250
DC-300S
300
모델명
날장(mm)
8015
240
8032
300
모델명
규격
재질
SM-MW10AL
10"
Al-Cu
SM-MW15AL
15"
Al-Cu
모델명
규격
구성
21XSB-S10
1/2"
T10, 15, 20, 25, 27, 30, 40, 45, 50, 55
83XSB-S9
3/8"
T10, 15, 20, 25, 27, 30, 40, 45, 50
모델명
A x B(mm)
C x D(mm)
SM-CLM10/5
100×50
15×5
SM-CLM15/5
150×50
15×5
SM-CLM20/5
200×50
15×5
SM-CLM25/5
250×50
15×5
SM-CLM30/5
300×50
15×5
SM-CLM15/8
150×80
22×6
SM-CLM20/8
200×80
22×6
SM-CLM25/8
250×80
22×6
SM-CLM30/8
300×80
22×6
SM-CLM20/10
200×100
27×7
SM-CLM25/10
250×100
27×7
SM-CLM30/10
300×100
27×7
SM-CLM40/10
400×100
27×7
SM-CLM50/10
500×100
27×7
모델명
사용범위(mm)
23488
3~42
23493
3~35
모델명
규격(mm)
D(mm)
A(mm)
L(mm)
중량(g)
3BH-03
3
17
48
75
25
3BH-04
4
17
48
75
30
3BH-05
5
17
48
75
30
3BH-06
6
17
48
75
45
3BH-08
8
19
48
75
45
3BH-10
10
20
48
75
70