Join the WRU Ezine Mailing List Name E-mail
www.wru.co.uk - The Welsh Rugby Union on the World Wide Web British and Irish Cup
www.wru.co.uk WRU Online Store Millennium Stadium Debenture Zone WRU Official Supporters Club Tickets and Hospitality for WRU matches and Millennium Stadium Events
Under Armour Brains Invesco Perpetual SWALEC SEAT Powerade Principality
Contact Us Job Vacancies RSS Feeds
BBC Sport S4C
British & Irish Cup 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 (0 OR CompGroup = 'domestic') AND CompSubGroup = 'britishandirish' AND (CompVisible = 'Yes' OR CompVisible IS NULL) AND (0 OR CompGroup = 'domestic') AND CompSubGroup = 'britishandirish' 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
DateTimeHomeScoreAwayTVAttendanceReport
November 2009
20/11/200919:15Llanelli16 - 19Aberavon


20/11/200919:15Pontypridd16 - 22Cardiff Rugby
921
20/11/200919:30Moseley27 - 38London Welsh
563
20/11/200919:30Neath11 - 18Bristol Rugby
1,500
20/11/200919:30Newport21 - 14Exeter Chiefs
798
20/11/200919:30Ulster Ravens29 - 3Bedford Blues
1,132
20/11/200919:45Coventry13 - 20Munster A
2,066
21/11/200914:00Heriot's FP0 - 5Nottingham
650
21/11/200914:00Rotherham Titans52 - 10Birmingham-Solihull
876
21/11/200916:30Plymouth Albion13 - 16Leinster A
2,208
22/11/200914:00Cornish Pirates29 - 8The Thistles
2,370
22/11/200914:00Doncaster32 - 7Ayr
1,496
27/11/200916:00Leinster A12 - 10Cornish Pirates
1,670
27/11/200919:15Aberavon7 - 36London Welsh
712
27/11/200919:30Moseley21 - 32Ulster Ravens
750
27/11/200919:30Munster A18 - 6Bristol Rugby
1,200
27/11/200919:30Newport3 - 3Plymouth Albion
593
27/11/200919:45Coventry57 - 12Heriot's FP
806
27/11/200920:00Ayr28 - 13Rotherham Titans
1,370
28/11/200914:00Birmingham-Solihull20 - 51Cardiff Rugby
377
28/11/200915:00Bedford Blues36 - 24Llanelli
2,553
28/11/200915:00Exeter Chiefs15 - 0The Thistles
2,478
29/11/200915:00Nottingham14 - 3Neath
2,087
February 2010
12/02/201019:00Munster A18 - 3Nottingham


12/02/201019:15Llanelli21 - 21Ulster Ravens
500
12/02/201019:30Newport27 - 5The Thistles
705
13/02/201012:00London Welsh26 - 13Bedford Blues
810
13/02/201014:00Bristol Rugby40 - 15Coventry
2,461
13/02/201014:00Rotherham Titans33 - 23Pontypridd
789
13/02/201015:00Exeter Chiefs10 - 22Leinster A
3,505
13/02/201015:00Plymouth Albion9 - 13Cornish Pirates
2,413
13/02/201016:00Ayr49 - 14Birmingham-Solihull
780
14/02/201014:00Heriot's FP21 - 38Neath
500
14/02/201015:00Doncaster34 - 10Cardiff Rugby
1,124
23/02/201019:30Aberavon10 - 0Moseley
362
26/02/201018:00Leinster A6 - 10Newport


26/02/201019:00The Thistles0 - 25Plymouth Albion
69
26/02/201019:30Ulster Ravens21 - 17London Welsh
739
27/02/201014:00Bedford Blues17 - 15Aberavon
1,230
27/02/201014:00Cardiff Rugby34 - 27Rotherham Titans


27/02/201014:00Doncaster41 - 8Birmingham-Solihull
783
27/02/201014:00Neath12 - 21Munster A


27/02/201014:30Llanelli35 - 21Moseley


27/02/201015:00Ayr21 - 22Pontypridd
1,290
28/02/201014:00Bristol Rugby34 - 17Heriot's FP
2,521
28/02/201014:00Cornish Pirates37 - 14Exeter Chiefs
2,564
28/02/201015:00Nottingham43 - 17Coventry
1,243
March 2010
03/03/201019:30Pontypridd11 - 24Doncaster


05/03/201019:30Moseley0 - 23Bedford Blues
520
06/03/201014:00London Welsh20 - 10Llanelli
1,650
06/03/201014:00Neath29 - 24Coventry
1,000
06/03/201014:00Rotherham Titans22 - 32Doncaster
1,427
06/03/201014:30Birmingham-Solihull24 - 27Pontypridd


06/03/201014:30Cardiff Rugby30 - 27Ayr


06/03/201015:00Plymouth Albion5 - 26Exeter Chiefs
2,766
07/03/201015:00Cornish Pirates26 - 20Newport
3,650
07/03/201015:00Nottingham16 - 21Bristol Rugby
1,046
10/03/201019:00The Thistles22 - 33Leinster A
300
12/03/201019:30Munster A34 - 7Heriot's FP


12/03/201019:30Ulster Ravens62 - 0Aberavon
793
E-mail this page
Print this page
British & Irish Cup: Home
British & Irish Cup: Latest News
British & Irish Cup: Fixtures & Results
British & Irish Cup: Tables
delivered by Sotic powered by RedDot Web Content Management