In the Local Press

Levy League 2018-19

Please visit the 2018-19 overview of internal competitions for an explanation of the Levy League.

The six players playing in the Levy League for the second half of the 2018-19 season are:
  • Dennis Russell
  • Barry Sweetman
  • Charlie Blackstock
  • Tony Collins
  • Zak Zaffiro
  • Oliver Zaffiro

Current Results Matrix for 2nd Half of 2018-19 Season

{jumi [jumicode/results_matrix.php] [LLL] [2018-2019] [2] [Currently no games have been played in the Levy League for the second part of the 2018-19 season.]}

Current Leaderboard for 2nd Half of 2018-19 Season

{artdatatable bInfo="false" bSort="true" sort="11, 'desc', 9, 'desc' " bFilter="false" bAutoWidth="true" bPaginate="false" noResult="Nothing"}{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='LLL' AND season='2018-2019' 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='LLL' AND season='2018-2019' 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}
 
 
{jumi [jumicode/no_records_found.php] [shm_player_stats] [team_id='LLL' AND season='2018-2019' AND part_season='2' AND user_id = '9999'] [Currently no games have been played in the Levy League for the second part of the 2018-19 season.]}

Final Results Matrix for 1st Half of 2018-19 Season

{jumi [jumicode/results_matrix.php] [LLL] [2018-2019] [1] [Currently no games have been played in the Levy League for the first part of the 2018-19 season.]}

Final Leaderboard for 1st Half of 2018-19 Season

{artdatatable bInfo="false" bSort="true" sort="11, 'desc', 9, 'desc' " bFilter="false" bAutoWidth="true" bPaginate="false" noResult="Nothing"}{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='LLL' AND season='2018-2019' 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='LLL' AND season='2018-2019' 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}
 
{jumi [jumicode/no_records_found.php] [shm_player_stats] [team_id='LLL' AND season='2018-2019' AND part_season='1' AND user_id = '9999'] [Currently no games have been played in the Levy League for the first part of the 2018-19 season.]}
In December 2018, Dennis Russell was relegated from the Dunleavy League to the Levy League, while Cliff Peach and Arthur Doble were promoted from the Levy League to the Dunleavy League.

Pre-Arranged Games

Any Levy 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="true" bInfo="true" bPaginate="false" bSort="false"}{artsqltable query="SELECT CONCAT('', cf_id, ''), shm_pre_arranged_games.match_day_of_week, DATE_FORMAT(game_date, '%d %b %Y'), CONCAT(white_surname, ', ', white_firstname), CONCAT(black_surname, ', ', black_firstname), GROUP_CONCAT(CONCAT(shm_fixtures.competition_code, ': ', home_team_name, ' v ', away_team_name) SEPARATOR '
') FROM shm_pre_arranged_games LEFT JOIN shm_fixtures ON shm_fixtures.deleted = 'No' AND shm_fixtures.match_display_date <> 'TBD' AND shm_pre_arranged_games.game_date = shm_fixtures.match_date WHERE DATE_FORMAT(NOW() + INTERVAL 5 hour, '%Y-%m-%d') <= game_date AND shm_pre_arranged_games.competition_code ='LLL' AND shm_pre_arranged_games.season = '2018-2019' AND shm_pre_arranged_games.deleted = 'No' GROUP BY cf_id ORDER BY game_date" headerNames="Ref, Day, Date, Player 1, Player 2, Club Fixture that Day"}{/artsqltable}{/artdatatable}
 

{jumi [jumicode/no_records_found.php] [shm_pre_arranged_games] [competition_code = 'LLL' AND DATE_FORMAT(NOW() + INTERVAL 5 hour, '%Y-%m-%d') <= game_date AND deleted = 'No'] [Currently there are no outstanding pre-arranged games in the Levy League.]}

Individual Game Results

The individual game results in the Levy League for the second part of the 2018-19 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="true" 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='LLL' AND season='2018-2019' AND part_season = '2' AND deleted='No' ORDER BY date_of_game" headerNames="Date, White, Result, Black, PGN?"}{/artsqltable}{/artdatatable}
 

{jumi [jumicode/no_records_found.php] [shm_games] [competition_code='LLL' AND season='2018-2019' AND part_season = '2' AND deleted='No'][No games have been played yet in the second part of the Levy League 2018-19 season.] }

For the record, the individual game results in the Levy League for the first part of the 2018-19 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="true" 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='LLL' AND season='2018-2019' AND part_season = '1' AND deleted='No' ORDER BY date_of_game" headerNames="Date, White, Result, Black, PGN?"}{/artsqltable}{/artdatatable}
 

{jumi [jumicode/no_records_found.php] [shm_games] [competition_code='LLL' AND season='2018-2019' AND part_season = '1' AND deleted='No'][This season no games have been played yet in the Levy League.] }

Recent News

Click here for reports in the local papers.
... ... more news