Dunleavy League 2014-2015

Please visit the 2014-15 overview of internal competitions for an explanation of the Dunleavy League. See also this news item for an account of how the Dunleavy 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] [DunL] [2014-2015] [2] [Currently no games have been played in the Dunleavy League for the second part of the 2017-18 season.]}

Final Leaderboard for 2nd 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 ='DunL' 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='DunL' 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}

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 David Archer and Ken Ashby will be promoted to the Homan League, while Roy Greenhalgh will play a play-off against Cliff Peach (who finished third in the Homan 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] [DunL] [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 ='DunL' 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='DunL' 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 Dunleavy League for the current 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='DunL' AND season='2014-2015' AND deleted='No' ORDER BY date_of_game" headerNames="Date, White, Result, Black, PGN?"}{/artsqltable}{/artdatatable}