SELECT G.game_ID, G.gamedate, 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 '23:59:59') 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)