Mike Jackson CHBL Career Statistics
Selected in the 34th round (#668 overall) of the 1970 Inaugural Draft.
SELECT lgyear AS [YR], lgteam AS [TEAM], W, L, SV, Format (ERA, '0.00') AS ERA, CASE WHEN IP = 0 THEN '9.99' ELSE Format(((H+BB)/IP), '0.00') END AS WHIP, Format (IP, '0.0') AS IP, H, R, ER, HR, BB, SO, G, GS, CG, SHO, QS, BF, IBB, HB, WP, BK FROM s_careerpitching WHERE lg_id = 2 AND player_id = 'jacksmi01' ORDER BY lgyear, lastname, firstname ASC
| YR |
TEAM |
W |
L |
SV |
ERA |
WHIP |
IP |
H |
R |
ER |
HR |
BB |
SO |
G |
GS |
CG |
SHO |
QS |
BF |
IBB |
HB |
WP |
BK |
|
1971 |
RIV |
1 |
2 |
0 |
10.46 |
2.48 |
26.2 |
43 |
35 |
31 |
6 |
22 |
9 |
28 |
0 |
0 |
0 |
0 |
140 |
1 |
0 |
0 |
0 |
|
1972 |
RIV |
1 |
4 |
1 |
6.88 |
2.12 |
51.0 |
79 |
50 |
39 |
2 |
29 |
31 |
24 |
2 |
0 |
0 |
1 |
260 |
2 |
0 |
2 |
0 |
|
1973 |
RIV |
1 |
0 |
0 |
4.67 |
1.87 |
17.1 |
22 |
9 |
9 |
2 |
10 |
11 |
12 |
0 |
0 |
0 |
0 |
82 |
0 |
2 |
0 |
0 |
SELECT DISTINCT Count(lgyear) AS [TOT],'Seasons' AS [STATS], Sum(W) AS [W], Sum(L) AS [L], Sum(SV) AS [SV], CASE WHEN Sum(IP) = 0 THEN NULL ELSE Format((Sum(ER)*9)/NULLIF(Sum(IP), 0), '0.00') END AS [ERA], CASE WHEN Sum(IP) = 0 THEN '9.99' ELSE (Format(((Sum(H)+Sum(BB))/Sum(IP)), '0.00')) END AS WHIP, Format(Sum(IP), '0.0') AS [IP], Sum(H) AS [H], Sum(R) AS [R], Sum(ER) AS [ER], Sum(HR) AS [HR], Sum(BB) AS [BB], Sum(SO) AS [SO], Sum(G) AS [G], Sum(GS) AS [GS], Sum(CG) AS [CG], Sum(SHO) AS [SHO], Sum(QS) AS [QS], Sum(BF) AS [BF], Sum(IBB) AS [IBB], Sum(HB) AS [HB], Sum(WP) AS [WP], Sum(BK) AS [BK] FROM s_careerpitching WHERE lg_id = 2 GROUP BY player_id HAVING player_id = 'jacksmi01'
| TOT |
STATS |
W |
L |
SV |
ERA |
WHIP |
IP |
H |
R |
ER |
HR |
BB |
SO |
G |
GS |
CG |
SHO |
QS |
BF |
IBB |
HB |
WP |
BK |
|
3 |
Seasons |
3 |
6 |
1 |
7.54 |
2.17 |
94.3 |
144 |
94 |
79 |
10 |
61 |
51 |
64 |
2 |
0 |
0 |
1 |
482 |
3 |
2 |
2 |
0 |
SELECT lgyear AS [YR], lgteam AS [TEAM], cp.lgsegment AS [SEG], W, L, SV, Format (ERA, '0.00') AS ERA, CASE WHEN IP = 0 THEN '9.99' ELSE (Format(((H+BB)/IP), '0.00')) END AS WHIP, Format (IP, '0.0') AS IP, H, R, ER, HR, BB, SO, G, GS, CG, SHO, QS, BF, IBB, HB, WP, BK FROM s_careerpitchingpo cp INNER JOIN playoffsort ps ON cp.lgsegment = ps.Segment WHERE lg_id = 2 AND player_id = 'jacksmi01' ORDER BY lgyear, lastname, firstname, ps.SortID ASC
| YR |
TEAM |
SEG |
W |
L |
SV |
ERA |
WHIP |
IP |
H |
R |
ER |
HR |
BB |
SO |
G |
GS |
CG |
SHO |
QS |
BF |
IBB |
HB |
WP |
BK |
SELECT DISTINCT Count(lgyear) AS [TOT],'Segments' AS [STATS], Sum(W) AS [W], Sum(L) AS [L], Sum(SV) AS [SV], CASE WHEN Sum(IP) = 0 THEN NULL ELSE Format((Sum(ER)*9)/NULLIF(Sum(IP), 0), '0.00') END AS [ERA], Format(Sum(IP), '0.0') AS [IP], Sum(H) AS [H], Sum(R) AS [R], Sum(ER) AS [ER], Sum(HR) AS [HR], Sum(BB) AS [BB], Sum(SO) AS [SO], Sum(G) AS [G], Sum(GS) AS [GS], Sum(CG) AS [CG], Sum(SHO) AS [SHO], Sum(QS) AS [QS], Sum(BF) AS [BF], Sum(IBB) AS [IBB], Sum(HB) AS [HB], Sum(WP) AS [WP], Sum(BK) AS [BK] FROM s_careerpitchingpo WHERE lg_id = 2 GROUP BY player_id HAVING player_id = 'jacksmi01'
| TOT |
STATS |
W |
L |
SV |
ERA |
IP |
H |
R |
ER |
HR |
BB |
SO |
G |
GS |
CG |
SHO |
QS |
BF |
IBB |
HB |
WP |
BK |
SELECT m.mlb_year AS YEAR, m.age AS AGE, m.mlb_team AS MLB, a.grade AS SG, a.rgrade AS RG, (a.ctrl + a.hrp) AS CTRL, m.w AS W, m.l AS L, m.sv AS SV, Format (m.era, '0.00') AS 'ERA', Format (m.WHIP, '0.00') AS WHIP, m.ip AS IP, m.h AS H, m.hr AS HR, m.bb AS BB, m.SO AS SO, m.bf AS BF, m.era_plus AS 'ERA+', Format(m.fip, '0.00') AS FIP, Format(m.war, '0.0') AS WAR, Format(Cast(COALESCE(m.mlb_salary, dbo.uf_get_min_salary(m.mlb_year)) AS INT), '$#,##0;($#,##0)') AS SALARY FROM mlb_pitchers m LEFT JOIN apba_pitchers a ON m.player_id = a.player_id AND m.mlb_year = a.year WHERE m.player_id = 'jacksmi01' ORDER BY m.mlb_year
| YEAR |
AGE |
MLB |
SG |
RG |
CTRL |
W |
L |
SV |
ERA |
WHIP |
IP |
H |
HR |
BB |
SO |
BF |
ERA+ |
FIP |
WAR |
SALARY |
|
1970 |
24 |
PHI |
|
6 |
YW G |
1 |
1 |
0 |
1.42 |
1.58 |
6.1 |
6 |
0 |
4 |
4 |
25 |
299 |
3.27 |
0.2 |
$12,000 |
|
1971 |
25 |
STL |
|
1 |
W |
0 |
0 |
0 |
0.00 |
3.00 |
0.2 |
1 |
0 |
1 |
0 |
4 |
|
6.95 |
0.1 |
$12,750 |
|
1972 |
26 |
KCR |
2 |
|
WY H |
1 |
2 |
0 |
6.41 |
1.93 |
19.2 |
24 |
0 |
14 |
15 |
92 |
48 |
3.01 |
-0.5 |
$13,500 |
|
1973 |
27 |
TOT |
|
1 |
YW L |
0 |
0 |
0 |
6.65 |
2.00 |
23 |
26 |
3 |
20 |
14 |
109 |
63 |
5.78 |
-0.4 |
$12,600 |
SELECT DISTINCT Count(m.mlb_year) AS TOT, 'Seasons' AS STATS, Sum(m.w) AS W, Sum(m.l) AS L, Sum(m.sv) AS SV, dbo.uf_get_era(Sum(m.ip), Sum(m.er)) AS 'ERA', dbo.uf_get_whip(Sum(m.ip), Sum(m.h), Sum(m.bb)) AS WHIP, Sum(m.ip) AS IP, Sum(m.h) AS H, Sum(m.hr) AS HR, Sum(m.bb) AS BB, Sum(m.SO) AS SO, Sum(m.bf) AS BF, Format(Sum(m.war), '0.0') AS WAR, Format(Sum(Cast(COALESCE(m.mlb_salary, dbo.uf_get_min_salary(m.mlb_year)) AS INT)), '$#,##0;($#,##0)') AS SALARY FROM mlb_pitchers m LEFT JOIN apba_pitchers a ON m.player_id = a.player_id AND m.mlb_year = a.year WHERE m.player_id = 'jacksmi01'
| TOT |
STATS |
W |
L |
SV |
ERA |
WHIP |
IP |
H |
HR |
BB |
SO |
BF |
WAR |
SALARY |
|
4 |
Seasons |
2 |
3 |
0 |
5.94 |
1.98 |
48.5 |
57 |
3 |
39 |
33 |
230 |
-0.6 |
$50,850 |