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 = 52 or Away.school_id_fk = 52)
AND GameDate > '10/1/2014'
ORDER BY GameDate, NEWTIME ASC, GameTime ASC Tue Oct 31 2023 08:30:00
-
HAFTR
Hawks
- (7-3-0-0)
@
-
-
BARKAI
Suns
-
(2-8-0-0)
Result
Loss: 38-59
Mon Nov 6 2023 08:00:00
-
BARKAI
Suns
- (2-8-0-0)
@
-
-
NORTH SHORE
Lions
-
(7-3-0-0)
Result
Win: 88-46
Tue Nov 7 2023 08:45:00
-
MAGEN DAVID
Warriors
- (4-4-0-0)
@
-
-
BARKAI
Barkai Suns
-
(0-8-0-0)
Result
Loss: 16-54
Thu Nov 16 2023 07:30:00
-
BARKAI
Barkai Suns
- (0-8-0-0)
@
-
-
BRURIAH
Lightning
-
(6-2-0-0)
Result
Win: 50-19
Thu Nov 16 2023 07:30:00
-
BARKAI
Suns
- (2-8-0-0)
@
-
-
RAMBAM
Ravens
-
(3-7-0-0)
Result
Win: 63-49
Sun Nov 19 2023 03:30:00
-
BARKAI
Suns
- (2-8-0-0)
@
-
-
MAGEN DAVID
Warriors
-
(6-4-0-0)
Result
Win: 77-47
Sun Nov 19 2023 12:00:00
-
BARKAI
Barkai Suns
- (0-8-0-0)
@
-
-
MAGEN DAVID
Warriors
-
(4-4-0-0)
Result
Win: 49-13
Tue Nov 21 2023 08:45:00
-
HANC
Hurricanes
- (3-7-0-0)
@
-
-
BARKAI
Suns
-
(2-8-0-0)
Result
Loss: 31-64
Mon Nov 27 2023 07:15:00
-
BARKAI
Suns
- (2-8-0-0)
@
-
-
YDE
Thunder
-
(5-5-0-0)
Result
Win: 69-44
Thu Nov 30 2023 07:45:00
-
BARKAI
Barkai Suns
- (0-8-0-0)
@
-
-
NAALEH
Eagles
-
(3-5-0-0)
Result
Win: 39-3
Sun Dec 3 2023 01:00:00
-
BARKAI
Barkai Suns
- (0-8-0-0)
@
-
-
SKA
Sonics
-
(7-1-0-0)
Result
Win: 43-15
Tue Dec 5 2023 08:30:00
-
FLATBUSH
Falcons
- (7-3-0-0)
@
-
-
BARKAI
Suns
-
(2-8-0-0)
Result
Loss: 29-73
Wed Dec 6 2023 07:30:00
-
BARKAI
Suns
- (2-8-0-0)
@
-
-
WESTCHESTER
Wildcats
-
(0-10-0-0)
Result
Loss: 37-57
Tue Dec 19 2023 08:45:00
-
SKA
Sonics
- (7-1-0-0)
@
-
-
BARKAI
Barkai Suns
-
(0-8-0-0)
Result
Loss: 26-54
Tue Dec 26 2023 08:45:00
-
BRURIAH
Lightning
- (6-2-0-0)
@
-
-
BARKAI
Barkai Suns
-
(0-8-0-0)
Result
Loss: 15-40
Tue Jan 2 2024 08:45:00
-
DRS
Wildcats
- (10-0-0-0)
@
-
-
BARKAI
Suns
-
(2-8-0-0)
Result
Loss: 41-76
Wed Jan 3 2024 08:45:00
-
NAALEH
Eagles
- (3-5-0-0)
@
-
-
BARKAI
Barkai Suns
-
(0-8-0-0)
Result
Loss: 19-35
Tue Jan 30 2024 08:30:00
-
WESTCHESTER
Wildcats
- (0-10-0-0)
@
-
-
BARKAI
Suns
-
(2-8-0-0)
Result
Win: 55-35