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)
중량(g)
SCR-L200
200
314
SCR-L300
300
380
SCR-L600
600
558
모델명
규격(mm)
날장(mm)
유효길이(mm)
전장(mm)
샹크(d)
1.5
18
26
43
D
2
19
31
49
D
2.5
20
38
57
D
3
15
42
61
D
3.5
18
46
70
D
4
19
51
75
4
4.5
21
55
80
4.5
5
23
60
86
5
5.5
26
66
93
5.5
6
26
73
93
6
7
31
80
109
7
8
33
86
117
8
9
36
91
125
9
10
38
99
133
10
12
44
106
141
12
13
44
106
141
12
14
47
110
160
12
15
50
112
162
12
모델명
규격(mm)
전장(mm)
83SB-3
3
44
83SB-4
4
46
83SB-5
5
49
83SB-6
6
51
83SB-8
8
56
83SB-10
10
59
모델명
배율
조명
BD-L10L
10배
LED
BD-L10LU
10배
LED/UV
BD-L15L
15배
LED
BD-L20L
20배
LED
모델명
규격(mm)
샹크(Ø)
날모양
C1319100
10
6
1날
C1309100
10
6
홀형
C1339100
10
6
3날
C1319150
15
8
1날
C1309150
15
8
홀형
C1339150
15
10
3날
C1319200
20
10
1날
C1309200
20
10
홀형
C1339200
20
10
3날
C1319250
25
12
1날
C1309250
25
12
홀형
C1339250
25
10
3날
C1319300
30
12
1날
C1309300
30
12
홀형
C1339300
30
12
3날
C1319350
35
16
1날
C1309350
35
16
홀형
C1339350
35
16
3날
C1319400
40
16
1날
C1309400
40
16
홀형
C1339400
40
16
3날
C1319450
45
16
1날
C1309450
45
16
홀형
C1339450
45
16
3날
C1319500
50
16
1날
C1309500
50
16
홀형
모델명
규격
구성(mm)
21TB-S4
1/2"×4P
5, 6, 8, 10
21TB-S7
1/2"×7P
5, 6, 8, 10, 12, 14, 17