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)
SM-LBS06
6
86
SM-LBS07
7
110
SM-LBS08
8
110
SM-LBS10
10
110
SM-LBS11
11
110
SM-LBS12
12
110
SM-LBS13
13
110
SM-LBS14
14
110
SM-LBS17
17
110
SM-LBS19
19
110
SM-LBS21
21
110
SM-LBS22
22
110
SM-LBS24
24
110
모델명
구성품
EXL-290
본체/인두기/기본팁(CR-S1)/스탠드/전원케이블
EXL-18SET
가죽공예 인두기팁 18P
모델명
S(mm)
D1(mm)
D2(mm)
L1(mm)
L2(mm)
SM-UIHS12-H6
6
8
28
74
82
SM-UIHS12-H7
7
9
28
74
82
SM-UIHS12-H8
8
10.5
28
74
82
SM-UIHS12-H10
10
12.5
28
74
82
SM-UIHS12-H12
12
15
28
74
82
SM-UIHS12-H14
14
17.5
28
74
82
SM-UIHS12-H16
16
20
28
74
82
SM-UIHS12-H19
19
23
28
74
82
SM-UIHS12-H21
21
23.8
28
74
82
모델명
사용범위(")
비고
14336
1/4~3/4
14836
1/4~3/4
수동 자동 겸용
모델명
A×B×C(mm)
SM-WBS
290×113×24
SM-WBL
245×100×35
모델명
규격(")
셋트
212ZLH CN
3/32, 1/8, 5/32, 3/16, 7/32, 1/4, 5/16
7P
212ZLH-12CN
1/20, 1/16, 5/64, 3/32, 7/64, 1/8, 9/64, 5/32, 3/16, 7/32, 1/4, 5/16
12P
모델명
규격
BOX
JCN2145
못굵기2.1x길이45
16,000
JCN2150
못굵기2.1x길이50
12,000
모델명
전장(mm)
a(mm)
b(mm)
c(mm)
d(mm)
중량(kg)
HO-300
300
10
19
50
50
0.42
HO-390
390
10
19
50
50
1.52
모델명
전장(mm)
날길이(mm)
1535
1400
172
1589
930
110
모델명
사용범위(㎣)
컷팅능력(㎟)
SB-740A
0.5, 1.2, 1.6, 2
최대 6
SB-740B
1, 1.6, 2, 2.6, 3.2
최대 6
SB-740C
1.25(2), 3.5, 5.5, 8
최대 6