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 Two West Table
2009-2010 - SWALEC Leagues
Pos
Team
P
W
D
L
F
A
TF
TA
TB
LB
Pts
1Maesteg RFC14112135213143117055
2BP R.F.C (Llandarcy) RFC15101423720029212246
3Kidwelly RFC1590637724447243443
4Ammanford RFC1481524320225192440
5Waunarlwydd RFC1371529120432184438
6Aberystwyth RFC1570826632332444335
7Loughor RFC1470725526525342434
8Pontyberem RFC1470721332519392131
9Aberavon Quins RFC1160517018718171328
10Mumbles RFC13301018725027282418
11Pencoed RFC14301116325915300618
12Dunvant RFC16311221337721480216
WRU National League Two West 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 = '2W' AND (0 OR CompGroup = 'wru') AND CompSubGroup = 'leagues' AND (CompVisible = 'Yes' OR CompVisible IS NULL) AND FixStgId = '2W' AND (0 OR CompGroup = 'wru') AND CompSubGroup = 'leagues' AND (CompVisible = 'Yes' OR CompVisible IS NULL) AND (((CompSeason = '2009' AND CompSeasonEnd = '2010')) OR CompId IS NULL) GROUP BY FixId, FixSource ORDER BY FixDate ASC, Ord, FixTime, HomeDisplay, AwayDisplay, Ord
DateTimeHomeScoreAway
September 2009
05/09/200914:30BP R.F.C (Llandarcy) RFC33 - 12Aberystwyth RFC
05/09/200914:30Kidwelly RFC21 - 6Aberavon Quins RFC
05/09/200914:30Loughor RFC19 - 14Pencoed RFC
05/09/200914:30Maesteg RFC31 - 6Dunvant RFC
05/09/200914:30Pontyberem RFC14 - 10Ammanford RFC
05/09/200914:30Waunarlwydd RFC25 - 15Mumbles RFC
12/09/200914:30Aberavon Quins RFC10 - 14Waunarlwydd RFC
12/09/200914:30Aberystwyth RFC16 - 17Pontyberem RFC
12/09/200914:30Ammanford RFC22 - 25Loughor RFC
12/09/200914:30Dunvant RFC27 - 17Kidwelly RFC
12/09/200914:30Mumbles RFC10 - 14BP R.F.C (Llandarcy) RFC
12/09/200914:30Pencoed RFC9 - 13Maesteg RFC
19/09/200914:30BP R.F.C (Llandarcy) RFC16 - 10Aberavon Quins RFC
19/09/200914:30Kidwelly RFC18 - 35Maesteg RFC
19/09/200914:30Loughor RFC43 - 7Aberystwyth RFC
19/09/200914:30Pencoed RFC11 - 28Ammanford RFC
19/09/200914:30Pontyberem RFC35 - 31Mumbles RFC
19/09/200914:30Waunarlwydd RFC41 - 21Dunvant RFC
26/09/200914:30Aberavon Quins RFC26 - 10Pontyberem RFC
26/09/200914:30Aberystwyth RFC28 - 11Pencoed RFC
26/09/200914:30Dunvant RFC10 - 17BP R.F.C (Llandarcy) RFC
26/09/200914:30Kidwelly RFC30 - 25Waunarlwydd RFC
26/09/200914:30Maesteg RFC26 - 10Ammanford RFC
26/09/200914:30Mumbles RFC10 - 20Loughor RFC
October 2009
03/10/200914:30Ammanford RFC32 - 10Aberystwyth RFC
03/10/200914:30BP R.F.C (Llandarcy) RFC16 - 22Kidwelly RFC
03/10/200914:30Loughor RFC20 - 24Aberavon Quins RFC
03/10/200914:30Pencoed RFC0 - 5Mumbles RFC
03/10/200914:30Pontyberem RFC32 - 20Dunvant RFC
03/10/200914:30Waunarlwydd RFC30 - 19Maesteg RFC
10/10/200914:30Aberavon Quins RFC18 - 12Pencoed RFC
10/10/200914:30Dunvant RFC5 - 24Loughor RFC
10/10/200914:30Kidwelly RFC42 - 15Pontyberem RFC
10/10/200914:30Maesteg RFC37 - 8Aberystwyth RFC
10/10/200914:30Mumbles RFC8 - 17Ammanford RFC
10/10/200914:30Waunarlwydd RFC11 - 19BP R.F.C (Llandarcy) RFC
17/10/200914:30Aberystwyth RFC24 - 38Mumbles RFC
17/10/200914:30Ammanford RFC10 - 12Aberavon Quins RFC
17/10/200914:30BP R.F.C (Llandarcy) RFC3 - 3Maesteg RFC
17/10/200914:30Loughor RFC18 - 15Kidwelly RFC
17/10/200914:30Pencoed RFC13 - 11Dunvant RFC
17/10/200914:30Pontyberem RFC15 - 13Waunarlwydd RFC
24/10/200914:30BP R.F.C (Llandarcy) RFC23 - 3Pontyberem RFC
24/10/200914:30Dunvant RFC15 - 15Ammanford RFC
24/10/200914:30Kidwelly RFC26 - 8Pencoed RFC
24/10/200914:30Maesteg RFC38 - 8Mumbles RFC
24/10/200914:30Waunarlwydd RFC25 - 10Loughor RFC
November 2009
14/11/200914:30Aberystwyth RFC30 - 8Dunvant RFC
December 2009
05/12/200914:30Dunvant RFC8 - 18Mumbles RFC
05/12/200914:30Kidwelly RFC5 - 6Aberystwyth RFC
05/12/200914:30Maesteg RFC37 - 6Aberavon Quins RFC
05/12/200914:30Pencoed RFC7 - 18BP R.F.C (Llandarcy) RFC
05/12/200914:30Pontyberem RFC8 - 10Loughor RFC
05/12/200914:30Waunarlwydd RFC6 - 9Ammanford RFC
19/12/200914:30Loughor RFC  v  Maesteg RFC
26/12/200914:30Aberavon Quins RFC18 - 14Kidwelly RFC
26/12/200914:30Aberystwyth RFC20 - 15BP R.F.C (Llandarcy) RFC
26/12/200914:30Ammanford RFC15 - 16Pontyberem RFC
26/12/200914:30Dunvant RFC0 - 26Maesteg RFC
28/12/200914:30Mumbles RFC15 - 17Waunarlwydd RFC
January 2010
16/01/201014:30Pencoed RFC  v  Pontyberem RFC
23/01/201014:30BP R.F.C (Llandarcy) RFC24 - 8Dunvant RFC
23/01/201014:30Loughor RFC12 - 13Ammanford RFC
23/01/201014:30Pencoed RFC20 - 45Aberystwyth RFC
23/01/201014:30Waunarlwydd RFC  v  Kidwelly RFC
30/01/201014:30Aberavon Quins RFC26 - 18Loughor RFC
30/01/201014:30Aberystwyth RFC14 - 18Ammanford RFC
30/01/201014:30Dunvant RFC20 - 29Pontyberem RFC
30/01/201014:30Kidwelly RFC37 - 10BP R.F.C (Llandarcy) RFC
30/01/201014:30Maesteg RFC16 - 16Waunarlwydd RFC
30/01/201014:30Mumbles RFC3 - 15Pencoed RFC
February 2010
05/02/201019:30Aberavon Quins RFC  v  Dunvant RFC
06/02/201013:30Aberystwyth RFC11 - 13Maesteg RFC
06/02/201013:30Pencoed RFC21 - 19Loughor RFC
12/02/201019:00Kidwelly RFC24 - 15Dunvant RFC
20/02/201014:30Ammanford RFC17 - 7Mumbles RFC
20/02/201014:30BP R.F.C (Llandarcy) RFC9 - 6Pencoed RFC
20/02/201014:30Pontyberem RFC13 - 22Kidwelly RFC
27/02/201014:30Aberavon Quins RFC14 - 15Aberystwyth RFC
27/02/201014:30Ammanford RFC27 - 26Kidwelly RFC
27/02/201014:30Dunvant RFC22 - 20Waunarlwydd RFC
27/02/201014:30Loughor RFC12 - 17BP R.F.C (Llandarcy) RFC
27/02/201014:30Pontyberem RFC3 - 29Maesteg RFC
March 2010
06/03/201014:30Aberavon Quins RFC  v  Ammanford RFC
06/03/201014:30Dunvant RFC17 - 16Pencoed RFC
06/03/201014:30Kidwelly RFC58 - 5Loughor RFC
06/03/201014:30Maesteg RFC29 - 3BP R.F.C (Llandarcy) RFC
06/03/201014:30Mumbles RFC19 - 20Aberystwyth RFC
06/03/201014:30Waunarlwydd RFC48 - 3Pontyberem RFC
12/03/201019:15Ammanford RFC  v  Maesteg RFC
19/03/201019:00Maesteg RFC  v  Pencoed RFC
19/03/201019:15Ammanford RFC  v  BP R.F.C (Llandarcy) RFC
21/03/201014:30Aberystwyth RFC  v  Aberavon Quins RFC
21/03/201014:30Loughor RFC  v  Mumbles RFC
27/03/201014:30Ammanford RFC  v  Dunvant RFC
27/03/201014:30Mumbles RFC  v  Aberavon Quins RFC
27/03/201014:30Pencoed RFC  v  Kidwelly RFC
27/03/201014:30Pontyberem RFC  v  BP R.F.C (Llandarcy) RFC
28/03/201014:30Loughor RFCP - PWaunarlwydd RFC
28/03/201014:30Mumbles RFCP - PMaesteg RFC
April 2010
03/04/201014:30Aberavon Quins RFC  v  Mumbles RFC
03/04/201014:30BP R.F.C (Llandarcy) RFC  v  Loughor RFC
03/04/201014:30Dunvant RFC  v  Aberystwyth RFC
03/04/201014:30Kidwelly RFC  v  Ammanford RFC
03/04/201014:30Maesteg RFC  v  Pontyberem RFC
03/04/201014:30Waunarlwydd RFC  v  Pencoed RFC
07/04/201019:00BP R.F.C (Llandarcy) RFC  v  Mumbles RFC
10/04/201014:30Aberavon Quins RFC  v  Maesteg RFC
10/04/201014:30Aberystwyth RFC  v  Kidwelly RFC
10/04/201014:30Ammanford RFC  v  Waunarlwydd RFC
10/04/201014:30Loughor RFC  v  Pontyberem RFC
10/04/201014:30Mumbles RFC  v  Dunvant RFC
14/04/201019:00BP R.F.C (Llandarcy) RFC  v  Waunarlwydd RFC
17/04/201014:30Aberavon Quins RFC  v  BP R.F.C (Llandarcy) RFC
17/04/201014:30Loughor RFC  v  Dunvant RFC
17/04/201014:30Mumbles RFC  v  Kidwelly RFC
17/04/201014:30Pencoed RFC  v  Waunarlwydd RFC
17/04/201014:30Pontyberem RFC  v  Aberystwyth RFC
24/04/201014:30BP R.F.C (Llandarcy) RFC  v  Ammanford RFC
24/04/201014:30Dunvant RFC  v  Aberavon Quins RFC
24/04/201014:30Kidwelly RFC  v  Mumbles RFC
24/04/201014:30Maesteg RFC  v  Loughor RFC
24/04/201014:30Pontyberem RFC  v  Pencoed RFC
24/04/201014:30Waunarlwydd RFC  v  Aberystwyth RFC
28/04/201018:30Pencoed RFC  v  Aberavon Quins RFC
May 2010
01/05/201014:30Aberystwyth RFC  v  Loughor RFC
01/05/201014:30Ammanford RFC  v  Pencoed RFC
01/05/201014:30Maesteg RFC  v  Kidwelly RFC
01/05/201014:30Mumbles RFC  v  Pontyberem RFC
01/05/201014:30Waunarlwydd RFC  v  Aberavon Quins RFC
15/05/201014:30Aberystwyth RFC  v  Waunarlwydd RFC
15/05/201014:30Pontyberem RFC  v  Aberavon Quins 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