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 = 51 or Away.school_id_fk = 51)
AND GameDate > '10/1/2014'
ORDER BY GameDate, NEWTIME ASC, GameTime ASC Fri Apr 21 2023 12:45:00
-
DRS
Wildcats
- (1-7-0-0)
@
-
-
NETZACH HATORAH
Knights
-
(6-1-0-1)
Result
Win: 12-5
Fri Apr 28 2023 12:45:00 22:00:00
-
MAY
Eagles
- (6-2-0-0)
@
-
-
NETZACH HATORAH
Knights
-
(6-1-0-1)
Result
Overtime Loss: 3-4
Fri Apr 28 2023 01:00:00 22:00:00
-
NETZACH HATORAH
Knights
- (6-1-0-1)
@
-
-
MAY
Eagles
-
(6-2-0-0)
Result
Win: 7-2
Fri May 5 2023 02:00:00 22:00:00
-
HAFTR
Hawks
- (5-3-0-0)
@
-
-
NETZACH HATORAH
Knights
-
(6-1-0-1)
Result
Win: 9-8
Fri May 5 2023 02:00:00 22:00:00
-
NETZACH HATORAH
Knights
- (6-1-0-1)
@
-
-
HAFTR
Hawks
-
(5-3-0-0)
Result
Loss: 4-14
Fri May 12 2023 02:00:00 22:00:00
-
RAMBAM
Ravens
- (0-8-0-0)
@
-
-
NETZACH HATORAH
Knights
-
(6-1-0-1)
Result
Win: 11-1
Fri May 12 2023 01:00:00 22:00:00
-
NETZACH HATORAH
Knights
- (6-1-0-1)
@
-
-
RAMBAM
Ravens
-
(0-8-0-0)
Result
Loss: 1-11
Fri May 19 2023 12:45:00 22:00:00
-
NETZACH HATORAH
Knights
- (6-1-0-1)
@
-
-
DARCHEI
Stingrays
-
(6-2-0-0)
Result
Loss: 3-6
Fri Jun 2 2023 01:00:00 22:00:00
-
DARCHEI
Stingrays
- (6-2-0-0)
@
-
-
NETZACH HATORAH
Knights
-
(6-1-0-1)
Result
Win: 1-0
Mon Jun 12 2023 06:00:00 22:00:00
-
NETZACH HATORAH
Knights
- (6-1-0-1)
@
-
-
HILLEL
Heat
-
(8-0-0-0)
Result
Loss: 0-2
Sun Jun 18 2023 01:00:00 22:00:00
-
NETZACH HATORAH
Knights
- (6-1-0-1)
@
-
-
MAY
Eagles
-
(6-2-0-0)
Result
Loss: 0-5
Fri Apr 5 2024 02:00:00 22:00:00
-
NETZACH HATORAH
Knights
- (3-1-0-0)
@
-
-
RAMBAM
Ravens
-
(0-5-0-0)
Result
Loss: 0-10
Fri Apr 5 2024 03:30:00 22:00:00
-
NETZACH HATORAH
Knights
- (3-1-0-0)
@
-
-
RAMBAM
Ravens
-
(0-5-0-0)
Result
Loss: 1-8
Fri Apr 5 2024 12:30:00 22:00:00
-
NETZACH HATORAH
Knights
- (4-1-0-0)
@
-
-
RAMBAM
Ravens
-
(0-5-0-0)
Result
Loss: 3-28
Sun Apr 7 2024 01:30:00 22:00:00
-
NETZACH HATORAH
Knights
- (4-1-0-0)
@
-
-
HAFTR
Hawks
-
(2-4-0-0)
Result
Loss: 1-8
Fri Apr 12 2024 01:30:00 22:00:00
-
NETZACH HATORAH
Knights
- (3-1-0-0)
@
-
-
DARCHEI
Bulldogs
-
(3-3-0-0)
Result
Win: 1-0
Fri Apr 12 2024 01:30:00 22:00:00
-
NETZACH HATORAH
Knights
- (3-1-0-0)
@
-
-
DARCHEI
Bulldogs
-
(3-3-0-0)
Result
Loss: 1-5
Tue Apr 16 2024 08:30:00 22:00:00
-
HANC
Hurricanes
- (3-4-0-0)
@
-
-
NETZACH HATORAH
Knights
-
(4-1-0-0)
Result
Win: 11-1
Fri May 3 2024 08:30:00 22:00:00
-
NETZACH HATORAH
Knights
- (4-1-0-0)
@
-
-
DARCHEI
Bulldogs
-
(5-1-0-0)
Result
Loss: 1-2
Fri May 3 2024 12:30:00 22:00:00
-
NETZACH HATORAH
Knights
- (4-1-0-0)
@
-
-
DARCHEI
Bulldogs
-
(5-1-0-0)
Result
Win: 3-2
Fri May 10 2024 01:45:00 22:00:00
-
NETZACH HATORAH
Knights
- (4-1-0-0)
@
-
-
DRS
Wildcats
-
(0-3-0-1)
01:45
- Grant Park Field 3
- Hewlett , NY 11557
-
Map it!
Fri May 10 2024 01:45:00 22:00:00
-
NETZACH HATORAH
Knights
- (4-1-0-0)
@
-
-
DRS
Wildcats
-
(0-3-0-1)
DH Game 2
- Grant Park Field 3
- Hewlett , NY 11557
-
Map it!
Fri May 10 2024 12:45:00 22:00:00
-
NETZACH HATORAH
Knights
- (3-1-0-0)
@
-
-
DRS
Wildcats
-
(2-5-0-0)
12:45
- Grant Park
- Woodmere,, N.Y. 11598
-
Map it!
Tue May 14 2024 08:00:00 22:00:00
-
NETZACH HATORAH
Knights
- (3-1-0-0)
@
-
-
HAFTR
Hawks
-
(2-2-0-0)
08:00
- O'Donahue Park
- HAFTR MS 44 Frost Lane
- Far Rockaway/Lawrence, New York 11691
-
Map it!
Fri May 17 2024 08:00:00 22:00:00
-
NETZACH HATORAH
Knights
- (3-1-0-0)
@
-
-
MAY
Eagles
-
(6-0-0-0)
DH Game 2
- 1625 Broadway Avenue
- hewlett , ny 11557
-
Map it!
Fri May 17 2024 01:30:00 22:00:00
-
NETZACH HATORAH
Knights
- (3-1-0-0)
@
-
-
MAY
Eagles
-
(6-0-0-0)
01:30
- 1625 Broadway Avenue
- hewlett , ny 11557
-
Map it!
Fri May 17 2024 01:00:00 22:00:00
-
NETZACH HATORAH
Knights
- (4-1-0-0)
@
-
-
MAY
Eagles
-
(5-0-0-0)
01:00
- Grant Park
- 1625 Broadway Field 1
- Hewlett , NY 11557
-
Map it!