Join the WRU Ezine Mailing List Name E-mail
WRU Regional Championship Poll
Which Regional Squad will lift the U18 Championship Trophy this season?
Blues
Dragons
Ospreys
Scarlets
WRU Regional Championships Fixtures & Results 2009-2010
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 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') 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') WHERE FcmpSource = FixSource AND FcmpFixId = FixId AND FcmpCompId = CompId AND FcmpStgId = StgId AND StgCompId = CompId AND FixDate IS NOT NULL AND (FixSource = 'sfms') AND (((CompSeason = '2009' AND CompSeasonEnd = '2010')) OR CompId IS NULL) AND (0 OR CompGroup = 'wru') AND CompSubGroup = 'regional' AND (CompVisible = 'Yes' OR CompVisible IS NULL) AND (((CompSeason = '2009' AND CompSeasonEnd = '2010')) OR CompId IS NULL) AND (0 OR CompGroup = 'wru') AND CompSubGroup = 'regional' AND (CompVisible = 'Yes' OR CompVisible IS NULL) AND StgId = 'U16' GROUP BY FixId, FixSource ORDER BY FixDate ASC, Ord, FixTime, HomeDisplay, AwayDisplay, Ord
DateKick OffHomeScoreAwayVenue
September 2009
02/09/2009
Ospreys U1631 - 7Blues South U16TBA
09/09/2009
Blues North U1611 - 25Dragons U16TBA
09/09/2009
Scarlets U1634 - 0RGC 1404 U16TBA
16/09/2009
Blues South U1621 - 32Scarlets U16TBA
16/09/2009
Dragons U1612 - 15Ospreys U16TBA
20/09/2009
RGC 1404 U1634 - 24Blues North U16TBA
27/09/2009
Blues South U1633 - 15RGC 1404 U16TBA
30/09/2009
Blues South U1624 - 20Dragons U16TBA
30/09/2009
Scarlets U1628 - 14Blues North U16TBA
October 2009
14/10/2009
Blues North U1619 - 17Ospreys U16TBA
14/10/2009
Dragons U1616 - 36Scarlets U16TBA
18/10/2009
RGC 1404 U1614 - 19Blues South U16TBA
28/10/2009
Blues South U1625 - 13Blues North U16TBA
28/10/2009
Scarlets U1617 - 13Ospreys U16TBA
November 2009
11/11/2009
Blues South U1624 - 18Ospreys U16TBA
11/11/2009
Dragons U1610 - 14Blues North U16TBA
22/11/2009
Ospreys U1627 - 20RGC 1404 U16TBA
28/11/2009
Blues North U16  v  RGC 1404 U16TBA
December 2009
02/12/2009
Ospreys U1620 - 3Dragons U16TBA
09/12/2009
Blues North U160 - 12Scarlets U16TBA
13/12/2009
RGC 1404 U1612 - 19Ospreys U16TBA
16/12/2009
Scarlets U1613 - 10Blues South U16TBA
20/12/2009
Dragons U16  v  RGC 1404 U16TBA
January 2010
20/01/2010
Blues North U167 - 8Blues South U16TBA
20/01/2010
Ospreys U1612 - 20Scarlets U16TBA
24/01/2010
RGC 1404 U1629 - 24Dragons U16TBA
27/01/2010
Dragons U1615 - 19Blues South U16TBA
27/01/2010
Ospreys U1635 - 3Blues North U16TBA
February 2010
03/02/2010
Scarlets U1617 - 17Dragons U16TBA
07/02/2010
RGC 1404 U1628 - 7Scarlets U16TBA
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