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 = 44 or Away.school_id_fk = 44) AND GameDate > '10/1/2014' ORDER BY GameDate, NEWTIME ASC, GameTime ASC Thu Nov 7 2019 06:30:00
  • MILL BASIN HS
    Mavericks 
  • (2-8-0-0)
@

  • YDE Girls
    Thunder 
  • (0-10-0-0)
Result
Loss: 25-27
Tue Nov 12 2019 07:30:00
  • SKA
    Sonics 
  • (5-5-0-0)
@

  • YDE Girls
    Thunder 
  • (0-10-0-0)
Result
Loss: 22-39
Thu Nov 21 2019 07:45:00
  • YDE Girls
    Thunder 
  • (0-10-0-0)
@

  • NAALEH
    Eagles 
  • (9-1-0-0)
Result
Win: 39-17
Tue Nov 26 2019 07:30:00
  • YDE Girls
    Thunder 
  • (0-10-0-0)
@

  • ILAN
    Invaders 
  • (6-4-0-0)
Result
Win: 28-9
Thu Dec 5 2019 07:30:00
  • YDE Girls
    Thunder 
  • (0-10-0-0)
@

  • SKA
    Sonics 
  • (5-5-0-0)
Result
Win: 38-24
Mon Dec 16 2019 07:30:00
  • NAALEH
    Eagles 
  • (9-1-0-0)
@

  • YDE Girls
    Thunder 
  • (0-10-0-0)
Result
Loss: 15-39
Tue Dec 17 2019 08:15:00
  • BRURIAH
    Lightning 
  • (8-2-0-0)
@

  • YDE Girls
    Thunder 
  • (0-10-0-0)
Result
Loss: 7-51
Thu Dec 26 2019 06:45:00
  • ILAN
    Invaders 
  • (6-4-0-0)
@

  • YDE Girls
    Thunder 
  • (0-10-0-0)
Result
Loss: 15-35
Sun Jan 5 2020 03:30:00
  • YDE Girls
    Thunder 
  • (0-10-0-0)
@

  • BRURIAH
    Lightning 
  • (8-2-0-0)
Result
Win: 56-18
Sun Feb 2 2020 01:15:00
  • YDE Girls
    Thunder 
  • (0-10-0-0)
@

  • MILL BASIN HS
    Mavericks 
  • (2-8-0-0)
Result
Win: 28-26
Thu Nov 17 2022 07:30:00
  • YDE Girls
    Thunder 
  • (0-12-0-0)
@

  • SHULAMITH-LI
    Sharks 
  • (6-6-0-0)
Result
Win: 50-15
Mon Nov 21 2022 08:30:00
  • YDE Girls
    Thunder 
  • (0-12-0-0)
@

  • BRURIAH
    Lightning 
  • (8-4-0-0)
Result
Win: 41-17
Tue Nov 22 2022 07:15:00
  • YDE Girls
    Thunder 
  • (0-12-0-0)
@

  • NAALEH
    Eagles 
  • (8-4-0-0)
Result
Win: 40-22
Mon Dec 5 2022 07:30:00
  • YDE Girls
    Thunder 
  • (0-12-0-0)
@

  • SKA
    Sonics 
  • (7-5-0-0)
Result
Win: 47-24
Mon Dec 12 2022 07:30:00
  • MAGEN DAVID
    Warriors 
  • (2-10-0-0)
@

  • YDE Girls
    Thunder 
  • (0-12-0-0)
Result
Loss: 24-53
Thu Dec 15 2022 08:15:00
  • BRURIAH
    Lightning 
  • (8-4-0-0)
@

  • YDE Girls
    Thunder 
  • (0-12-0-0)
Result
Loss: 22-46
Tue Dec 20 2022 07:00:00
  • ILAN
    Invaders 
  • (11-1-0-0)
@

  • YDE Girls
    Thunder 
  • (0-12-0-0)
Result
Loss: 32-47
Tue Dec 27 2022 07:00:00
  • YDE Girls
    Thunder 
  • (0-12-0-0)
@

  • ILAN
    Invaders 
  • (11-1-0-0)
Result
Win: 48-16
Sun Jan 1 2023 01:00:00
  • NAALEH
    Eagles 
  • (8-4-0-0)
@

  • YDE Girls
    Thunder 
  • (0-12-0-0)
Result
Loss: 24-33
Thu Jan 5 2023 07:30:00
  • SHULAMITH-LI
    Sharks 
  • (6-6-0-0)
@

  • YDE Girls
    Thunder 
  • (0-12-0-0)
Result
Loss: 15-34
Sun Jan 8 2023 11:30:00
  • YDE Girls
    Thunder 
  • (0-12-0-0)
@

  • MAGEN DAVID
    Warriors 
  • (2-10-0-0)
Result
Win: 30-23
Thu Feb 2 2023 08:00:00
  • SKA
    Sonics 
  • (7-5-0-0)
@

  • YDE Girls
    Thunder 
  • (0-12-0-0)
Result
Loss: 19-43
Thu Oct 26 2023 07:30:00
  • YDE Girls
    Thunder 
  • (0-11-0-1)
@

  • NAALEH
    Eagles 
  • (6-6-0-0)
Result
Win: 35-13
Mon Oct 30 2023 07:30:00
  • ILAN
    Invaders 
  • (12-0-0-0)
@

  • YDE Girls
    Thunder 
  • (0-11-0-1)
Result
Loss: 10-34
Mon Nov 6 2023 07:30:00
  • YDE Girls
    Thunder 
  • (0-11-0-1)
@

  • BRURIAH
    Lightning 
  • (3-9-0-0)
Result
Win: 32-19
Wed Nov 8 2023 07:30:00
  • MAGEN DAVID
    Warriors 
  • (6-6-0-0)
@

  • YDE Girls
    Thunder 
  • (0-11-0-1)
Result
Loss: 36-44
Wed Nov 15 2023 07:30:00
  • YDE Girls
    Thunder 
  • (0-11-0-1)
@

  • ILAN
    Invaders 
  • (12-0-0-0)
Result
Win: 42-16
Thu Nov 30 2023 07:30:00
  • NAALEH
    Eagles 
  • (6-6-0-0)
@

  • YDE Girls
    Thunder 
  • (0-11-0-1)
Result
Loss: 18-33
Mon Dec 4 2023 07:30:00
  • SHULAMITH-LI
    Sharks 
  • (7-5-0-0)
@

  • YDE Girls
    Thunder 
  • (0-11-0-1)
Result
Loss: 24-41
Wed Dec 6 2023 07:30:00
  • BRURIAH
    Lightning 
  • (3-9-0-0)
@

  • YDE Girls
    Thunder 
  • (0-11-0-1)
Result
Overtime Loss: 46-56
Wed Dec 20 2023 08:15:00
  • YDE Girls
    Thunder 
  • (0-11-0-1)
@

  • SKA
    Sonics 
  • (8-4-0-0)
Result
Win: 55-35
Sun Dec 24 2023 12:00:00
  • YDE Girls
    Thunder 
  • (0-11-0-1)
@

  • MAGEN DAVID
    Warriors 
  • (6-6-0-0)
Result
Win: 58-26
Wed Jan 31 2024 08:15:00
  • SKA
    Sonics 
  • (8-4-0-0)
@

  • YDE Girls
    Thunder 
  • (0-11-0-1)
Result
Loss: 34-68
Thu Feb 8 2024 07:45:00
  • YDE Girls
    Thunder 
  • (0-11-0-1)
@

  • SHULAMITH-LI
    Sharks 
  • (7-5-0-0)
Result
Win: 39-11

Click on game to see more info