James Harden vs. Dallas Mavericks

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_pvt_summary

WITH
  rspvt AS (
SELECT person_id, COUNT(*) as games, SUM(win=1) as wins, SUM(loss=1) as losses, SUM(tie=1) as ties, (SUM(pts))/(COUNT(*)) as pts_per_pvt_csk, ROUND((SUM(pts))/(COUNT(*)),1) AS pts_per_pvt, (SUM(trb))/((COUNT(*)-SUM(trb IS NULL))) as trb_per_pvt_csk, ROUND((SUM(trb))/((COUNT(*)-SUM(trb IS NULL))),1) AS trb_per_pvt, (SUM(ast))/((COUNT(*)-SUM(ast IS NULL))) as ast_per_pvt_csk, ROUND((SUM(ast))/((COUNT(*)-SUM(ast IS NULL))),1) AS ast_per_pvt
FROM sup_player_games as st
  JOIN (SELECT win, loss, tie, game_id, year_id, comp_id, phase_id, team_id, opp_team_id FROM sup_team_games) as tg USING (game_id, team_id)
  JOIN sup_games USING (game_id)
  JOIN sup_phase_seasons USING (comp_id, phase_id, year_id)
WHERE ((person_id=?))
  AND opp_team_id=?
  AND type="reg"  
  ),
  popvt AS (
SELECT person_id, COUNT(*) as games, SUM(win=1) as wins, SUM(loss=1) as losses, (SUM(pts))/(COUNT(*)) as pts_per_pvt_csk, ROUND((SUM(pts))/(COUNT(*)),1) AS pts_per_pvt, (SUM(trb))/((COUNT(*)-SUM(trb IS NULL))) as trb_per_pvt_csk, ROUND((SUM(trb))/((COUNT(*)-SUM(trb IS NULL))),1) AS trb_per_pvt, (SUM(ast))/((COUNT(*)-SUM(ast IS NULL))) as ast_per_pvt_csk, ROUND((SUM(ast))/((COUNT(*)-SUM(ast IS NULL))),1) AS ast_per_pvt
FROM sup_player_games as st
  JOIN (SELECT win, loss, tie, game_id, year_id, comp_id, phase_id, team_id, opp_team_id FROM sup_team_games) as tg USING (game_id, team_id)
  JOIN sup_games USING (game_id)
  JOIN sup_phase_seasons USING (comp_id, phase_id, year_id)
WHERE ((person_id=?))
  AND opp_team_id=?
  AND type="post"  
  )
SELECT rspvt.person_id, rspvt.games as rspvt_games, rspvt.wins as rspvt_wins, rspvt.losses as rspvt_losses, rspvt.ties as rspvt_ties, popvt.games as popvt_games, popvt.wins as popvt_wins, popvt.losses as popvt_losses, rspvt.pts_per_pvt AS rspvt_pts_per_pvt, popvt.pts_per_pvt AS popvt_pts_per_pvt, rspvt.trb_per_pvt AS rspvt_trb_per_pvt, popvt.trb_per_pvt AS popvt_trb_per_pvt, rspvt.ast_per_pvt AS rspvt_ast_per_pvt, popvt.ast_per_pvt AS popvt_ast_per_pvt
FROM rspvt
  JOIN popvt
WHERE 1  LIMIT 0, 200

SQL PARAMS -- $VAR1 = [
          'hardeja01',
          'DAL',
          'hardeja01',
          'DAL'
        ];

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

pvt_per_game

Page Setup Time: 0.00576 seconds

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, GROUP_CONCAT(DISTINCT CONCAT('<a href="', 'DOMAIN', ts.link, '" target="_blank">', ts.name_abbr, '</a>')) as teams_played_for, (SUM(mp))/((COUNT(*)-SUM(mp IS NULL))) as mp_per_g_csk, ROUND((SUM(mp))/((COUNT(*)-SUM(mp IS NULL))),1) AS mp_per_g, (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, (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, (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, (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, (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_player_games as st
  JOIN (SELECT game_id, year_id, comp_id, phase_id, 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, team_id)
  JOIN sup_phase_seasons USING (comp_id, phase_id, year_id)
  JOIN (SELECT team_id, year_id, name_abbr, name, link, phase_id FROM sup_team_seasons) as ts USING (team_id, year_id, phase_id)
WHERE ((person_id=?))
  AND opp_team_id=?
  AND type="reg" 
GROUP BY year_id
ORDER BY year_id LIMIT 0, 200

SQL PARAMS -- $VAR1 = [
          'hardeja01',
          'DAL'
        ];

Query Time: 0.02 seconds
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, GROUP_CONCAT(DISTINCT CONCAT('<a href="', 'DOMAIN', ts.link, '" target="_blank">', ts.name_abbr, '</a>')) as teams_played_for, (SUM(mp))/((COUNT(*)-SUM(mp IS NULL))) as mp_per_g_csk, ROUND((SUM(mp))/((COUNT(*)-SUM(mp IS NULL))),1) AS mp_per_g, (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, (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, (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, (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, (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_player_games as st
  JOIN (SELECT game_id, year_id, comp_id, phase_id, 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, team_id)
  JOIN sup_phase_seasons USING (comp_id, phase_id, year_id)
  JOIN (SELECT team_id, year_id, name_abbr, name, link, phase_id FROM sup_team_seasons) as ts USING (team_id, year_id, phase_id)
WHERE ((person_id=?))
  AND opp_team_id=?
  AND type="post" 
GROUP BY year_id
ORDER BY year_id LIMIT 0, 200

SQL PARAMS -- $VAR1 = [
          'hardeja01',
          'DAL'
        ];

Query Time: 0.02 seconds
Table Build Time: 0.05 seconds

Table Build Time: 0.04 seconds


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

pvt_totals

Page Setup Time: 0.00163 seconds

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, GROUP_CONCAT(DISTINCT CONCAT('<a href="', 'DOMAIN', ts.link, '" target="_blank">', ts.name_abbr, '</a>')) as teams_played_for, COUNT(*) AS games, SUM(is_starter) AS games_started, SUM(mp) AS mp, 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, IF(SUM(fga + fta), SUM((fga IS NOT NULL AND fta IS NOT NULL) * pts) / SUM(2 * (fga + (0.44 * fta))), NULL) as ts_pct_csk, TRIM(LEADING '0' FROM ROUND(IF(SUM(fga + fta), SUM((fga IS NOT NULL AND fta IS NOT NULL) * pts) / SUM(2 * (fga + (0.44 * fta))), NULL),3)) AS ts_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_player_games as st
  JOIN (SELECT game_id, year_id, comp_id, phase_id, 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, team_id)
  JOIN sup_phase_seasons USING (comp_id, phase_id, year_id)
  JOIN (SELECT team_id, year_id, name_abbr, name, link, phase_id FROM sup_team_seasons) as ts USING (team_id, year_id, phase_id)
WHERE ((person_id=?))
  AND opp_team_id=?
  AND type="reg" 
GROUP BY year_id
ORDER BY year_id LIMIT 0, 200

SQL PARAMS -- $VAR1 = [
          'hardeja01',
          'DAL'
        ];

Query Time: 0.02 seconds
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, GROUP_CONCAT(DISTINCT CONCAT('<a href="', 'DOMAIN', ts.link, '" target="_blank">', ts.name_abbr, '</a>')) as teams_played_for, COUNT(*) AS games, SUM(is_starter) AS games_started, SUM(mp) AS mp, 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, IF(SUM(fga + fta), SUM((fga IS NOT NULL AND fta IS NOT NULL) * pts) / SUM(2 * (fga + (0.44 * fta))), NULL) as ts_pct_csk, TRIM(LEADING '0' FROM ROUND(IF(SUM(fga + fta), SUM((fga IS NOT NULL AND fta IS NOT NULL) * pts) / SUM(2 * (fga + (0.44 * fta))), NULL),3)) AS ts_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_player_games as st
  JOIN (SELECT game_id, year_id, comp_id, phase_id, 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, team_id)
  JOIN sup_phase_seasons USING (comp_id, phase_id, year_id)
  JOIN (SELECT team_id, year_id, name_abbr, name, link, phase_id FROM sup_team_seasons) as ts USING (team_id, year_id, phase_id)
WHERE ((person_id=?))
  AND opp_team_id=?
  AND type="post" 
GROUP BY year_id
ORDER BY year_id LIMIT 0, 200

SQL PARAMS -- $VAR1 = [
          'hardeja01',
          'DAL'
        ];

Query Time: 0.02 seconds
Table Build Time: 0.06 seconds

Table Build Time: 0.04 seconds


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

pvt_gamelogs

Page Setup Time: 0.00208 seconds

SELECT age_on_day, ts.name_abbr as team_name_abbr, ts.link as team_link, opp_team_link, date, game_id, sup_games.link as game_link, year_id as year_id_csk, IF(comp_id="WNBA", year_id, 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, os.name_abbr as opp_name_abbr, is_starter as is_starter_csk, IF(is_starter,'*','') AS is_starter, mp, 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, IF(fga + fta, pts / (2 * (fga + 0.44 * fta)), NULL) as ts_pct_csk, TRIM(LEADING '0' FROM ROUND(IF(fga + fta, pts / (2 * (fga + 0.44 * fta)), NULL),3)) AS ts_pct, orb, trb - orb AS drb, trb, ast, stl, blk, tov, pf, pts, pts + 0.4 * fg - 0.7 * fga - 0.4 * (fta - ft) + 0.7 * orb + 0.3 * (trb - orb) + stl + 0.7 * ast + 0.7 * blk - 0.4 * pf - tov as game_score_csk, ROUND(pts + 0.4 * fg - 0.7 * fga - 0.4 * (fta - ft) + 0.7 * orb + 0.3 * (trb - orb) + stl + 0.7 * ast + 0.7 * blk - 0.4 * pf - tov,1) AS game_score, bpm as bpm_csk, ROUND(bpm,1) AS bpm
FROM sup_player_games as st
  JOIN sup_games USING (game_id)
  JOIN sup_people USING (person_id)
  JOIN sup_players USING (person_id)
  JOIN (SELECT game_id, year_id, comp_id, phase_id, part_id, team_id, opp_team_id, opp_comp_id, opp_phase_id, team_game_num_season, home_away_neutral, win, loss, tie FROM sup_team_games) as tg USING (game_id, team_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 FROM sup_team_seasons GROUP BY team_id, year_id ) as ts USING (team_id, year_id)
  JOIN (SELECT team_id as opp_team_id, year_id, name_abbr, link as opp_team_link FROM sup_team_seasons GROUP BY team_id, year_id ) as os USING (opp_team_id, year_id)
WHERE ((person_id=?))
  AND opp_team_id=?
  AND type="reg" 
ORDER BY date DESC LIMIT 0, 20

SQL PARAMS -- $VAR1 = [
          'hardeja01',
          'DAL'
        ];

Query Time: 0.08 seconds
SELECT age_on_day, ts.name_abbr as team_name_abbr, ts.link as team_link, opp_team_link, date, game_id, sup_games.link as game_link, year_id as year_id_csk, IF(comp_id="WNBA", year_id, 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, os.name_abbr as opp_name_abbr, is_starter as is_starter_csk, IF(is_starter,'*','') AS is_starter, mp, 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, IF(fga + fta, pts / (2 * (fga + 0.44 * fta)), NULL) as ts_pct_csk, TRIM(LEADING '0' FROM ROUND(IF(fga + fta, pts / (2 * (fga + 0.44 * fta)), NULL),3)) AS ts_pct, orb, trb - orb AS drb, trb, ast, stl, blk, tov, pf, pts, pts + 0.4 * fg - 0.7 * fga - 0.4 * (fta - ft) + 0.7 * orb + 0.3 * (trb - orb) + stl + 0.7 * ast + 0.7 * blk - 0.4 * pf - tov as game_score_csk, ROUND(pts + 0.4 * fg - 0.7 * fga - 0.4 * (fta - ft) + 0.7 * orb + 0.3 * (trb - orb) + stl + 0.7 * ast + 0.7 * blk - 0.4 * pf - tov,1) AS game_score, bpm as bpm_csk, ROUND(bpm,1) AS bpm
FROM sup_player_games as st
  JOIN sup_games USING (game_id)
  JOIN sup_people USING (person_id)
  JOIN sup_players USING (person_id)
  JOIN (SELECT game_id, year_id, comp_id, phase_id, part_id, team_id, opp_team_id, opp_comp_id, opp_phase_id, team_game_num_season, home_away_neutral, win, loss, tie FROM sup_team_games) as tg USING (game_id, team_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 FROM sup_team_seasons GROUP BY team_id, year_id ) as ts USING (team_id, year_id)
  JOIN (SELECT team_id as opp_team_id, year_id, name_abbr, link as opp_team_link FROM sup_team_seasons GROUP BY team_id, year_id ) as os USING (opp_team_id, year_id)
WHERE ((person_id=?))
  AND opp_team_id=?
  AND type="post" 
ORDER BY date DESC LIMIT 0, 20

SQL PARAMS -- $VAR1 = [
          'hardeja01',
          'DAL'
        ];

Query Time: 0.13 seconds
Table Build Time: 0.05 seconds

Table Build Time: 0.06 seconds


--------------------------------------
SH->PARAM -- $VAR1 = {
          'team_id1' => 'DAL',
          't1yrto' => 2026,
          't2yrto' => 2026,
          'player_id1' => 'hardeja01',
          'match' => 'versus_playervteam'
        };
SH->PARAM_NO_DEFAULT -- $VAR1 = {
          'player_id1' => 'hardeja01',
          'match' => 'versus_playervteam',
          'team_id1' => 'DAL'
        };

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

Player 1

Javascript is required for the selection of a player.

Choice is: James Harden

Team 1

Team 2

Clear All

You have edited your search criteria

or keep editing your search

clear changes

Fetching Results

James Harden vs. Dallas Mavericks

Regular Season: 54 GP (33-21), 23.1 PTS, 6.1 TRB, 7.5 AST

Playoffs: 20 GP (11-9), 20.7 PTS, 4.9 TRB, 6.1 AST

James Harden vs. Dallas Mavericks: Per Game

Regular Season

Playoffs

James Harden vs. Dallas Mavericks: Per Game Table
Rk	Season	Team	MP	FG	FGA	2P	2PA	3P	3PA	FT	FTA	ORB	DRB	TRB	AST	STL	BLK	TOV	PF	PTS
1	2009-10	OKC	26.3	3.8	7.3	2.3	3.5	1.5	3.8	3.8	4.8	0.8	3.3	4.0	2.8	0.8	0.0	2.5	3.8	12.8
2	2010-11	OKC	25.3	2.3	6.3	0.7	2.0	1.7	4.3	3.3	3.7	0.0	3.7	3.7	3.0	2.0	0.0	1.3	1.3	9.7
3	2011-12	OKC	34.0	4.0	10.3	3.3	5.3	0.8	5.0	5.5	6.3	0.5	4.5	5.0	5.0	0.5	0.3	1.0	2.0	14.3
4	2012-13	HOU	38.0	6.3	16.8	3.5	8.8	2.8	8.0	11.8	13.3	0.3	5.3	5.5	8.0	2.0	0.3	3.0	3.0	27.0
5	2013-14	HOU	41.0	8.5	15.5	5.5	7.5	3.0	8.0	8.5	10.0	0.5	2.0	2.5	5.5	2.0	0.0	2.5	3.0	28.5
6	2014-15	HOU	37.8	6.8	15.3	4.3	9.0	2.5	6.3	8.8	10.3	1.3	4.8	6.0	5.8	2.3	0.0	4.8	3.8	24.8
7	2015-16	HOU	39.5	7.5	21.0	5.3	13.0	2.3	8.0	7.5	8.0	1.5	7.3	8.8	8.3	1.0	1.8	4.5	2.5	24.8
8	2016-17	HOU	36.3	7.5	17.3	4.3	9.0	3.3	8.3	8.3	9.8	1.0	6.0	7.0	11.0	1.0	0.3	5.8	2.8	26.5
9	2017-18	HOU	32.7	8.3	18.0	3.0	6.0	5.3	12.0	5.0	6.0	0.3	4.3	4.7	8.3	1.7	0.7	3.0	2.3	27.0
10	2018-19	HOU	36.0	8.5	21.3	3.8	6.5	4.8	14.8	6.0	6.5	0.8	6.3	7.0	9.0	3.0	0.5	6.0	3.8	27.8
11	2019-20	HOU	40.3	11.7	23.0	8.0	10.3	3.7	12.7	11.7	13.7	1.0	10.3	11.3	8.3	2.7	1.0	3.3	4.7	38.7
12	2020-21	BRK,HOU	35.5	7.0	19.0	3.5	8.0	3.5	11.0	7.5	9.0	0.5	4.5	5.0	8.0	1.0	0.5	4.0	1.0	25.0
13	2021-22	BRK,PHI	42.0	6.5	13.5	3.5	6.5	3.0	7.0	7.5	8.5	0.0	8.0	8.0	12.0	1.0	1.0	3.5	2.0	23.5
14	2022-23	PHI	38.0	6.0	13.0	2.5	6.5	3.5	6.5	5.5	6.5	1.0	3.0	4.0	12.5	1.5	0.0	4.0	2.0	21.0
15	2023-24	LAC	32.0	3.0	8.7	1.0	3.0	2.0	5.7	5.0	5.3	0.0	4.7	4.7	7.0	1.0	1.3	2.7	1.3	13.0
16	2024-25	LAC	33.5	6.5	15.5	5.0	10.0	1.5	5.5	6.8	7.0	0.8	5.0	5.8	7.3	1.3	0.3	5.0	2.0	21.3
17	2025-26	LAC	44.0	9.0	21.0	5.0	12.0	4.0	9.0	13.0	15.0	1.0	10.0	11.0	11.0	0.5	1.5	5.0	2.0	35.0
18	Totals		35.5	6.5	15.4	3.8	7.5	2.8	7.9	7.3	8.3	0.7	5.4	6.1	7.5	1.5	0.5	3.7	2.6	23.1

James Harden vs. Dallas Mavericks: Per Game Table
Rk	Season	Team	MP	FG	FGA	2P	2PA	3P	3PA	FT	FTA	ORB	DRB	TRB	AST	STL	BLK	TOV	PF	PTS
1	2010-11	OKC	32.2	4.6	8.6	3.4	4.6	1.2	4.0	4.0	5.0	0.6	5.4	6.0	3.4	1.2	0.2	1.6	3.0	14.4
2	2011-12	OKC	32.3	5.0	10.0	3.5	6.8	1.5	3.3	6.8	7.8	0.5	5.0	5.5	4.3	2.5	0.3	2.3	3.0	18.3
3	2014-15	HOU	36.0	8.0	17.2	5.6	11.0	2.4	6.2	10.0	10.4	0.4	3.4	3.8	7.8	1.2	0.2	3.8	3.0	28.4
4	2023-24	LAC	40.2	6.7	14.8	3.7	7.0	3.0	7.8	4.8	5.3	0.5	4.0	4.5	8.0	1.0	1.0	2.3	2.2	21.2
5	Totals		35.6	6.2	12.9	4.1	7.4	2.1	5.6	6.3	7.0	0.5	4.4	4.9	6.1	1.4	0.5	2.5	2.8	20.7

James Harden vs. Dallas Mavericks: Totals

Regular Season

Playoffs

James Harden vs. Dallas Mavericks: Totals Table
Rk	Season	Team	G	GS	MP	FG	FGA	FG%	2P	2PA	2P%	3P	3PA	3P%	eFG%	FT	FTA	FT%	TS%	ORB	DRB	TRB	AST	STL	BLK	TOV	PF	PTS
1	2009-10	OKC	4	0	105	15	29	.517	9	14	.643	6	15	.400	.621	15	19	.789	.683	3	13	16	11	3	0	10	15	51
2	2010-11	OKC	3	0	76	7	19	.368	2	6	.333	5	13	.385	.500	10	11	.909	.608	0	11	11	9	6	0	4	4	29
3	2011-12	OKC	4	0	136	16	41	.390	13	21	.619	3	20	.150	.427	22	25	.880	.548	2	18	20	20	2	1	4	8	57
4	2012-13	HOU	4	4	152	25	67	.373	14	35	.400	11	32	.344	.455	47	53	.887	.598	1	21	22	32	8	1	12	12	108
5	2013-14	HOU	2	2	82	17	31	.548	11	15	.733	6	16	.375	.645	17	20	.850	.716	1	4	5	11	4	0	5	6	57
6	2014-15	HOU	4	4	151	27	61	.443	17	36	.472	10	25	.400	.525	35	41	.854	.626	5	19	24	23	9	0	19	15	99
7	2015-16	HOU	4	4	158	30	84	.357	21	52	.404	9	32	.281	.411	30	32	.938	.505	6	29	35	33	4	7	18	10	99
8	2016-17	HOU	4	4	145	30	69	.435	17	36	.472	13	33	.394	.529	33	39	.846	.615	4	24	28	44	4	1	23	11	106
9	2017-18	HOU	3	3	98	25	54	.463	9	18	.500	16	36	.444	.611	15	18	.833	.654	1	13	14	25	5	2	9	7	81
10	2018-19	HOU	4	4	144	34	85	.400	15	26	.577	19	59	.322	.512	24	26	.923	.575	3	25	28	36	12	2	24	15	111
11	2019-20	HOU	3	3	121	35	69	.507	24	31	.774	11	38	.289	.587	35	41	.854	.666	3	31	34	25	8	3	10	14	116
12	2020-21	BRK,HOU	2	2	71	14	38	.368	7	16	.438	7	22	.318	.461	15	18	.833	.544	1	9	10	16	2	1	8	2	50
13	2021-22	BRK,PHI	2	2	84	13	27	.481	7	13	.538	6	14	.429	.593	15	17	.882	.682	0	16	16	24	2	2	7	4	47
14	2022-23	PHI	2	2	76	12	26	.462	5	13	.385	7	13	.538	.596	11	13	.846	.662	2	6	8	25	3	0	8	4	42
15	2023-24	LAC	3	3	96	9	26	.346	3	9	.333	6	17	.353	.462	15	16	.938	.590	0	14	14	21	3	4	8	4	39
16	2024-25	LAC	4	4	134	26	62	.419	20	40	.500	6	22	.273	.468	27	28	.964	.572	3	20	23	29	5	1	20	8	85
17	2025-26	LAC	2	2	88	18	42	.429	10	24	.417	8	18	.444	.524	26	30	.867	.634	2	20	22	22	1	3	10	4	70
18	Totals		54	43	1917	353	830	.425	204	405	.504	149	425	.351	.515	392	447	.877	.607	37	293	330	406	81	28	199	143	1247

James Harden vs. Dallas Mavericks: Totals Table
Rk	Season	Team	G	GS	MP	FG	FGA	FG%	2P	2PA	2P%	3P	3PA	3P%	eFG%	FT	FTA	FT%	TS%	ORB	DRB	TRB	AST	STL	BLK	TOV	PF	PTS
1	2010-11	OKC	5	0	161	23	43	.535	17	23	.739	6	20	.300	.605	20	25	.800	.667	3	27	30	17	6	1	8	15	72
2	2011-12	OKC	4	0	129	20	40	.500	14	27	.519	6	13	.462	.575	27	31	.871	.680	2	20	22	17	10	1	9	12	73
3	2014-15	HOU	5	5	180	40	86	.465	28	55	.509	12	31	.387	.535	50	52	.962	.652	2	17	19	39	6	1	19	15	142
4	2023-24	LAC	6	6	241	40	89	.449	22	42	.524	18	47	.383	.551	29	32	.906	.616	3	24	27	48	6	6	14	13	127
5	Totals		20	11	711	123	258	.477	81	147	.551	42	111	.378	.558	126	140	.900	.648	10	88	98	121	28	9	50	55	414

James Harden vs. Dallas Mavericks: Game Logs

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.

James Harden vs. Dallas Mavericks: Game Logs Table
Rk	Date	Age	Team		Opp	Result	GS	MP	FG	FGA	FG%	2P	2PA	2P%	3P	3PA	3P%	FT	FTA	FT%	TS%	ORB	DRB	TRB	AST	STL	BLK	TOV	PF	PTS	GmSc	BPM
1	2025-11-29	36-095	LAC		DAL	L, 110-114	*	37	5	17	.294	3	11	.273	2	6	.333	17	19	.895	.572	0	8	8	11	0	1	7	1	29	21.7	1.3
2	2025-11-14	36-080	LAC	@	DAL	W, 133-127 (2OT)	*	51	13	25	.520	7	13	.538	6	12	.500	9	11	.818	.687	2	12	14	11	1	2	3	3	41	38.8	12.4
3	2025-04-05	35-222	LAC		DAL	W, 135-104	*	31	10	19	.526	9	15	.600	1	4	.250	8	9	.889	.632	2	5	7	14	1	0	2	2	29	30.2	14.5
4	2025-04-04	35-221	LAC		DAL	W, 114-91	*	30	4	11	.364	3	7	.429	1	4	.250	4	4	1.000	.509	0	4	4	5	2	0	5	2	13	7.8	-4.6
5	2024-12-21	35-117	LAC	@	DAL	L, 97-113	*	37	6	18	.333	4	9	.444	2	9	.222	5	5	1.000	.470	0	8	8	3	1	1	7	2	19	7.2	-8.9
6	2024-12-19	35-115	LAC	@	DAL	W, 118-95	*	36	6	14	.429	4	9	.444	2	5	.400	10	10	1.000	.652	1	3	4	7	1	0	6	2	24	17.3	-0.8
7	2023-12-20	34-116	LAC	@	DAL	W, 120-111	*	39	4	12	.333	2	4	.500	2	8	.250	7	8	.875	.548	0	5	5	11	0	2	4	3	17	15.2	-0.7
8	2023-11-25	34-091	LAC		DAL	W, 107-88	*	28	2	8	.250	0	2	.000	2	6	.333	2	2	1.000	.450	0	4	4	7	1	2	2	1	8	9.3	6.9
9	2023-11-10	34-076	LAC	@	DAL	L, 126-144	*	29	3	6	.500	1	3	.333	2	3	.667	6	6	1.000	.810	0	5	5	3	2	0	2	0	14	14.6	4.5
10	2023-03-29	33-215	PHI		DAL	W, 116-108	*	38	4	14	.286	2	8	.250	2	6	.333	5	7	.714	.439	2	2	4	12	3	0	2	3	15	16.2	2.2

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.

James Harden vs. Dallas Mavericks

Compare Players

Compare Teams

Player vs. Team

Search Criteria

James Harden vs. Dallas Mavericks

James Harden vs. Dallas Mavericks: Per Game

James Harden vs. Dallas Mavericks: Per Game

James Harden vs. Dallas Mavericks: Totals

James Harden vs. Dallas Mavericks: Totals

James Harden vs. Dallas Mavericks: Game Logs

James Harden vs. Dallas Mavericks: Game Logs

Subscribe to Stathead Pro Basketball for full results.

Full Site Menu

FAQs, Tip & Tricks