Jim Brown vs. Marion Motley: Head-to-Head Stats Comparison
Compare players and teams or see head to head results between teams, players, or player vs. team. Data Coverage
THIS QUESTION WAS ANSWERED USING
POWERED BY 
Your All Access Pass to the
Pro Football
Database
Go beyond the basics. Become a Stathead
Start Your FREE Trial
Display Query »
--------------------------------------
header_comp
WITH
h2h_record AS (
SELECT p1.person_id as p1_person_id, SUM(p1.win AND p1.type="reg") as p1_rs_wins, SUM(p1.win AND p1.type="post") as p1_po_wins, SUM(p1.loss AND p1.type="reg") as p1_rs_losses, SUM(p1.loss AND p1.type="post") as p1_po_losses, SUM(p1.tie AND p1.type="reg") as p1_rs_ties, SUM(p1.tie AND p1.type="post") as p1_po_ties, p2.person_id as p2_person_id, SUM(p2.win AND p2.type="reg") as p2_rs_wins, SUM(p2.win AND p2.type="post") as p2_po_wins, SUM(p2.loss AND p2.type="reg") as p2_rs_losses, SUM(p2.loss AND p2.type="post") as p2_po_losses, SUM(p2.tie AND p2.type="reg") as p2_rs_ties, SUM(p2.tie AND p2.type="post") as p2_po_ties
FROM (SELECT person_id, win as win, loss as loss, tie as tie, game_id, type, team_id
FROM sup_team_games
JOIN sup_games USING (game_id)
JOIN sup_player_games USING (game_id, team_id)
JOIN sup_phase_seasons USING (year_id, comp_id, phase_id)
WHERE person_id=? ) as p1
JOIN (SELECT person_id, win as win, loss as loss, tie as tie, game_id, type, team_id FROM sup_team_games
JOIN sup_games USING (game_id)
JOIN sup_player_games USING (game_id, team_id)
JOIN sup_phase_seasons USING (year_id, comp_id, phase_id)
WHERE person_id=? ) as p2 ON p1.game_id=p2.game_id AND p1.team_id!=p2.team_id
),
h2h_record_tot AS (
SELECT person_id, rs_wins, rs_losses, rs_ties, po_wins, po_losses, po_ties
FROM (SELECT p1_person_id as person_id, p1_rs_wins as rs_wins, p1_rs_losses as rs_losses, p1_rs_ties as rs_ties, p1_po_wins as po_wins, p1_po_losses as po_losses, p1_po_ties as po_ties
FROM h2h_record
UNION SELECT p2_person_id as person_id, p2_rs_wins as rs_wins, p2_rs_losses as rs_losses, p2_rs_ties as rs_ties, p2_po_wins as po_wins, p2_po_losses as po_losses, p2_po_ties as po_ties
FROM h2h_record) as zzz
WHERE 1
)
SELECT person_id, rs_wins, rs_losses, rs_ties, po_wins, po_losses, po_ties, SUM(games) AS games, SUM(av) AS av, SUM(rush_att) AS rush_att, SUM(rush_yds) AS rush_yds, IF(SUM(rush_att), SUM(rush_yds)/SUM(rush_att), NULL) as rush_yds_per_att_csk, ROUND(IF(SUM(rush_att), SUM(rush_yds)/SUM(rush_att), NULL),1) AS rush_yds_per_att, SUM(rush_td) AS rush_td, SUM(rec) AS rec, SUM(rec_yds) AS rec_yds, IF(SUM(rec), SUM(rec_yds)/SUM(rec), NULL) as rec_yds_per_rec_csk, ROUND(IF(SUM(rec), SUM(rec_yds)/SUM(rec), NULL),1) AS rec_yds_per_rec, SUM(rec_td) AS rec_td, SUM(punt_ret) AS punt_ret, SUM(punt_ret_yds) AS punt_ret_yds, SUM(punt_ret_td) AS punt_ret_td, SUM(kick_ret) AS kick_ret, SUM(kick_ret_yds) AS kick_ret_yds, SUM(kick_ret_td) AS kick_ret_td, SUM(fantasy_points) as fantasy_points_csk, ROUND(SUM(fantasy_points),2) AS fantasy_points
FROM sup_player_team_seasons as st
JOIN sup_people USING (person_id)
JOIN sup_players USING (person_id)
JOIN sup_phase_seasons USING (comp_id, phase_id, year_id)
JOIN sup_comp_seasons USING (comp_id, year_id)
LEFT JOIN h2h_record_tot USING (person_id)
WHERE ((person_id=?) OR (person_id=?))
AND type="reg"
GROUP BY person_id
ORDER BY person_id
SQL PARAMS -- $VAR1 = [
'BrowJi00',
'MotlMa00',
'BrowJi00',
'MotlMa00'
];
SELECT name_short, name, award_id FROM sup_awards WHERE award_id IN ("probowl","allpro","apmvp","apopoy","apdpoy","aafcmvp","appoy","upimvp","upipoy","upiopoy","upidpoy","sbmvp") GROUP BY award_id
SQL PARAMS -- $VAR1 = [];
WITH
champ AS (
SELECT person_id, COUNT(*) as championships
FROM sup_player_team_seasons
LEFT JOIN sup_team_seasons USING (team_id, year_id, comp_id, phase_id)
WHERE person_id=? AND phase_id='reg' AND is_champion=1
),
awards AS (
SELECT person_id,
SUM(award_id="aafcmvp") as `aafcmvp`, SUM(award_id="allpro") as `allpro`, SUM(award_id="apdpoy") as `apdpoy`, SUM(award_id="apmvp") as `apmvp`, SUM(award_id="apopoy") as `apopoy`, SUM(award_id="appoy") as `appoy`, SUM(award_id="probowl") as `probowl`, SUM(award_id="sbmvp") as `sbmvp`, SUM(award_id="upidpoy") as `upidpoy`, SUM(award_id="upimvp") as `upimvp`, SUM(award_id="upiopoy") as `upiopoy`, SUM(award_id="upipoy") as `upipoy`
FROM sup_awards_players
WHERE person_id=?
)
SELECT person_id, is_hof, championships, awards.* FROM sup_players
LEFT JOIN awards USING (person_id)
LEFT JOIN champ USING (person_id)
WHERE person_id=?
SQL PARAMS -- $VAR1 = [
'BrowJi00',
'BrowJi00',
'BrowJi00'
];
WITH
champ AS (
SELECT person_id, COUNT(*) as championships
FROM sup_player_team_seasons
LEFT JOIN sup_team_seasons USING (team_id, year_id, comp_id, phase_id)
WHERE person_id=? AND phase_id='reg' AND is_champion=1
),
awards AS (
SELECT person_id,
SUM(award_id="aafcmvp") as `aafcmvp`, SUM(award_id="allpro") as `allpro`, SUM(award_id="apdpoy") as `apdpoy`, SUM(award_id="apmvp") as `apmvp`, SUM(award_id="apopoy") as `apopoy`, SUM(award_id="appoy") as `appoy`, SUM(award_id="probowl") as `probowl`, SUM(award_id="sbmvp") as `sbmvp`, SUM(award_id="upidpoy") as `upidpoy`, SUM(award_id="upimvp") as `upimvp`, SUM(award_id="upiopoy") as `upiopoy`, SUM(award_id="upipoy") as `upipoy`
FROM sup_awards_players
WHERE person_id=?
)
SELECT person_id, is_hof, championships, awards.* FROM sup_players
LEFT JOIN awards USING (person_id)
LEFT JOIN champ USING (person_id)
WHERE person_id=?
SQL PARAMS -- $VAR1 = [
'MotlMa00',
'MotlMa00',
'MotlMa00'
];
--------------------------------------
h2h_sum_rush
Page Setup Time: 0.00164 seconds
WITH
pgames AS (
SELECT person_id, game_id, team_id, year_id
FROM sup_team_games
JOIN sup_player_games USING (game_id, team_id)
JOIN sup_phase_seasons USING (year_id, comp_id, phase_id)
WHERE 1
),
pgames_list AS (
SELECT p1.game_id
FROM (SELECT game_id, team_id
FROM pgames
WHERE person_id=? ) as p1
JOIN (SELECT game_id, team_id FROM pgames WHERE person_id=? ) as p2 ON p1.game_id=p2.game_id AND p1.team_id!=p2.team_id
)
SELECT person_id, COUNT(*) AS games, SUM(is_starter) AS games_started, SUM(rush_att) AS rush_att, SUM(rush_yds) AS rush_yds, IF(SUM(rush_att), SUM(rush_yds)/SUM(rush_att), NULL) as rush_yds_per_att_csk, ROUND(IF(SUM(rush_att), SUM(rush_yds)/SUM(rush_att), NULL),1) AS rush_yds_per_att, SUM(rush_td) AS rush_td, SUM(rush_first_down) AS rush_first_down, SUM(targets) AS targets, SUM(rec) AS rec, SUM(rec_yds) AS rec_yds, IF(SUM(rec), SUM(rec_yds)/SUM(rec), NULL) as rec_yds_per_rec_csk, ROUND(IF(SUM(rec), SUM(rec_yds)/SUM(rec), NULL),1) AS rec_yds_per_rec, SUM(rec_td) AS rec_td, IF(SUM(IF(targets IS NOT NULL, targets,0)) = 0, NULL, SUM(IF(targets IS NOT NULL,rec,0))/SUM(IF(targets IS NOT NULL, targets,0))) as catch_pct_csk, ROUND(100 * (IF(SUM(IF(targets IS NOT NULL, targets,0)) = 0, NULL, SUM(IF(targets IS NOT NULL,rec,0))/SUM(IF(targets IS NOT NULL, targets,0)))),1) AS catch_pct, IF(SUM(IF(targets IS NOT NULL, targets,0)) = 0, NULL, SUM(IF(targets IS NOT NULL,rec_yds,0))/SUM(IF(targets IS NOT NULL, targets,0))) as rec_yds_per_tgt_csk, ROUND(IF(SUM(IF(targets IS NOT NULL, targets,0)) = 0, NULL, SUM(IF(targets IS NOT NULL,rec_yds,0))/SUM(IF(targets IS NOT NULL, targets,0))),1) AS rec_yds_per_tgt, SUM(rec_first_down) AS rec_first_down, SUM(fantasy_points) as fantasy_points_csk, ROUND(SUM(fantasy_points),2) AS fantasy_points
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 FROM sup_team_seasons GROUP BY team_id, year_id ) as ts USING (team_id, year_id)
JOIN sup_games USING (game_id)
JOIN pgames_list USING (game_id)
WHERE ((person_id=?) OR (person_id=?))
AND type="reg"
GROUP BY person_id LIMIT 0, 200
SQL PARAMS -- $VAR1 = [
'BrowJi00',
'MotlMa00',
'BrowJi00',
'MotlMa00'
];
Query Time: 0.01 seconds
WITH
pgames AS (
SELECT person_id, game_id, team_id, year_id
FROM sup_team_games
JOIN sup_player_games USING (game_id, team_id)
JOIN sup_phase_seasons USING (year_id, comp_id, phase_id)
WHERE 1
),
pgames_list AS (
SELECT p1.game_id
FROM (SELECT game_id, team_id
FROM pgames
WHERE person_id=? ) as p1
JOIN (SELECT game_id, team_id FROM pgames WHERE person_id=? ) as p2 ON p1.game_id=p2.game_id AND p1.team_id!=p2.team_id
)
SELECT person_id, COUNT(*) AS games, SUM(is_starter) AS games_started, SUM(rush_att) AS rush_att, SUM(rush_yds) AS rush_yds, IF(SUM(rush_att), SUM(rush_yds)/SUM(rush_att), NULL) as rush_yds_per_att_csk, ROUND(IF(SUM(rush_att), SUM(rush_yds)/SUM(rush_att), NULL),1) AS rush_yds_per_att, SUM(rush_td) AS rush_td, SUM(rush_first_down) AS rush_first_down, SUM(targets) AS targets, SUM(rec) AS rec, SUM(rec_yds) AS rec_yds, IF(SUM(rec), SUM(rec_yds)/SUM(rec), NULL) as rec_yds_per_rec_csk, ROUND(IF(SUM(rec), SUM(rec_yds)/SUM(rec), NULL),1) AS rec_yds_per_rec, SUM(rec_td) AS rec_td, IF(SUM(IF(targets IS NOT NULL, targets,0)) = 0, NULL, SUM(IF(targets IS NOT NULL,rec,0))/SUM(IF(targets IS NOT NULL, targets,0))) as catch_pct_csk, ROUND(100 * (IF(SUM(IF(targets IS NOT NULL, targets,0)) = 0, NULL, SUM(IF(targets IS NOT NULL,rec,0))/SUM(IF(targets IS NOT NULL, targets,0)))),1) AS catch_pct, IF(SUM(IF(targets IS NOT NULL, targets,0)) = 0, NULL, SUM(IF(targets IS NOT NULL,rec_yds,0))/SUM(IF(targets IS NOT NULL, targets,0))) as rec_yds_per_tgt_csk, ROUND(IF(SUM(IF(targets IS NOT NULL, targets,0)) = 0, NULL, SUM(IF(targets IS NOT NULL,rec_yds,0))/SUM(IF(targets IS NOT NULL, targets,0))),1) AS rec_yds_per_tgt, SUM(rec_first_down) AS rec_first_down, SUM(fantasy_points) as fantasy_points_csk, ROUND(SUM(fantasy_points),2) AS fantasy_points
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 FROM sup_team_seasons GROUP BY team_id, year_id ) as ts USING (team_id, year_id)
JOIN sup_games USING (game_id)
JOIN pgames_list USING (game_id)
WHERE ((person_id=?) OR (person_id=?))
AND type="post"
GROUP BY person_id LIMIT 0, 200
SQL PARAMS -- $VAR1 = [
'BrowJi00',
'MotlMa00',
'BrowJi00',
'MotlMa00'
];
Query Time: 0.01 seconds
--------------------------------------
h2h_sum_return
Page Setup Time: 0.00110 seconds
WITH
pgames AS (
SELECT person_id, game_id, team_id, year_id
FROM sup_team_games
JOIN sup_player_games USING (game_id, team_id)
JOIN sup_phase_seasons USING (year_id, comp_id, phase_id)
WHERE 1
),
pgames_list AS (
SELECT p1.game_id
FROM (SELECT game_id, team_id
FROM pgames
WHERE person_id=? ) as p1
JOIN (SELECT game_id, team_id FROM pgames WHERE person_id=? ) as p2 ON p1.game_id=p2.game_id AND p1.team_id!=p2.team_id
)
SELECT person_id, COUNT(*) AS games, SUM(is_starter) AS games_started, SUM(kick_ret) AS kick_ret, SUM(kick_ret_yds) AS kick_ret_yds, IF(SUM(kick_ret), SUM(kick_ret_yds)/SUM(kick_ret), NULL) as kick_ret_yds_per_ret_csk, ROUND(IF(SUM(kick_ret), SUM(kick_ret_yds)/SUM(kick_ret), NULL),1) AS kick_ret_yds_per_ret, SUM(kick_ret_td) AS kick_ret_td, SUM(punt_ret) AS punt_ret, SUM(punt_ret_yds) AS punt_ret_yds, IF(SUM(punt_ret), SUM(punt_ret_yds)/SUM(punt_ret), NULL) as punt_ret_yds_per_ret_csk, ROUND(IF(SUM(punt_ret), SUM(punt_ret_yds)/SUM(punt_ret), NULL),1) AS punt_ret_yds_per_ret, SUM(punt_ret_td) AS punt_ret_td, SUM(fantasy_points) as fantasy_points_csk, ROUND(SUM(fantasy_points),2) AS fantasy_points
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 FROM sup_team_seasons GROUP BY team_id, year_id ) as ts USING (team_id, year_id)
JOIN sup_games USING (game_id)
JOIN pgames_list USING (game_id)
WHERE ((person_id=?) OR (person_id=?))
AND type="reg"
GROUP BY person_id LIMIT 0, 200
SQL PARAMS -- $VAR1 = [
'BrowJi00',
'MotlMa00',
'BrowJi00',
'MotlMa00'
];
Query Time: 0.01 seconds
WITH
pgames AS (
SELECT person_id, game_id, team_id, year_id
FROM sup_team_games
JOIN sup_player_games USING (game_id, team_id)
JOIN sup_phase_seasons USING (year_id, comp_id, phase_id)
WHERE 1
),
pgames_list AS (
SELECT p1.game_id
FROM (SELECT game_id, team_id
FROM pgames
WHERE person_id=? ) as p1
JOIN (SELECT game_id, team_id FROM pgames WHERE person_id=? ) as p2 ON p1.game_id=p2.game_id AND p1.team_id!=p2.team_id
)
SELECT person_id, COUNT(*) AS games, SUM(is_starter) AS games_started, SUM(kick_ret) AS kick_ret, SUM(kick_ret_yds) AS kick_ret_yds, IF(SUM(kick_ret), SUM(kick_ret_yds)/SUM(kick_ret), NULL) as kick_ret_yds_per_ret_csk, ROUND(IF(SUM(kick_ret), SUM(kick_ret_yds)/SUM(kick_ret), NULL),1) AS kick_ret_yds_per_ret, SUM(kick_ret_td) AS kick_ret_td, SUM(punt_ret) AS punt_ret, SUM(punt_ret_yds) AS punt_ret_yds, IF(SUM(punt_ret), SUM(punt_ret_yds)/SUM(punt_ret), NULL) as punt_ret_yds_per_ret_csk, ROUND(IF(SUM(punt_ret), SUM(punt_ret_yds)/SUM(punt_ret), NULL),1) AS punt_ret_yds_per_ret, SUM(punt_ret_td) AS punt_ret_td, SUM(fantasy_points) as fantasy_points_csk, ROUND(SUM(fantasy_points),2) AS fantasy_points
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 FROM sup_team_seasons GROUP BY team_id, year_id ) as ts USING (team_id, year_id)
JOIN sup_games USING (game_id)
JOIN pgames_list USING (game_id)
WHERE ((person_id=?) OR (person_id=?))
AND type="post"
GROUP BY person_id LIMIT 0, 200
SQL PARAMS -- $VAR1 = [
'BrowJi00',
'MotlMa00',
'BrowJi00',
'MotlMa00'
];
Query Time: 0.01 seconds
--------------------------------------
h2h_sum_defense
Page Setup Time: 0.00122 seconds
WITH
pgames AS (
SELECT person_id, game_id, team_id, year_id
FROM sup_team_games
JOIN sup_player_games USING (game_id, team_id)
JOIN sup_phase_seasons USING (year_id, comp_id, phase_id)
WHERE 1
),
pgames_list AS (
SELECT p1.game_id
FROM (SELECT game_id, team_id
FROM pgames
WHERE person_id=? ) as p1
JOIN (SELECT game_id, team_id FROM pgames WHERE person_id=? ) as p2 ON p1.game_id=p2.game_id AND p1.team_id!=p2.team_id
)
SELECT person_id, COUNT(*) AS games, SUM(is_starter) AS games_started, SUM(sacks) as sacks_csk, ROUND(SUM(sacks),1) AS sacks, SUM(tackles_solo) AS tackles_solo, SUM(tackles_assists) AS tackles_assists, SUM(tackles_combined) AS tackles_combined, SUM(tackles_loss) AS tackles_loss, SUM(qb_hits) AS qb_hits, SUM(def_int) AS def_int, SUM(def_int_yds) AS def_int_yds, SUM(def_int_td) AS def_int_td, SUM(pass_defended) AS pass_defended, SUM(fumbles) AS fumbles, SUM(fumbles_rec) AS fumbles_rec, SUM(fumbles_rec_yds) AS fumbles_rec_yds, SUM(fumbles_rec_td) AS fumbles_rec_td, SUM(fumbles_forced) AS fumbles_forced, SUM(fantasy_points) as fantasy_points_csk, ROUND(SUM(fantasy_points),2) AS fantasy_points
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 FROM sup_team_seasons GROUP BY team_id, year_id ) as ts USING (team_id, year_id)
JOIN sup_games USING (game_id)
JOIN pgames_list USING (game_id)
WHERE ((person_id=?) OR (person_id=?))
AND type="reg"
GROUP BY person_id LIMIT 0, 200
SQL PARAMS -- $VAR1 = [
'BrowJi00',
'MotlMa00',
'BrowJi00',
'MotlMa00'
];
Query Time: 0.01 seconds
WITH
pgames AS (
SELECT person_id, game_id, team_id, year_id
FROM sup_team_games
JOIN sup_player_games USING (game_id, team_id)
JOIN sup_phase_seasons USING (year_id, comp_id, phase_id)
WHERE 1
),
pgames_list AS (
SELECT p1.game_id
FROM (SELECT game_id, team_id
FROM pgames
WHERE person_id=? ) as p1
JOIN (SELECT game_id, team_id FROM pgames WHERE person_id=? ) as p2 ON p1.game_id=p2.game_id AND p1.team_id!=p2.team_id
)
SELECT person_id, COUNT(*) AS games, SUM(is_starter) AS games_started, SUM(sacks) as sacks_csk, ROUND(SUM(sacks),1) AS sacks, SUM(tackles_solo) AS tackles_solo, SUM(tackles_assists) AS tackles_assists, SUM(tackles_combined) AS tackles_combined, SUM(tackles_loss) AS tackles_loss, SUM(qb_hits) AS qb_hits, SUM(def_int) AS def_int, SUM(def_int_yds) AS def_int_yds, SUM(def_int_td) AS def_int_td, SUM(pass_defended) AS pass_defended, SUM(fumbles) AS fumbles, SUM(fumbles_rec) AS fumbles_rec, SUM(fumbles_rec_yds) AS fumbles_rec_yds, SUM(fumbles_rec_td) AS fumbles_rec_td, SUM(fumbles_forced) AS fumbles_forced, SUM(fantasy_points) as fantasy_points_csk, ROUND(SUM(fantasy_points),2) AS fantasy_points
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 FROM sup_team_seasons GROUP BY team_id, year_id ) as ts USING (team_id, year_id)
JOIN sup_games USING (game_id)
JOIN pgames_list USING (game_id)
WHERE ((person_id=?) OR (person_id=?))
AND type="post"
GROUP BY person_id LIMIT 0, 200
SQL PARAMS -- $VAR1 = [
'BrowJi00',
'MotlMa00',
'BrowJi00',
'MotlMa00'
];
Query Time: 0.01 seconds
--------------------------------------
h2h_gamelogs
Page Setup Time: 0.00242 seconds
WITH
pgames AS (
SELECT person_id, game_id, team_id, year_id
FROM sup_team_games
JOIN sup_player_games USING (game_id, team_id)
JOIN sup_phase_seasons USING (year_id, comp_id, phase_id)
WHERE 1
),
pgames_list AS (
SELECT p1.game_id
FROM (SELECT game_id, team_id
FROM pgames
WHERE person_id=? ) as p1
JOIN (SELECT game_id, team_id FROM pgames WHERE person_id=? ) as p2 ON p1.game_id=p2.game_id AND p1.team_id!=p2.team_id
)
SELECT person_id, ts.name_abbr as team_name_abbr, ts.link as team_link, game_id, date, sup_games.link as game_link, rush_att, rush_yds, IF(rush_att, rush_yds/rush_att, NULL) as rush_yds_per_att_csk, ROUND(IF(rush_att, rush_yds/rush_att, NULL),1) AS rush_yds_per_att, rush_td, rush_first_down, targets, rec, rec_yds, IF(rec, rec_yds/rec, NULL) as rec_yds_per_rec_csk, ROUND(IF(rec, rec_yds/rec, NULL),1) AS rec_yds_per_rec, rec_td, rec/targets as catch_pct_csk, ROUND(100 * (rec/targets),1) AS catch_pct, IF(targets, rec_yds/targets, NULL) as rec_yds_per_tgt_csk, ROUND(IF(targets, rec_yds/targets, NULL),1) AS rec_yds_per_tgt, rec_first_down, kick_ret, kick_ret_yds, IF(kick_ret, kick_ret_yds/kick_ret, NULL) as kick_ret_yds_per_ret_csk, ROUND(IF(kick_ret, kick_ret_yds/kick_ret, NULL),1) AS kick_ret_yds_per_ret, kick_ret_td, punt_ret, punt_ret_yds, IF(punt_ret, punt_ret_yds/punt_ret, NULL) as punt_ret_yds_per_ret_csk, ROUND(IF(punt_ret, punt_ret_yds/punt_ret, NULL),1) AS punt_ret_yds_per_ret, punt_ret_td, sacks as sacks_csk, ROUND(sacks,1) AS sacks, tackles_solo, tackles_assists, tackles_combined, tackles_loss, qb_hits, def_int, def_int_yds, def_int_td, pass_defended, fumbles, fumbles_rec, fumbles_rec_yds, fumbles_rec_td, fumbles_forced
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 FROM sup_team_seasons GROUP BY team_id, year_id ) as ts USING (team_id, year_id)
JOIN sup_games USING (game_id)
JOIN pgames_list USING (game_id)
WHERE ((person_id=?) OR (person_id=?))
AND type="reg"
ORDER BY date DESC, person_id LIMIT 0, 20
SQL PARAMS -- $VAR1 = [
'BrowJi00',
'MotlMa00',
'BrowJi00',
'MotlMa00'
];
Query Time: 0.01 seconds
WITH
pgames AS (
SELECT person_id, game_id, team_id, year_id
FROM sup_team_games
JOIN sup_player_games USING (game_id, team_id)
JOIN sup_phase_seasons USING (year_id, comp_id, phase_id)
WHERE 1
),
pgames_list AS (
SELECT p1.game_id
FROM (SELECT game_id, team_id
FROM pgames
WHERE person_id=? ) as p1
JOIN (SELECT game_id, team_id FROM pgames WHERE person_id=? ) as p2 ON p1.game_id=p2.game_id AND p1.team_id!=p2.team_id
)
SELECT person_id, ts.name_abbr as team_name_abbr, ts.link as team_link, game_id, date, sup_games.link as game_link, rush_att, rush_yds, IF(rush_att, rush_yds/rush_att, NULL) as rush_yds_per_att_csk, ROUND(IF(rush_att, rush_yds/rush_att, NULL),1) AS rush_yds_per_att, rush_td, rush_first_down, targets, rec, rec_yds, IF(rec, rec_yds/rec, NULL) as rec_yds_per_rec_csk, ROUND(IF(rec, rec_yds/rec, NULL),1) AS rec_yds_per_rec, rec_td, rec/targets as catch_pct_csk, ROUND(100 * (rec/targets),1) AS catch_pct, IF(targets, rec_yds/targets, NULL) as rec_yds_per_tgt_csk, ROUND(IF(targets, rec_yds/targets, NULL),1) AS rec_yds_per_tgt, rec_first_down, kick_ret, kick_ret_yds, IF(kick_ret, kick_ret_yds/kick_ret, NULL) as kick_ret_yds_per_ret_csk, ROUND(IF(kick_ret, kick_ret_yds/kick_ret, NULL),1) AS kick_ret_yds_per_ret, kick_ret_td, punt_ret, punt_ret_yds, IF(punt_ret, punt_ret_yds/punt_ret, NULL) as punt_ret_yds_per_ret_csk, ROUND(IF(punt_ret, punt_ret_yds/punt_ret, NULL),1) AS punt_ret_yds_per_ret, punt_ret_td, sacks as sacks_csk, ROUND(sacks,1) AS sacks, tackles_solo, tackles_assists, tackles_combined, tackles_loss, qb_hits, def_int, def_int_yds, def_int_td, pass_defended, fumbles, fumbles_rec, fumbles_rec_yds, fumbles_rec_td, fumbles_forced
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 FROM sup_team_seasons GROUP BY team_id, year_id ) as ts USING (team_id, year_id)
JOIN sup_games USING (game_id)
JOIN pgames_list USING (game_id)
WHERE ((person_id=?) OR (person_id=?))
AND type="post"
ORDER BY date DESC, person_id LIMIT 0, 20
SQL PARAMS -- $VAR1 = [
'BrowJi00',
'MotlMa00',
'BrowJi00',
'MotlMa00'
];
Query Time: 0.01 seconds
--------------------------------------
player_comp_rush
Page Setup Time: 0.00180 seconds
SELECT person_id, IF(MIN(age)=MAX(age), MIN(age), CONCAT(MIN(age), '-', MAX(age))) as age_range, MIN(year_id) as year_min, MAX(year_id) as year_max, SUM(games IS NULL) as games_incomplete, SUM(games) AS games, SUM(games_started IS NULL) as games_started_incomplete, SUM(games_started) AS games_started, SUM(rush_att IS NULL) as rush_att_incomplete, SUM(rush_att) AS rush_att, SUM(rush_yds IS NULL) as rush_yds_incomplete, SUM(rush_yds) AS rush_yds, IF(SUM(rush_att), SUM(rush_yds)/SUM(rush_att), NULL) as rush_yds_per_att_csk, SUM(rush_att IS NULL)+SUM(rush_yds IS NULL) as rush_yds_per_att_incomplete, ROUND(IF(SUM(rush_att), SUM(rush_yds)/SUM(rush_att), NULL),1) AS rush_yds_per_att, SUM(rush_td IS NULL) as rush_td_incomplete, SUM(rush_td) AS rush_td, SUM(rush_first_down IS NULL) as rush_first_down_incomplete, SUM(rush_first_down) AS rush_first_down, SUM(targets IS NULL) as targets_incomplete, SUM(targets) AS targets, SUM(rec IS NULL) as rec_incomplete, SUM(rec) AS rec, SUM(rec_yds IS NULL) as rec_yds_incomplete, SUM(rec_yds) AS rec_yds, IF(SUM(rec), SUM(rec_yds)/SUM(rec), NULL) as rec_yds_per_rec_csk, SUM(rec IS NULL)+SUM(rec_yds IS NULL) as rec_yds_per_rec_incomplete, ROUND(IF(SUM(rec), SUM(rec_yds)/SUM(rec), NULL),1) AS rec_yds_per_rec, SUM(rec_td IS NULL) as rec_td_incomplete, SUM(rec_td) AS rec_td, IF(SUM(IF(targets IS NOT NULL, targets,0)) = 0, NULL, SUM(IF(targets IS NOT NULL,rec,0))/SUM(IF(targets IS NOT NULL, targets,0))) as catch_pct_csk, SUM(targets IS NULL)+SUM(rec IS NULL) as catch_pct_incomplete, ROUND(100 * (IF(SUM(IF(targets IS NOT NULL, targets,0)) = 0, NULL, SUM(IF(targets IS NOT NULL,rec,0))/SUM(IF(targets IS NOT NULL, targets,0)))),1) AS catch_pct, IF(SUM(IF(targets IS NOT NULL, targets,0)) = 0, NULL, SUM(IF(targets IS NOT NULL,rec_yds,0))/SUM(IF(targets IS NOT NULL, targets,0))) as rec_yds_per_tgt_csk, SUM(targets IS NULL)+SUM(rec_yds IS NULL) as rec_yds_per_tgt_incomplete, ROUND(IF(SUM(IF(targets IS NOT NULL, targets,0)) = 0, NULL, SUM(IF(targets IS NOT NULL,rec_yds,0))/SUM(IF(targets IS NOT NULL, targets,0))),1) AS rec_yds_per_tgt, SUM(rec_first_down IS NULL) as rec_first_down_incomplete, SUM(rec_first_down) AS rec_first_down, SUM(av IS NULL) as av_incomplete, SUM(av) AS av, SUM(fantasy_points) as fantasy_points_csk, SUM(fantasy_points IS NULL) as fantasy_points_incomplete, ROUND(SUM(fantasy_points),2) AS fantasy_points
FROM sup_player_team_seasons as st
JOIN sup_people USING (person_id)
JOIN sup_players USING (person_id)
JOIN sup_phase_seasons USING (comp_id, phase_id, year_id)
JOIN sup_comp_seasons USING (comp_id, year_id)
WHERE ((person_id=?) OR (person_id=?))
AND type="reg"
GROUP BY person_id
ORDER BY person_id
SQL PARAMS -- $VAR1 = [
'BrowJi00',
'MotlMa00'
];
Query Time: 0.00 seconds
SELECT person_id, IF(MIN(age)=MAX(age), MIN(age), CONCAT(MIN(age), '-', MAX(age))) as age_range, MIN(year_id) as year_min, MAX(year_id) as year_max, SUM(games IS NULL) as games_incomplete, SUM(games) AS games, SUM(games_started IS NULL) as games_started_incomplete, SUM(games_started) AS games_started, SUM(rush_att IS NULL) as rush_att_incomplete, SUM(rush_att) AS rush_att, SUM(rush_yds IS NULL) as rush_yds_incomplete, SUM(rush_yds) AS rush_yds, IF(SUM(rush_att), SUM(rush_yds)/SUM(rush_att), NULL) as rush_yds_per_att_csk, SUM(rush_att IS NULL)+SUM(rush_yds IS NULL) as rush_yds_per_att_incomplete, ROUND(IF(SUM(rush_att), SUM(rush_yds)/SUM(rush_att), NULL),1) AS rush_yds_per_att, SUM(rush_td IS NULL) as rush_td_incomplete, SUM(rush_td) AS rush_td, SUM(rush_first_down IS NULL) as rush_first_down_incomplete, SUM(rush_first_down) AS rush_first_down, SUM(targets IS NULL) as targets_incomplete, SUM(targets) AS targets, SUM(rec IS NULL) as rec_incomplete, SUM(rec) AS rec, SUM(rec_yds IS NULL) as rec_yds_incomplete, SUM(rec_yds) AS rec_yds, IF(SUM(rec), SUM(rec_yds)/SUM(rec), NULL) as rec_yds_per_rec_csk, SUM(rec IS NULL)+SUM(rec_yds IS NULL) as rec_yds_per_rec_incomplete, ROUND(IF(SUM(rec), SUM(rec_yds)/SUM(rec), NULL),1) AS rec_yds_per_rec, SUM(rec_td IS NULL) as rec_td_incomplete, SUM(rec_td) AS rec_td, IF(SUM(IF(targets IS NOT NULL, targets,0)) = 0, NULL, SUM(IF(targets IS NOT NULL,rec,0))/SUM(IF(targets IS NOT NULL, targets,0))) as catch_pct_csk, SUM(targets IS NULL)+SUM(rec IS NULL) as catch_pct_incomplete, ROUND(100 * (IF(SUM(IF(targets IS NOT NULL, targets,0)) = 0, NULL, SUM(IF(targets IS NOT NULL,rec,0))/SUM(IF(targets IS NOT NULL, targets,0)))),1) AS catch_pct, IF(SUM(IF(targets IS NOT NULL, targets,0)) = 0, NULL, SUM(IF(targets IS NOT NULL,rec_yds,0))/SUM(IF(targets IS NOT NULL, targets,0))) as rec_yds_per_tgt_csk, SUM(targets IS NULL)+SUM(rec_yds IS NULL) as rec_yds_per_tgt_incomplete, ROUND(IF(SUM(IF(targets IS NOT NULL, targets,0)) = 0, NULL, SUM(IF(targets IS NOT NULL,rec_yds,0))/SUM(IF(targets IS NOT NULL, targets,0))),1) AS rec_yds_per_tgt, SUM(rec_first_down IS NULL) as rec_first_down_incomplete, SUM(rec_first_down) AS rec_first_down, SUM(av IS NULL) as av_incomplete, SUM(av) AS av, SUM(fantasy_points) as fantasy_points_csk, SUM(fantasy_points IS NULL) as fantasy_points_incomplete, ROUND(SUM(fantasy_points),2) AS fantasy_points
FROM sup_player_team_seasons as st
JOIN sup_people USING (person_id)
JOIN sup_players USING (person_id)
JOIN sup_phase_seasons USING (comp_id, phase_id, year_id)
JOIN sup_comp_seasons USING (comp_id, year_id)
WHERE ((person_id=?) OR (person_id=?))
AND type="post"
GROUP BY person_id
ORDER BY person_id
SQL PARAMS -- $VAR1 = [
'BrowJi00',
'MotlMa00'
];
Query Time: 0.01 seconds
Table Build Time: 0.04 seconds
Table Build Time: 0.04 seconds
--------------------------------------
player_comp_return
Page Setup Time: 0.00087 seconds
SELECT person_id, IF(MIN(age)=MAX(age), MIN(age), CONCAT(MIN(age), '-', MAX(age))) as age_range, MIN(year_id) as year_min, MAX(year_id) as year_max, SUM(games IS NULL) as games_incomplete, SUM(games) AS games, SUM(games_started IS NULL) as games_started_incomplete, SUM(games_started) AS games_started, SUM(kick_ret IS NULL) as kick_ret_incomplete, SUM(kick_ret) AS kick_ret, SUM(kick_ret_yds IS NULL) as kick_ret_yds_incomplete, SUM(kick_ret_yds) AS kick_ret_yds, IF(SUM(kick_ret), SUM(kick_ret_yds)/SUM(kick_ret), NULL) as kick_ret_yds_per_ret_csk, SUM(kick_ret IS NULL)+SUM(kick_ret_yds IS NULL) as kick_ret_yds_per_ret_incomplete, ROUND(IF(SUM(kick_ret), SUM(kick_ret_yds)/SUM(kick_ret), NULL),1) AS kick_ret_yds_per_ret, SUM(kick_ret_td IS NULL) as kick_ret_td_incomplete, SUM(kick_ret_td) AS kick_ret_td, SUM(punt_ret IS NULL) as punt_ret_incomplete, SUM(punt_ret) AS punt_ret, SUM(punt_ret_yds IS NULL) as punt_ret_yds_incomplete, SUM(punt_ret_yds) AS punt_ret_yds, IF(SUM(punt_ret), SUM(punt_ret_yds)/SUM(punt_ret), NULL) as punt_ret_yds_per_ret_csk, SUM(punt_ret_yds IS NULL)+SUM(punt_ret IS NULL) as punt_ret_yds_per_ret_incomplete, ROUND(IF(SUM(punt_ret), SUM(punt_ret_yds)/SUM(punt_ret), NULL),1) AS punt_ret_yds_per_ret, SUM(punt_ret_td IS NULL) as punt_ret_td_incomplete, SUM(punt_ret_td) AS punt_ret_td, SUM(av IS NULL) as av_incomplete, SUM(av) AS av, SUM(fantasy_points) as fantasy_points_csk, SUM(fantasy_points IS NULL) as fantasy_points_incomplete, ROUND(SUM(fantasy_points),2) AS fantasy_points
FROM sup_player_team_seasons as st
JOIN sup_people USING (person_id)
JOIN sup_players USING (person_id)
JOIN sup_phase_seasons USING (comp_id, phase_id, year_id)
JOIN sup_comp_seasons USING (comp_id, year_id)
WHERE ((person_id=?) OR (person_id=?))
AND type="reg"
GROUP BY person_id
ORDER BY person_id
SQL PARAMS -- $VAR1 = [
'BrowJi00',
'MotlMa00'
];
Query Time: 0.00 seconds
SELECT person_id, IF(MIN(age)=MAX(age), MIN(age), CONCAT(MIN(age), '-', MAX(age))) as age_range, MIN(year_id) as year_min, MAX(year_id) as year_max, SUM(games IS NULL) as games_incomplete, SUM(games) AS games, SUM(games_started IS NULL) as games_started_incomplete, SUM(games_started) AS games_started, SUM(kick_ret IS NULL) as kick_ret_incomplete, SUM(kick_ret) AS kick_ret, SUM(kick_ret_yds IS NULL) as kick_ret_yds_incomplete, SUM(kick_ret_yds) AS kick_ret_yds, IF(SUM(kick_ret), SUM(kick_ret_yds)/SUM(kick_ret), NULL) as kick_ret_yds_per_ret_csk, SUM(kick_ret IS NULL)+SUM(kick_ret_yds IS NULL) as kick_ret_yds_per_ret_incomplete, ROUND(IF(SUM(kick_ret), SUM(kick_ret_yds)/SUM(kick_ret), NULL),1) AS kick_ret_yds_per_ret, SUM(kick_ret_td IS NULL) as kick_ret_td_incomplete, SUM(kick_ret_td) AS kick_ret_td, SUM(punt_ret IS NULL) as punt_ret_incomplete, SUM(punt_ret) AS punt_ret, SUM(punt_ret_yds IS NULL) as punt_ret_yds_incomplete, SUM(punt_ret_yds) AS punt_ret_yds, IF(SUM(punt_ret), SUM(punt_ret_yds)/SUM(punt_ret), NULL) as punt_ret_yds_per_ret_csk, SUM(punt_ret_yds IS NULL)+SUM(punt_ret IS NULL) as punt_ret_yds_per_ret_incomplete, ROUND(IF(SUM(punt_ret), SUM(punt_ret_yds)/SUM(punt_ret), NULL),1) AS punt_ret_yds_per_ret, SUM(punt_ret_td IS NULL) as punt_ret_td_incomplete, SUM(punt_ret_td) AS punt_ret_td, SUM(av IS NULL) as av_incomplete, SUM(av) AS av, SUM(fantasy_points) as fantasy_points_csk, SUM(fantasy_points IS NULL) as fantasy_points_incomplete, ROUND(SUM(fantasy_points),2) AS fantasy_points
FROM sup_player_team_seasons as st
JOIN sup_people USING (person_id)
JOIN sup_players USING (person_id)
JOIN sup_phase_seasons USING (comp_id, phase_id, year_id)
JOIN sup_comp_seasons USING (comp_id, year_id)
WHERE ((person_id=?) OR (person_id=?))
AND type="post"
GROUP BY person_id
ORDER BY person_id
SQL PARAMS -- $VAR1 = [
'BrowJi00',
'MotlMa00'
];
Query Time: 0.00 seconds
Table Build Time: 0.03 seconds
Table Build Time: 0.03 seconds
--------------------------------------
player_comp_defense
Page Setup Time: 0.00101 seconds
SELECT person_id, IF(MIN(age)=MAX(age), MIN(age), CONCAT(MIN(age), '-', MAX(age))) as age_range, MIN(year_id) as year_min, MAX(year_id) as year_max, SUM(games IS NULL) as games_incomplete, SUM(games) AS games, SUM(games_started IS NULL) as games_started_incomplete, SUM(games_started) AS games_started, SUM(sacks) as sacks_csk, SUM(sacks IS NULL) as sacks_incomplete, ROUND(SUM(sacks),1) AS sacks, SUM(tackles_solo IS NULL) as tackles_solo_incomplete, SUM(tackles_solo) AS tackles_solo, SUM(tackles_assists IS NULL) as tackles_assists_incomplete, SUM(tackles_assists) AS tackles_assists, SUM(tackles_combined IS NULL) as tackles_combined_incomplete, SUM(tackles_combined) AS tackles_combined, SUM(tackles_loss IS NULL) as tackles_loss_incomplete, SUM(tackles_loss) AS tackles_loss, SUM(qb_hits IS NULL) as qb_hits_incomplete, SUM(qb_hits) AS qb_hits, SUM(def_int IS NULL) as def_int_incomplete, SUM(def_int) AS def_int, SUM(def_int_yds IS NULL) as def_int_yds_incomplete, SUM(def_int_yds) AS def_int_yds, SUM(def_int_td IS NULL) as def_int_td_incomplete, SUM(def_int_td) AS def_int_td, SUM(pass_defended IS NULL) as pass_defended_incomplete, SUM(pass_defended) AS pass_defended, SUM(fumbles IS NULL) as fumbles_incomplete, SUM(fumbles) AS fumbles, SUM(fumbles_rec IS NULL) as fumbles_rec_incomplete, SUM(fumbles_rec) AS fumbles_rec, SUM(fumbles_rec_yds IS NULL) as fumbles_rec_yds_incomplete, SUM(fumbles_rec_yds) AS fumbles_rec_yds, SUM(fumbles_rec_td IS NULL) as fumbles_rec_td_incomplete, SUM(fumbles_rec_td) AS fumbles_rec_td, SUM(fumbles_forced IS NULL) as fumbles_forced_incomplete, SUM(fumbles_forced) AS fumbles_forced, SUM(av IS NULL) as av_incomplete, SUM(av) AS av, SUM(fantasy_points) as fantasy_points_csk, SUM(fantasy_points IS NULL) as fantasy_points_incomplete, ROUND(SUM(fantasy_points),2) AS fantasy_points
FROM sup_player_team_seasons as st
JOIN sup_people USING (person_id)
JOIN sup_players USING (person_id)
JOIN sup_phase_seasons USING (comp_id, phase_id, year_id)
JOIN sup_comp_seasons USING (comp_id, year_id)
WHERE ((person_id=?) OR (person_id=?))
AND type="reg"
GROUP BY person_id
ORDER BY person_id
SQL PARAMS -- $VAR1 = [
'BrowJi00',
'MotlMa00'
];
Query Time: 0.00 seconds
SELECT person_id, IF(MIN(age)=MAX(age), MIN(age), CONCAT(MIN(age), '-', MAX(age))) as age_range, MIN(year_id) as year_min, MAX(year_id) as year_max, SUM(games IS NULL) as games_incomplete, SUM(games) AS games, SUM(games_started IS NULL) as games_started_incomplete, SUM(games_started) AS games_started, SUM(sacks) as sacks_csk, SUM(sacks IS NULL) as sacks_incomplete, ROUND(SUM(sacks),1) AS sacks, SUM(tackles_solo IS NULL) as tackles_solo_incomplete, SUM(tackles_solo) AS tackles_solo, SUM(tackles_assists IS NULL) as tackles_assists_incomplete, SUM(tackles_assists) AS tackles_assists, SUM(tackles_combined IS NULL) as tackles_combined_incomplete, SUM(tackles_combined) AS tackles_combined, SUM(tackles_loss IS NULL) as tackles_loss_incomplete, SUM(tackles_loss) AS tackles_loss, SUM(qb_hits IS NULL) as qb_hits_incomplete, SUM(qb_hits) AS qb_hits, SUM(def_int IS NULL) as def_int_incomplete, SUM(def_int) AS def_int, SUM(def_int_yds IS NULL) as def_int_yds_incomplete, SUM(def_int_yds) AS def_int_yds, SUM(def_int_td IS NULL) as def_int_td_incomplete, SUM(def_int_td) AS def_int_td, SUM(pass_defended IS NULL) as pass_defended_incomplete, SUM(pass_defended) AS pass_defended, SUM(fumbles IS NULL) as fumbles_incomplete, SUM(fumbles) AS fumbles, SUM(fumbles_rec IS NULL) as fumbles_rec_incomplete, SUM(fumbles_rec) AS fumbles_rec, SUM(fumbles_rec_yds IS NULL) as fumbles_rec_yds_incomplete, SUM(fumbles_rec_yds) AS fumbles_rec_yds, SUM(fumbles_rec_td IS NULL) as fumbles_rec_td_incomplete, SUM(fumbles_rec_td) AS fumbles_rec_td, SUM(fumbles_forced IS NULL) as fumbles_forced_incomplete, SUM(fumbles_forced) AS fumbles_forced, SUM(av IS NULL) as av_incomplete, SUM(av) AS av, SUM(fantasy_points) as fantasy_points_csk, SUM(fantasy_points IS NULL) as fantasy_points_incomplete, ROUND(SUM(fantasy_points),2) AS fantasy_points
FROM sup_player_team_seasons as st
JOIN sup_people USING (person_id)
JOIN sup_players USING (person_id)
JOIN sup_phase_seasons USING (comp_id, phase_id, year_id)
JOIN sup_comp_seasons USING (comp_id, year_id)
WHERE ((person_id=?) OR (person_id=?))
AND type="post"
GROUP BY person_id
ORDER BY person_id
SQL PARAMS -- $VAR1 = [
'BrowJi00',
'MotlMa00'
];
Query Time: 0.00 seconds
Table Build Time: 0.04 seconds
Table Build Time: 0.04 seconds
--------------------------------------
SH->PARAM -- $VAR1 = {
'match' => 'versus_playervplayer',
'player_id1' => 'BrowJi00',
'player_id2' => 'MotlMa00'
};
SH->PARAM_NO_DEFAULT -- $VAR1 = {
'player_id1' => 'BrowJi00',
'player_id2' => 'MotlMa00'
};
Show Criteria
Hide Criteria
Data coverage:
Player game data: since 1933. Scoring statistics (TD, XP, FG) are complete. Yardage and attempts statistics are nearly complete. Game participation data since 1970.
Player season data: all-time (since 1920). Scoring statistics (TD, XP, FG) are complete all-time. Yardage and attempts statistics were not recorded until 1932. Advanced stats since 2018.
Team Game data: since 1920. Before 1940, only wins, losses, points for, and points allowed are available. Scoring statistics (TD, XP, FG) are complete since 1920. Yardage and attempts statistics are nearly complete since 1933.
Team Season data: since 1940. Scoring statistics (TD, XP, FG) are complete all-time.
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.
We're Social...for Statheads
Site Last Updated:
Question, Comment, Feedback, or Correction?
Subscribe to our Free Email Newsletter
Do you have a sports website? Or write about sports? We have tools and resources that can help you use sports data. Find out more.