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개씩 보기
모델명
탱크용량(ℓ)
호스길이(M)
노즐길이(mm)
B-CS4F
4
2
400
B-CS7F
7
2
400
B-CS8F
8
2
400
B-CS5F
5
2
400
모델명
인선직경(Ø)
절삭길이(mm)
전장(mm)
SA-41M DC
1.5
6
38
SA-42M DC
2.5
11
38
SA-43M DC
3
14
38
SB-43M DC
3
14
38
SC-41M DC
2.5
11
38
SC-42M DC
3
14
38
SD-41M DC
25
3
38
SD-42M DC
3
2.5
38
SE-41M DC
3
5.5
38
SF-41M DC
3
6
38
SF-42M DC
3
12.7
38
SG-41M DC
3
6
38
SG-43M DC
3
9.5
38
SG-44M DC
3
12.7
38
SH-41M DC
3
6.3
38
SJ-42M SC
3
2.5
38
SK-42M SC
3
1.5
38
SL-41M DC
3
9.5
38
SL-42M DC
3
12.7
38
SM-41M DC
3
8.9
38
SM-42M DC
3
11
38
SM-43M DC
3
16
38
SN-41M DC
2.5
3
38
SN-42M DC
3
4
38
모델명
색상
중량(g)
PLC2-B300
블루
300
PLC2-R300
레드
300
PLC2-W300
화이트
300
PLC2-Y300
옐로우
300
모델명
규격(mm)
LBB-8
8
LBB-10
10
LBB-11
11
LBB-12
12
LBB-13
13
LBB-14
14
LBB-17
17
LBB-19
19
LBB-21
21
LBB-22
22
LBB-24
24
모델명
사용모델
IR-120T
7R, 8R (일자용)
IR-150T
71R(일자용)
IR-129T
7R, 8R(90도용)