Team Game Stats Finder - College Basketball

--------------------------------------

main

Page Setup Time: 0.00173 seconds

SELECT ts.name_short as team_name_abbr, ts.link as team_link, IFNULL(os.name_short,(SELECT IFNULL(team_name_short,name) FROM sup_teams WHERE sup_teams.team_id=opp_team_id)) as opp_name_abbr, os.opp_team_link as opp_team_link, date, game_id, year_id as year_id_csk, CONCAT(year_id-1,"-",SUBSTRING(year_id,3,2)) as year_id, IF(home_away_neutral="H","",IF(home_away_neutral="A","@","N")) as game_location, (SELECT pts-opp_pts+IFNULL(pts,0)/100 FROM sup_team_games tg2 WHERE tg2.game_id=st.game_id AND tg2.team_id=st.team_id) as game_result_csk, (SELECT CONCAT(IF(win=1,'W',IF(loss=1,'L','T')),' ',pts,'-',opp_pts,IF(overtimes>0, ' (', ''),IF(overtimes>1, overtimes, ''),IF(overtimes>0, 'OT)', '')) FROM sup_team_games tg2 WHERE tg2.game_id=st.game_id AND tg2.team_id=st.team_id) as game_result, sup_games.link as game_link, comp_id, IF(tourn_id="ncaa"," <small>NCAA</small>","") as date_append, fg, fga, IF(fga, fg / fga, NULL) as fg_pct_csk, TRIM(LEADING '0' FROM ROUND(IF(fga, fg / fga, NULL),3)) AS fg_pct, (fg - IFNULL(fg3, 0)) AS fg2, (fga - IFNULL(fg3a, 0)) AS fg2a, (fg - IFNULL(fg3, 0)) / (fga - IFNULL(fg3a, 0)) as fg2_pct_csk, TRIM(LEADING '0' FROM ROUND((fg - IFNULL(fg3, 0)) / (fga - IFNULL(fg3a, 0)),3)) AS fg2_pct, fg3, fg3a, IF(fg3a, fg3 / fg3a, NULL) as fg3_pct_csk, TRIM(LEADING '0' FROM ROUND(IF(fg3a, fg3 / fg3a, NULL),3)) AS fg3_pct, ft, fta, IF(fta, ft / fta, NULL) as ft_pct_csk, TRIM(LEADING '0' FROM ROUND(IF(fta, ft / fta, NULL),3)) AS ft_pct, pts, mp, opp_fg, opp_fga, IF(opp_fga, opp_fg / opp_fga, NULL) as opp_fg_pct_csk, TRIM(LEADING '0' FROM ROUND(IF(opp_fga, opp_fg / opp_fga, NULL),3)) AS opp_fg_pct, (opp_fg - IFNULL(opp_fg3, 0)) AS opp_fg2, (opp_fga - IFNULL(opp_fg3a, 0)) AS opp_fg2a, IF((opp_fga - IFNULL(opp_fg3a, 0)), (opp_fg - IFNULL(opp_fg3, 0)) / (opp_fga - IFNULL(opp_fg3a, 0)), NULL) as opp_fg2_pct_csk, TRIM(LEADING '0' FROM ROUND(IF((opp_fga - IFNULL(opp_fg3a, 0)), (opp_fg - IFNULL(opp_fg3, 0)) / (opp_fga - IFNULL(opp_fg3a, 0)), NULL),3)) AS opp_fg2_pct, opp_fg3, opp_fg3a, IF(opp_fg3a, opp_fg3 / opp_fg3a, NULL) as opp_fg3_pct_csk, TRIM(LEADING '0' FROM ROUND(IF(opp_fg3a, opp_fg3 / opp_fg3a, NULL),3)) AS opp_fg3_pct, opp_ft, opp_fta, IF(opp_fta, opp_ft / opp_fta, NULL) as opp_ft_pct_csk, TRIM(LEADING '0' FROM ROUND(IF(opp_fta, opp_ft / opp_fta, NULL),3)) AS opp_ft_pct, opp_pts
FROM sup_team_games as st
  JOIN sup_games USING (game_id)
  JOIN sup_phase_seasons USING (comp_id, phase_id, year_id)
  JOIN sup_comp_seasons USING (comp_id, year_id)
  JOIN (SELECT team_id, year_id, name_abbr, name, link, name_short, conf_id FROM sup_team_seasons GROUP BY team_id, year_id ) as ts USING (team_id, year_id)
  LEFT JOIN (SELECT team_id as opp_team_id, link as opp_team_link, year_id, name_abbr, name_short, conf_id as opp_conf_id FROM sup_team_seasons GROUP BY team_id, year_id ) as os USING (opp_team_id, year_id)
  LEFT JOIN (SELECT parent_conf_id, conf_id, conf_name, conf_abbr, link, comp_id, year_id FROM sup_conference_seasons) as team_conf USING (conf_id, comp_id, year_id)
  LEFT JOIN (SELECT parent_conf_id as opp_parent_conf_id, conf_id as opp_conf_id, conf_name, conf_abbr, link, comp_id, year_id FROM sup_conference_seasons) as opp_team_conf USING (opp_conf_id, comp_id, year_id)
WHERE sup_games.status = 'Played'
  AND comp_id=?
  AND year_id>=?
  AND year_id<=?
  AND date < current_date() 
ORDER BY pts DESC, date DESC, team_id LIMIT 0, 20

SQL PARAMS -- $VAR1 = [
          'NCAAM',
          2025,
          2025
        ];

Query Time: 1.47 seconds
Table Build Time: 0.07 seconds


--------------------------------------
SH->PARAM -- $VAR1 = {
          'match' => 'team_game',
          'game_status' => 1,
          'timeframe' => 'seasons',
          'comp_id' => 'NCAAM',
          'year_min' => 2025,
          'year_max' => 2025,
          'order_by' => 'pts'
        };
SH->PARAM_NO_DEFAULT -- $VAR1 = {
          'year_min' => 2025,
          'comp_id' => 'NCAAM',
          'year_max' => 2025,
          'game_status' => 1
        };