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개씩 보기
모델명
방식
264-005
PS/2
264-007
RS232C
264-016-10(264-012-10)
USB
모델명
규격(mm)
전장(mm)
174-35
35
250
174-40
40
300
174-50
50
400
174-60
60
500
모델명
규격(mm)
D(mm)
L(mm)
A(mm)
4TX-T30H
T30
22
74
39
4TX-T40H
T40
22
74
39
4TX-T45H
T45
22
74
39
4TX-T50H
T50
22
74
39
4TX-T55H
T55
22
74
39
4TX-T60H
T60
22
74
39
4TX-T70H
T70
22
74
36
모델명
규격
6"
8"
10"
12"
18"
24"
모델명
규격(mm)
KK-025
25
KK-042
42
모델명
규격(mm)
전장(mm)
재질
167A-1.5
1.5
45
Al-Cu
167A-2
2
50
Al-Cu
167A-2.5
2.5
55
Al-Cu
167A-3
3
63
Al-Cu
167A-4
4
70
Al-Cu
167A-5
5
80
Al-Cu
167A-6
6
90
Al-Cu
167A-8
8
100
Al-Cu
167A-10
10
112
Al-Cu
167A-4
4
70
Be-Cu
167A-5
5
80
Be-Cu
167A-6
6
90
Be-Cu
167A-8
8
100
Be-Cu
167A-10
10
112
Be-Cu
모델명
규격(mm)
전장(mm)
M05
52
M06
52
M08
52
M10
52
M12
76
모델명
규격(mm)
DC-150S
150
DC-200S
200
DC-250S
250
DC-300S
300
모델명
사용범위(mm)
비고
SM-PC206
36
SM-PC204
36
SM-PC201
42
SM-PC207
42
원터치 OPEN
SM-PC203
36
방아쇠형
SM-PC208
63
모델명
사용범위(mm)
SM-PC224
36
SM-PC225
42
SM-PC226
63
모델명
폭(mm)
전장(mm)
재질
203-1006
50
200
Al-Cu
203-1006
50
200
Be-Cu