Homan League 2014-15

Please visit the 2014-15 overview of internal competitions for an explanation of the Homan League. See also this news item for an account of how the Homan League was re-configured in January for the second half of the season.

Final Results Matrix for 2nd Half of 2014-15 Season

{jumi [jumicode/results_matrix.php] [HomL] [2014-2015] [2] []}

Final Leaderboard for 2nd Half of 2016-17 Season

Here is the final leaderboard for the Homan League for the second half of the season. Click on a column heading to sort the table according to that column; click again to reverse the sort order. Note that in January 2015 Dennis Russell was promoted to the Homan League from the Dunleavy League. However he has been unable to play a sufficient number of games in the Homan League since then, and he has been withdrawn from the competition - making it a four-way competition between Ben, Cliff, James and Phil. Games the involving Dennis have been scratched from the league table (though they still count for grading purposes).

{artdatatable bInfo="false" bSort="true" sort="11, 'desc', 9, 'desc' " bFilter="false" bAutoWidth="true" bPaginate="false"}{artsqltable query="SELECT name, grade,CONCAT('',ecf_code,''), played, won, drawn, lost, ave_opp, perf, percent, defaulted, points FROM shm_player_stats WHERE team_id='HomL' AND season='2014-2015' AND part_season='2' AND user_id = '9999' ORDER BY perf DESC " headerNames="Name,Grade,ECF,P,W,D,L,Ave Op,Perf,%,Def Pts,Pts"}{/artsqltable}{/artdatatable}

{artdatatable bInfo="false" bSort="true" sort="10, 'desc', 8, 'desc' " bFilter="false" bAutoWidth="true" bPaginate="false"}{artsqltable query="SELECT name, grade, played, won, drawn, lost, ave_opp, perf, percent, defaulted, points FROM shm_player_stats WHERE team_id='HomL' AND season='2014-2015' AND part_season='2' AND user_id = '9999' ORDER BY perf DESC " headerNames="Name,Grade,P,W,D,L,Ave Op,Perf,%,Def,Pts"}{/artsqltable}{/artdatatable}

As winner of the Homan league, Phil McConnell is the Club Champion for 2014-2015.

Unless new players are inserted into the leagues at the start of the 2015-16 season, the expectation is that at the start of the season James Fowler and Dennis Russell will be relegated to the Dunleavy League, while Clifford Peach will play a play-off against Roy Greenhalgh (who finished third in the Dunleavy League); the winner of the play-off will play in the Homan league, and the loser will play in the Dunleavy League.

Final Results Matrix for 1st Half of 2014-15 Season

{jumi [jumicode/results_matrix.php] [HomL] [2014-2015] [1] []}

Final Leaderboard for 1st Half of 2014-15 Season

{artdatatable bInfo="false" bSort="true" sort="11, 'desc', 9, 'desc' " bFilter="false" bAutoWidth="true" bPaginate="false"}{artsqltable query="SELECT name, grade,CONCAT('',ecf_code,''), played, won, drawn, lost, ave_opp, perf, percent, defaulted, points FROM shm_player_stats WHERE team_id='HomL' AND season='2014-2015' AND part_season='1' AND user_id = '9999' ORDER BY perf DESC " headerNames="Name,Grade,ECF,P,W,D,L,Ave Op,Perf,%,Def Pts,Pts"}{/artsqltable}{/artdatatable}

{artdatatable bInfo="false" bSort="true" sort="10, 'desc', 8, 'desc' " bFilter="false" bAutoWidth="true" bPaginate="false"}{artsqltable query="SELECT name, grade, played, won, drawn, lost, ave_opp, perf, percent, defaulted, points FROM shm_player_stats WHERE team_id='HomL' AND season='2014-2015' AND part_season='1' AND user_id = '9999' ORDER BY perf DESC " headerNames="Name,Grade,P,W,D,L,Ave Op,Perf,%,Def,Pts"}{/artsqltable}{/artdatatable}

Individual Game Results

The individual game results in the Homan League for the 2014-15 season are set out below. To limit the display to games involving a particular player, start typing that player's name in the "Filter" box.

{artdatatable bInfo="false" bFilter="true" bPaginate="false" iDisplayLength="10" bSort="true" sort="0, 'desc' "}{artsqltable query="SELECT DATE_FORMAT(date_of_game,'%d %b %Y'), CONCAT(white_surname, ', ',white_firstname, ' (', white_grade, ')'), result, CONCAT(black_surname, ', ',black_firstname, ' (', black_grade, ')'), CASE pgn_indic WHEN 'Submit' THEN CONCAT ('', pgn_indic, '') WHEN 'View' THEN CONCAT ('', pgn_indic, '') END AS display_indic FROM shm_games WHERE competition_code='HomL' AND season='2014-2015' AND deleted='No' ORDER BY date_of_game" headerNames="Date, White, Result, Black, PGN?"}{/artsqltable}{/artdatatable}