Team Game Stats Finder - Pro Football

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

main

Page Setup Time: 0.00247 seconds

SELECT ts.name_abbr as team_name_abbr, ts.link as team_link, os.name_abbr as opp_name_abbr, opp_team_link, date, game_id, year_id as year_id_csk, year_id as year_id, IF(home_away_neutral="H","",IF(home_away_neutral="A","@","N")) as game_location, (SELECT points-points_opp+ifnull(points,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, CONCAT((SELECT CONCAT(IF(win=1,'W',IF(loss=1,'L','T')),', ',points,'-',points_opp) FROM sup_team_games tg2 WHERE tg2.game_id=st.game_id AND tg2.team_id=st.team_id),IF(overtimes>0,IF(overtimes>1,CONCAT(' (',overtimes,'OT)'),' (OT)'),'')) as game_result, sup_games.link as game_link, comp_id, LEFT(DAYNAME(`date`), 3) as game_day_of_week, team_game_num_season as game_num, week_num_season as week_num, pass_cmp, pass_att, (pass_att-pass_cmp) AS pass_inc, IF(pass_att, pass_cmp/pass_att, NULL) as pass_cmp_pct_csk, ROUND(100 * (IF(pass_att, pass_cmp/pass_att, NULL)),1) AS pass_cmp_pct, pass_yds, pass_td, pass_int, IF(pass_att, pass_td/pass_att, NULL) as pass_td_pct_csk, ROUND(100 * (IF(pass_att, pass_td/pass_att, NULL)),1) AS pass_td_pct, IF(pass_att, pass_int/pass_att, NULL) as pass_int_pct_csk, ROUND(100 * (IF(pass_att, pass_int/pass_att, NULL)),1) AS pass_int_pct, IF(pass_att = 0, NULL, 
  ROUND(100 *
  (1.0 / 6.0) *
  (LEAST(GREATEST(((pass_cmp / pass_att) - 0.3) / 0.2, 0), 2.375)
  + LEAST(GREATEST((((pass_yds+ifnull(pass_sacked_yds,0))  / pass_att) - 3.0) / 4.0, 0.0), 2.375)
  + LEAST(GREATEST( (pass_td  / pass_att) / 0.05, 0.0), 2.375)
  + LEAST(GREATEST((0.095 - (pass_int / pass_att)) / 0.04, 0.0), 2.375)
  ),
   1)
  ) 
  as pass_rating_csk, ROUND(IF(pass_att = 0, NULL, 
  ROUND(100 *
  (1.0 / 6.0) *
  (LEAST(GREATEST(((pass_cmp / pass_att) - 0.3) / 0.2, 0), 2.375)
  + LEAST(GREATEST((((pass_yds+ifnull(pass_sacked_yds,0))  / pass_att) - 3.0) / 4.0, 0.0), 2.375)
  + LEAST(GREATEST( (pass_td  / pass_att) / 0.05, 0.0), 2.375)
  + LEAST(GREATEST((0.095 - (pass_int / pass_att)) / 0.04, 0.0), 2.375)
  ),
   1)
  ) ,
  1) AS pass_rating, pass_sacked, pass_sacked_yds, IF(pass_sacked IS NULL, NULL, pass_sacked/(pass_sacked+pass_att) ) as pass_sacked_pct_csk, ROUND(100 * (IF(pass_sacked IS NULL, NULL, pass_sacked/(pass_sacked+pass_att) )),2) AS pass_sacked_pct, IF(pass_att, ((pass_yds)/(pass_att)), NULL) as pass_yds_per_att_csk, ROUND(IF(pass_att, ((pass_yds)/(pass_att)), NULL),1) AS pass_yds_per_att, (pass_yds)/(pass_sacked+pass_att) as pass_net_yds_per_att_csk, ROUND((pass_yds)/(pass_sacked+pass_att),2) AS pass_net_yds_per_att, IF(pass_att,((pass_yds + (20.0 * pass_td) - (45.0 * pass_int))/(pass_att)),NULL) as pass_adj_yds_per_att_csk, ROUND(IF(pass_att,((pass_yds + (20.0 * pass_td) - (45.0 * pass_int))/(pass_att)),NULL),2) AS pass_adj_yds_per_att, IF(pass_sacked is NULL,NULL,((pass_yds + (20.0 * pass_td) - (45.0 * pass_int))/(pass_sacked+pass_att))) as pass_adj_net_yds_per_att_csk, ROUND(IF(pass_sacked is NULL,NULL,((pass_yds + (20.0 * pass_td) - (45.0 * pass_int))/(pass_sacked+pass_att))),2) AS pass_adj_net_yds_per_att, IF(pass_cmp, pass_yds/pass_cmp, NULL) as pass_yds_per_cmp_csk, ROUND(IF(pass_cmp, pass_yds/pass_cmp, NULL),1) AS pass_yds_per_cmp
FROM sup_team_games as st
  JOIN sup_games USING (game_id)
  JOIN sup_phase_seasons USING (comp_id, phase_id, year_id)
  JOIN sup_comp_seasons USING (comp_id, year_id)
  JOIN (SELECT team_id, year_id, name_abbr, name, link FROM sup_team_seasons GROUP BY team_id, year_id ) as ts USING (team_id, year_id)
  LEFT JOIN (SELECT team_id as opp_team_id, link as opp_team_link, year_id, name_abbr FROM sup_team_seasons GROUP BY team_id, year_id ) as os USING (opp_team_id, year_id)
WHERE type="reg"
  AND team_id=?
  AND opp_team_id=?
  AND date < current_date() 
ORDER BY pass_td DESC, date DESC, team_id LIMIT 0, 20

SQL PARAMS -- $VAR1 = [
          'nor',
          'rav'
        ];

Query Time: 0.04 seconds
Table Build Time: 0.04 seconds


--------------------------------------
SH->PARAM -- $VAR1 = {
          'week_num_season_min' => 1,
          'team_game_num_season_min' => 1,
          'team_game_num_season_max' => 17,
          'comp_type' => 'reg',
          'match' => 'team_game',
          'order_by' => 'pass_td',
          'timeframe' => 'seasons',
          'team_id' => 'nor',
          'week_num_season_max' => 22,
          'opp_team_id' => 'rav'
        };
SH->PARAM_NO_DEFAULT -- $VAR1 = {
          'opp_team_id' => 'rav',
          'team_id' => 'nor'
        };