Portland Trail Blazers vs. San Antonio Spurs: Head-to-Head Reg Season and Playoffs Stats Comparison

Compare players and teams or see head to head results between teams, players, or player vs. team. • Tutorial Video • Sample Searches • Data Coverage

THIS QUESTION WAS ANSWERED USING

Your All Access Pass to the Pro Basketball Database Go beyond the basics. Become a Stathead

Start Your FREE Trial

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

header_comp

WITH
  t1 AS (
SELECT team_id, SUM(win AND type="reg") as rsw, SUM(loss AND type="reg") as rsl, SUM(tie AND type="reg") as rst, SUM(win AND type="post") as pow, SUM(loss AND type="post") as pol
FROM sup_team_games
  JOIN sup_games USING (game_id)
  JOIN sup_phase_seasons USING (year_id, comp_id, phase_id)
WHERE (team_id=?)
  AND opp_team_id=?  
  ),
  t2 AS (
SELECT team_id, SUM(win AND type="reg") as rsw, SUM(loss AND type="reg") as rsl, SUM(tie AND type="reg") as rst, SUM(win AND type="post") as pow, SUM(loss AND type="post") as pol
FROM sup_team_games
  JOIN sup_games USING (game_id)
  JOIN sup_phase_seasons USING (year_id, comp_id, phase_id)
WHERE (team_id=?)
  AND opp_team_id=?  
  )
SELECT team_id, rs_wins, rs_losses, rs_ties, po_wins, po_losses, SUM(games) AS games, SUM(wins) AS wins, SUM(losses) AS losses, SUM(wins) / SUM(wins + losses) as win_loss_pct_csk, TRIM(LEADING '0' FROM ROUND(SUM(wins) / SUM(wins + losses),3)) AS win_loss_pct, SUM(pts)/SUM(games) as team_ppg_csk, ROUND(SUM(pts)/SUM(games),1) AS team_ppg, SUM(opp_pts)/SUM(games) as team_oppg_csk, ROUND(SUM(opp_pts)/SUM(games),1) AS team_oppg, SUM(is_playoff_team) AS is_playoff_team, SUM(is_finals_team) AS is_conf_champ, SUM(is_lg_champ) AS is_lg_champ
FROM sup_team_seasons as ts
  JOIN sup_phase_seasons USING (comp_id, phase_id, year_id)
  JOIN sup_comp_seasons USING (comp_id, year_id)
  LEFT JOIN (SELECT t1.team_id, t1.rsw as rs_wins, t1.rsl as rs_losses, t1.rst as rs_ties, t1.pow as po_wins, t1.pol as po_losses FROM t1
  UNION SELECT t2.team_id, t2.rsw as rs_wins, t2.rsl as rs_losses, t2.rst as rs_ties, t2.pow as po_wins, t2.pol as po_losses
FROM t2) as xxx USING (team_id)
WHERE ((team_id=?) OR (team_id=?))
  AND type="reg" 
GROUP BY team_id
ORDER BY team_id 

SQL PARAMS -- $VAR1 = [
          'POR',
          'SAS',
          'SAS',
          'POR',
          'POR',
          'SAS'
        ];

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

h2h_gamelogs

Page Setup Time: 0.00081 seconds

SELECT IF(away_team_id="POR","@","") as loc, IF(away_team_id="POR",away_score,home_score) as team1_score, IF(away_team_id="SAS",away_score,home_score) as team2_score, game_id, date, game_id, sup_games.link as game_link, sup_venue_seasons.name as venue_name, city as venue_city, IF(overtimes, IF(overtimes>1, CONCAT(overtimes,"OT"), "OT"), "") as overtimes
FROM sup_games
  JOIN (SELECT game_id, year_id, comp_id, phase_id, team_id as away_team_id, opp_team_id, opp_comp_id, opp_phase_id, team_game_num_season, home_away_neutral FROM sup_team_games) as tg USING (game_id, away_team_id)
  JOIN sup_phase_seasons USING (comp_id, phase_id, year_id)
  LEFT JOIN sup_venues USING (venue_id)
  LEFT JOIN sup_venue_seasons USING (venue_id, year_id)
WHERE ((away_team_id=? AND home_team_id=?) OR (away_team_id=? AND home_team_id=?))
  AND home_score IS NOT NULL
  AND type="reg" 
ORDER BY date DESC LIMIT 0, 20

SQL PARAMS -- $VAR1 = [
          'POR',
          'SAS',
          'SAS',
          'POR'
        ];

Query Time: 0.02 seconds
SELECT IF(away_team_id="POR","@","") as loc, IF(away_team_id="POR",away_score,home_score) as team1_score, IF(away_team_id="SAS",away_score,home_score) as team2_score, game_id, date, game_id, sup_games.link as game_link, sup_venue_seasons.name as venue_name, city as venue_city, IF(overtimes, IF(overtimes>1, CONCAT(overtimes,"OT"), "OT"), "") as overtimes
FROM sup_games
  JOIN (SELECT game_id, year_id, comp_id, phase_id, team_id as away_team_id, opp_team_id, opp_comp_id, opp_phase_id, team_game_num_season, home_away_neutral FROM sup_team_games) as tg USING (game_id, away_team_id)
  JOIN sup_phase_seasons USING (comp_id, phase_id, year_id)
  LEFT JOIN sup_venues USING (venue_id)
  LEFT JOIN sup_venue_seasons USING (venue_id, year_id)
WHERE ((away_team_id=? AND home_team_id=?) OR (away_team_id=? AND home_team_id=?))
  AND home_score IS NOT NULL
  AND type="post" 
ORDER BY date DESC LIMIT 0, 20

SQL PARAMS -- $VAR1 = [
          'POR',
          'SAS',
          'SAS',
          'POR'
        ];

Query Time: 0.10 seconds
Table Build Time: 0.04 seconds

Table Build Time: 0.03 seconds

Column 'comp_id' in field list is ambiguous

WITH
  tr1 AS (
SELECT year_id, comp_id, COUNT(*) AS games, SUM(win=1) AS wins, SUM(loss=1) AS losses, SUM(pts) AS pts, SUM(pts)/COUNT(*) as team_ppg_csk, ROUND(SUM(pts)/COUNT(*),1) AS team_ppg
FROM sup_team_games
  JOIN sup_games USING (game_id)
  JOIN sup_phase_seasons USING (year_id, comp_id, phase_id)
WHERE (team_id=?)
  AND opp_team_id=?
  AND type="reg" 
GROUP BY year_id 
  ),
  tr2 AS (
SELECT year_id, comp_id, COUNT(*) AS games, SUM(win=1) AS wins, SUM(loss=1) AS losses, SUM(pts) AS pts, SUM(pts)/COUNT(*) as team_ppg_csk, ROUND(SUM(pts)/COUNT(*),1) AS team_ppg
FROM sup_team_games
  JOIN sup_games USING (game_id)
  JOIN sup_phase_seasons USING (year_id, comp_id, phase_id)
WHERE (team_id=?)
  AND opp_team_id=?
  AND type="reg" 
GROUP BY year_id 
  )
SELECT year_id as year_id_csk, IF(comp_id="WNBA", year_id, CONCAT(year_id-1,"-",SUBSTRING(year_id,3,2))) as year_id, tr1.comp_id, tr1.games AS tr1_games, tr2.games AS tr2_games, tr1.wins AS tr1_wins, tr2.wins AS tr2_wins, tr1.losses AS tr1_losses, tr2.losses AS tr2_losses, tr1.pts AS tr1_pts, tr2.pts AS tr2_pts, tr1.team_ppg AS tr1_team_ppg, tr2.team_ppg AS tr2_team_ppg
FROM tr1
  JOIN tr2 USING (year_id)
WHERE 1 
GROUP BY year_id
ORDER BY year_id 
--------------------------------------

h2h_per_game

Page Setup Time: 0.00618 seconds

WITH
  t1gms AS (
SELECT game_id
FROM sup_team_games
  JOIN sup_phase_seasons USING (year_id, comp_id, phase_id)
WHERE (team_id=?)
  AND type="reg"  
  ),
  t2gms AS (
SELECT game_id
FROM sup_team_games
  JOIN sup_phase_seasons USING (year_id, comp_id, phase_id)
WHERE (team_id=?)
  AND type="reg"  
  )
SELECT (SELECT name_abbr FROM sup_team_seasons WHERE team_id=st.team_id AND sup_team_seasons.year_id=MAX(st.year_id) LIMIT 1) as franch_abbr, team_id, MIN(year_id) as year_min_csk, IF(comp_id='WNBA', MIN(year_id), CONCAT_WS('-', (MIN(year_id) - 1), RIGHT(MIN(year_id), 2))) as year_min, MAX(year_id) as year_max_csk, IF(comp_id='WNBA', MAX(year_id), CONCAT_WS('-', (MAX(year_id) - 1), RIGHT(MAX(year_id), 2))) as year_max, (SUM(fg))/(COUNT(*)) as fg_per_g_csk, ROUND((SUM(fg))/(COUNT(*)),1) AS fg_per_g, (SUM(fga))/(COUNT(*)) as fga_per_g_csk, ROUND((SUM(fga))/(COUNT(*)),1) AS fga_per_g, IF(SUM(fga), SUM((fga IS NOT NULL) * fg) / SUM(fga), NULL) as fg_pct_csk, TRIM(LEADING '0' FROM ROUND(IF(SUM(fga), SUM((fga IS NOT NULL) * fg) / SUM(fga), NULL),3)) AS fg_pct, (SUM(fg)/(COUNT(*)) - IFNULL(SUM(fg3 * (fg IS NOT NULL))/(COUNT(*)-SUM(fg IS NULL)), 0)) as fg2_per_g_csk, ROUND((SUM(fg)/(COUNT(*)) - IFNULL(SUM(fg3 * (fg IS NOT NULL))/(COUNT(*)-SUM(fg IS NULL)), 0)),1) AS fg2_per_g, (SUM(fga)/(COUNT(*)) - IFNULL(SUM(fg3a * (fga IS NOT NULL))/(COUNT(*)-SUM(fga IS NULL)), 0)) as fg2a_per_g_csk, ROUND((SUM(fga)/(COUNT(*)) - IFNULL(SUM(fg3a * (fga IS NOT NULL))/(COUNT(*)-SUM(fga IS NULL)), 0)),1) AS fg2a_per_g, IF(SUM(fga - IFNULL(fg3a, 0)), SUM(((fga - IFNULL(fg3a, 0)) IS NOT NULL) * (fg - IFNULL(fg3, 0))) / SUM(fga - IFNULL(fg3a, 0)), NULL) as fg2_pct_csk, TRIM(LEADING '0' FROM ROUND(IF(SUM(fga - IFNULL(fg3a, 0)), SUM(((fga - IFNULL(fg3a, 0)) IS NOT NULL) * (fg - IFNULL(fg3, 0))) / SUM(fga - IFNULL(fg3a, 0)), NULL),3)) AS fg2_pct, (SUM(fg3))/((COUNT(*)-SUM(fg3 IS NULL))) as fg3_per_g_csk, ROUND((SUM(fg3))/((COUNT(*)-SUM(fg3 IS NULL))),1) AS fg3_per_g, (SUM(fg3a))/((COUNT(*)-SUM(fg3a IS NULL))) as fg3a_per_g_csk, ROUND((SUM(fg3a))/((COUNT(*)-SUM(fg3a IS NULL))),1) AS fg3a_per_g, IF(SUM(fg3a), SUM((fg3a IS NOT NULL) * fg3) / SUM(fg3a), NULL) as fg3_pct_csk, TRIM(LEADING '0' FROM ROUND(IF(SUM(fg3a), SUM((fg3a IS NOT NULL) * fg3) / SUM(fg3a), NULL),3)) AS fg3_pct, IF(SUM(fga), SUM(fg + 0.5 * IFNULL(fg3, 0)) / SUM(fga), NULL) as efg_pct_csk, TRIM(LEADING '0' FROM ROUND(IF(SUM(fga), SUM(fg + 0.5 * IFNULL(fg3, 0)) / SUM(fga), NULL),3)) AS efg_pct, (SUM(ft))/(COUNT(*)) as ft_per_g_csk, ROUND((SUM(ft))/(COUNT(*)),1) AS ft_per_g, (SUM(fta))/((COUNT(*)-SUM(fta IS NULL))) as fta_per_g_csk, ROUND((SUM(fta))/((COUNT(*)-SUM(fta IS NULL))),1) AS fta_per_g, IF(SUM(fta), SUM(ft) / SUM(fta), NULL) as ft_pct_csk, TRIM(LEADING '0' FROM ROUND(IF(SUM(fta), SUM(ft) / SUM(fta), NULL),3)) AS ft_pct, (SUM(orb))/((COUNT(*)-SUM(orb IS NULL))) as orb_per_g_csk, ROUND((SUM(orb))/((COUNT(*)-SUM(orb IS NULL))),1) AS orb_per_g, (SUM(trb * (orb IS NOT NULL))/(COUNT(*)-SUM(orb IS NULL)) - SUM(orb * (orb IS NOT NULL))/(COUNT(*)-SUM(orb IS NULL))) as drb_per_g_csk, ROUND((SUM(trb * (orb IS NOT NULL))/(COUNT(*)-SUM(orb IS NULL)) - SUM(orb * (orb IS NOT NULL))/(COUNT(*)-SUM(orb IS NULL))),1) AS drb_per_g, (SUM(trb))/((COUNT(*)-SUM(trb IS NULL))) as trb_per_g_csk, ROUND((SUM(trb))/((COUNT(*)-SUM(trb IS NULL))),1) AS trb_per_g, (SUM(ast))/((COUNT(*)-SUM(ast IS NULL))) as ast_per_g_csk, ROUND((SUM(ast))/((COUNT(*)-SUM(ast IS NULL))),1) AS ast_per_g, (SUM(stl))/((COUNT(*)-SUM(stl IS NULL))) as stl_per_g_csk, ROUND((SUM(stl))/((COUNT(*)-SUM(stl IS NULL))),1) AS stl_per_g, (SUM(blk))/((COUNT(*)-SUM(blk IS NULL))) as blk_per_g_csk, ROUND((SUM(blk))/((COUNT(*)-SUM(blk IS NULL))),1) AS blk_per_g, (SUM(tov))/((COUNT(*)-SUM(tov IS NULL))) as tov_per_g_csk, ROUND((SUM(tov))/((COUNT(*)-SUM(tov IS NULL))),1) AS tov_per_g, (SUM(pf))/((COUNT(*)-SUM(pf IS NULL))) as pf_per_g_csk, ROUND((SUM(pf))/((COUNT(*)-SUM(pf IS NULL))),1) AS pf_per_g, (SUM(pts))/(COUNT(*)) as pts_per_g_csk, ROUND((SUM(pts))/(COUNT(*)),1) AS pts_per_g
FROM sup_team_games as st
  JOIN sup_games USING (game_id)
  JOIN sup_phase_seasons USING (year_id, comp_id, phase_id)
  JOIN t1gms USING (game_id)
  JOIN t2gms USING (game_id)
WHERE home_score IS NOT NULL 
GROUP BY team_id LIMIT 0, 200

SQL PARAMS -- $VAR1 = [
          'POR',
          'SAS'
        ];

Query Time: 0.17 seconds
WITH
  t1gms AS (
SELECT game_id
FROM sup_team_games
  JOIN sup_phase_seasons USING (year_id, comp_id, phase_id)
WHERE (team_id=?)
  AND type="post"  
  ),
  t2gms AS (
SELECT game_id
FROM sup_team_games
  JOIN sup_phase_seasons USING (year_id, comp_id, phase_id)
WHERE (team_id=?)
  AND type="post"  
  )
SELECT (SELECT name_abbr FROM sup_team_seasons WHERE team_id=st.team_id AND sup_team_seasons.year_id=MAX(st.year_id) LIMIT 1) as franch_abbr, team_id, MIN(year_id) as year_min_csk, IF(comp_id='WNBA', MIN(year_id), CONCAT_WS('-', (MIN(year_id) - 1), RIGHT(MIN(year_id), 2))) as year_min, MAX(year_id) as year_max_csk, IF(comp_id='WNBA', MAX(year_id), CONCAT_WS('-', (MAX(year_id) - 1), RIGHT(MAX(year_id), 2))) as year_max, (SUM(fg))/(COUNT(*)) as fg_per_g_csk, ROUND((SUM(fg))/(COUNT(*)),1) AS fg_per_g, (SUM(fga))/(COUNT(*)) as fga_per_g_csk, ROUND((SUM(fga))/(COUNT(*)),1) AS fga_per_g, IF(SUM(fga), SUM((fga IS NOT NULL) * fg) / SUM(fga), NULL) as fg_pct_csk, TRIM(LEADING '0' FROM ROUND(IF(SUM(fga), SUM((fga IS NOT NULL) * fg) / SUM(fga), NULL),3)) AS fg_pct, (SUM(fg)/(COUNT(*)) - IFNULL(SUM(fg3 * (fg IS NOT NULL))/(COUNT(*)-SUM(fg IS NULL)), 0)) as fg2_per_g_csk, ROUND((SUM(fg)/(COUNT(*)) - IFNULL(SUM(fg3 * (fg IS NOT NULL))/(COUNT(*)-SUM(fg IS NULL)), 0)),1) AS fg2_per_g, (SUM(fga)/(COUNT(*)) - IFNULL(SUM(fg3a * (fga IS NOT NULL))/(COUNT(*)-SUM(fga IS NULL)), 0)) as fg2a_per_g_csk, ROUND((SUM(fga)/(COUNT(*)) - IFNULL(SUM(fg3a * (fga IS NOT NULL))/(COUNT(*)-SUM(fga IS NULL)), 0)),1) AS fg2a_per_g, IF(SUM(fga - IFNULL(fg3a, 0)), SUM(((fga - IFNULL(fg3a, 0)) IS NOT NULL) * (fg - IFNULL(fg3, 0))) / SUM(fga - IFNULL(fg3a, 0)), NULL) as fg2_pct_csk, TRIM(LEADING '0' FROM ROUND(IF(SUM(fga - IFNULL(fg3a, 0)), SUM(((fga - IFNULL(fg3a, 0)) IS NOT NULL) * (fg - IFNULL(fg3, 0))) / SUM(fga - IFNULL(fg3a, 0)), NULL),3)) AS fg2_pct, (SUM(fg3))/((COUNT(*)-SUM(fg3 IS NULL))) as fg3_per_g_csk, ROUND((SUM(fg3))/((COUNT(*)-SUM(fg3 IS NULL))),1) AS fg3_per_g, (SUM(fg3a))/((COUNT(*)-SUM(fg3a IS NULL))) as fg3a_per_g_csk, ROUND((SUM(fg3a))/((COUNT(*)-SUM(fg3a IS NULL))),1) AS fg3a_per_g, IF(SUM(fg3a), SUM((fg3a IS NOT NULL) * fg3) / SUM(fg3a), NULL) as fg3_pct_csk, TRIM(LEADING '0' FROM ROUND(IF(SUM(fg3a), SUM((fg3a IS NOT NULL) * fg3) / SUM(fg3a), NULL),3)) AS fg3_pct, IF(SUM(fga), SUM(fg + 0.5 * IFNULL(fg3, 0)) / SUM(fga), NULL) as efg_pct_csk, TRIM(LEADING '0' FROM ROUND(IF(SUM(fga), SUM(fg + 0.5 * IFNULL(fg3, 0)) / SUM(fga), NULL),3)) AS efg_pct, (SUM(ft))/(COUNT(*)) as ft_per_g_csk, ROUND((SUM(ft))/(COUNT(*)),1) AS ft_per_g, (SUM(fta))/((COUNT(*)-SUM(fta IS NULL))) as fta_per_g_csk, ROUND((SUM(fta))/((COUNT(*)-SUM(fta IS NULL))),1) AS fta_per_g, IF(SUM(fta), SUM(ft) / SUM(fta), NULL) as ft_pct_csk, TRIM(LEADING '0' FROM ROUND(IF(SUM(fta), SUM(ft) / SUM(fta), NULL),3)) AS ft_pct, (SUM(orb))/((COUNT(*)-SUM(orb IS NULL))) as orb_per_g_csk, ROUND((SUM(orb))/((COUNT(*)-SUM(orb IS NULL))),1) AS orb_per_g, (SUM(trb * (orb IS NOT NULL))/(COUNT(*)-SUM(orb IS NULL)) - SUM(orb * (orb IS NOT NULL))/(COUNT(*)-SUM(orb IS NULL))) as drb_per_g_csk, ROUND((SUM(trb * (orb IS NOT NULL))/(COUNT(*)-SUM(orb IS NULL)) - SUM(orb * (orb IS NOT NULL))/(COUNT(*)-SUM(orb IS NULL))),1) AS drb_per_g, (SUM(trb))/((COUNT(*)-SUM(trb IS NULL))) as trb_per_g_csk, ROUND((SUM(trb))/((COUNT(*)-SUM(trb IS NULL))),1) AS trb_per_g, (SUM(ast))/((COUNT(*)-SUM(ast IS NULL))) as ast_per_g_csk, ROUND((SUM(ast))/((COUNT(*)-SUM(ast IS NULL))),1) AS ast_per_g, (SUM(stl))/((COUNT(*)-SUM(stl IS NULL))) as stl_per_g_csk, ROUND((SUM(stl))/((COUNT(*)-SUM(stl IS NULL))),1) AS stl_per_g, (SUM(blk))/((COUNT(*)-SUM(blk IS NULL))) as blk_per_g_csk, ROUND((SUM(blk))/((COUNT(*)-SUM(blk IS NULL))),1) AS blk_per_g, (SUM(tov))/((COUNT(*)-SUM(tov IS NULL))) as tov_per_g_csk, ROUND((SUM(tov))/((COUNT(*)-SUM(tov IS NULL))),1) AS tov_per_g, (SUM(pf))/((COUNT(*)-SUM(pf IS NULL))) as pf_per_g_csk, ROUND((SUM(pf))/((COUNT(*)-SUM(pf IS NULL))),1) AS pf_per_g, (SUM(pts))/(COUNT(*)) as pts_per_g_csk, ROUND((SUM(pts))/(COUNT(*)),1) AS pts_per_g
FROM sup_team_games as st
  JOIN sup_games USING (game_id)
  JOIN sup_phase_seasons USING (year_id, comp_id, phase_id)
  JOIN t1gms USING (game_id)
  JOIN t2gms USING (game_id)
WHERE home_score IS NOT NULL 
GROUP BY team_id LIMIT 0, 200

SQL PARAMS -- $VAR1 = [
          'POR',
          'SAS'
        ];

Query Time: 0.02 seconds
Table Build Time: 0.04 seconds

Table Build Time: 0.04 seconds


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

h2h_sum

Page Setup Time: 0.00158 seconds

WITH
  t1gms AS (
SELECT game_id
FROM sup_team_games
  JOIN sup_phase_seasons USING (year_id, comp_id, phase_id)
WHERE (team_id=?)
  AND type="reg"  
  ),
  t2gms AS (
SELECT game_id
FROM sup_team_games
  JOIN sup_phase_seasons USING (year_id, comp_id, phase_id)
WHERE (team_id=?)
  AND type="reg"  
  )
SELECT (SELECT name_abbr FROM sup_team_seasons WHERE team_id=st.team_id AND sup_team_seasons.year_id=MAX(st.year_id) LIMIT 1) as franch_abbr, team_id, MIN(year_id) as year_min_csk, IF(comp_id='WNBA', MIN(year_id), CONCAT_WS('-', (MIN(year_id) - 1), RIGHT(MIN(year_id), 2))) as year_min, MAX(year_id) as year_max_csk, IF(comp_id='WNBA', MAX(year_id), CONCAT_WS('-', (MAX(year_id) - 1), RIGHT(MAX(year_id), 2))) as year_max, SUM(win=1) AS wins, SUM(loss=1) AS losses, COUNT(*) AS games, SUM(fg) AS fg, SUM(fga) AS fga, IF(SUM(fga), SUM((fga IS NOT NULL) * fg) / SUM(fga), NULL) as fg_pct_csk, TRIM(LEADING '0' FROM ROUND(IF(SUM(fga), SUM((fga IS NOT NULL) * fg) / SUM(fga), NULL),3)) AS fg_pct, SUM(fg - IFNULL(fg3, 0)) AS fg2, SUM(fga - IFNULL(fg3a, 0)) AS fg2a, IF(SUM(fga - IFNULL(fg3a, 0)), SUM(((fga - IFNULL(fg3a, 0)) IS NOT NULL) * (fg - IFNULL(fg3, 0))) / SUM(fga - IFNULL(fg3a, 0)), NULL) as fg2_pct_csk, TRIM(LEADING '0' FROM ROUND(IF(SUM(fga - IFNULL(fg3a, 0)), SUM(((fga - IFNULL(fg3a, 0)) IS NOT NULL) * (fg - IFNULL(fg3, 0))) / SUM(fga - IFNULL(fg3a, 0)), NULL),3)) AS fg2_pct, SUM(fg3) AS fg3, SUM(fg3a) AS fg3a, IF(SUM(fg3a), SUM((fg3a IS NOT NULL) * fg3) / SUM(fg3a), NULL) as fg3_pct_csk, TRIM(LEADING '0' FROM ROUND(IF(SUM(fg3a), SUM((fg3a IS NOT NULL) * fg3) / SUM(fg3a), NULL),3)) AS fg3_pct, IF(SUM(fga), SUM(fg + 0.5 * IFNULL(fg3, 0)) / SUM(fga), NULL) as efg_pct_csk, TRIM(LEADING '0' FROM ROUND(IF(SUM(fga), SUM(fg + 0.5 * IFNULL(fg3, 0)) / SUM(fga), NULL),3)) AS efg_pct, SUM(ft) AS ft, SUM(fta) AS fta, IF(SUM(fta), SUM(ft) / SUM(fta), NULL) as ft_pct_csk, TRIM(LEADING '0' FROM ROUND(IF(SUM(fta), SUM(ft) / SUM(fta), NULL),3)) AS ft_pct, SUM(orb) AS orb, SUM(trb - orb) AS drb, SUM(trb) AS trb, SUM(ast) AS ast, SUM(stl) AS stl, SUM(blk) AS blk, SUM(tov) AS tov, SUM(pf) AS pf, SUM(pts) AS pts
FROM sup_team_games as st
  JOIN sup_games USING (game_id)
  JOIN sup_phase_seasons USING (year_id, comp_id, phase_id)
  JOIN t1gms USING (game_id)
  JOIN t2gms USING (game_id)
WHERE home_score IS NOT NULL 
GROUP BY team_id LIMIT 0, 200

SQL PARAMS -- $VAR1 = [
          'POR',
          'SAS'
        ];

Query Time: 0.12 seconds
WITH
  t1gms AS (
SELECT game_id
FROM sup_team_games
  JOIN sup_phase_seasons USING (year_id, comp_id, phase_id)
WHERE (team_id=?)
  AND type="post"  
  ),
  t2gms AS (
SELECT game_id
FROM sup_team_games
  JOIN sup_phase_seasons USING (year_id, comp_id, phase_id)
WHERE (team_id=?)
  AND type="post"  
  )
SELECT (SELECT name_abbr FROM sup_team_seasons WHERE team_id=st.team_id AND sup_team_seasons.year_id=MAX(st.year_id) LIMIT 1) as franch_abbr, team_id, MIN(year_id) as year_min_csk, IF(comp_id='WNBA', MIN(year_id), CONCAT_WS('-', (MIN(year_id) - 1), RIGHT(MIN(year_id), 2))) as year_min, MAX(year_id) as year_max_csk, IF(comp_id='WNBA', MAX(year_id), CONCAT_WS('-', (MAX(year_id) - 1), RIGHT(MAX(year_id), 2))) as year_max, SUM(win=1) AS wins, SUM(loss=1) AS losses, COUNT(*) AS games, SUM(fg) AS fg, SUM(fga) AS fga, IF(SUM(fga), SUM((fga IS NOT NULL) * fg) / SUM(fga), NULL) as fg_pct_csk, TRIM(LEADING '0' FROM ROUND(IF(SUM(fga), SUM((fga IS NOT NULL) * fg) / SUM(fga), NULL),3)) AS fg_pct, SUM(fg - IFNULL(fg3, 0)) AS fg2, SUM(fga - IFNULL(fg3a, 0)) AS fg2a, IF(SUM(fga - IFNULL(fg3a, 0)), SUM(((fga - IFNULL(fg3a, 0)) IS NOT NULL) * (fg - IFNULL(fg3, 0))) / SUM(fga - IFNULL(fg3a, 0)), NULL) as fg2_pct_csk, TRIM(LEADING '0' FROM ROUND(IF(SUM(fga - IFNULL(fg3a, 0)), SUM(((fga - IFNULL(fg3a, 0)) IS NOT NULL) * (fg - IFNULL(fg3, 0))) / SUM(fga - IFNULL(fg3a, 0)), NULL),3)) AS fg2_pct, SUM(fg3) AS fg3, SUM(fg3a) AS fg3a, IF(SUM(fg3a), SUM((fg3a IS NOT NULL) * fg3) / SUM(fg3a), NULL) as fg3_pct_csk, TRIM(LEADING '0' FROM ROUND(IF(SUM(fg3a), SUM((fg3a IS NOT NULL) * fg3) / SUM(fg3a), NULL),3)) AS fg3_pct, IF(SUM(fga), SUM(fg + 0.5 * IFNULL(fg3, 0)) / SUM(fga), NULL) as efg_pct_csk, TRIM(LEADING '0' FROM ROUND(IF(SUM(fga), SUM(fg + 0.5 * IFNULL(fg3, 0)) / SUM(fga), NULL),3)) AS efg_pct, SUM(ft) AS ft, SUM(fta) AS fta, IF(SUM(fta), SUM(ft) / SUM(fta), NULL) as ft_pct_csk, TRIM(LEADING '0' FROM ROUND(IF(SUM(fta), SUM(ft) / SUM(fta), NULL),3)) AS ft_pct, SUM(orb) AS orb, SUM(trb - orb) AS drb, SUM(trb) AS trb, SUM(ast) AS ast, SUM(stl) AS stl, SUM(blk) AS blk, SUM(tov) AS tov, SUM(pf) AS pf, SUM(pts) AS pts
FROM sup_team_games as st
  JOIN sup_games USING (game_id)
  JOIN sup_phase_seasons USING (year_id, comp_id, phase_id)
  JOIN t1gms USING (game_id)
  JOIN t2gms USING (game_id)
WHERE home_score IS NOT NULL 
GROUP BY team_id LIMIT 0, 200

SQL PARAMS -- $VAR1 = [
          'POR',
          'SAS'
        ];

Query Time: 0.02 seconds
Table Build Time: 0.04 seconds

Table Build Time: 0.04 seconds


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

overall_per_game

Page Setup Time: 0.00594 seconds

SELECT (SELECT name_abbr FROM sup_team_seasons WHERE team_id=st.team_id AND sup_team_seasons.year_id=MAX(st.year_id) LIMIT 1) as franch_abbr, team_id, MIN(year_id) as year_min_csk, IF(comp_id='WNBA', MIN(year_id), CONCAT_WS('-', (MIN(year_id) - 1), RIGHT(MIN(year_id), 2))) as year_min, MAX(year_id) as year_max_csk, IF(comp_id='WNBA', MAX(year_id), CONCAT_WS('-', (MAX(year_id) - 1), RIGHT(MAX(year_id), 2))) as year_max, (SUM(fg))/(SUM(games)) as fg_per_season_csk, SUM(fg IS NULL) as fg_per_season_incomplete, ROUND((SUM(fg))/(SUM(games)),1) AS fg_per_season, (SUM(fga))/(SUM(games)) as fga_per_season_csk, SUM(fga IS NULL) as fga_per_season_incomplete, ROUND((SUM(fga))/(SUM(games)),1) AS fga_per_season, IF(SUM(fga), SUM(fg) / SUM(fga), NULL) as fg_pct_csk, SUM(fga IS NULL)+SUM(fg IS NULL) as fg_pct_incomplete, TRIM(LEADING '0' FROM ROUND(IF(SUM(fga), SUM(fg) / SUM(fga), NULL),3)) AS fg_pct, (SUM(fg)/(SUM(games)) - IFNULL(SUM(fg3 * (fg IS NOT NULL))/SUM(games*(fg IS NOT NULL)), 0)) as fg2_per_season_csk, NULL as fg2_per_season_incomplete, ROUND((SUM(fg)/(SUM(games)) - IFNULL(SUM(fg3 * (fg IS NOT NULL))/SUM(games*(fg IS NOT NULL)), 0)),1) AS fg2_per_season, (SUM(fga)/(SUM(games)) - IFNULL(SUM(fg3a * (fga IS NOT NULL))/SUM(games*(fga IS NOT NULL)), 0)) as fg2a_per_season_csk, NULL as fg2a_per_season_incomplete, ROUND((SUM(fga)/(SUM(games)) - IFNULL(SUM(fg3a * (fga IS NOT NULL))/SUM(games*(fga IS NOT NULL)), 0)),1) AS fg2a_per_season, SUM(fg - IFNULL(fg3, 0)) / SUM(fga - IFNULL(fg3a, 0)) as fg2_pct_csk, NULL as fg2_pct_incomplete, TRIM(LEADING '0' FROM ROUND(SUM(fg - IFNULL(fg3, 0)) / SUM(fga - IFNULL(fg3a, 0)),3)) AS fg2_pct, (SUM(fg3))/(SUM(games*(fg3 IS NOT NULL))) as fg3_per_season_csk, NULL as fg3_per_season_incomplete, ROUND((SUM(fg3))/(SUM(games*(fg3 IS NOT NULL))),1) AS fg3_per_season, (SUM(fg3a))/(SUM(games*(fg3a IS NOT NULL))) as fg3a_per_season_csk, NULL as fg3a_per_season_incomplete, ROUND((SUM(fg3a))/(SUM(games*(fg3a IS NOT NULL))),1) AS fg3a_per_season, IF(SUM(fg3a), SUM(fg3) / SUM(fg3a), NULL) as fg3_pct_csk, NULL as fg3_pct_incomplete, TRIM(LEADING '0' FROM ROUND(IF(SUM(fg3a), SUM(fg3) / SUM(fg3a), NULL),3)) AS fg3_pct, IF(SUM(fga), SUM(fg + 0.5 * IFNULL(fg3, 0)) / SUM(fga), NULL) as efg_pct_csk, NULL as efg_pct_incomplete, TRIM(LEADING '0' FROM ROUND(IF(SUM(fga), SUM(fg + 0.5 * IFNULL(fg3, 0)) / SUM(fga), NULL),3)) AS efg_pct, (SUM(ft))/(SUM(games)) as ft_per_season_csk, SUM(ft IS NULL) as ft_per_season_incomplete, ROUND((SUM(ft))/(SUM(games)),1) AS ft_per_season, (SUM(fta))/(SUM(games*(fta IS NOT NULL))) as fta_per_season_csk, SUM(fta IS NULL) as fta_per_season_incomplete, ROUND((SUM(fta))/(SUM(games*(fta IS NOT NULL))),1) AS fta_per_season, IF(SUM(fta), SUM(ft) / SUM(fta), NULL) as ft_pct_csk, SUM(fta IS NULL)+SUM(ft IS NULL) as ft_pct_incomplete, TRIM(LEADING '0' FROM ROUND(IF(SUM(fta), SUM(ft) / SUM(fta), NULL),3)) AS ft_pct, (SUM(orb))/(SUM(games*(orb IS NOT NULL))) as orb_per_season_csk, SUM(orb IS NULL) as orb_per_season_incomplete, ROUND((SUM(orb))/(SUM(games*(orb IS NOT NULL))),1) AS orb_per_season, (SUM(trb * (orb IS NOT NULL))/SUM(games*(orb IS NOT NULL)) - SUM(orb * (orb IS NOT NULL))/SUM(games*(orb IS NOT NULL))) as drb_per_season_csk, SUM(orb IS NULL)+SUM(trb IS NULL) as drb_per_season_incomplete, ROUND((SUM(trb * (orb IS NOT NULL))/SUM(games*(orb IS NOT NULL)) - SUM(orb * (orb IS NOT NULL))/SUM(games*(orb IS NOT NULL))),1) AS drb_per_season, (SUM(trb))/(SUM(games*(trb IS NOT NULL))) as trb_per_season_csk, SUM(trb IS NULL) as trb_per_season_incomplete, ROUND((SUM(trb))/(SUM(games*(trb IS NOT NULL))),1) AS trb_per_season, (SUM(ast))/(SUM(games*(ast IS NOT NULL))) as ast_per_season_csk, SUM(ast IS NULL) as ast_per_season_incomplete, ROUND((SUM(ast))/(SUM(games*(ast IS NOT NULL))),1) AS ast_per_season, (SUM(stl))/(SUM(games*(stl IS NOT NULL))) as stl_per_season_csk, SUM(stl IS NULL) as stl_per_season_incomplete, ROUND((SUM(stl))/(SUM(games*(stl IS NOT NULL))),1) AS stl_per_season, (SUM(blk))/(SUM(games*(blk IS NOT NULL))) as blk_per_season_csk, SUM(blk IS NULL) as blk_per_season_incomplete, ROUND((SUM(blk))/(SUM(games*(blk IS NOT NULL))),1) AS blk_per_season, (SUM(tov))/(SUM(games*(tov IS NOT NULL))) as tov_per_season_csk, SUM(tov IS NULL) as tov_per_season_incomplete, ROUND((SUM(tov))/(SUM(games*(tov IS NOT NULL))),1) AS tov_per_season, (SUM(pf))/(SUM(games*(pf IS NOT NULL))) as pf_per_season_csk, SUM(pf IS NULL) as pf_per_season_incomplete, ROUND((SUM(pf))/(SUM(games*(pf IS NOT NULL))),1) AS pf_per_season, (SUM(pts))/(SUM(games)) as pts_per_season_csk, SUM(pts IS NULL) as pts_per_season_incomplete, ROUND((SUM(pts))/(SUM(games)),1) AS pts_per_season, SUM(games IS NULL) as games_incomplete, SUM(games) AS games
FROM sup_team_seasons as st
  JOIN sup_phase_seasons USING (year_id, comp_id, phase_id)
WHERE ((team_id=?) OR (team_id=?))
  AND type="reg" 
GROUP BY team_id LIMIT 0, 200

SQL PARAMS -- $VAR1 = [
          'POR',
          'SAS'
        ];

Query Time: 0.01 seconds
SELECT (SELECT name_abbr FROM sup_team_seasons WHERE team_id=st.team_id AND sup_team_seasons.year_id=MAX(st.year_id) LIMIT 1) as franch_abbr, team_id, MIN(year_id) as year_min_csk, IF(comp_id='WNBA', MIN(year_id), CONCAT_WS('-', (MIN(year_id) - 1), RIGHT(MIN(year_id), 2))) as year_min, MAX(year_id) as year_max_csk, IF(comp_id='WNBA', MAX(year_id), CONCAT_WS('-', (MAX(year_id) - 1), RIGHT(MAX(year_id), 2))) as year_max, (SUM(fg))/(SUM(games)) as fg_per_season_csk, SUM(fg IS NULL) as fg_per_season_incomplete, ROUND((SUM(fg))/(SUM(games)),1) AS fg_per_season, (SUM(fga))/(SUM(games)) as fga_per_season_csk, SUM(fga IS NULL) as fga_per_season_incomplete, ROUND((SUM(fga))/(SUM(games)),1) AS fga_per_season, IF(SUM(fga), SUM(fg) / SUM(fga), NULL) as fg_pct_csk, SUM(fga IS NULL)+SUM(fg IS NULL) as fg_pct_incomplete, TRIM(LEADING '0' FROM ROUND(IF(SUM(fga), SUM(fg) / SUM(fga), NULL),3)) AS fg_pct, (SUM(fg)/(SUM(games)) - IFNULL(SUM(fg3 * (fg IS NOT NULL))/SUM(games*(fg IS NOT NULL)), 0)) as fg2_per_season_csk, NULL as fg2_per_season_incomplete, ROUND((SUM(fg)/(SUM(games)) - IFNULL(SUM(fg3 * (fg IS NOT NULL))/SUM(games*(fg IS NOT NULL)), 0)),1) AS fg2_per_season, (SUM(fga)/(SUM(games)) - IFNULL(SUM(fg3a * (fga IS NOT NULL))/SUM(games*(fga IS NOT NULL)), 0)) as fg2a_per_season_csk, NULL as fg2a_per_season_incomplete, ROUND((SUM(fga)/(SUM(games)) - IFNULL(SUM(fg3a * (fga IS NOT NULL))/SUM(games*(fga IS NOT NULL)), 0)),1) AS fg2a_per_season, SUM(fg - IFNULL(fg3, 0)) / SUM(fga - IFNULL(fg3a, 0)) as fg2_pct_csk, NULL as fg2_pct_incomplete, TRIM(LEADING '0' FROM ROUND(SUM(fg - IFNULL(fg3, 0)) / SUM(fga - IFNULL(fg3a, 0)),3)) AS fg2_pct, (SUM(fg3))/(SUM(games*(fg3 IS NOT NULL))) as fg3_per_season_csk, NULL as fg3_per_season_incomplete, ROUND((SUM(fg3))/(SUM(games*(fg3 IS NOT NULL))),1) AS fg3_per_season, (SUM(fg3a))/(SUM(games*(fg3a IS NOT NULL))) as fg3a_per_season_csk, NULL as fg3a_per_season_incomplete, ROUND((SUM(fg3a))/(SUM(games*(fg3a IS NOT NULL))),1) AS fg3a_per_season, IF(SUM(fg3a), SUM(fg3) / SUM(fg3a), NULL) as fg3_pct_csk, NULL as fg3_pct_incomplete, TRIM(LEADING '0' FROM ROUND(IF(SUM(fg3a), SUM(fg3) / SUM(fg3a), NULL),3)) AS fg3_pct, IF(SUM(fga), SUM(fg + 0.5 * IFNULL(fg3, 0)) / SUM(fga), NULL) as efg_pct_csk, NULL as efg_pct_incomplete, TRIM(LEADING '0' FROM ROUND(IF(SUM(fga), SUM(fg + 0.5 * IFNULL(fg3, 0)) / SUM(fga), NULL),3)) AS efg_pct, (SUM(ft))/(SUM(games)) as ft_per_season_csk, SUM(ft IS NULL) as ft_per_season_incomplete, ROUND((SUM(ft))/(SUM(games)),1) AS ft_per_season, (SUM(fta))/(SUM(games*(fta IS NOT NULL))) as fta_per_season_csk, SUM(fta IS NULL) as fta_per_season_incomplete, ROUND((SUM(fta))/(SUM(games*(fta IS NOT NULL))),1) AS fta_per_season, IF(SUM(fta), SUM(ft) / SUM(fta), NULL) as ft_pct_csk, SUM(fta IS NULL)+SUM(ft IS NULL) as ft_pct_incomplete, TRIM(LEADING '0' FROM ROUND(IF(SUM(fta), SUM(ft) / SUM(fta), NULL),3)) AS ft_pct, (SUM(orb))/(SUM(games*(orb IS NOT NULL))) as orb_per_season_csk, SUM(orb IS NULL) as orb_per_season_incomplete, ROUND((SUM(orb))/(SUM(games*(orb IS NOT NULL))),1) AS orb_per_season, (SUM(trb * (orb IS NOT NULL))/SUM(games*(orb IS NOT NULL)) - SUM(orb * (orb IS NOT NULL))/SUM(games*(orb IS NOT NULL))) as drb_per_season_csk, SUM(orb IS NULL)+SUM(trb IS NULL) as drb_per_season_incomplete, ROUND((SUM(trb * (orb IS NOT NULL))/SUM(games*(orb IS NOT NULL)) - SUM(orb * (orb IS NOT NULL))/SUM(games*(orb IS NOT NULL))),1) AS drb_per_season, (SUM(trb))/(SUM(games*(trb IS NOT NULL))) as trb_per_season_csk, SUM(trb IS NULL) as trb_per_season_incomplete, ROUND((SUM(trb))/(SUM(games*(trb IS NOT NULL))),1) AS trb_per_season, (SUM(ast))/(SUM(games*(ast IS NOT NULL))) as ast_per_season_csk, SUM(ast IS NULL) as ast_per_season_incomplete, ROUND((SUM(ast))/(SUM(games*(ast IS NOT NULL))),1) AS ast_per_season, (SUM(stl))/(SUM(games*(stl IS NOT NULL))) as stl_per_season_csk, SUM(stl IS NULL) as stl_per_season_incomplete, ROUND((SUM(stl))/(SUM(games*(stl IS NOT NULL))),1) AS stl_per_season, (SUM(blk))/(SUM(games*(blk IS NOT NULL))) as blk_per_season_csk, SUM(blk IS NULL) as blk_per_season_incomplete, ROUND((SUM(blk))/(SUM(games*(blk IS NOT NULL))),1) AS blk_per_season, (SUM(tov))/(SUM(games*(tov IS NOT NULL))) as tov_per_season_csk, SUM(tov IS NULL) as tov_per_season_incomplete, ROUND((SUM(tov))/(SUM(games*(tov IS NOT NULL))),1) AS tov_per_season, (SUM(pf))/(SUM(games*(pf IS NOT NULL))) as pf_per_season_csk, SUM(pf IS NULL) as pf_per_season_incomplete, ROUND((SUM(pf))/(SUM(games*(pf IS NOT NULL))),1) AS pf_per_season, (SUM(pts))/(SUM(games)) as pts_per_season_csk, SUM(pts IS NULL) as pts_per_season_incomplete, ROUND((SUM(pts))/(SUM(games)),1) AS pts_per_season, SUM(games IS NULL) as games_incomplete, SUM(games) AS games
FROM sup_team_seasons as st
  JOIN sup_phase_seasons USING (year_id, comp_id, phase_id)
WHERE ((team_id=?) OR (team_id=?))
  AND phase_id="PST" 
GROUP BY team_id LIMIT 0, 200

SQL PARAMS -- $VAR1 = [
          'POR',
          'SAS'
        ];

Query Time: 0.00 seconds
Table Build Time: 0.04 seconds

Table Build Time: 0.04 seconds


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

overall_sum

Page Setup Time: 0.00172 seconds

SELECT (SELECT name_abbr FROM sup_team_seasons WHERE team_id=st.team_id AND sup_team_seasons.year_id=MAX(st.year_id) LIMIT 1) as franch_abbr, team_id, MIN(year_id) as year_min_csk, IF(comp_id='WNBA', MIN(year_id), CONCAT_WS('-', (MIN(year_id) - 1), RIGHT(MIN(year_id), 2))) as year_min, MAX(year_id) as year_max_csk, IF(comp_id='WNBA', MAX(year_id), CONCAT_WS('-', (MAX(year_id) - 1), RIGHT(MAX(year_id), 2))) as year_max, SUM(wins IS NULL) as wins_incomplete, SUM(wins) AS wins, SUM(losses IS NULL) as losses_incomplete, SUM(losses) AS losses, SUM(games IS NULL) as games_incomplete, SUM(games) AS games, SUM(fg IS NULL) as fg_incomplete, SUM(fg) AS fg, SUM(fga IS NULL) as fga_incomplete, SUM(fga) AS fga, IF(SUM(fga), SUM(fg) / SUM(fga), NULL) as fg_pct_csk, SUM(fga IS NULL)+SUM(fg IS NULL) as fg_pct_incomplete, TRIM(LEADING '0' FROM ROUND(IF(SUM(fga), SUM(fg) / SUM(fga), NULL),3)) AS fg_pct, NULL as fg2_incomplete, SUM(fg - IFNULL(fg3, 0)) AS fg2, NULL as fg2a_incomplete, SUM(fga - IFNULL(fg3a, 0)) AS fg2a, SUM(fg - IFNULL(fg3, 0)) / SUM(fga - IFNULL(fg3a, 0)) as fg2_pct_csk, NULL as fg2_pct_incomplete, TRIM(LEADING '0' FROM ROUND(SUM(fg - IFNULL(fg3, 0)) / SUM(fga - IFNULL(fg3a, 0)),3)) AS fg2_pct, NULL as fg3_incomplete, SUM(fg3) AS fg3, NULL as fg3a_incomplete, SUM(fg3a) AS fg3a, IF(SUM(fg3a), SUM(fg3) / SUM(fg3a), NULL) as fg3_pct_csk, NULL as fg3_pct_incomplete, TRIM(LEADING '0' FROM ROUND(IF(SUM(fg3a), SUM(fg3) / SUM(fg3a), NULL),3)) AS fg3_pct, IF(SUM(fga), SUM(fg + 0.5 * IFNULL(fg3, 0)) / SUM(fga), NULL) as efg_pct_csk, NULL as efg_pct_incomplete, TRIM(LEADING '0' FROM ROUND(IF(SUM(fga), SUM(fg + 0.5 * IFNULL(fg3, 0)) / SUM(fga), NULL),3)) AS efg_pct, SUM(ft IS NULL) as ft_incomplete, SUM(ft) AS ft, SUM(fta IS NULL) as fta_incomplete, SUM(fta) AS fta, IF(SUM(fta), SUM(ft) / SUM(fta), NULL) as ft_pct_csk, SUM(fta IS NULL)+SUM(ft IS NULL) as ft_pct_incomplete, TRIM(LEADING '0' FROM ROUND(IF(SUM(fta), SUM(ft) / SUM(fta), NULL),3)) AS ft_pct, SUM(orb IS NULL) as orb_incomplete, SUM(orb) AS orb, SUM(trb IS NULL)+SUM(orb IS NULL) as drb_incomplete, SUM(trb - orb) AS drb, SUM(trb IS NULL) as trb_incomplete, SUM(trb) AS trb, SUM(ast IS NULL) as ast_incomplete, SUM(ast) AS ast, SUM(stl IS NULL) as stl_incomplete, SUM(stl) AS stl, SUM(blk IS NULL) as blk_incomplete, SUM(blk) AS blk, SUM(tov IS NULL) as tov_incomplete, SUM(tov) AS tov, SUM(pf IS NULL) as pf_incomplete, SUM(pf) AS pf, SUM(pts IS NULL) as pts_incomplete, SUM(pts) AS pts
FROM sup_team_seasons as st
  JOIN sup_phase_seasons USING (year_id, comp_id, phase_id)
WHERE ((team_id=?) OR (team_id=?))
  AND type="reg" 
GROUP BY team_id LIMIT 0, 200

SQL PARAMS -- $VAR1 = [
          'POR',
          'SAS'
        ];

Query Time: 0.01 seconds
SELECT (SELECT name_abbr FROM sup_team_seasons WHERE team_id=st.team_id AND sup_team_seasons.year_id=MAX(st.year_id) LIMIT 1) as franch_abbr, team_id, MIN(year_id) as year_min_csk, IF(comp_id='WNBA', MIN(year_id), CONCAT_WS('-', (MIN(year_id) - 1), RIGHT(MIN(year_id), 2))) as year_min, MAX(year_id) as year_max_csk, IF(comp_id='WNBA', MAX(year_id), CONCAT_WS('-', (MAX(year_id) - 1), RIGHT(MAX(year_id), 2))) as year_max, SUM(wins IS NULL) as wins_incomplete, SUM(wins) AS wins, SUM(losses IS NULL) as losses_incomplete, SUM(losses) AS losses, SUM(games IS NULL) as games_incomplete, SUM(games) AS games, SUM(fg IS NULL) as fg_incomplete, SUM(fg) AS fg, SUM(fga IS NULL) as fga_incomplete, SUM(fga) AS fga, IF(SUM(fga), SUM(fg) / SUM(fga), NULL) as fg_pct_csk, SUM(fga IS NULL)+SUM(fg IS NULL) as fg_pct_incomplete, TRIM(LEADING '0' FROM ROUND(IF(SUM(fga), SUM(fg) / SUM(fga), NULL),3)) AS fg_pct, NULL as fg2_incomplete, SUM(fg - IFNULL(fg3, 0)) AS fg2, NULL as fg2a_incomplete, SUM(fga - IFNULL(fg3a, 0)) AS fg2a, SUM(fg - IFNULL(fg3, 0)) / SUM(fga - IFNULL(fg3a, 0)) as fg2_pct_csk, NULL as fg2_pct_incomplete, TRIM(LEADING '0' FROM ROUND(SUM(fg - IFNULL(fg3, 0)) / SUM(fga - IFNULL(fg3a, 0)),3)) AS fg2_pct, NULL as fg3_incomplete, SUM(fg3) AS fg3, NULL as fg3a_incomplete, SUM(fg3a) AS fg3a, IF(SUM(fg3a), SUM(fg3) / SUM(fg3a), NULL) as fg3_pct_csk, NULL as fg3_pct_incomplete, TRIM(LEADING '0' FROM ROUND(IF(SUM(fg3a), SUM(fg3) / SUM(fg3a), NULL),3)) AS fg3_pct, IF(SUM(fga), SUM(fg + 0.5 * IFNULL(fg3, 0)) / SUM(fga), NULL) as efg_pct_csk, NULL as efg_pct_incomplete, TRIM(LEADING '0' FROM ROUND(IF(SUM(fga), SUM(fg + 0.5 * IFNULL(fg3, 0)) / SUM(fga), NULL),3)) AS efg_pct, SUM(ft IS NULL) as ft_incomplete, SUM(ft) AS ft, SUM(fta IS NULL) as fta_incomplete, SUM(fta) AS fta, IF(SUM(fta), SUM(ft) / SUM(fta), NULL) as ft_pct_csk, SUM(fta IS NULL)+SUM(ft IS NULL) as ft_pct_incomplete, TRIM(LEADING '0' FROM ROUND(IF(SUM(fta), SUM(ft) / SUM(fta), NULL),3)) AS ft_pct, SUM(orb IS NULL) as orb_incomplete, SUM(orb) AS orb, SUM(trb IS NULL)+SUM(orb IS NULL) as drb_incomplete, SUM(trb - orb) AS drb, SUM(trb IS NULL) as trb_incomplete, SUM(trb) AS trb, SUM(ast IS NULL) as ast_incomplete, SUM(ast) AS ast, SUM(stl IS NULL) as stl_incomplete, SUM(stl) AS stl, SUM(blk IS NULL) as blk_incomplete, SUM(blk) AS blk, SUM(tov IS NULL) as tov_incomplete, SUM(tov) AS tov, SUM(pf IS NULL) as pf_incomplete, SUM(pf) AS pf, SUM(pts IS NULL) as pts_incomplete, SUM(pts) AS pts
FROM sup_team_seasons as st
  JOIN sup_phase_seasons USING (year_id, comp_id, phase_id)
WHERE ((team_id=?) OR (team_id=?))
  AND phase_id="PST" 
GROUP BY team_id LIMIT 0, 200

SQL PARAMS -- $VAR1 = [
          'POR',
          'SAS'
        ];

Query Time: 0.00 seconds
Table Build Time: 0.04 seconds

Table Build Time: 0.04 seconds


--------------------------------------
SH->PARAM -- $VAR1 = {
          'match' => 'versus_teamvteam',
          't1yrto' => 2026,
          't2yrto' => 2026,
          'team_id2' => 'SAS',
          'team_id1' => 'POR'
        };
SH->PARAM_NO_DEFAULT -- $VAR1 = {
          'team_id1' => 'POR',
          'match' => 'versus_teamvteam',
          'team_id2' => 'SAS'
        };

Show Criteria

Compare Players

Head-to-head stats or multi-player comparisons

Compare Teams

Head-to-head results and comparisons

Player vs. Team

Head-to-head stats for a single player against a team

Search Criteria

Seasons

All seasons

Choose season(s) for each choice

Choose same season(s) for all choices

Team 1

Team 2

Clear All

You have edited your search criteria

or keep editing your search

clear changes

Fetching Results

San Antonio Spurs

Portland Trail Blazers

99-93

14-6

Reg Season

Playoffs

93-99

6-14

4715

2732

1983

.579

106.6

104.2

W/L%

PS/G

PA/G

Playoff Apps.

Finals Apps.

Championships

4467

2337

2130

.523

105.3

104.5

Portland Trail Blazers vs. San Antonio Spurs: Head-to-Head Stats

Portland Trail Blazers vs. San Antonio Spurs: Recent Games

Regular Season

Subscribe to Stathead Pro Basketball for full results.

Go inside the Pro Basketball database and access the sports search engine that was made for fans like you. Subscriptions start at just $9/month. Learn More.

Get your first month FREE

Already a paid subscriber? Log in for full results.

Portland Trail Blazers vs. San Antonio Spurs: Recent Games Table
Rk	Date	POR		SAS	Venue	City
1	2025-11-26	102		115	Moda Center	Portland
2	2025-04-06	120		109	Moda Center	Portland
3	2024-12-21	94	@	114	Frost Bank Center	San Antonio
4	2024-12-13	116		118	Moda Center	Portland
5	2024-11-07	105	@	118	Frost Bank Center	San Antonio
6	2024-01-26	100	@	116	Frost Bank Center	San Antonio
7	2023-12-29	134		128	Moda Center	Portland
8	2023-12-28	105		118	Moda Center	Portland
9	2023-04-06	127	@	129	Moody Center	Austin
10	2023-01-23	147		127	Moda Center	Portland

Portland Trail Blazers vs. San Antonio Spurs: Head-to-Head Stats Per Game

Regular Season

Playoffs

Portland Trail Blazers vs. San Antonio Spurs: Head-to-Head Stats Per Game Table
Rk	Team	From	To	FG	FGA	FG%	2P	2PA	2P%	3P	3PA	3P%	eFG%	FT	FTA	FT%	ORB	DRB	TRB	AST	STL	BLK	TOV	PF	PTS
1	POR	1976-77	2025-26	40.4	87.2	.463	35.3	73.0	.483	5.4	15.0	.361	.493	18.6	24.4	.761	13.0	29.6	42.6	23.0	8.1	5.0	14.8	22.6	104.5
2	SAS	1976-77	2025-26	40.0	84.0	.477	35.0	70.5	.497	5.3	14.3	.371	.506	20.0	26.3	.762	12.0	30.8	42.9	24.1	7.5	5.3	15.7	21.2	105.1

Portland Trail Blazers vs. San Antonio Spurs: Head-to-Head Stats Per Game Table
Rk	Team	From	To	FG	FGA	FG%	2P	2PA	2P%	3P	3PA	3P%	eFG%	FT	FTA	FT%	ORB	DRB	TRB	AST	STL	BLK	TOV	PF	PTS
1	POR	1989-90	2013-14	35.5	84.7	.419	31.5	72.7	.433	4.1	12.0	.339	.443	22.2	29.6	.750	14.2	29.5	43.7	20.2	7.1	4.6	15.6	23.6	97.3
2	SAS	1989-90	2013-14	40.7	85.8	.474	37.0	75.4	.491	3.7	10.4	.351	.495	18.6	25.4	.730	12.8	30.9	43.7	24.5	7.8	5.8	13.5	25.5	103.5

Portland Trail Blazers vs. San Antonio Spurs: Head-to-Head Stats Totals

Regular Season

Playoffs

Portland Trail Blazers vs. San Antonio Spurs: Head-to-Head Stats Totals Table
Rk	Team	From	To	W	L	G	FG	FGA	FG%	2P	2PA	2P%	3P	3PA	3P%	eFG%	FT	FTA	FT%	ORB	DRB	TRB	AST	STL	BLK	TOV	PF	PTS
1	POR	1976-77	2025-26	93	99	192	7756	16740	.463	6776	14022	.483	980	2718	.361	.493	3568	4691	.761	2492	5685	8177	4411	1554	963	2837	4343	20060
2	SAS	1976-77	2025-26	99	93	192	7687	16129	.477	6726	13539	.497	961	2590	.371	.506	3848	5048	.762	2310	5921	8231	4619	1431	1014	3007	4074	20183

Portland Trail Blazers vs. San Antonio Spurs: Head-to-Head Stats Totals Table
Rk	Team	From	To	W	L	G	FG	FGA	FG%	2P	2PA	2P%	3P	3PA	3P%	eFG%	FT	FTA	FT%	ORB	DRB	TRB	AST	STL	BLK	TOV	PF	PTS
1	POR	1989-90	2013-14	6	14	20	710	1693	.419	629	1454	.433	81	239	.339	.443	444	592	.750	284	589	873	403	141	92	312	471	1945
2	SAS	1989-90	2013-14	14	6	20	813	1715	.474	740	1507	.491	73	208	.351	.495	371	508	.730	256	617	873	489	156	115	270	510	2070

Portland Trail Blazers vs. San Antonio Spurs: Team Comparison

Portland Trail Blazers vs. San Antonio Spurs: Overall Stats Per Game

Regular Season

Playoffs

Portland Trail Blazers vs. San Antonio Spurs: Overall Stats Per Game Table
Rk	Team	From	To	FG	FGA	FG%	2P	2PA	2P%	3P	3PA	3P%	eFG%	FT	FTA	FT%	ORB	DRB	TRB	AST	STL	BLK	TOV	PF	PTS
1	POR	1970-71	2025-26	40.2	86.5	.465	35.3	72.5	.486	5.9	16.8	.354	.493	19.9	26.4	.755	13.1	30.8	44.2	23.5	8.1	5.0	16.3	22.5	105.3
2	SAS	1967-68	2025-26	40.9	86.4	.474	36.3	73.6	.494	4.8	13.4	.359	.500	20.2	26.7	.758	12.7	32.1	44.9	24.0	8.0	5.7	15.8	21.9	106.6

Portland Trail Blazers vs. San Antonio Spurs: Overall Stats Per Game Table
Rk	Team	From	To	FG	FGA	FG%	2P	2PA	2P%	3P	3PA	3P%	eFG%	FT	FTA	FT%	ORB	DRB	TRB	AST	STL	BLK	TOV	PF	PTS
1	POR	1976-77	2020-21	38.2	84.4	.453	33.2	70.3	.473	5.5	15.7	.351	.482	21.2	28.2	.751	12.9	29.7	42.6	21.9	7.6	4.7	14.9	25.1	102.6
2	SAS	1967-68	2018-19	38.1	82.7	.460	33.2	69.2	.480	5.1	14.3	.359	.490	19.7	26.7	.740	11.9	31.4	43.7	21.5	7.2	5.5	14.4	22.7	100.8

Portland Trail Blazers vs. San Antonio Spurs: Overall Stats Totals

Regular Season

Playoffs

Portland Trail Blazers vs. San Antonio Spurs: Overall Stats Totals Table
Rk	Team	From	To	W	L	G	FG	FGA	FG%	2P	2PA	2P%	3P	3PA	3P%	eFG%	FT	FTA	FT%	ORB	DRB	TRB	AST	STL	BLK	TOV	PF	PTS
1	POR	1970-71	2025-26	2337	2130	4467	179681	386554	.465	157527	324005	.486	22154	62549	.354	.493	89005	117882	.755	55489	129932	197555	105133	34323	21017	72748	100697	470521
2	SAS	1967-68	2025-26	2732	1983	4715	192847	407151	.474	171296	347044	.494	21551	60107	.359	.500	95346	125752	.758	58769	148815	211614	113027	33750	23880	74675	103323	502591

Portland Trail Blazers vs. San Antonio Spurs: Overall Stats Totals Table
Rk	Team	From	To	W	L	G	FG	FGA	FG%	2P	2PA	2P%	3P	3PA	3P%	eFG%	FT	FTA	FT%	ORB	DRB	TRB	AST	STL	BLK	TOV	PF	PTS
1	POR	1976-77	2020-21	119	155	274	10470	23136	.453	9110	19266	.473	1360	3870	.351	.482	5812	7739	.751	3527	8143	11670	6007	2079	1298	4069	6869	28112
2	SAS	1967-68	2018-19	239	213	452	17219	37395	.460	15019	31260	.480	2200	6135	.359	.490	8916	12054	.740	5072	13390	19772	9733	3037	2308	6448	10269	45554

Data coverage:

Game data: since 1946-47 unless otherwise noted. Regular season: PTS, FG, FT, 3P complete all-time. FTA complete back to 1948-49. FGA, TRB, AST, PF, GS over 99% complete back to 1975-76. MP over 99% complete back to 1976-77. +/- complete back to 1996-97. All other box score stats (3PA, ORB, DRB, STL, BLK, TOV) complete back to 1983-84. Playoffs: PTS, FG, FT, FTA, 3P, 3PA complete all-time. PF complete back to 1948-49. FGA, TRB, AST complete back to 1962-63. GS complete back to 1973-74. MP complete back to 1974-75. +/- complete back to 1996-97. STL, BLK, TOV complete back to 1982-83. ORB, DRB complete back to 1983-84. BPM not available for WNBA & ABA.

Season data: since 1946-47 unless otherwise noted. All box score stats are covered all-time (though not all stats were tracked for all of NBA history). PER since 1951-52. AST% since 1964-65. TRB% since 1970-71. BPM, VORP, DRtg and Per 100 Poss stats since 1973-74. ORtg since 1977-78. GS since 1981-82. Some stats were available earlier in the ABA. WNBA all-time (since 1997) unless otherwise noted. BPM and VORP not available for WNBA.

Please see our data coverage page for details.

If you utilize material unique to a Sports Reference site for a tweet, an article, or for research for a broadcast or podcast, please strongly consider citing this site as the source for the material. It would be greatly appreciated and would help us continue to produce this material.

Portland Trail Blazers vs. San Antonio Spurs: Head-to-Head Reg Season and Playoffs Stats Comparison

Compare Players

Compare Teams

Player vs. Team

Search Criteria

Portland Trail Blazers vs. San Antonio Spurs: Head-to-Head Stats

Portland Trail Blazers vs. San Antonio Spurs: Recent Games

Portland Trail Blazers vs. San Antonio Spurs: Recent Games

Subscribe to Stathead Pro Basketball for full results.

Portland Trail Blazers vs. San Antonio Spurs: Head-to-Head Stats Per Game

Portland Trail Blazers vs. San Antonio Spurs: Head-to-Head Stats Per Game

Portland Trail Blazers vs. San Antonio Spurs: Head-to-Head Stats Totals

Portland Trail Blazers vs. San Antonio Spurs: Head-to-Head Stats Totals

Portland Trail Blazers vs. San Antonio Spurs: Team Comparison

Portland Trail Blazers vs. San Antonio Spurs: Overall Stats Per Game

Portland Trail Blazers vs. San Antonio Spurs: Overall Stats Per Game

Portland Trail Blazers vs. San Antonio Spurs: Overall Stats Totals

Portland Trail Blazers vs. San Antonio Spurs: Overall Stats Totals

Full Site Menu

FAQs, Tip & Tricks