Boys Volleyball 2015 Archive

SELECT G.GameID, GameDate, 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, gym_text, Home.short_name as HShort, Away.short_name as AShort, L.short_name, Gyms.gym_name, text_score, CASE WHEN AMorPM = 'PM' and GameTime < 12000 and GameTime not in ('0','1','2','3','4','5') THEN GameTime +120005 WHEN GameTime in ('0','1','2','3','4','5') THEN 235555 ELSE GameTime +5 END as 'NEWTIME', Gyms.add_1, Gyms.cross_st, Gyms.city, Gyms.state, Gyms.zip, G.gym_number, Home.icon as Hicon, Away.icon as Aicon, SH.icon as SHicon, SA.icon as SAicon, CASE WHEN GameDate = 0 THEN '2099-12-29' ELSE GameDate END as NewDate, L.uses_matchups, L.matchup_rules_id, G.watch_link_url, Home.team_video_url , GT.GameType, G.GameTypeID 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 GameTypes GT on G.GameTypeID = GT.GameTypeID LEFT JOIN Gyms on Gyms.gym_id = G.gym_id_fk Where G.LeagueID = 32 and G.is_deleted = 0 and G.GameTypeID in (2,4,5,6,7,8) AND nullif(HomeTeamID,0) is not null AND nullif(AwayTeamID,0) is not null ORDER BY GameTypeSort Desc, NewDate, HomeSchool ASC, NEWTIME ASC, GameTime ASC