Senior County Team

Winners

In 2017, our Senior County won the National inter-county Crosfield Cup competition for the second time beating The Potteries and District in a thrilling final.

We previously held the cup in 2005 (beating North Lancs & Fylde) and have been runners up in 1960, 61, 68, 91, 93, 2001, 2002 and 2014.

All matches involve a home team of 12 and an away team of 12 playing at the same time in a league format. The top team from each league progress to a knockout semi-final. A ‘Supplementary Competition’ of eight aside is played between those Counties not making the final stages of the main cup.

Full details of the County Championship can be viewed here.
Full details of the Supplementary Cup can be viewed here.

[insert_php]Global $league, $year; $league = 2; $year = 2018; [/insert_php]

[insert_php]
Global $insert, $league, $year;
if($year !== “”) { $insert = “where homefor is not null and oidleague = $league and EXTRACT(YEAR FROM matchdate) = $year”; }
[/insert_php]


[insert_php]
Global $insert, $league;
try
{
$dbh = new PDO(getConnString(), getUser(), getpw());
#$dbh->setAttribute( PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION );

if($league> 0)
{
$teamQ =$dbh->Query( “SELECT day from league where oidleague = $league”);
$team = $teamQ->fetch();
echo(“

“.$team[‘day’].”

“);
}

$sql = “SELECT oidcountymatches, matchdate as \”Date\”,opponent as \”Opponent\”,homefor+awayfor as \”For\”,homeopp+awayopp as \”Against\”,overallresult as \”Result\”, isincomplete, notes, issupplemental FROM countymatches $insert order by matchdate desc”;
echo “

“;
echo “

“;
echo “

“;
echo “

“;
echo “

“;
echo “

“;
echo “

“;
echo “

“;
foreach ($dbh->query($sql) as $row)
{
$date = date(“jS F Y”, strtotime($row[‘Date’]));
$oidCM = $row[‘oidcountymatches’];
echo “

“;
echo “

“;
echo “

“;
echo “

“;
echo “

“;
echo “

“;
if($row[‘isincomplete’] == true) { echo “

“; }
else { echo “

“; }
echo “

“;
}
echo “

DateOpponentFA
“.$date.”“.$row[‘Opponent’];
if(!is_null($row[‘notes’]))
{
echo ” (“.$row[‘notes’].”)”;
}
if($row[‘issupplemental’] == true)
{
echo ” *”;
}
$incomplete = $row[‘isincomplete’] == true;
if($incomplete) { echo ” #”; }
echo”
“.$row[‘For’].”“.$row[‘Against’].”“.$row[‘Result’].”

“;
$dbh= null;
echo “

# incomplete results held, * Supplemental match

“;
}
catch(PDOException $e) { echo $e; }
[/insert_php]


Full(ish) history of results can be viewed here.

[insert_php]
function getPlayerLink($player)
{
return “$player“;
}

Global $league;
try
{
$mode = $_GET[“mode”];
if(is_null($mode)) { $mode = “Aggregate”; }
$dbh = new PDO(getConnString(), getUser(), getpw());
$dbh->setAttribute( PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION );
if($league !== null) {$sqlTeams = “SELECT oidleague, day as \”Team\” FROM league where oidleague = $league”;}
else {$sqlTeams = “SELECT oidleague, day as \”Team\” FROM league where oidleague <> 1″;}
foreach ($dbh->query($sqlTeams) as $rowTeam)
{
echo “

“.$rowTeam[‘Team’].” Top Stats

“;
echo “

“;
echo “

“;
echo “

“;
echo “

“;
echo “

“;
echo “

“;
echo “

“;
echo “

“;

$mod = “rowEven”;
$oidleague = $rowTeam[‘oidleague’];
$sqlPlayers = “SELECT * FROM playerstats WHERE oidleague = $oidleague and played >= 5 ORDER BY $mode DESC limit 10”;
foreach ($dbh->query($sqlPlayers) as $rowStats)
{
echo “

“;
echo “

“;
echo “

“;
echo “

“;
echo “

“;
echo “

“;
echo “

“;
echo “

“;
echo “

“;
if($mod == “rowEven”) { $mod = “rowOdd”; }
else { $mod = “rowEven”; }
}
echo “

PlayerPldW%WonFirstLastAgg
“.getPlayerLink($rowStats[‘homeplayer’]).”“.$rowStats[‘played’].”“.round($rowStats[‘wp’],1).”%“.$rowStats[‘won’].”“.date(“jS M Y”, strtotime($rowStats[‘firstplayed’])).”“. date(“jS M Y”, strtotime($rowStats[‘lastplayed’])).”“.$rowStats[‘aggregate’].”

“;
}
$dbh = null;
}
catch(PDOException $e) { echo $e; }
[/insert_php]