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개씩 보기
모델명
규격
적용모델
4" 카본캡
DG-100B, H / EBS-30 / MBC-03
함마드릴용
PHD-38, 25 / D-13,16 / CS-7C
7" 카본캡
DGS-180B,C / NHC-14D
D-23
D-20, PG-125
모델명
규격(")
전장(mm)
T6HD017
7/16×1/2
135
T6HD050
3/4×7/8
205
T6HD076
5/8×11/16
165
T6HD092
7/8×15/16
220
모델명
날장(mm)
적용모델
PE-210B
210
PEC-210
PE-240B
240
PEC-240
PE-270B
270
PEC-270
PE-300B
300
PEC-300
PE-350B
350
PEC-350
모델명
적용모델
048
GDR 14.4V
223
GWS 6-100, GWS 6-100S
252
GWS 7-100
171
GWS 20-180
GPO 12CE
290
GSB 10RE,13RE
222
GSB 16RE
525
GBH 2-22RE,26RE
079
GBH 4-32DFR
245
GBH 5-38X,GSH 388,GSH 5
144
GBH 5-40, GSH 5CE
225
GBH 5DCE
277
GSH 11E, DE, 10C, DC
239
GST 54E, 65E
925
GST 75BE
912
GST 85PBE, GGS 27, 27L
941
GST 135BCE
346
GKS 190
917
GSA 1100E
H53
GHG 500-2
398
GHO 10-82
149
GMR 1
199
GEX 125-1AE, GSS 230
438
GDS 18E
904
GSR 12VE-2, 14.4VE, 18VE
모델명
규격(mm)
전장(mm)
SM-DOW34×36
34×36
325
SM-DOW36×41
36×41
330
SM-DOW41×46
41×46
365
SM-DOW46×50
46×50
475
SM-DOW50×55
50×55
500
SM-DOW55×60
55×60
500
SM-DOW32×36
32×36
290
모델명
적용모델
GA4030
5740NB
N5900B
2414NBH
HM0810, HM0810T
6904VH
6906
6910
9227CB
TW0200
TW0350
모델명
측정범위(mm)
눈금(mm)
측정깊이(mm)
측정자
G-20
0~10
0.01
20
Ø20 (메탈)
G-30
0~10
0.01
20
Ø30 (메탈)
모델명
적용모델
DW-293용
DW-303,304PK공용
모델명
규격(mm)
전장(mm)
중량(g)
SN0014
14
140
45
SN0017
17
160
85
SN0019
19
180
115
SN0022
22
195
140
SN0024
24
215
200
SN0027
27
235
250
SN0030
30
275
320
SN0032
32
275
370
SN0035
35
305
550
SN0036
36
305
550
SN0038
38
305
550
SN0041
41
345
820
모델명
규격(mm)
WCL-06BP
6
WCL-09BP
9
WCL-12BP
12
WCL-15BP
15
WCL-19BP
19
WCL-22BP
22
WCL-25BP
25
WCL-32BP
32
WCL-38BP
38
모델명
마력(HP)
소음(dB)
탱크용량(ℓ)
에어생산량(ℓ)
L×W×H(mm)
중량(kg)
UDS-2024D
2
50
24
128
570×300×500
21
UDS-3040D
3
62
40
193
670×360×670
38
모델명
규격(mm)
4536
16~18
4546
20~22
4556
25~28
4566
30~32
4576
34~36
4586
40~42
4596
45~50
4606
52~55
4616
58~62
4626
68~75
4636
80~90
4646
95~100
모델명
날폭(mm)
전장(mm)
SM-FC06W
6
245
SM-FC10W
10
245
SM-FC13W
13
245
SM-FC16W
16
245
SM-FC19W
19
245
SM-FC22W
22
245
SM-FC25W
25
245
SM-FC32W
32
265
SM-FC38W
38
265