SQL/DB Error -- [You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'order by gender DESC, team_season.name' at line 1 . SELECT *, team_season.id as team_season_id, team_season.name as team_season_name FROM teams INNER JOIN team_season ON team_season.team_id = teams.team_id WHERE team_season.reg_event_id= order by gender DESC, team_season.name]
SQL/DB Error -- [You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND do_not_include_in_record in (0,2)) games ON teams.team_id = games.home_id ' at line 44 . SELECT team_id, team_season_id, team_name_long,division_id,division_section_id,league_id, SUM(league_wins) as league_wins, SUM(league_losses) as league_losses, SUM(league_ties) as league_ties, SUM(league_goals_for) as league_goals_for, SUM(league_goals_against) as league_goals_against, 2 * SUM(league_wins) + SUM(league_ties) as league_points, SUM(overall_wins) as overall_wins, SUM(overall_losses) as overall_losses, SUM(overall_ties) as overall_ties, SUM(overall_goals_for) as overall_goals_for, SUM(overall_goals_against) as overall_goals_against, 2 * SUM(overall_wins) + SUM(overall_ties) as overall_points, ROUND(IFNULL( (2 * SUM(overall_wins) + SUM(overall_ties) ) / (2 * SUM(overall_wins) + 2 * SUM(overall_losses) + 2 * SUM(overall_ties)),'0.00'),3) as win_pct FROM ( SELECT teams.team_id, team_season.id as team_season_id, team_season.league_season_id, team_season.name as team_name_long,division_id,division_section_id,teams.league_id, if( result_home_score > result_visit_score AND ( ( (select league_season_id from team_season where id = home_season_id) = (select league_season_id from team_season where id = visit_season_id) AND do_not_include_in_league_record = 0 ) OR include_in_league_record = 1), 1, 0 ) as league_wins, if( result_home_score < result_visit_score AND ( ( (select league_season_id from team_season where id = home_season_id) = (select league_season_id from team_season where id = visit_season_id) AND do_not_include_in_league_record = 0 ) OR include_in_league_record = 1), 1, 0 ) as league_losses, if( result_home_score = result_visit_score AND ( ( (select league_season_id from team_season where id = home_season_id) = (select league_season_id from team_season where id = visit_season_id) AND do_not_include_in_league_record = 0 ) OR include_in_league_record = 1), 1, 0 ) as league_ties, if( ( (select league_season_id from team_season where id = home_season_id) = (select league_season_id from team_season where id = visit_season_id) AND do_not_include_in_league_record = 0 ) OR include_in_league_record = 1, result_home_score, 0 ) as league_goals_for, if( ( (select league_season_id from team_season where id = home_season_id) = (select league_season_id from team_season where id = visit_season_id) AND do_not_include_in_league_record = 0 ) OR include_in_league_record = 1, result_visit_score, 0 ) as league_goals_against, if( result_home_score > result_visit_score, 1, 0 ) as overall_wins, if( result_home_score < result_visit_score, 1, 0 ) as overall_losses, if( result_home_score = result_visit_score, 1, 0 ) as overall_ties, IFNULL(result_home_score, 0) as overall_goals_for, IFNULL(result_visit_score, 0) as overall_goals_against FROM teams INNER JOIN team_season ON team_season.team_id = teams.team_id LEFT JOIN (select * from event_mgr where status = 1 and end_time < UNIX_TIMESTAMP(now()) AND season_id = AND do_not_include_in_record in (0,2)) games ON teams.team_id = games.home_id WHERE team_season.reg_event_id = UNION ALL SELECT teams.team_id, team_season.id as team_season_id, team_season.league_season_id, team_season.name as team_name_long,division_id,division_section_id,teams.league_id, if( result_visit_score > result_home_score AND ( ( (select league_season_id from team_season where id = visit_season_id) = (select league_season_id from team_season where id = home_season_id) AND do_not_include_in_league_record = 0) OR include_in_league_record = 1), 1, 0 ) as league_wins, if( result_visit_score < result_home_score AND ( ( (select league_season_id from team_season where id = visit_season_id) = (select league_season_id from team_season where id = home_season_id) AND do_not_include_in_league_record = 0) OR include_in_league_record = 1), 1, 0 ) as league_losses, if( result_visit_score = result_home_score AND ( ( (select league_season_id from team_season where id = visit_season_id) = (select league_season_id from team_season where id = home_season_id) AND do_not_include_in_league_record = 0) OR include_in_league_record = 1), 1, 0 ) as league_ties, if( ( (select league_season_id from team_season where id = home_season_id) = (select league_season_id from team_season where id = visit_season_id) AND do_not_include_in_league_record = 0) OR include_in_league_record = 1, result_visit_score, 0 ) as league_goals_for, if( ( (select league_season_id from team_season where id = home_season_id) = (select league_season_id from team_season where id = visit_season_id) AND do_not_include_in_league_record = 0) OR include_in_league_record = 1, result_home_score, 0 ) as league_goals_against, if( result_visit_score > result_home_score, 1, 0 ) as overall_wins, if( result_visit_score < result_home_score, 1, 0 ) as overall_losses, if( result_visit_score = result_home_score, 1, 0 ) as overall_ties, IFNULL(result_visit_score, 0) as overall_goals_for, IFNULL(result_home_score, 0) as overall_goals_against FROM teams INNER JOIN team_season ON team_season.team_id = teams.team_id LEFT JOIN (select * from event_mgr where status = 1 and end_time < UNIX_TIMESTAMP(now()) AND season_id = AND do_not_include_in_record in (0,2)) games ON teams.team_id = games.visit_id WHERE team_season.reg_event_id = ) data WHERE team_season_id = 5324 GROUP BY team_id, team_name_long ]
SQL/DB Error -- [You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'or `home_id` = ) and `season_id`= and `do_not_include_in_record` = 2 and statu' at line 2 . SELECT home_id,visit_id,result_home_score,result_visit_score,exempt_home_team,exempt_visit_team FROM `event_mgr` WHERE (`visit_id` = or `home_id` = ) and `season_id`= and `do_not_include_in_record` = 2 and status = 1 and end_time < UNIX_TIMESTAMP(now())]
SQL/DB Error -- [You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'or `home_id` = ) and `season_id`= and `do_not_include_in_record` = 0 and stat' at line 2 . SELECT home_id,visit_id,result_home_score,result_visit_score FROM `event_mgr` WHERE (`visit_id` = or `home_id` = ) and `season_id`= and `do_not_include_in_record` = 0 and status = 1 and end_time < UNIX_TIMESTAMP(now())]
SQL/DB Error -- [You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'GROUP BY event_mgrID ORDER BY start_time ASC)ez_results' at line 1 . SELECT count(*) FROM (SELECT event_mgrID AS id , event_mgr.league_id, event_mgr.home_id, event_mgr.visit_id, event_mgr.location_id, event_mgr.start_time, event_mgr.end_time, event_mgr.event_type_id, event_mgr.result_home_score, event_mgr.result_visit_score, event_mgr.event_desc, 'team1' as team1, 'team2' as team2, home_team_name, visit_team_name, event_mgr.home_season_id, event_mgr.visit_season_id FROM division, event_mgr WHERE (event_type_id = 1 OR end_time > 1548020335) AND (event_mgr.home_season_id = '5324' OR event_mgr.visit_season_id = '5324') AND event_mgr.status = '1' AND season_id = GROUP BY event_mgrID ORDER BY start_time ASC)ez_results]
SQL/DB Error -- [You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'GROUP BY event_mgrID ORDER BY start_time ASC LIMIT 0,999999' at line 1 . SELECT event_mgrID AS id , event_mgr.league_id, event_mgr.home_id, event_mgr.visit_id, event_mgr.location_id, event_mgr.start_time, event_mgr.end_time, event_mgr.event_type_id, event_mgr.result_home_score, event_mgr.result_visit_score, event_mgr.event_desc, 'team1' as team1, 'team2' as team2, home_team_name, visit_team_name, event_mgr.home_season_id, event_mgr.visit_season_id FROM division, event_mgr WHERE (event_type_id = 1 OR end_time > 1548020335) AND (event_mgr.home_season_id = '5324' OR event_mgr.visit_season_id = '5324') AND event_mgr.status = '1' AND season_id = GROUP BY event_mgrID ORDER BY start_time ASC LIMIT 0,999999]
SQL/DB Error -- [You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')ez_results' at line 1 . SELECT count(*) FROM (SELECT coach.title, coach.name, coach.contact_information FROM coach WHERE coach.team_id = '' AND coach.reg_events_id = )ez_results]
SQL/DB Error -- [You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'LIMIT 0,999999' at line 1 . SELECT coach.title, coach.name, coach.contact_information FROM coach WHERE coach.team_id = '' AND coach.reg_events_id = LIMIT 0,999999]
SQL/DB Error -- [You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ORDER BY player.number)ez_results' at line 2 . SELECT count(*) FROM (SELECT player.id, player.first_name, player.last_name, player.year, player.type, IF(player.hometown = '','N/A',player.hometown), player.goals, player.assists, player.points, player.number,player.games_played,player.penalty_minutes FROM player WHERE player.type!='Goalie' AND player.team_id = '' AND player.reg_events_id = ORDER BY player.number)ez_results]
SQL/DB Error -- [You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ORDER BY player.number LIMIT 0,999999' at line 2 . SELECT player.id, player.first_name, player.last_name, player.year, player.type, IF(player.hometown = '','N/A',player.hometown), player.goals, player.assists, player.points, player.number,player.games_played,player.penalty_minutes FROM player WHERE player.type!='Goalie' AND player.team_id = '' AND player.reg_events_id = ORDER BY player.number LIMIT 0,999999]
SQL/DB Error -- [You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ORDER BY player.number)ez_results' at line 3 . SELECT count(*) FROM (SELECT player.id, player.first_name, player.last_name, player.year, player.type, IF(player.hometown = '','N/A',player.hometown), player.games_played, player.periods, player.minutes, player.goals_against, player.goals_against_average, player.shots, player.saves, player.save_percentage, player.shutout, player.number, player.assists FROM player WHERE player.type='Goalie' AND player.team_id = '' AND player.reg_events_id = ORDER BY player.number)ez_results]
SQL/DB Error -- [You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ORDER BY player.number LIMIT 0,999999' at line 3 . SELECT player.id, player.first_name, player.last_name, player.year, player.type, IF(player.hometown = '','N/A',player.hometown), player.games_played, player.periods, player.minutes, player.goals_against, player.goals_against_average, player.shots, player.saves, player.save_percentage, player.shutout, player.number, player.assists FROM player WHERE player.type='Goalie' AND player.team_id = '' AND player.reg_events_id = ORDER BY player.number LIMIT 0,999999]

:

Record
League\ConferenceOverall
WONLOSTTIEDGFGAPTSWONLOSTTIEDGFGAPTSWin%
State Tournament Qualifying (minus exempt games)State Tournament Record
WONLOSTTIEDGFGAPTSWin%WONLOSTTIEDGFGAPTSWin%
0000000.0000000000.000
Schedule
First team listed is home team
No Results