Challengers League 2014-15
Please visit the 2014-15 overview of internal competitions for an explanation of the Challengers League.
Leaderboard
Here is the final leaderboard for the Challengers League. Click on a column heading to sort the table according to that column; click again to reverse the sort order.
{artdatatable bInfo="false" bSort="true" sort="10, '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, points FROM shm_player_stats WHERE team_id='ChaL' AND season='2014-2015' AND user_id = '9999' ORDER BY perf DESC " headerNames="Name,Grade,ECF,P,W,D,L,Ave Op,Perf,%,Pts"}{/artsqltable}{/artdatatable}
{artdatatable bInfo="false" bSort="true" sort="9, 'desc', 8, 'desc' " bFilter="false" bAutoWidth="true" bPaginate="false"}{artsqltable query="SELECT name, grade, played, won, drawn, lost, ave_opp, perf, percent, points FROM shm_player_stats WHERE team_id='ChaL' AND season='2014-2015' AND user_id = '9999' ORDER BY perf DESC " headerNames="Name,Grade,P,W,D,L,Ave Op,Perf,%,Pts"}{/artsqltable}{/artdatatable}
Congratulations to Anderson McCammont - winner of the Challengers League for 2014-15.
Pre-Arranged Games
Any Challengers Leagues games which have been pre-arranged but not yet played are set out below. If you are logged in as a member you can record on this website a game that you have pre-aranged by clicking here.
{artdatatable bFilter="false" bInfo="false" bPaginate="false" bSort="false"}{artsqltable query="SELECT CONCAT('
', cf_id, ''), game_date, CONCAT(white_surname, ', ', white_firstname), CONCAT(black_surname, ', ', black_firstname) FROM shm_pre_arranged_games WHERE competition_code = 'ChaL' AND DATE_FORMAT(NOW() + INTERVAL 5 hour, '%Y-%m-%d') <= game_date AND deleted = 'No' ORDER BY game_date" headerNames="Ref, Date, Player 1, Player 2"}{/artsqltable}{/artdatatable}
Individual Game Results
The individual game results in the Challengers League for the current season will appear 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='ChaL' AND season='2014-2015' AND deleted='No' ORDER BY date_of_game" headerNames="Date, White, Result, Black, PGN?"}{/artsqltable}{/artdatatable}
