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 = 48 or Away.school_id_fk = 48)
AND GameDate > '10/1/2014'
ORDER BY GameDate, NEWTIME ASC, GameTime ASC Thu Nov 4 2021 07:00:00
-
OHR YISROEL
- (2-11-0-0)
@
-
-
SAR
STING
-
(9-5-0-0)
Result
Win: 18-1
Sun Nov 7 2021 01:00:00
-
OHR YISROEL
- (2-12-0-0)
@
-
-
HESCHEL
Heat
-
(3-11-0-0)
Result
Win: 73-54
Thu Nov 11 2021 08:30:00
-
FRISCH
Cougars
- (9-5-0-0)
@
-
-
OHR YISROEL
-
(2-12-0-0)
Result
Loss: 39-63
Sun Nov 14 2021 07:00:00
-
MTA
Lions
- (9-4-0-1)
@
-
-
OHR YISROEL
-
(2-12-0-0)
Result
Loss: 26-41
Sun Nov 21 2021 05:30:00
-
OHR YISROEL
- (2-12-0-0)
@
-
-
RAMBAM
Ravens
-
(0-14-0-0)
Result
Loss: 39-87
Mon Dec 6 2021 07:30:00
-
OHR YISROEL
- (2-11-0-0)
@
-
-
RAMAZ
Rams
-
(8-6-0-0)
Result
Win: 5-4
Thu Dec 16 2021 08:45:00
-
TABC
Storm
- (12-1-0-1)
@
-
-
OHR YISROEL
-
(2-11-0-0)
Result
Loss: 0-11
Sat Dec 18 2021 07:15:00
-
OHR YISROEL
- (2-11-0-0)
@
-
-
FRISCH
Cougars
-
(11-2-0-1)
Result
Win: 11-2
Thu Dec 23 2021 08:30:00
-
OHR YISROEL
- (2-11-0-0)
@
-
-
KUSHNER
Cobras
-
(5-8-0-1)
Result
Win: 7-1
Sun Dec 26 2021 07:00:00
-
TABC
Storm
- (10-3-0-1)
@
-
-
OHR YISROEL
-
(2-12-0-0)
Result
Loss: 57-59
Thu Jan 6 2022 08:30:00
-
WATERBURY
Wolfpack
- (9-5-0-0)
@
-
-
OHR YISROEL
-
(2-12-0-0)
Result
Loss: 42-74
Sun Jan 9 2022 07:00:00
-
SAR
STING
- (9-5-0-0)
@
-
-
OHR YISROEL
-
(2-11-0-0)
Result
Loss: 1-15
Mon Jan 10 2022 08:45:00
-
OHR YISROEL
- (2-12-0-0)
@
-
-
KUSHNER
Cobras
-
(6-7-0-1)
Result
Win: 47-45
Wed Jan 12 2022 08:00:00
-
OHR YISROEL
- (2-12-0-0)
@
-
-
HILLEL
Heat
-
(6-7-0-1)
Result
Win: 72-54
Sat Jan 15 2022 07:30:00
-
KUSHNER
Cobras
- (6-7-0-1)
@
-
-
OHR YISROEL
-
(2-12-0-0)
Result
Loss: 42-70
Sun Jan 16 2022 07:00:00
-
MTA
Lions
- (10-3-0-1)
@
-
-
OHR YISROEL
-
(2-11-0-0)
Result
Loss: 1-7
Mon Jan 17 2022 06:30:00
-
OHR YISROEL
- (2-12-0-0)
@
-
-
SAR
Sting
-
(13-1-0-0)
Result
Win: 72-54
Wed Feb 2 2022 08:00:00
-
OHR YISROEL
- (2-12-0-0)
@
-
-
TABC
Storm
-
(10-3-0-1)
Result
Win: 81-53
Tue Feb 8 2022 08:30:00
-
JEC
Thunder
- (3-11-0-0)
@
-
-
OHR YISROEL
-
(2-12-0-0)
Result
Win: 58-51
Wed Feb 9 2022 07:00:00
-
RAMAZ
Rams
- (8-6-0-0)
@
-
-
OHR YISROEL
-
(2-11-0-0)
Result
Loss: 2-6
Sun Feb 13 2022 01:00:00
-
OHR YISROEL
- (2-12-0-0)
@
-
-
RAMAZ
Rams
-
(12-2-0-0)
Result
Win: 57-38
Mon Feb 14 2022 08:00:00
-
OHR YISROEL
- (2-11-0-0)
@
-
-
MAGEN DAVID
Warriors
-
(8-5-1-0)
Result
Win: 8-3
Mon Feb 14 2022 08:15:00
-
OHR YISROEL
- (2-12-0-0)
@
-
-
JEC
Thunder
-
(3-11-0-0)
Result
Win: 67-63
Tue Feb 15 2022 07:00:00
-
OHR YISROEL
- (2-11-0-0)
@
-
-
JEC
-
(1-12-0-0)
Result
Loss: 2-8
Thu Feb 17 2022 08:00:00
-
OHR YISROEL
- (2-11-0-0)
@
-
-
HAFTR
Hawks
-
(0-14-0-0)
Result
Loss: 3-6
Sat Feb 19 2022 08:15:00
-
OHR YISROEL
- (2-11-0-0)
@
-
-
TABC
Storm
-
(12-1-0-1)
Result
Win: 14-0
Sun Feb 20 2022 04:30:00
-
KUSHNER
Cobras
- (5-8-0-1)
@
-
-
OHR YISROEL
-
(2-11-0-0)
Result
Loss: 2-4
Sun Oct 30 2022 06:00:00
-
OHR YISROEL
- (3-10-0-0)
@
-
-
FRISCH
Cougars
-
(12-2-0-0)
Result
Win: 85-53
Thu Nov 3 2022 06:30:00
-
OHR YISROEL
- (4-6-0-0)
@
-
-
KUSHNER
Cobras
-
(2-8-0-0)
Result
Loss: 0-7
Thu Nov 3 2022 08:45:00
-
OHR YISROEL
- (3-10-0-0)
@
-
-
HANC
Hurricanes
-
(3-10-0-1)
Result
Overtime Loss: 44-55
Sun Nov 6 2022 06:30:00
-
JEC
Thunder
- (8-5-0-1)
@
-
-
OHR YISROEL
-
(3-10-0-0)
Result
Loss: 46-59
Tue Nov 8 2022 07:15:00
-
OHR YISROEL
- (4-6-0-0)
@
-
-
NORTH SHORE
Lions
-
(7-2-0-1)
Result
Win: 6-3
Thu Nov 10 2022 08:00:00
-
OHR YISROEL
- (3-10-0-0)
@
-
-
SAR
Sting
-
(12-2-0-0)
Result
Win: 63-48
Sun Nov 13 2022 04:30:00
-
RAMAZ
Rams
- (6-8-0-0)
@
-
-
OHR YISROEL
-
(3-10-0-0)
Result
Loss: 48-64
Wed Nov 16 2022 07:15:00
-
OHR YISROEL
- (3-10-0-0)
@
-
-
KUSHNER
Cobras
-
(3-11-0-0)
Result
Loss: 40-57
Sun Nov 20 2022 04:30:00
-
HILLEL
Heat
- (10-3-0-1)
@
-
-
OHR YISROEL
-
(3-10-0-0)
Result
Loss: 49-62
Sun Nov 20 2022 06:30:00
-
YDE
Thunder
- (2-8-0-0)
@
-
-
OHR YISROEL
-
(4-6-0-0)
Result
Win: 3-1
Wed Nov 23 2022 06:15:00
-
TABC
Storm
- (10-0-0-0)
@
-
-
OHR YISROEL
-
(4-6-0-0)
Result
Loss: 1-5
Tue Nov 29 2022 07:30:00
-
OHR YISROEL
- (4-6-0-0)
@
-
-
JEC
Thunder
-
(0-10-0-0)
Result
Loss: 2-7
Sun Dec 4 2022 05:00:00
-
MTA
Lions
- (4-10-0-0)
@
-
-
OHR YISROEL
-
(3-10-0-0)
Result
Win: 56-52
Sat Dec 10 2022 08:30:00
-
HAFTR
Hawks
- (8-6-0-0)
@
-
-
OHR YISROEL
-
(3-10-0-0)
Result
Loss: 40-55
Sun Dec 11 2022 06:30:00
-
JEC
Thunder
- (0-10-0-0)
@
-
-
OHR YISROEL
-
(4-6-0-0)
Result
Win: 6-1
Tue Dec 13 2022 07:00:00
-
OHR YISROEL
- (4-6-0-0)
@
-
-
FRISCH
Cougars
-
(5-5-0-0)
Result
Win: 3-1
Wed Dec 14 2022 07:15:00
-
OHR YISROEL
- (3-10-0-0)
@
-
-
TABC
Storm
-
(10-4-0-0)
Result
Win: 71-42
Thu Dec 29 2022 08:30:00
-
FRISCH
Cougars
- (5-5-0-0)
@
-
-
OHR YISROEL
-
(4-6-0-0)
Result
Loss: 1-4
Sun Jan 8 2023 04:30:00
-
KUSHNER
Cobras
- (3-11-0-0)
@
-
-
OHR YISROEL
-
(3-10-0-0)
Result
Loss: 35-49
Sun Jan 8 2023 06:30:00
-
SAR
Sting
- (8-2-0-0)
@
-
-
OHR YISROEL
-
(4-6-0-0)
Result
Loss: 1-5
Tue Jan 31 2023 06:30:00
-
OHR YISROEL
- (4-6-0-0)
@
-
-
MTA
Lions
-
(6-3-1-0)
Result
Win: 8-5
Sun Feb 5 2023 02:00:00
-
OHR YISROEL
- (3-10-0-0)
@
-
-
HILLEL
Heat
-
(10-3-0-1)
Result
Win: 70-47
Tue Feb 7 2023 07:30:00
-
OHR YISROEL
- (3-10-0-0)
@
-
-
JEC
Thunder
-
(8-5-0-1)
Result
Win: 53-25
Mon Oct 23 2023 08:30:00
-
OHR YISROEL
Ohr yisroel
- (4-9-0-0)
@
-
-
RAMBAM
Ravens
-
(7-6-0-1)
Result
Win: 5-2
Thu Oct 26 2023 07:00:00
-
OHR YISROEL
Ohr yisroel
- (4-9-0-0)
@
-
-
SAR
STING
-
(7-7-0-0)
Result
Win: 9-3
Sun Oct 29 2023 06:30:00
-
MTA
Lions
- (2-12-0-0)
@
-
-
OHR YISROEL
Flames
-
(8-6-0-0)
Result
Win: 51-40
Thu Nov 2 2023 08:00:00
-
OHR YISROEL
Flames
- (8-6-0-0)
@
-
-
HESCHEL
Heat
-
(9-5-0-0)
Result
Win: 65-63
Sun Nov 5 2023 06:30:00
-
KUSHNER
Cobras
- (9-5-0-0)
@
-
-
OHR YISROEL
Ohr yisroel
-
(4-9-0-0)
Result
Loss: 2-6
Thu Nov 9 2023 06:00:00
-
OHR YISROEL
Ohr yisroel
- (4-9-0-0)
@
-
-
TABC
Storm
-
(12-2-0-0)
Result
Win: 11-0
Sun Nov 12 2023 04:30:00
-
RAMAZ
Rams
- (10-4-0-0)
@
-
-
OHR YISROEL
Flames
-
(8-6-0-0)
Result
Win: 63-62
Sun Nov 12 2023 06:30:00
-
NORTH SHORE
Lions
- (3-11-0-0)
@
-
-
OHR YISROEL
Ohr yisroel
-
(4-9-0-0)
Result
Win: 5-4
Thu Nov 16 2023 08:00:00
-
OHR YISROEL
Flames
- (8-6-0-0)
@
-
-
SAR
Sting
-
(7-7-0-0)
Result
Win: 45-35
Mon Nov 27 2023 07:15:00
-
OHR YISROEL
Ohr yisroel
- (4-9-0-0)
@
-
-
FRISCH
Cougars
-
(10-4-0-0)
Result
Win: 9-3
Sun Dec 3 2023 04:00:00
-
MTA
Lions
- (7-6-0-1)
@
-
-
OHR YISROEL
Ohr yisroel
-
(4-9-0-0)
Result
Win: 4-3
Sun Dec 3 2023 06:30:00
-
TABC
Storm
- (12-2-0-0)
@
-
-
OHR YISROEL
Flames
-
(8-6-0-0)
Result
Loss: 44-66
Mon Dec 4 2023 07:00:00
-
OHR YISROEL
Flames
- (8-6-0-0)
@
-
-
KUSHNER
Cobras
-
(1-13-0-0)
Result
Loss: 39-58
Sun Dec 10 2023 06:30:00
-
HESCHEL
Heat
- (9-5-0-0)
@
-
-
OHR YISROEL
Flames
-
(8-6-0-0)
Result
Win: 58-47
Sat Dec 16 2023 08:30:00
-
JEC
Thunder
- (7-7-0-0)
@
-
-
OHR YISROEL
Flames
-
(8-6-0-0)
Result
Loss: 46-51
Sun Dec 17 2023 06:30:00
-
KUSHNER
Cobras
- (1-13-0-0)
@
-
-
OHR YISROEL
Flames
-
(8-6-0-0)
Result
Win: 85-49
Wed Dec 20 2023 08:00:00
-
OHR YISROEL
Flames
- (8-6-0-0)
@
-
-
FRISCH
Cougars
-
(10-4-0-0)
Result
Win: 80-67
Sun Dec 24 2023 07:00:00
-
OHR YISROEL
Flames
- (8-6-0-0)
@
-
-
YDE
Thunder
-
(5-9-0-0)
Result
Loss: 45-48
Sun Dec 31 2023 05:15:00
-
WATERBURY
Wolfpack
- (5-9-0-0)
@
-
-
OHR YISROEL
Flames
-
(8-6-0-0)
Result
Win: 66-49
Sun Dec 31 2023 01:00:00
-
OHR YISROEL
Ohr yisroel
- (4-9-0-0)
@
-
-
JEC
Thunder
-
(2-11-0-0)
Result
Loss: 3-8
Tue Jan 2 2024 06:30:00
-
OHR YISROEL
Ohr yisroel
- (4-9-0-0)
@
-
-
MTA
Lions
-
(7-6-0-1)
Result
Win: 4-2
Sun Jan 7 2024 04:30:00
-
TABC
Storm
- (12-2-0-0)
@
-
-
OHR YISROEL
Ohr yisroel
-
(4-9-0-0)
Result
Loss: 0-1
Mon Jan 15 2024 08:00:00
-
OHR YISROEL
Ohr yisroel
- (4-9-0-0)
@
-
-
FRISCH
Cougars
-
(10-4-0-0)
Result
Win: 8-1
Tue Jan 16 2024 07:00:00
-
OHR YISROEL
Flames
- (8-6-0-0)
@
-
-
RAMAZ
Rams
-
(10-4-0-0)
Result
Win: 65-57
Wed Jan 31 2024 07:00:00
-
OHR YISROEL
Ohr yisroel
- (4-9-0-0)
@
-
-
HILLEL
Heat
-
(1-13-0-0)
Result
Win: 6-5
Sun Feb 4 2024 04:30:00
-
HILLEL
Heat
- (1-13-0-0)
@
-
-
OHR YISROEL
Ohr yisroel
-
(4-9-0-0)
Result
Win: 1-0
Tue Feb 6 2024 08:30:00
-
OHR YISROEL
Flames
- (8-6-0-0)
@
-
-
HILLEL
Heat
-
(5-9-0-0)
Result
Loss: 29-69
Wed Feb 14 2024 07:30:00
-
OHR YISROEL
Flames
- (8-6-0-0)
@
-
-
HESCHEL
Heat
-
(9-5-0-0)
Result
Loss: 37-47
Tue Feb 27 2024 08:00:00
-
OHR YISROEL
Flames
- (8-6-0-0)
@
-
-
FLATBUSH
Falcons
-
(12-2-0-0)
Result
Win: 69-47