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개씩 보기
모델명
전압(AC/DC)
저항
비고
FLUKE-113
0~600V
0~40MΩ
FLUKE-114
0~600V
0~40MΩ
FLUKE-115
0~600V
0~40MΩ
전류 10A
FLUKE-116
0~600V
0~40MΩ
FLUKE-117
0~600V
0~40MΩ
전류 10A, 허전압측정
모델명
규격(")
전장(mm)
3/4
750
3/4
1000
모델명
내경(mm)
길이(m)
38
10
50
10
65
10
75
10
100
10
125
10
150
10
200
10
모델명
A(mm)
B(mm)
C(mm)
LS0505
8.8
19.5
21.5
LS0506
10.8
25
24.5
모델명
규격(mm)
D1(mm)
D2(mm)
L1(mm)
L(mm)
d(mm)
중량(g)
6NV-17
17
27.5
38
13
50
14
240
6NV-19
19
30.5
38
14
50
16
255
6NV-22
22
34.5
38
15
52
18
275
6NV-23
23
36
38
15
52
20
275
6NV-24
24
38
38
16
52
20
290
6NV-25
25
40
40
19
55
22
340
6NV-27
27
42
40
19
55
22
360
6NV-28
28
45
40
19
55
22
400
6NV-29
29
45
40
19
55
22
380
6NV-30
30
46
40
20
55
25
380
6NV-32
32
48
42
20
55
25
420
6NV-33
33
50
44
22
55
25
475
6NV-34
34
52.5
44
22
58
25
550
6NV-35
35
52.5
44
22
58
25
500
6NV-36
36
54
46
22
58
30
570
6NV-38
38
57
48
22
58
30
630
6NV-41
41
60
50
22
58
35
770
6NV-46
46
65
50
22
60
35
790
6NV-50
50
70
53
25
60
-
800
6NV-55
55
78
53
25
60
-
1120
모델명
규격(")
D(mm)
d(mm)
L(mm)
중량(g)
NE30-075
3/8
19
10
75
75
NE30-150
3/8
19
12.5
150
145
NE40-075
1/2
25
13
75
140
NE40-100
1/2
25
13
100
160
NE40-150
1/2
25
13
150
215
NE60-150
3/4
37
21
150
535
NE60-250
3/4
37
21
250
1070
NE80-150
1
50
28
150
1060
NE80-250
1
50
30
250
1670
NE80-400
1
50
33
400
2880