Provincial
Magners League 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='irfu',1,0)+IF(FixSource='irfutag',2,0)+IF(FixSource='irfu18',3,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 = 'irfu' OR VenSource = 'irfutag' OR VenSource = 'irfu18') 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 = 'irfu' LEFT JOIN stats_rugby.teams ON TeamId = FixTeamA AND (TeamSource = 'sfms' OR TeamSource = 'irfu' OR TeamSource = 'irfutag' OR TeamSource = 'irfu18') 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 = 'irfu' OR FixSource = 'irfutag' OR FixSource = 'irfu18') AND (0 OR CompGroup = 'celtic') AND CompSubGroup = 'league' AND (CompVisible = 'Yes' OR CompVisible IS NULL) AND (0 OR CompGroup = 'celtic') AND CompSubGroup = 'league' 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
DateTimeStageHomeScoreAwayVenueTV/AttendLinks
Fri 4th Sep 0919:00
Connacht Rugby12 - 19OspreysSportsground1,982
Fri 4th Sep 0919:05
Cardiff Blues21 - 22EdinburghCardiff City Stadium8,124
Fri 4th Sep 0920:00
Glasgow Warriors22 - 9MunsterFirhill Arena3,694
Sat 5th Sep 0918:30
Scarlets18 - 16LeinsterParc y Scarlets6,075
Sun 6th Sep 0914:05
Newport Gwent Dragons23 - 6Ulster RugbyRodney Parade4,561
Fri 11th Sep 0919:05
Munster24 - 13Cardiff BluesThomond Park Stadium19,752
Fri 11th Sep 0919:30
Edinburgh62 - 13Connacht RugbyMurrayfield3,042
Sat 12th Sep 0918:30
Ospreys16 - 20Ulster RugbyLiberty Stadium7,072
Sat 12th Sep 0919:00
Leinster23 - 14Newport Gwent DragonsRoyal Dublin Society15,145
Sun 13th Sep 0917:05
Glasgow Warriors19 - 11ScarletsFirhill Arena2,582
Fri 18th Sep 0919:00
Connacht Rugby18 - 16Cardiff BluesSportsground1,425
Fri 18th Sep 0919:05
Ospreys11 - 18LeinsterLiberty Stadium7,182
Fri 18th Sep 0919:30
Newport Gwent Dragons30 - 19Glasgow WarriorsRodney Parade5,219
Fri 18th Sep 0920:00
Ulster Rugby13 - 16EdinburghRavenhill8,899
Sat 19th Sep 0918:30
Scarlets20 - 22MunsterParc y Scarlets6,313
Fri 25th Sep 0919:05
Glasgow Warriors16 - 26OspreysFirhill Arena3,108
Fri 25th Sep 0920:00
Connacht Rugby6 - 30Ulster RugbySportsground2,435
Sat 26th Sep 0918:30
Cardiff Blues19 - 15ScarletsCardiff City Stadium12,198
Sat 26th Sep 0918:30
Edinburgh19 - 21LeinsterMurrayfield5,761
Sun 27th Sep 0917:05
Munster27 - 3Newport Gwent DragonsMusgrave Park8,685
Fri 2nd Oct 0919:05
Ulster Rugby45 - 24ScarletsRavenhill8,141
Sat 3rd Oct 0916:30
Newport Gwent Dragons23 - 10Connacht RugbyRodney Parade5,331
Sat 3rd Oct 0918:30
Cardiff Blues5 - 21Glasgow WarriorsCardiff City Stadium9,185
Sat 3rd Oct 0918:30
Leinster30 - 0MunsterRoyal Dublin Society18,500
Sun 4th Oct 0916:00
Ospreys31 - 10EdinburghLiberty Stadium7,033
Fri 23rd Oct 0919:05
Scarlets18 - 3Newport Gwent DragonsParc y Scarlets6,464
Fri 23rd Oct 0919:30
Glasgow Warriors34 - 20Connacht RugbyFirhill Arena2,887
Fri 23rd Oct 0920:00
Edinburgh12 - 7MunsterMurrayfield5,426
Sat 24th Oct 0918:00
Ulster Rugby16 - 14LeinsterRavenhill11,523
Sat 24th Oct 0918:30
Cardiff Blues20 - 12OspreysCardiff City Stadium16,341
Fri 30th Oct 0918:30
Connacht Rugby16 - 10ScarletsSportsground1,756
Fri 30th Oct 0919:05
Ospreys9 - 9Glasgow WarriorsLiberty Stadium6,661
Sat 31st Oct 0917:00
Munster24 - 10Ulster RugbyThomond Park Stadium23,298
Sat 31st Oct 0918:30
Leinster23 - 6Cardiff BluesRoyal Dublin Society15,910
Sun 1st Nov 0917:05
Edinburgh8 - 9Newport Gwent DragonsMurrayfield2,066
Fri 4th Dec 0919:05
Scarlets16 - 17EdinburghParc y Scarlets5,540
Fri 4th Dec 0920:00
Ulster Rugby13 - 25Glasgow WarriorsRavenhill8,761
Sat 5th Dec 0918:30
Ospreys19 - 14MunsterLiberty Stadium8,077
Sun 6th Dec 0915:00
Cardiff Blues21 - 9Connacht RugbyCardiff City Stadium7,105
Sun 6th Dec 0917:00
Newport Gwent Dragons30 - 14LeinsterRodney Parade5,437
Sat 26th Dec 0914:05
Scarlets14 - 21OspreysParc y Scarlets14,739
Sat 26th Dec 0917:30
Leinster15 - 3Ulster RugbyRoyal Dublin Society18,140
Sat 26th Dec 0919:30
Munster35 - 3Connacht RugbyThomond Park Stadium25,291
Sun 27th Dec 0915:05
Glasgow Warriors25 - 12EdinburghFirhill Arena8,830
Sun 27th Dec 0918:00
Cardiff Blues42 - 13Newport Gwent DragonsCardiff City Stadium15,210
Thu 31st Dec 0914:05
Newport Gwent Dragons9 - 14ScarletsRodney Parade6,429
Fri 1st Jan 1017:15
Ospreys26 - 0Cardiff BluesLiberty Stadium14,476
Sat 2nd Jan 1015:05
Edinburgh15 - 22Glasgow WarriorsMurrayfield11,785
Sat 2nd Jan 1016:00
Connacht RugbyP - PLeinsterSportsgroundSetanta(Ir)
Sat 2nd Jan 1018:00
Ulster Rugby15 - 10MunsterRavenhill11,800
Sat 9th Jan 1018:30
Edinburgh21 - 12Cardiff BluesMurrayfield1,569
Fri 19th Feb 1019:05
Ulster Rugby22 - 22Newport Gwent DragonsRavenhill7,909
Fri 19th Feb 1019:30
Glasgow Warriors7 - 30Cardiff BluesFirhill Arena2,754
Fri 19th Feb 1020:00
Munster19 - 12EdinburghMusgrave Park8,500
Sat 20th Feb 1018:30
Leinster27 - 14ScarletsRoyal Dublin Society13,890
Sun 21st Feb 1017:00
Ospreys19 - 17Connacht RugbyLiberty Stadium5,053
Fri 5th Mar 1019:05
Scarlets25 - 8Ulster RugbyParc y Scarlets6,266
Fri 5th Mar 1020:00
Connacht Rugby19 - 19Glasgow WarriorsSportsground1,412
Sat 6th Mar 1018:30
Newport Gwent Dragons31 - 22MunsterRodney Parade6,137
Sun 7th Mar 1014:00
Edinburgh33 - 17OspreysMurrayfield2,329
Sun 7th Mar 1016:00
Cardiff Blues20 - 29LeinsterCardiff City Stadium9,384
Wed 17th Mar 1018:30
Connacht Rugby  v  Newport Gwent DragonsSportsground
Thu 18th Mar 1019:30
Leinster  v  Glasgow WarriorsRoyal Dublin Society
Thu 18th Mar 1019:35
Munster  v  ScarletsMusgrave ParkS4C
Fri 19th Mar 1018:10
Ulster RugbyP - POspreysRavenhillBBCw
Fri 26th Mar 1019:05
Cardiff Blues  v  Ulster RugbyCardiff City StadiumBBCw
Fri 26th Mar 1019:30
Edinburgh  v  ScarletsMurrayfield
Fri 26th Mar 1020:00
Munster  v  Glasgow WarriorsThomond Park StadiumSetanta(I)
Sat 27th Mar 1016:30
Leinster  v  Connacht RugbyRoyal Dublin SocietySetanta(I)
Sat 27th Mar 1018:30
Newport Gwent Dragons  v  OspreysRodney ParadeS4C
Fri 2nd Apr 1018:00
Connacht Rugby  v  EdinburghSportsground
Fri 2nd Apr 1019:05
Ospreys  v  ScarletsLiberty StadiumBBCw/Set(I)
Fri 2nd Apr 1020:05
Munster  v  LeinsterThomond Park StadiumSetanta
Sat 3rd Apr 1019:30
Ulster Rugby  v  Cardiff BluesRavenhillS4C/Set(I)
Sun 4th Apr 1015:05
Glasgow Warriors  v  Newport Gwent DragonsFirhill ArenaBBCw/Set(I)
Fri 16th Apr 1019:05
Glasgow Warriors  v  Ulster RugbyFirhill ArenaSetanta(I)
Fri 16th Apr 1019:05
Leinster  v  OspreysRoyal Dublin SocietyBBCw/Setant1
Sat 17th Apr 1018:30
Scarlets  v  Cardiff BluesParc y ScarletsS4C/Setanta1
Sun 18th Apr 1017:05
Connacht Rugby  v  MunsterSportsgroundSetanta(I)
Sun 18th Apr 1017:05
Newport Gwent Dragons  v  EdinburghRodney ParadeS4C/Set(I)
23/24/25 Apr

Edinburgh  v  Ulster RugbyMurrayfield
23/24/25 Apr

Glasgow Warriors  v  LeinsterFirhill Arena
23/24/25 Apr

Munster  v  OspreysThomond Park Stadium
23/24/25 Apr

Newport Gwent Dragons  v  Cardiff BluesRodney Parade
23/24/25 Apr

Scarlets  v  Connacht RugbyParc y Scarlets
7/8/9 May

Cardiff Blues  v  MunsterCardiff City Stadium
7/8/9 May

Leinster  v  EdinburghRoyal Dublin Society
7/8/9 May

Ospreys  v  Newport Gwent DragonsLiberty Stadium
7/8/9 May

Scarlets  v  Glasgow WarriorsParc y Scarlets
7/8/9 May

Ulster Rugby  v  Connacht RugbyRavenhill
14/15/16 May
SF
  v  
TBA
14/15/16 May
SF
  v  
TBA
Sat 29th May 1018:30F
  v  
TBA
E-mail this page
Print this page
delivered by Sotic powered by RedDot Web Content Management