Fulham

English League Championship English Premier League

2017 2016 2015 2014

Ranking Summary

Error: Query produced zero results: SELECT `Team`, `Aggregate Rank`, `Over / Under Rank`, `PPM Rank`, `Goal Difference Rank`, `Three Factors Rank`, `Home / Away Rank`, `Team Rating Rank` FROM ( SELECT Team, @a := IF(@as = `Aggregate Avg`, @a, @a+1) AS `Aggregate Rank`, Rank - @a AS `Over / Under Rank`, `PPM Rank`, `Goal Difference Rank`, `Three Factors Rank`, `Home / Away Rank`, `Team Rating Rank`, @as := `Aggregate Avg` FROM (SELECT @a:=0) AS a_i, ( SELECT l.Team, (r_2.Rank + r_3.Rank + r_4.Rank + r_5.Rank) / 4 AS `Aggregate Avg`, r_1.Rank, r_1.String AS `PPM Rank`, r_2.String AS `Goal Difference Rank`, r_3.String AS `Three Factors Rank`, r_4.String AS `Home / Away Rank`, r_5.String AS `Team Rating Rank` FROM league_summary AS l JOIN ( SELECT Team, @r_1 := IF(@rs_1 = `PPM Avg`, @r_1, @r_1+1) AS `Rank`, CONCAT(FORMAT(`PPM Avg`, 2), ' (', @r_1, ')') AS `String`, @rs_1 := `PPM Avg` FROM (SELECT @r_1:=0, @rs_1:='') i, league_summary r_1 WHERE Summary = 1 AND League = 'English League Championship' AND Season = '2018' ORDER BY `PPM Avg` DESC ) AS r_1 ON l.Team = r_1.Team JOIN ( SELECT Team, @r_2 := IF(@rs_2 = `GD Avg`, @r_2, @r_2+1) AS `Rank`, CONCAT(FORMAT(`GD Avg`, 2), ' (', @r_2, ')') AS `String`, @rs_2 := `GD Avg` FROM (SELECT @r_2:=0, @rs_2:='') i, league_summary r_2 WHERE Summary = 1 AND League = 'English League Championship' AND Season = '2018' ORDER BY `GD Avg` DESC ) AS r_2 ON l.Team = r_2.Team JOIN ( SELECT Team, @r_3 := IF(@rs_3 = `Three Factors Rating`, @r_3, @r_3+1) AS `Rank`, CONCAT(FORMAT(`Three Factors Rating`, 2), ' (', @r_3, ')') AS `String`, @rs_3 := `Three Factors Rating` FROM (SELECT @r_3:=0, @rs_3:='') i, league_summary r_3 WHERE Summary = 1 AND League = 'English League Championship' AND Season = '2018' ORDER BY `Three Factors Rating` DESC ) AS r_3 ON l.Team = r_3.Team JOIN ( SELECT Team, @r_4 := IF(@rs_4 = `Home / Away Rating`, @r_4, @r_4+1) AS `Rank`, CONCAT(FORMAT(`Home / Away Rating`, 2), ' (', @r_4, ')') AS `String`, @rs_4 := `Home / Away Rating` FROM (SELECT @r_4:=0, @rs_4:='') i, league_summary r_4 WHERE Summary = 1 AND League = 'English League Championship' AND Season = '2018' ORDER BY `Home / Away Rating` DESC ) AS r_4 ON l.Team = r_4.Team JOIN ( SELECT Team, @r_5 := IF(@rs_5 = `Team Rating`, @r_5, @r_5+1) AS `Rank`, CONCAT(FORMAT(`Team Rating`, 0), ' (', @r_5, ')') AS `String`, @rs_5 := `Team Rating` FROM (SELECT @r_5:=0, @rs_5:='') i, league_summary r_5 WHERE Summary = 1 AND League = 'English League Championship' AND Season = '2018' ORDER BY `Team Rating` DESC ) AS r_5 ON l.Team = r_5.Team WHERE Summary = 1 AND League = 'English League Championship' AND Season = '2018' ORDER BY `Aggregate Avg` ) a ) f WHERE `Team` = 'Fulham'

Team Stats

Error: Query produced zero results: SELECT DATE(`Date`) AS `Date`, `Opponent`, `Location`, `Points`, `Minutes`, `Total Shots`, `SoT`, `Total Shots Allowed`, `SoT Allowed` FROM team_match_info WHERE 1=1 AND League = 'English League Championship' AND Season = '2018' AND `Team` = 'Fulham' ORDER BY Date

Offense

Error: Query produced zero results: SELECT DATE(`Date`) AS `Date`, `Opponent`, `Location`, `Goals Scored`, CONCAT(FORMAT(`Shots / 96`, 1), '%') AS `Shots / 96`, CONCAT(FORMAT(`SoT / Sh`, 1), '%') AS `SoT / Sh`, CONCAT(FORMAT(`Scoring %`, 1), '%') AS `Scoring %` FROM team_match_info WHERE 1=1 AND League = 'English League Championship' AND Season = '2018' AND `Team` = 'Fulham' ORDER BY Date

Defense

Error: Query produced zero results: SELECT DATE(`Date`) AS `Date`, `Opponent`, `Location`, `Goals Allowed`, CONCAT(FORMAT(`Def Shots / 96`, 1), '%') AS `Def Shots / 96`, CONCAT(FORMAT(`Def SoT / Sh`, 1), '%') AS `Def SoT / Sh`, CONCAT(FORMAT(`Def Scoring %`, 1), '%') AS `Def Scoring %` FROM team_match_info WHERE 1=1 AND League = 'English League Championship' AND Season = '2018' AND `Team` = 'Fulham' ORDER BY Date

Point and Goal Trends

Error: Query produced zero results: SELECT DATE(`Date`) AS `Date`, `Opponent`, `Location`, FORMAT(`PPM Avg`, 2) AS `PPM Avg`, FORMAT(`GS Avg`, 2) AS `GS Avg`, FORMAT(`GA Avg`, 2) AS `GA Avg`, FORMAT(`GD Avg`, 2) AS `GD Avg` FROM ( SELECT `Date`, `Opponent`, `Location`, @g := (SELECT COUNT(*) FROM team_match_info WHERE League = d.League AND Season = d.Season AND Team = d.Team AND Date <= d.Date) AS `Game`, @l := (POW(@g, 2) + @g) / 2 AS `Linear Weight`, (SELECT SUM(`Points`) FROM team_match_info WHERE League = d.League AND Season = d.Season AND Team = d.Team AND Date <= d.Date) / @g AS `PPM Avg`, @gs_sum := IF(@g = 1, (`Goals Scored` * @g), @gs_sum + (`Goals Scored` * @g)) AS `GS Sum`, @gs_sum / @l AS `GS Avg`, @ga_sum := IF(@g = 1, (`Goals Allowed` * @g), @ga_sum + (`Goals Allowed` * @g)) AS `GA Sum`, @ga_sum / @l AS `GA Avg`, (@gs_sum / @l) - (@ga_sum / @l) AS `GD Avg` FROM (SELECT @l:=0, @gs_sum:=0, @ga_sum:=0) AS initialization, ( SELECT * FROM team_match_info WHERE 1=1 AND League = 'English League Championship' AND Season = '2018' AND `Team` = 'Fulham' ORDER BY Team, Date ) AS d WHERE 1=1 AND League = 'English League Championship' AND Season = '2018' AND `Team` = 'Fulham' ORDER BY Team, Date ) t

Offensive Shot and Scoring Trends

Error: Query produced zero results: SELECT DATE(`Date`) AS `Date`, `Opponent`, `Location`, CONCAT(FORMAT(`Shots / 96 Avg`, 1), '%') AS `Shots / 96 Avg`, CONCAT(FORMAT(`SoT / Sh Avg`, 1), '%') AS `SoT / Sh Avg`, CONCAT(FORMAT(`Scoring % Avg`, 1), '%') AS `Scoring % Avg` FROM ( SELECT `Date`, `Opponent`, `Location`, @g := (SELECT COUNT(*) FROM team_match_info WHERE League = d.League AND Season = d.Season AND Team = d.Team AND Date <= d.Date) AS `Game`, @l := (POW(@g, 2) + @g) / 2 AS `Linear Weight`, @shots96_sum := IF(@g = 1, (`Shots / 96` * @g), @shots96_sum + (`Shots / 96` * @g)) AS `Shots / 96 Sum`, @shots96_sum / @l AS `Shots / 96 Avg`, @sotsh_sum := IF(@g = 1, (`SoT / Sh` * @g), @sotsh_sum + (`SoT / Sh` * @g)) AS `SoT / Sh Sum`, @sotsh_sum / @l AS `SoT / Sh Avg`, @scoring_sum := IF(@g = 1, (`Scoring %` * @g), @scoring_sum + (`Scoring %` * @g)) AS `Scoring % Sum`, @scoring_sum / @l AS `Scoring % Avg` FROM ( SELECT @l:=0, @shots96_sum:=0, @sotsh_sum:=0, @scoring_sum:=0 ) AS initialization, ( SELECT * FROM team_match_info WHERE 1=1 AND League = 'English League Championship' AND Season = '2018' AND `Team` = 'Fulham' ORDER BY Team, Date ) AS d WHERE 1=1 AND League = 'English League Championship' AND Season = '2018' AND `Team` = 'Fulham' ORDER BY Team, Date ) t

Defensive Shot and Scoring Trends

Error: Query produced zero results: SELECT DATE(`Date`) AS `Date`, `Opponent`, `Location`, CONCAT(FORMAT(`Def Shots / 96 Avg`, 1), '%') AS `Def Shots / 96 Avg`, CONCAT(FORMAT(`Def SoT / Sh Avg`, 1), '%') AS `Def SoT / Sh Avg`, CONCAT(FORMAT(`Def Scoring % Avg`, 1), '%') AS `Def Scoring % Avg` FROM ( SELECT `Date`, `Opponent`, `Location`, @g := (SELECT COUNT(*) FROM team_match_info WHERE League = d.League AND Season = d.Season AND Team = d.Team AND Date <= d.Date) AS `Game`, @l := (POW(@g, 2) + @g) / 2 AS `Linear Weight`, @defshots96_sum := IF(@g = 1, (`Def Shots / 96` * @g), @defshots96_sum + (`Def Shots / 96` * @g)) AS `Def Shots / 96 Sum`, @defshots96_sum / @l AS `Def Shots / 96 Avg`, @defsotsh_sum := IF(@g = 1, (`Def SoT / Sh` * @g), @defsotsh_sum + (`Def SoT / Sh` * @g)) AS `Def SoT / Sh Sum`, @defsotsh_sum / @l AS `Def SoT / Sh Avg`, @defscoring_sum := IF(@g = 1, (`Def Scoring %` * @g), @defscoring_sum + (`Def Scoring %` * @g)) AS `Def Scoring % Sum`, @defscoring_sum / @l AS `Def Scoring % Avg` FROM ( SELECT @l:=0, @defshots96_sum:=0, @defsotsh_sum:=0, @defscoring_sum:=0 ) AS initialization, ( SELECT * FROM team_match_info WHERE 1=1 AND League = 'English League Championship' AND Season = '2018' AND `Team` = 'Fulham' ORDER BY Team, Date ) AS d WHERE 1=1 AND League = 'English League Championship' AND Season = '2018' AND `Team` = 'Fulham' ORDER BY Team, Date ) t

Shot Summary Trends

Error: Query produced zero results: SELECT DATE(`Date`) AS `Date`, `Opponent`, `Location`, FORMAT(`Shots Avg`, 1) AS `Shots Avg`, FORMAT(`SoT Avg`, 1) AS `SoT Avg`, FORMAT(`Shots Allowed Avg`, 1) AS `Shots Allowed Avg`, FORMAT(`SoT Allowed Avg`, 1) AS `SoT Allowed Avg`FROM ( SELECT `Date`, `Opponent`, `Location`, @g := (SELECT COUNT(*) FROM team_match_info WHERE League = d.League AND Season = d.Season AND Team = d.Team AND Date <= d.Date) AS `Game`, @l := (POW(@g, 2) + @g) / 2 AS `Linear Weight`, @shots_sum := IF(@g = 1, (`Total Shots` * @g), @shots_sum + (`Total Shots` * @g)) AS `Shots Sum`, @shots_sum / @l AS `Shots Avg`, @sot_sum := IF(@g = 1, (`SoT` * @g), @sot_sum + (`SoT` * @g)) AS `SoT Sum`, @sot_sum / @l AS `SoT Avg`, @shotsa_sum := IF(@g = 1, (`Total Shots Allowed` * @g), @shotsa_sum + (`Total Shots Allowed` * @g)) AS `Shots Allowed Sum`, @shotsa_sum / @l AS `Shots Allowed Avg`, @sota_sum := IF(@g = 1, (`SoT Allowed` * @g), @sota_sum + (`SoT Allowed` * @g)) AS `SoT Allowed Sum`, @sota_sum / @l AS `SoT Allowed Avg` FROM ( SELECT @l:=0, @shots_sum:=0, @sot_sum:=0, @shotsa_sum:=0, @sota_sum:=0 ) AS initialization, ( SELECT * FROM team_match_info WHERE 1=1 AND League = 'English League Championship' AND Season = '2018' AND `Team` = 'Fulham' ORDER BY Team, Date ) AS d WHERE 1=1 AND League = 'English League Championship' AND Season = '2018' AND `Team` = 'Fulham' ORDER BY Team, Date ) t