SELECT G.GameID, GameDate, G.GameTime , G.HomeTeamID, G.AwayTeamID, Home.TeamName as Home, Away.TeamName as Away, Complete, G.HomeTeamResult, G.AwayTeamResult, G.HomeTeamScore, G.AwayTeamScore, Description, G.AMorPM, SH.school_name as HomeSchool , SA.school_name as AwaySchool, Home.short_name as HShort, Away.short_name as AShort, L.short_name, CASE WHEN AMorPM = 'PM' and GameTime < 12000 THEN GameTime +120005 ELSE GameTime +5 END as 'NEWTIME', L.LeagueName, sport_name, Away.school_id_fk as AwaySchools, Home.school_id_fk as HomeSchools , Home.logo as homelogo, Away.logo as awaylogo, S.sport_icon, RTA.ResultName as AwayResult, RTH.ResultName as HomeResult, Home.* From Games G Left Join Teams Home on Home.TeamID = HomeTeamID Left Join Teams Away on Away.TeamID = AwayTeamID Left Join Schools SH on SH.school_id = Home.school_id_fk Left Join Schools SA on SA.school_id = Away.school_id_fk LEFT JOIN Leagues L on L.LeagueID = G.LeagueID Left Join Sports S on S.sport_id = L.sport_id_fk LEFT JOIN ResultTypes RTH on HomeTeamResult = RTH.ResultTypeID LEFT JOIN ResultTypes RTA on AwayTeamResult = RTA.ResultTypeID Where G.is_deleted = 0 AND (Home.school_id_fk = 26 or Away.school_id_fk = 26) AND GameDate > '10/1/2014' ORDER BY GameDate, NEWTIME ASC, GameTime ASC Tue Oct 22 2013 07:00:00
Wed Oct 30 2013 07:00:00
Mon Nov 4 2013 07:00:00
Thu Nov 7 2013 06:30:00
Tue Nov 12 2013 07:00:00
Tue Nov 12 2013 07:00:00 22:00:00
Thu Nov 14 2013 07:30:00 22:00:00
Mon Nov 18 2013 06:30:00 22:00:00
Thu Nov 21 2013 07:15:00 22:00:00
Mon Nov 25 2013 07:30:00 22:00:00
Tue Nov 26 2013 07:30:00 22:00:00
Tue Nov 26 2013 07:30:00 22:00:00
Mon Dec 9 2013 07:00:00 22:00:00
Mon Dec 9 2013 07:00:00 22:00:00
Mon Dec 16 2013 06:30:00 22:00:00
Wed Dec 18 2013 07:30:00 22:00:00
Mon Dec 23 2013 07:30:00 22:00:00
Thu Dec 26 2013 06:30:00 22:00:00
Thu Jan 30 2014 07:30:00 22:00:00
Thu Jan 30 2014 07:30:00 22:00:00
Wed Feb 5 2014 06:30:00 22:00:00
Thu Mar 20 2014 07:30:00 22:00:00
Wed Nov 5 2014 07:00:00 22:00:00
Wed Nov 5 2014 07:30:00 22:00:00
Wed Nov 12 2014 07:00:00 22:00:00
Wed Nov 12 2014 07:00:00 22:00:00
Wed Nov 12 2014 07:00:00 22:00:00
Sat Nov 15 2014 08:30:00 22:00:00
Tue Nov 18 2014 06:30:00 22:00:00
Tue Nov 18 2014 07:00:00 22:00:00
Tue Nov 25 2014 07:30:00 22:00:00
Mon Dec 1 2014 07:00:00 22:00:00
Tue Dec 2 2014 07:00:00 22:00:00
Thu Dec 4 2014 08:00:00 22:00:00
Mon Dec 8 2014 07:30:00 22:00:00
Tue Dec 9 2014 07:00:00 22:00:00
Wed Dec 10 2014 07:00:00 22:00:00
Sun Dec 14 2014 11:00:00 22:00:00
Wed Dec 17 2014 06:30:00 22:00:00
Tue Jan 6 2015 07:00:00 22:00:00
Thu Jan 29 2015 07:30:00 22:00:00
Tue Feb 3 2015 06:00:00 22:00:00
Thu Feb 12 2015 07:00:00 22:00:00
Thu Feb 12 2015 07:00:00 22:00:00
Thu Mar 12 2015 08:00:00 22:00:00
Mon Nov 9 2015 08:00:00 22:00:00
Mon Nov 9 2015 08:00:00 22:00:00
Tue Nov 10 2015 08:00:00 22:00:00
Tue Nov 10 2015 07:00:00 22:00:00
Thu Nov 12 2015 07:00:00 22:00:00
Mon Nov 16 2015 07:30:00 22:00:00
Tue Nov 17 2015 07:30:00 22:00:00
Thu Nov 19 2015 07:00:00 22:00:00
Sun Nov 22 2015 05:00:00 22:00:00
Tue Nov 24 2015 06:45:00 22:00:00
Tue Dec 1 2015 07:00:00 22:00:00
Thu Dec 3 2015 07:00:00 22:00:00
Tue Dec 15 2015 07:15:00 22:00:00
Thu Dec 17 2015 07:00:00 22:00:00
Sat Dec 19 2015 07:30:00 22:00:00
Mon Dec 21 2015 07:30:00 22:00:00
Tue Jan 5 2016 07:15:00 22:00:00
Thu Feb 4 2016 07:30:00 22:00:00
Thu Feb 4 2016 07:30:00 22:00:00
Tue Feb 9 2016 07:30:00 22:00:00
Tue Feb 16 2016 07:00:00 22:00:00
Thu Feb 18 2016 06:30:00 22:00:00
Tue Mar 8 2016 07:30:00 22:00:00
Thu Nov 17 2016 07:30:00 22:00:00
Wed Nov 23 2016 07:30:00 22:00:00
Tue Nov 29 2016 08:00:00 22:00:00
Tue Dec 6 2016 06:30:00 22:00:00
Thu Dec 8 2016 06:30:00 22:00:00
Thu Dec 8 2016 07:00:00 22:00:00
Thu Dec 15 2016 07:00:00 22:00:00
Thu Dec 15 2016 06:30:00 22:00:00
Thu Feb 2 2017 07:30:00 22:00:00
Tue Feb 7 2017 06:30:00 22:00:00
Mon Mar 6 2017 07:45:00 22:00:00
Wed Oct 25 2017 07:30:00 22:00:00
Mon Oct 30 2017 07:30:00 22:00:00
Mon Nov 6 2017 06:45:00 22:00:00
Mon Nov 13 2017 07:00:00 22:00:00
Thu Dec 7 2017 07:30:00 22:00:00
Mon Dec 11 2017 07:30:00 22:00:00
Mon Dec 11 2017 06:45:00 22:00:00
Tue Dec 26 2017 06:45:00 22:00:00
Tue Dec 26 2017 07:30:00 22:00:00
Thu Feb 1 2018 07:30:00 22:00:00
Tue Feb 20 2018 07:30:00 22:00:00
Mon Oct 22 2018 07:30:00 22:00:00
Mon Oct 29 2018 07:30:00 22:00:00
Mon Nov 5 2018 07:15:00 22:00:00
Thu Nov 8 2018 08:00:00 22:00:00
Wed Nov 14 2018 07:30:00 22:00:00
Tue Nov 20 2018 07:30:00 22:00:00
Mon Nov 26 2018 07:15:00 22:00:00
Thu Nov 29 2018 08:00:00 22:00:00
Wed Dec 12 2018 07:30:00 22:00:00
Mon Dec 17 2018 07:30:00 22:00:00
Thu Nov 14 2019 08:00:00 22:00:00
Tue Nov 19 2019 07:30:00 22:00:00
Mon Nov 25 2019 08:00:00 22:00:00
Wed Nov 27 2019 07:00:00 22:00:00
Wed Nov 27 2019 07:00:00 22:00:00
Mon Dec 9 2019 07:30:00 22:00:00
Wed Dec 11 2019 07:30:00 22:00:00
Mon Dec 16 2019 08:00:00 22:00:00
Thu Dec 19 2019 06:45:00 22:00:00
Thu Dec 19 2019 08:15:00 22:00:00
Wed Dec 15 2021 07:00:00 22:00:00
Mon Dec 20 2021 07:00:00 22:00:00
Thu Jan 6 2022 07:15:00 22:00:00
Tue Jan 11 2022 07:00:00 22:00:00
Mon Jan 17 2022 07:00:00 22:00:00
Thu Feb 3 2022 06:30:00 22:00:00
Mon Feb 7 2022 06:30:00 22:00:00
Wed Feb 9 2022 05:30:00 22:00:00
TBA TBA 22:00:00