 |
| 2009-2010 - SWALEC Leagues | |
Pos
| Team
| P
| W
| D
| L
| F
| A
| TF
| TA
| TB
| LB
| Pts
|
| 1 | Oakdale RFC | 14 | 12 | 1 | 1 | 357 | 155 | 49 | 16 | 8 | 1 | 59 |
| 2 | Usk RFC | 13 | 8 | 1 | 4 | 313 | 227 | 47 | 31 | 7 | 1 | 42 |
| 3 | Caldicot RFC | 14 | 8 | 0 | 6 | 289 | 237 | 37 | 33 | 3 | 2 | 37 |
| 4 | Blaenavon RFC | 12 | 8 | 1 | 3 | 209 | 167 | 29 | 22 | 2 | 1 | 37 |
| 5 | Brynithel RFC | 12 | 8 | 1 | 3 | 240 | 174 | 25 | 14 | 2 | 1 | 37 |
| 6 | Bettws (Newport) RFC | 13 | 5 | 2 | 6 | 264 | 245 | 31 | 28 | 3 | 4 | 31 |
| 7 | Ynysddu RFC | 13 | 5 | 1 | 7 | 202 | 206 | 24 | 21 | 1 | 5 | 28 |
| 8 | Hartridge RFC | 13 | 5 | 0 | 8 | 248 | 191 | 29 | 21 | 2 | 5 | 27 |
| 9 | Trinant RFC | 13 | 4 | 1 | 8 | 150 | 239 | 14 | 33 | 0 | 4 | 22 |
| 10 | RTB (Ebbw Vale) RFC | 11 | 3 | 2 | 6 | 170 | 189 | 22 | 25 | 3 | 1 | 20 |
| 11 | Llanhilleth RFC | 11 | 3 | 2 | 6 | 161 | 208 | 17 | 25 | 1 | 0 | 17 |
| 12 | Pontllanfraith RFC | 13 | 1 | 0 | 12 | 78 | 443 | 8 | 63 | 1 | 0 | 5 |
|
|
 |
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 = '5E' AND (0 OR CompGroup = 'wru') AND CompSubGroup = 'leagues' AND (CompVisible = 'Yes' OR CompVisible IS NULL) AND FixStgId = '5E' 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
|
| Date | Time | Home | Score | Away |
| September 2009 |
| 05/09/2009 | 14:30 | Blaenavon RFC | 16 - 21 | Bettws (Newport) RFC |
| 05/09/2009 | 14:30 | Brynithel RFC | 43 - 9 | Pontllanfraith RFC |
| 05/09/2009 | 14:30 | Hartridge RFC | 24 - 0 | Caldicot RFC |
| 05/09/2009 | 14:30 | Llanhilleth RFC | 25 - 34 | Oakdale RFC |
| 05/09/2009 | 14:30 | RTB (Ebbw Vale) RFC | 7 - 7 | Trinant RFC |
| 05/09/2009 | 14:30 | Usk RFC | 7 - 26 | Ynysddu RFC |
| 12/09/2009 | 14:30 | Bettws (Newport) RFC | 22 - 31 | Usk RFC |
| 12/09/2009 | 14:30 | Caldicot RFC | 16 - 10 | Brynithel RFC |
| 12/09/2009 | 14:30 | Oakdale RFC | 24 - 9 | RTB (Ebbw Vale) RFC |
| 12/09/2009 | 14:30 | Pontllanfraith RFC | 29 - 5 | Blaenavon RFC |
| 12/09/2009 | 14:30 | Trinant RFC | 21 - 27 | Hartridge RFC |
| 12/09/2009 | 14:30 | Ynysddu RFC | 14 - 21 | Llanhilleth RFC |
| 19/09/2009 | 14:30 | Blaenavon RFC | 16 - 25 | Brynithel RFC |
| 19/09/2009 | 14:30 | Caldicot RFC | 14 - 17 | Trinant RFC |
| 19/09/2009 | 14:30 | Hartridge RFC | 20 - 21 | Oakdale RFC |
| 19/09/2009 | 14:30 | Llanhilleth RFC | 17 - 17 | Bettws (Newport) RFC |
| 19/09/2009 | 14:30 | RTB (Ebbw Vale) RFC | 24 - 24 | Ynysddu RFC |
| 19/09/2009 | 14:30 | Usk RFC | 22 - 11 | Pontllanfraith RFC |
| 26/09/2009 | 14:30 | Bettws (Newport) RFC | 31 - 10 | RTB (Ebbw Vale) RFC |
| 26/09/2009 | 14:30 | Blaenavon RFC | 32 - 27 | Usk RFC |
| 26/09/2009 | 14:30 | Brynithel RFC | 17 - 13 | Trinant RFC |
| 26/09/2009 | 14:30 | Oakdale RFC | 51 - 17 | Caldicot RFC |
| 26/09/2009 | 14:30 | Pontllanfraith RFC | 10 - 26 | Llanhilleth RFC |
| 26/09/2009 | 14:30 | Ynysddu RFC | 18 - 14 | Hartridge RFC |
| October 2009 |
| 03/10/2009 | 14:30 | Blaenavon RFC | 17 - 3 | Llanhilleth RFC |
| 03/10/2009 | 14:30 | Hartridge RFC | 16 - 17 | Bettws (Newport) RFC |
| 03/10/2009 | 14:30 | RTB (Ebbw Vale) RFC | 31 - 0 | Pontllanfraith RFC |
| 03/10/2009 | 14:30 | Trinant RFC | 5 - 14 | Oakdale RFC |
| 03/10/2009 | 14:30 | Usk RFC | 40 - 13 | Brynithel RFC |
| 10/10/2009 | 14:30 | Bettws (Newport) RFC | 20 - 23 | Caldicot RFC |
| 10/10/2009 | 14:30 | Brynithel RFC | 0 - 34 | Oakdale RFC |
| 10/10/2009 | 14:30 | Ynysddu RFC | 26 - 3 | Trinant RFC |
| 17/10/2009 | 14:30 | Caldicot RFC | 56 - 0 | Pontllanfraith RFC |
| 17/10/2009 | 14:30 | Hartridge RFC | 14 - 17 | Blaenavon RFC |
| 17/10/2009 | 14:30 | Llanhilleth RFC | 9 - 9 | Brynithel RFC |
| 17/10/2009 | 14:30 | Oakdale RFC | 15 - 13 | Ynysddu RFC |
| 17/10/2009 | 14:30 | RTB (Ebbw Vale) RFC | 3 - 26 | Usk RFC |
| 17/10/2009 | 14:30 | Trinant RFC | 26 - 20 | Bettws (Newport) RFC |
| 24/10/2009 | 14:30 | Bettws (Newport) RFC | 13 - 22 | Oakdale RFC |
| 24/10/2009 | 14:30 | Blaenavon RFC | 32 - 13 | Caldicot RFC |
| 24/10/2009 | 14:30 | Brynithel RFC | 14 - 9 | Ynysddu RFC |
| 24/10/2009 | 14:30 | Pontllanfraith RFC | 0 - 11 | Trinant RFC |
| 24/10/2009 | 14:30 | RTB (Ebbw Vale) RFC | 14 - 5 | Llanhilleth RFC |
| 24/10/2009 | 14:30 | Usk RFC | 7 - 26 | Hartridge RFC |
| November 2009 |
| 06/11/2009 | 19:30 | Caldicot RFC | 15 - 8 | Ynysddu RFC |
| 14/11/2009 | 14:30 | Caldicot RFC | 5 - 12 | Usk RFC |
| 14/11/2009 | 14:30 | Trinant RFC | 3 - 7 | Blaenavon RFC |
| 14/11/2009 | 14:30 | Ynysddu RFC | v | Bettws (Newport) RFC |
| December 2009 |
| 05/12/2009 | 14:30 | Blaenavon RFC | 13 - 13 | Oakdale RFC |
| 05/12/2009 | 14:30 | Brynithel RFC | 12 - 6 | Bettws (Newport) RFC |
| 05/12/2009 | 14:30 | Hartridge RFC | 10 - 8 | RTB (Ebbw Vale) RFC |
| 05/12/2009 | 14:30 | Pontllanfraith RFC | v | Usk RFC |
| 05/12/2009 | 14:30 | Usk RFC | 41 - 3 | Trinant RFC |
| 12/12/2009 | 14:30 | Pontllanfraith RFC | 0 - 47 | Hartridge RFC |
| 12/12/2009 | 14:30 | Usk RFC | 25 - 14 | Llanhilleth RFC |
| 19/12/2009 | 14:30 | Hartridge RFC | v | Brynithel RFC |
| January 2010 |
| 02/01/2010 | 14:30 | Caldicot RFC | 34 - 21 | Hartridge RFC |
| 09/01/2010 | 14:30 | Brynithel RFC | v | Caldicot RFC |
| 09/01/2010 | 14:30 | Hartridge RFC | v | Trinant RFC |
| 16/01/2010 | 14:30 | Pontllanfraith RFC | v | Usk RFC |
| 16/01/2010 | 14:30 | Trinant RFC | v | Caldicot RFC |
| 18/01/2010 | 14:30 | Bettws (Newport) RFC | v | Llanhilleth RFC |
| 23/01/2010 | 14:30 | Caldicot RFC | 5 - 14 | Oakdale RFC |
| 23/01/2010 | 14:30 | Llanhilleth RFC | 29 - 11 | Pontllanfraith RFC |
| 23/01/2010 | 14:30 | RTB (Ebbw Vale) RFC | v | Bettws (Newport) RFC |
| 23/01/2010 | 14:30 | Trinant RFC | 12 - 17 | Brynithel RFC |
| 30/01/2010 | 14:30 | Bettws (Newport) RFC | 13 - 11 | Hartridge RFC |
| 30/01/2010 | 14:30 | Brynithel RFC | v | Usk RFC |
| 30/01/2010 | 14:30 | Llanhilleth RFC | 7 - 18 | Blaenavon RFC |
| 30/01/2010 | 14:30 | Oakdale RFC | v | Trinant RFC |
| 30/01/2010 | 14:30 | Pontllanfraith RFC | 5 - 49 | RTB (Ebbw Vale) RFC |
| 30/01/2010 | 14:30 | Ynysddu RFC | 5 - 30 | Caldicot RFC |
| February 2010 |
| 06/02/2010 | 13:00 | Hartridge RFC | 13 - 21 | Ynysddu RFC |
| 06/02/2010 | 13:00 | Oakdale RFC | 39 - 5 | Llanhilleth RFC |
| 06/02/2010 | 13:00 | Pontllanfraith RFC | 0 - 52 | Brynithel RFC |
| 12/02/2010 | 19:00 | Caldicot RFC | 21 - 20 | Bettws (Newport) RFC |
| 12/02/2010 | 19:15 | Oakdale RFC | 36 - 15 | Usk RFC |
| 20/02/2010 | 14:30 | Hartridge RFC | v | Pontllanfraith RFC |
| 20/02/2010 | 14:30 | Oakdale RFC | v | Brynithel RFC |
| 20/02/2010 | 14:30 | Trinant RFC | 20 - 16 | Ynysddu RFC |
| 27/02/2010 | 14:30 | Llanhilleth RFC | v | Caldicot RFC |
| 27/02/2010 | 14:30 | Oakdale RFC | 32 - 0 | Pontllanfraith RFC |
| 27/02/2010 | 14:30 | RTB (Ebbw Vale) RFC | 10 - 28 | Brynithel RFC |
| 27/02/2010 | 14:30 | Usk RFC | 31 - 31 | Bettws (Newport) RFC |
| 27/02/2010 | 14:30 | Ynysddu RFC | 7 - 22 | Blaenavon RFC |
| March 2010 |
| 06/03/2010 | 14:30 | Bettws (Newport) RFC | 33 - 9 | Trinant RFC |
| 06/03/2010 | 14:30 | Blaenavon RFC | 14 - 5 | Hartridge RFC |
| 06/03/2010 | 14:30 | Brynithel RFC | v | Llanhilleth RFC |
| 06/03/2010 | 14:30 | Pontllanfraith RFC | 3 - 40 | Caldicot RFC |
| 06/03/2010 | 14:30 | Usk RFC | 29 - 5 | RTB (Ebbw Vale) RFC |
| 06/03/2010 | 14:30 | Ynysddu RFC | 15 - 8 | Oakdale RFC |
| 11/03/2010 | 19:00 | Caldicot RFC | v | RTB (Ebbw Vale) RFC |
| 12/03/2010 | 19:00 | Blaenavon RFC | v | Pontllanfraith RFC |
| 12/03/2010 | 19:00 | Llanhilleth RFC | v | Ynysddu RFC |
| 19/03/2010 | 19:00 | Usk RFC | v | Blaenavon RFC |
| 19/03/2010 | 19:15 | Oakdale RFC | v | Hartridge RFC |
| 21/03/2010 | 14:30 | Ynysddu RFC | v | RTB (Ebbw Vale) RFC |
| 27/03/2010 | 14:30 | Caldicot RFC | v | Blaenavon RFC |
| 27/03/2010 | 14:30 | Hartridge RFC | v | Usk RFC |
| 27/03/2010 | 14:30 | Llanhilleth RFC | v | RTB (Ebbw Vale) RFC |
| 27/03/2010 | 14:30 | Oakdale RFC | v | Bettws (Newport) RFC |
| 27/03/2010 | 14:30 | Trinant RFC | v | Pontllanfraith RFC |
| 27/03/2010 | 14:30 | Ynysddu RFC | v | Brynithel RFC |
| April 2010 |
| 03/04/2010 | 14:30 | Bettws (Newport) RFC | v | Ynysddu RFC |
| 03/04/2010 | 14:30 | Blaenavon RFC | v | Trinant RFC |
| 03/04/2010 | 14:30 | Brynithel RFC | v | RTB (Ebbw Vale) RFC |
| 03/04/2010 | 14:30 | Llanhilleth RFC | v | Hartridge RFC |
| 03/04/2010 | 14:30 | Pontllanfraith RFC | v | Oakdale RFC |
| 03/04/2010 | 14:30 | Usk RFC | v | Caldicot RFC |
| 10/04/2010 | 14:30 | Bettws (Newport) RFC | v | Brynithel RFC |
| 10/04/2010 | 14:30 | Caldicot RFC | v | Llanhilleth RFC |
| 10/04/2010 | 14:30 | Oakdale RFC | v | Blaenavon RFC |
| 10/04/2010 | 14:30 | RTB (Ebbw Vale) RFC | v | Hartridge RFC |
| 10/04/2010 | 14:30 | Trinant RFC | v | Usk RFC |
| 10/04/2010 | 14:30 | Ynysddu RFC | v | Pontllanfraith RFC |
| 17/04/2010 | 14:30 | Bettws (Newport) RFC | v | Pontllanfraith RFC |
| 17/04/2010 | 14:30 | Blaenavon RFC | v | RTB (Ebbw Vale) RFC |
| 17/04/2010 | 14:30 | Hartridge RFC | v | Llanhilleth RFC |
| 17/04/2010 | 14:30 | Ynysddu RFC | v | Usk RFC |
| 21/04/2010 | 19:00 | Trinant RFC | v | RTB (Ebbw Vale) RFC |
| 24/04/2010 | 14:30 | Blaenavon RFC | v | Ynysddu RFC |
| 24/04/2010 | 14:30 | Brynithel RFC | v | Hartridge RFC |
| 24/04/2010 | 14:30 | Llanhilleth RFC | v | Trinant RFC |
| 24/04/2010 | 14:30 | Pontllanfraith RFC | v | Bettws (Newport) RFC |
| 24/04/2010 | 14:30 | RTB (Ebbw Vale) RFC | v | Caldicot RFC |
| 24/04/2010 | 14:30 | Usk RFC | v | Oakdale RFC |
| May 2010 |
| 01/05/2010 | 14:30 | Brynithel RFC | v | Blaenavon RFC |
| 01/05/2010 | 14:30 | Pontllanfraith RFC | v | Ynysddu RFC |
| 01/05/2010 | 14:30 | RTB (Ebbw Vale) RFC | v | Oakdale RFC |
| 01/05/2010 | 14:30 | Trinant RFC | v | Llanhilleth RFC |
| 12/05/2010 | 18:15 | RTB (Ebbw Vale) RFC | v | Blaenavon RFC |
| 15/05/2010 | 14:30 | Bettws (Newport) RFC | v | Blaenavon RFC |
| 15/05/2010 | 14:30 | Llanhilleth RFC | v | Usk RFC |
|
|
|
|
|
|
|
|
|