The M. Wray Shield 2014-15

This year we are reviving the M. Wray Shield. Back in the days when the club was much larger, it was a competition for players who were knocked out in the first round of the Cookworthy Cup. This year it will be a competition for the players entered into the Preliminary Competition of the Cookworthy Cup. So this year the entrants will be Ken Ashby, Barry Sweetman, Tony Collins, Anderson McCommant and Derek Drake. It will be an all-play-all format, with one game against each opponent, and a toss for colours for each game.

Leaderboard

Here is the final leaderboard for the M. Wray Shield. 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='Wray' 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='Wray' 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 Ken Ashby - winner of the M. Wray Shield for 2014-15.

Pre-Arranged Games

Any M. Wray Shield 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 = 'Wray' 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 M. Wray Shield 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='Wray' AND season='2014-2015' AND deleted='No' ORDER BY date_of_game" headerNames="Date, White, Result, Black, PGN?"}{/artsqltable}{/artdatatable}