Join the WRU Ezine Mailing List Name E-mail
SWALEC Leagues Poll
Will a WRU National League be settled by March?
Yes
No - April
No - May
SWALEC League Five North Table
2008-2009 - SWALEC Leagues
Pos
Team
P
W
D
L
F
A
TF
TA
TB
LB
Pts
1Bro Ffestiniog RFC1817017931761242116084
2Bethesda RFC1816027341681091914179
3COBRA18140452018179218165
4Rhyl and District RFC18100837140555587249
5Newtown RFC18100830739439574242
6Machynlleth RFC18801056543083659542
7Wrexham RFC18801030643547635239
8Welshpool RFC18401431347844753524
9Rhosllanerchrugog RFC18301520557834904214
10Bangor RFC18001812599418163000
Notes:
Machynlleth RFC (-4) : Failed to play fixture at Rhosllenerchrugog
Rhosllanerchrugog RFC (-4) : Failed to play COBRA RFC on 7.3.09.
Newtown RFC (-4) : Failed to play Bro Ffestiniog RFC on 28.2.09.
SWALEC League Five North Fixtures & Results
SELECT TeamTicketLink AS BuyTickets, FixId, FixSource, FixDate, FixTime, FixDays,IF(FixTime IS NOT NULL,CONVERT_TZ(CONCAT(FixDate,' ',FixTime),@@global.time_zone,'+00:00'),NULL) AS GMTFixDateTime, IF(FixTime IS NOT NULL,CONCAT(FixDate,' ',FixTime),NULL) AS FixDateTime, TIME_FORMAT(FixTime,'%H:%i') AS TimeLong, TIME_FORMAT(FixTime,'%l:%i') AS TimeShort, DATE_FORMAT(FixDate,'%e/%c') AS DateDmShort, DATE_FORMAT(FixDate,'%d/%m') AS DateDmLong, DATE_FORMAT(FixDate,'%e/%c/%y') AS DateDmyShort, DATE_FORMAT(FixDate,'%d/%m/%Y') AS DateDmyLong, DATE_FORMAT(FixDate,'%a %e %b') AS DateShort, DATE_FORMAT(FixDate,'%a %D %b %y') AS DateAbbrev, DATE_FORMAT(FixDate,'%W %D %M %Y') AS DateLong, DATE_FORMAT(FixDate,'%a') AS DayShort, DATE_FORMAT(FixDate,'%d %b') AS DateDmTxt, FixTeamA, FixTeamB, CompGroup, CompSubGroup, CompSponsor, CompLive, FixRound AS Round, FixVenType, IF(VnnmVenueId IS NULL,FixVenCustom,VnnmFullName) AS VenName, teamsa.TmnmDisplay AS HomeDisplay, teamsb.TmnmDisplay AS AwayDisplay, teamsa.TmnmShort AS HomeShort, teamsb.TmnmShort AS AwayShort, FixTryA, FixConvA, FixDropA, FixPenA, FixMarkA, FixTryB, FixConvB, FixDropB, FixPenB, FixMarkB, FixFullPtsA, FixFullPtsB, FixStatus, FixAttend, FixBroadcast AS Broadcast, FixLive, ProvName, DataTicketInfo AS Ticketing, DataSeasonTicket AS SeasonTicket, DataTicketLink AS TicketLink, FixRefOffId, FixTjaOffId, FixTjbOffId, FixFourOffId, FixTmoOffId, FixAssrOffId, FixComrOffId, FixRefName, 0+IF(FixSource='sfms',0,0)+IF(FixSource='wru',1,0)+IF(FixSource='writemedia',2,0) AS Ord, DataReport, GROUP_CONCAT(DISTINCT StgId ORDER BY StgOrd, StgName ASC SEPARATOR ',') AS StageId, GROUP_CONCAT(DISTINCT StgName ORDER BY StgOrd, StgName ASC SEPARATOR ',') AS StageName, GROUP_CONCAT(DISTINCT StgAbbrev ORDER BY StgOrd, StgName ASC SEPARATOR ',') AS StageAbbrev, GROUP_CONCAT(DISTINCT StgAbbrev ORDER BY StgOrd, StgName ASC SEPARATOR ',') AS StageShortName, GROUP_CONCAT(DISTINCT CompAbbrev ORDER BY CompAbbrev ASC SEPARATOR ',') AS CompAbbrev, GROUP_CONCAT(DISTINCT CompName ORDER BY CompName ASC SEPARATOR ',') AS CompName FROM (stats_rugby.fixtures, stats_rugby.fixcompetitions, stats_rugby.competitions, stats_rugby.stages) LEFT JOIN stats_rugby.teamnames AS teamsa ON teamsa.TmnmTeamId = FixTeamA AND teamsa.TmnmStart <= CompSeason AND (teamsa.TmnmEnd = -1 OR teamsa.TmnmEnd >= CompSeason) LEFT JOIN stats_rugby.teamnames AS teamsb ON teamsb.TmnmTeamId = FixTeamB AND teamsb.TmnmStart <= CompSeason AND (teamsb.TmnmEnd = -1 OR teamsb.TmnmEnd >= CompSeason) LEFT JOIN stats_rugby.venues ON VenId = FixVenId AND (VenSource = 'sfms' OR VenSource = 'wru' OR VenSource = 'writemedia') LEFT JOIN stats_rugby.venuenames ON VnnmVenueId = FixVenId AND VnnmStart <= FixDate AND (venuenames.VnnmEnd = '0000-00-00' OR venuenames.VnnmEnd >= FixDate) LEFT JOIN stats_rugby.broadcasts ON BcastFixId = FixId LEFT JOIN stats_rugby.bcastproviders ON BcastProvId = ProvId LEFT JOIN stats_rugby.fixdata ON DataFixId = FixId AND DataProjId = 'wru' LEFT JOIN stats_rugby.teams ON TeamId = FixTeamA AND (TeamSource = 'sfms' OR TeamSource = 'wru' OR TeamSource = 'writemedia') WHERE FcmpSource = FixSource AND FcmpFixId = FixId AND FcmpCompId = CompId AND FcmpStgId = StgId AND StgCompId = CompId AND FixDate IS NOT NULL AND (FixSource = 'sfms' OR FixSource = 'wru' OR FixSource = 'writemedia') AND FixStgId = 'R5N' AND (0 OR CompGroup = 'wru') AND CompSubGroup = 'leagues' AND (CompVisible = 'Yes' OR CompVisible IS NULL) AND FixStgId = 'R5N' AND (0 OR CompGroup = 'wru') AND CompSubGroup = 'leagues' AND (CompVisible = 'Yes' OR CompVisible IS NULL) AND (((CompSeason = '2008' AND CompSeasonEnd = '2009')) OR CompId IS NULL) GROUP BY FixId, FixSource ORDER BY FixDate ASC, Ord, FixTime, HomeDisplay, AwayDisplay, Ord
DateTimeHomeScoreAway
September 2008
06/09/200814:30Bangor RFC7 - 32Wrexham RFC
06/09/200814:30Newtown RFC8 - 45Bro Ffestiniog RFC
13/09/200814:30Bro Ffestiniog RFC45 - 15Welshpool RFC
13/09/200814:30COBRA29 - 0Newtown RFC
13/09/200814:30Rhyl and District RFC37 - 15Bangor RFC
13/09/200814:30Wrexham RFC3 - 39Bethesda RFC
20/09/200814:30Bethesda RFC63 - 0Bangor RFC
20/09/200814:30Newtown RFC18 - 24Wrexham RFC
20/09/200814:30Rhosllanerchrugog RFC19 - 22Rhyl and District RFC
20/09/200814:30Welshpool RFC18 - 29COBRA
27/09/200814:30Machynlleth RFC8 - 33Bro Ffestiniog RFC
October 2008
04/10/200814:30Bangor RFC10 - 29Newtown RFC
04/10/200814:30Bro Ffestiniog RFC36 - 0Rhosllanerchrugog RFC
04/10/200814:30COBRA14 - 10Machynlleth RFC
04/10/200814:30Rhyl and District RFC8 - 50Bethesda RFC
04/10/200814:30Wrexham RFC43 - 17Welshpool RFC
11/10/200814:30Bro Ffestiniog RFC32 - 0Rhyl and District RFC
11/10/200814:30Machynlleth RFC41 - 15Wrexham RFC
11/10/200814:30Newtown RFC6 - 19Bethesda RFC
11/10/200814:30Rhosllanerchrugog RFC0 - 36COBRA
11/10/200814:30Welshpool RFC63 - 3Bangor RFC
18/10/200814:30Bangor RFC10 - 65Machynlleth RFC
18/10/200814:30Bethesda RFC48 - 0Welshpool RFC
18/10/200814:30COBRA10 - 19Bro Ffestiniog RFC
18/10/200814:30Rhyl and District RFC12 - 10Newtown RFC
18/10/200814:30Wrexham RFC24 - 5Rhosllanerchrugog RFC
November 2008
01/11/200814:30Bro Ffestiniog RFC29 - 15Wrexham RFC
01/11/200814:30COBRA39 - 8Rhyl and District RFC
01/11/200814:30Machynlleth RFC24 - 48Bethesda RFC
01/11/200814:30Rhosllanerchrugog RFC37 - 5Bangor RFC
01/11/200814:30Welshpool RFC18 - 22Newtown RFC
December 2008
06/12/200814:30Bangor RFC0 - 95Bro Ffestiniog RFC
06/12/200814:30Bethesda RFC78 - 11Rhosllanerchrugog RFC
06/12/200814:30Newtown RFC22 - 20Machynlleth RFC
06/12/200814:30Rhyl and District RFC17 - 14Welshpool RFC
06/12/200814:30Wrexham RFC5 - 8COBRA
13/12/200814:30Bro Ffestiniog RFC26 - 6Bethesda RFC
13/12/200814:30COBRA62 - 7Bangor RFC
13/12/200814:30Machynlleth RFC17 - 19Welshpool RFC
13/12/200814:30Rhosllanerchrugog RFC3 - 8Newtown RFC
January 2009
17/01/200914:30Bangor RFC0 - 56Bethesda RFC
17/01/200914:30Bro Ffestiniog RFC53 - 7Machynlleth RFC
17/01/200914:30COBRA21 - 14Welshpool RFC
17/01/200914:30Rhyl and District RFC32 - 12Rhosllanerchrugog RFC
17/01/200914:30Wrexham RFC17 - 18Newtown RFC
24/01/200914:30COBRA14 - 13Bethesda RFC
24/01/200914:30Machynlleth RFC27 - 5Rhosllanerchrugog RFC
24/01/200914:30Wrexham RFC31 - 3Bangor RFC
31/01/200914:30Bethesda RFC33 - 6Rhyl and District RFC
31/01/200914:30Machynlleth RFC10 - 12COBRA
31/01/200914:30Newtown RFC47 - 16Bangor RFC
31/01/200914:30Rhosllanerchrugog RFC0 - 36Bro Ffestiniog RFC
31/01/200914:30Welshpool RFC0 - 12Wrexham RFC
February 2009
21/02/200914:30Bangor RFC12 - 43Rhyl and District RFC
21/02/200914:30Bethesda RFC19 - 11COBRA
28/02/200914:30Rhyl and District RFC28 - 10Machynlleth RFC
March 2009
07/03/200914:30Bangor RFC12 - 31Welshpool RFC
07/03/200914:30Bethesda RFC22 - 13Newtown RFC
07/03/200914:30Rhyl and District RFC17 - 34Bro Ffestiniog RFC
07/03/200914:30Wrexham RFC28 - 27Machynlleth RFC
14/03/200912:00Welshpool RFC12 - 41Bro Ffestiniog RFC
28/03/200914:30Bro Ffestiniog RFC33 - 5COBRA
28/03/200914:30Newtown RFC26 - 23Rhyl and District RFC
28/03/200914:30Rhosllanerchrugog RFC5 - 21Wrexham RFC
28/03/200914:30Welshpool RFC0 - 36Bethesda RFC
April 2009
04/04/200914:30Bangor RFC7 - 50Rhosllanerchrugog RFC
04/04/200914:30Bethesda RFC78 - 12Machynlleth RFC
04/04/200914:30Newtown RFC31 - 11Welshpool RFC
04/04/200914:30Rhyl and District RFC13 - 17COBRA
04/04/200914:30Wrexham RFC11 - 53Bro Ffestiniog RFC
11/04/200914:30Bro Ffestiniog RFC90 - 6Bangor RFC
11/04/200914:30COBRA59 - 0Wrexham RFC
11/04/200914:30Machynlleth RFC57 - 12Newtown RFC
11/04/200914:30Rhosllanerchrugog RFC0 - 38Bethesda RFC
11/04/200914:30Welshpool RFC13 - 29Rhyl and District RFC
18/04/200914:30Bangor RFC0 - 80COBRA
18/04/200914:30Bethesda RFC48 - 31Bro Ffestiniog RFC
18/04/200914:30Newtown RFC17 - 0Rhosllanerchrugog RFC
18/04/200914:30Welshpool RFC19 - 26Machynlleth RFC
18/04/200914:30Wrexham RFC22 - 40Rhyl and District RFC
22/04/200919:15Welshpool RFC32 - 22Rhosllanerchrugog RFC
25/04/200914:30Bethesda RFC40 - 3Wrexham RFC
25/04/200914:30Bro Ffestiniog RFC62 - 8Newtown RFC
25/04/200914:30COBRA68 - 0Rhosllanerchrugog RFC
25/04/200914:30Machynlleth RFC47 - 10Rhyl and District RFC
29/04/200918:00Machynlleth RFC83 - 12Bangor RFC
May 2009
02/05/200914:30Rhosllanerchrugog RFC12 - 74Machynlleth RFC
02/05/200914:30Rhyl and District RFC26 - 0Wrexham RFC
08/05/200918:30Newtown RFC12 - 6COBRA
08/05/200918:30Rhosllanerchrugog RFC24 - 17Welshpool RFC
E-mail this page
Print this page

Welsh Rugby Union Limited: A Company Registered in England & Wales under the Number: 3419514 - Millennium Stadium plc: A Company Registered in England & Wales under the Number: 3176906

International, International Age Grade and Regional Statistics provided by and Copyright SFMS Ltd - Welsh Club and Women's Rugby Results provided by and Copyright Welsh Rugby Union

delivered by Sotic powered by RedDot Web Content Management