SELECT COUNT(*), G.gamenum_in_day, G.start_time, G.daygame_flag
, 	WA.temp
,	WA.press_atmos, WA.press_sealvl, WA.press_altim
,	WA.press_chg_3hr_del, WA.press_chg_3hr_obs
,	WA.wind_dir, WA.wind_obs, WA.wind_speed, WA.wind_gust_speed
,	WC.cloud_cover_low, WC.vis_dist, WC.sunshine_time
,	WO.wea_pr_m_obs_1, WO.wea_pr_m_obs_2, WO.wea_pr_m_obs_3
,	WP.groundcond, WP.precip_hist_contin, WP.precip_lq1_depth, WP.precip_lq1_period  
FROM	vizsagedb_rsnew.GameInfo	G,
		vizsagedb_weather.HourlyAir				WA,
		vizsagedb_weather.HourlyCloud			WC,
		vizsagedb_weather.HourlyPrecipitation	WP,
		vizsagedb_weather.HourlyObservation		WO
WHERE	(G.v_siteID = 'BOS07') 		AND (WA.ID_NCDC = 14739)
AND		(DATE(WA.datetime) = G.gamedate)
AND		(	((TIME(WA.datetime) BETWEEN '10:00:00' AND '17:00:00') AND     G.daygame_flag)
		OR	((TIME(WA.datetime) BETWEEN '17:00:00' AND '23:59:59') AND NOT G.daygame_flag) )
AND		(WA.ID_NCDC=WC.ID_NCDC) AND (WA.ID_USAF=WC.ID_USAF) AND (WA.datetime=WC.datetime)
AND		(WA.ID_NCDC=WP.ID_NCDC) AND (WA.ID_USAF=WP.ID_USAF) AND (WA.datetime=WP.datetime)
AND		(WA.ID_NCDC=WO.ID_NCDC) AND (WA.ID_USAF=WO.ID_USAF) AND (WA.datetime=WO.datetime)
GROUP BY	G.game_ID

SELECT COUNT(*) FROM
(SELECT COUNT(*), G.*, DATE(WA.datetime)
	FROM	vizsagedb_rsnew.GameInfo		G 
	LEFT JOIN	vizsagedb_weather.HourlyAir		WA
	ON			(G.gamedate = DATE(WA.datetime)) 
WHERE	(G.v_siteID = 'BOS07') 		
AND 	(YEAR(G.gamedate) = 2001)
AND		(WA.ID_NCDC = 14739)
GROUP BY	G.game_ID) Y
GROUP BY YEAR(Y.gamedate)

SELECT	M.playerID, M.nameFirst, M.nameLast
 ,		COUNT(*) as stints, SUM(B.G) as games
 ,		SUM(B.HR) as hrs, SUM(B.H)/SUM(B.AB) AS avg, SUM(B.H) AS hits, SUM(B.AB) AS abs ,		SUM(P.W), SUM(P.L), SUM(P.W)/SUM(P.L) AS Wpct
 ,		(SUM(P.ER)/SUM(P.IPouts))*9/3 AS era
 ,		SUM(P.SO)/SUM(P.BB) as SO_BB, SUM(P.HR)/(SUM(P.IPouts)/3) as HR_IP
FROM	(
	SELECT		nameFirst, COUNT(nameFirst) AS occ 
	FROM 		vizsagedb_baseballdatabank.`Master` M 
	GROUP BY 	nameFirst  HAVING	occ = 1) F
		JOIN vizsagedb_baseballdatabank.Master   M ON (M.nameFirst = F.nameFirst)		LEFT JOIN vizsagedb_baseballdatabank.Batting  B ON (B.playerID  = M.playerID)
		LEFT JOIN vizsagedb_baseballdatabank.Pitching P ON (M.playerID = P.playerID) AND (B.yearID = P.yearID)
GROUP BY M.playerID
ORDER BY M.nameFirst ASC

Yogi		Berra,
Vida		Blue,
,
Oil Can		Boyd,
Blue Moon	Odom,
Muddy		Ruel,
,
,
Mysterious	Walker,
Firpo		Marberry,
The Only	Nolan,
Zoilo		Versalles,
Phenomenal	Smith,
,
Pi		Schwert,
Ambiorix	Burgos,
Alamazoo	Jennings,
Chicken		Hawks,
Bevo		LeBourveau,
Buttercup	Dickerson,
Urban		Shocker,
Twink		Twining,
Pussy		Tebeau,
Bris		Lord,
Boob		Fowler,
Crazy		Schmit,
Creepy		Crespi,
Cuddles		Marshall,
Vinegar Bend	Mizell,
Welcome		Gaston,


Cool Papa	Bell,
Eppa		Rixey,
Early		Wynn,
Preacher	Roe,

Sixto		Lezcano,
Wheezer		Dell,
Yam		Yaryan,
Yo-Yo		Davalillo,
Admiral		Schlei,
Boss		Schmidt,
Brick		Smith,
Brickyard	Kennedy,
Broadway	Jones,
Cannonball	Titcomb,
Baby Doll	Jacobson,
Sweetbreads	Bailey,
Zaza		Harvey,
Bubbles		Hargrave,
Pickles		Dillhoefer,
Double Joe	Dwyer,
Cowboy		Jones,
Coot		Veal,
Mul		Holland,
Live Oak	Taylor,
Skyrocket	Smith,
Kaiser		Wilhelm,
Kewpie		Pennington,
Possum		Whitted,
Snooks		Dowd,
Mox		McQuery,

Mother		Watson,
,
,
Amalio		Carreno,
Baby		Ortiz,
Taffy		Wright,
,
Topsy		Hartsel,
Bake		McBride,
Tot		Pressnell,
Beauty		McGowan,
Tully		Sparks,
Andruw		Jones,
Binky		Jones,
Bitsy		Mott,
Blaise		Ilsley,
Blondie		Purcell,
Brownie		Foreman,
Buttons		Briggs,
,
,
Astyanax	Douglass,
Mookie		Wilson,
Moonlight	Graham,
Boof		Bonser,
Boog		Powell,
,
,
,
Nanny		Fernandez,
Nippy		Jones,
Peek-A-Boo	Veach,
,
Boileryard	Clarke,
Blix		Donnelly,
Boom-Boom	Beck,
Crash		Davis,
,
Bumpus		Jones,
,
Cuckoo		Christensen,
Daff		Gammons,
Dazzy		Vance,
,
Cupid		Childs,
,
Dory		Dean,
Dot		Fulghum,
Dots		Miller,
,
,
,
Fats		Dantonio,
Fatty		Briody,
,
Faye		Throneberry,
,
Flame		Delhi,
Flea		Clifton,
Fleet		Walker,
Fletcher	Low,
,
Flip		Lafferty,
Foghorn		Bradley,
Footer		Johnson,
Footsie		Blair,
Franquelis	Osoria,
Fritzie		Connally,
Frosty		Thomas,
Fuzz		White,
,
,
Heathcliff	Slocumb,
Hercules	Burnett,
Honus		Wagner,
Icicle		Reeder,
,
Jule		Mallonee,
,
Leonidas	Lee,
Lip		Pike,
Mayo		Smith,
Memo		Luna,
,
Moon		Mullen,
Mose		Solomon,
Mudcat		Grant,
,
Mutz		Ens,
,
,
Narciso		Elvira,
,
,
Nixey		Callahan,
,
Oddibe		McDowell,
,
Onix		Concepcion,
Oral		Hildebrand,
Orator		Shaffer,
Orber		Moreno,
Orel		Hershiser,
,
Ossee		Schreckengost,
Pea Ridge	Day,
Peanuts		Lowrey,
Pee Wee		Reese,
Pee-Wee		Wanninger,
,
Pembroke	Finlayson,
Petie		Behan,
,
Pie		Traynor,
Piggy		Ward,
Pinch		Thomas,
Ping		Bodie,
Pink		Hawley,
Pip		Koehler,
Pit		Gilman,
Podge		Weihe,
Pokey		Reese,
Pol		Perritt,
Pony		Sager,
Pop-Boy		Smith,
Porfi		Altamirano,
Press		Cruthers,
Pretzel		Pezzullo,
Puchy		Delgado,
Pud		Galvin,
Pumpsie		Green,
Punch		Knoll,
Purnal		Goldy,
Putsy		Caballero,
Queenie		O'Rourke,
Quilvio		Veras,
,
Rheal		Cormier,
Rimp		Lanier,
Rivington	Bisland,
Rocco		Baldelli,
Scarborough	Green,
,
,
Skippy		Roberge,
Slats		Jordan,
Sled		Allen,
Sleeper		Sullivan,
Slicker		Parks,
Sloppy		Thurston,
Slow Joe	Doyle,
Snapper		Kennedy,
Snuffy		Stirnweiss,
Soup		Campbell,
Spades		Wood,
Swat		McCabe,
,
,
,
Tip		O'Neill,
Tookie		Gilbert,
,
,
Trace		Coquillette,
Trader		Horne,
Trench		Davis,
Tris		Speaker,
Trot		Nixon,
Tub		Welch,
Tubby		Spencer,
Tucker		Ashford,
Tuffy		Stewart,
,
,
Vada		Pinson,
,
Waddy		Macphee,
Webbo		Clarke,
Wedo		Martini,
,
Whammy		Douglas,
,
Zinn		Beck,
,
,
,
,
,