|
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
|
| Date | Time | Stage | Home | Score | Away | Venue | TV/Attend | Links |
| Fri 4th Sep 09 | 19:00 |
| Connacht Rugby | 12 - 19 | Ospreys | Sportsground | 1,982 | Report | Audio |
| Fri 4th Sep 09 | 19:05 |
| Cardiff Blues | 21 - 22 | Edinburgh | Cardiff City Stadium | 8,124 |
|
| Fri 4th Sep 09 | 20:00 |
| Glasgow Warriors | 22 - 9 | Munster | Firhill Arena | 3,694 | Report | Audio |
| Sat 5th Sep 09 | 18:30 |
| Scarlets | 18 - 16 | Leinster | Parc y Scarlets | 6,075 | Report | Audio |
| Sun 6th Sep 09 | 14:05 |
| Newport Gwent Dragons | 23 - 6 | Ulster Rugby | Rodney Parade | 4,561 | Report |
| Fri 11th Sep 09 | 19:05 |
| Munster | 24 - 13 | Cardiff Blues | Thomond Park Stadium | 19,752 | Report |
| Fri 11th Sep 09 | 19:30 |
| Edinburgh | 62 - 13 | Connacht Rugby | Murrayfield | 3,042 | Report |
| Sat 12th Sep 09 | 18:30 |
| Ospreys | 16 - 20 | Ulster Rugby | Liberty Stadium | 7,072 | Report |
| Sat 12th Sep 09 | 19:00 |
| Leinster | 23 - 14 | Newport Gwent Dragons | Royal Dublin Society | 15,145 | Report | Audio |
| Sun 13th Sep 09 | 17:05 |
| Glasgow Warriors | 19 - 11 | Scarlets | Firhill Arena | 2,582 |
|
| Fri 18th Sep 09 | 19:00 |
| Connacht Rugby | 18 - 16 | Cardiff Blues | Sportsground | 1,425 | Report |
| Fri 18th Sep 09 | 19:05 |
| Ospreys | 11 - 18 | Leinster | Liberty Stadium | 7,182 | Report |
| Fri 18th Sep 09 | 19:30 |
| Newport Gwent Dragons | 30 - 19 | Glasgow Warriors | Rodney Parade | 5,219 |
|
| Fri 18th Sep 09 | 20:00 |
| Ulster Rugby | 13 - 16 | Edinburgh | Ravenhill | 8,899 | Report |
| Sat 19th Sep 09 | 18:30 |
| Scarlets | 20 - 22 | Munster | Parc y Scarlets | 6,313 | Report |
| Fri 25th Sep 09 | 19:05 |
| Glasgow Warriors | 16 - 26 | Ospreys | Firhill Arena | 3,108 |
|
| Fri 25th Sep 09 | 20:00 |
| Connacht Rugby | 6 - 30 | Ulster Rugby | Sportsground | 2,435 | Report |
| Sat 26th Sep 09 | 18:30 |
| Cardiff Blues | 19 - 15 | Scarlets | Cardiff City Stadium | 12,198 |
|
| Sat 26th Sep 09 | 18:30 |
| Edinburgh | 19 - 21 | Leinster | Murrayfield | 5,761 | Report |
| Sun 27th Sep 09 | 17:05 |
| Munster | 27 - 3 | Newport Gwent Dragons | Musgrave Park | 8,685 | Report |
| Fri 2nd Oct 09 | 19:05 |
| Ulster Rugby | 45 - 24 | Scarlets | Ravenhill | 8,141 | Report |
| Sat 3rd Oct 09 | 16:30 |
| Newport Gwent Dragons | 23 - 10 | Connacht Rugby | Rodney Parade | 5,331 | Report |
| Sat 3rd Oct 09 | 18:30 |
| Cardiff Blues | 5 - 21 | Glasgow Warriors | Cardiff City Stadium | 9,185 | Report |
| Sat 3rd Oct 09 | 18:30 |
| Leinster | 30 - 0 | Munster | Royal Dublin Society | 18,500 | Report | Audio |
| Sun 4th Oct 09 | 16:00 |
| Ospreys | 31 - 10 | Edinburgh | Liberty Stadium | 7,033 |
|
| Fri 23rd Oct 09 | 19:05 |
| Scarlets | 18 - 3 | Newport Gwent Dragons | Parc y Scarlets | 6,464 |
|
| Fri 23rd Oct 09 | 19:30 |
| Glasgow Warriors | 34 - 20 | Connacht Rugby | Firhill Arena | 2,887 | Report |
| Fri 23rd Oct 09 | 20:00 |
| Edinburgh | 12 - 7 | Munster | Murrayfield | 5,426 | Report |
| Sat 24th Oct 09 | 18:00 |
| Ulster Rugby | 16 - 14 | Leinster | Ravenhill | 11,523 | Report | Audio |
| Sat 24th Oct 09 | 18:30 |
| Cardiff Blues | 20 - 12 | Ospreys | Cardiff City Stadium | 16,341 |
|
| Fri 30th Oct 09 | 18:30 |
| Connacht Rugby | 16 - 10 | Scarlets | Sportsground | 1,756 | Report | Audio |
| Fri 30th Oct 09 | 19:05 |
| Ospreys | 9 - 9 | Glasgow Warriors | Liberty Stadium | 6,661 |
|
| Sat 31st Oct 09 | 17:00 |
| Munster | 24 - 10 | Ulster Rugby | Thomond Park Stadium | 23,298 | Report | Audio |
| Sat 31st Oct 09 | 18:30 |
| Leinster | 23 - 6 | Cardiff Blues | Royal Dublin Society | 15,910 | Report | Audio |
| Sun 1st Nov 09 | 17:05 |
| Edinburgh | 8 - 9 | Newport Gwent Dragons | Murrayfield | 2,066 |
|
| Fri 4th Dec 09 | 19:05 |
| Scarlets | 16 - 17 | Edinburgh | Parc y Scarlets | 5,540 |
|
| Fri 4th Dec 09 | 20:00 |
| Ulster Rugby | 13 - 25 | Glasgow Warriors | Ravenhill | 8,761 | Report |
| Sat 5th Dec 09 | 18:30 |
| Ospreys | 19 - 14 | Munster | Liberty Stadium | 8,077 | Report |
| Sun 6th Dec 09 | 15:00 |
| Cardiff Blues | 21 - 9 | Connacht Rugby | Cardiff City Stadium | 7,105 | Report |
| Sun 6th Dec 09 | 17:00 |
| Newport Gwent Dragons | 30 - 14 | Leinster | Rodney Parade | 5,437 | Report |
| Sat 26th Dec 09 | 14:05 |
| Scarlets | 14 - 21 | Ospreys | Parc y Scarlets | 14,739 |
|
| Sat 26th Dec 09 | 17:30 |
| Leinster | 15 - 3 | Ulster Rugby | Royal Dublin Society | 18,140 | Report | Audio |
| Sat 26th Dec 09 | 19:30 |
| Munster | 35 - 3 | Connacht Rugby | Thomond Park Stadium | 25,291 | Report |
| Sun 27th Dec 09 | 15:05 |
| Glasgow Warriors | 25 - 12 | Edinburgh | Firhill Arena | 8,830 |
|
| Sun 27th Dec 09 | 18:00 |
| Cardiff Blues | 42 - 13 | Newport Gwent Dragons | Cardiff City Stadium | 15,210 |
|
| Thu 31st Dec 09 | 14:05 |
| Newport Gwent Dragons | 9 - 14 | Scarlets | Rodney Parade | 6,429 |
|
| Fri 1st Jan 10 | 17:15 |
| Ospreys | 26 - 0 | Cardiff Blues | Liberty Stadium | 14,476 |
|
| Sat 2nd Jan 10 | 15:05 |
| Edinburgh | 15 - 22 | Glasgow Warriors | Murrayfield | 11,785 |
|
| Sat 2nd Jan 10 | 16:00 |
| Connacht Rugby | P - P | Leinster | Sportsground | Setanta(Ir) |
|
| Sat 2nd Jan 10 | 18:00 |
| Ulster Rugby | 15 - 10 | Munster | Ravenhill | 11,800 | Report | Audio |
| Sat 9th Jan 10 | 18:30 |
| Edinburgh | 21 - 12 | Cardiff Blues | Murrayfield | 1,569 |
|
| Fri 19th Feb 10 | 19:05 |
| Ulster Rugby | 22 - 22 | Newport Gwent Dragons | Ravenhill | 7,909 | Report |
| Fri 19th Feb 10 | 19:30 |
| Glasgow Warriors | 7 - 30 | Cardiff Blues | Firhill Arena | 2,754 |
|
| Fri 19th Feb 10 | 20:00 |
| Munster | 19 - 12 | Edinburgh | Musgrave Park | 8,500 | Report |
| Sat 20th Feb 10 | 18:30 |
| Leinster | 27 - 14 | Scarlets | Royal Dublin Society | 13,890 | Report | Audio |
| Sun 21st Feb 10 | 17:00 |
| Ospreys | 19 - 17 | Connacht Rugby | Liberty Stadium | 5,053 | Report |
| Fri 5th Mar 10 | 19:05 |
| Scarlets | 25 - 8 | Ulster Rugby | Parc y Scarlets | 6,266 | Report |
| Fri 5th Mar 10 | 20:00 |
| Connacht Rugby | 19 - 19 | Glasgow Warriors | Sportsground | 1,412 | Report |
| Sat 6th Mar 10 | 18:30 |
| Newport Gwent Dragons | 31 - 22 | Munster | Rodney Parade | 6,137 | Report |
| Sun 7th Mar 10 | 14:00 |
| Edinburgh | 33 - 17 | Ospreys | Murrayfield | 2,329 |
|
| Sun 7th Mar 10 | 16:00 |
| Cardiff Blues | 20 - 29 | Leinster | Cardiff City Stadium | 9,384 | Report |
| Wed 17th Mar 10 | 18:30 |
| Connacht Rugby | v | Newport Gwent Dragons | Sportsground |
|
|
| Thu 18th Mar 10 | 19:30 |
| Leinster | v | Glasgow Warriors | Royal Dublin Society |
|
|
| Thu 18th Mar 10 | 19:35 |
| Munster | v | Scarlets | Musgrave Park | S4C |
|
| Fri 19th Mar 10 | 18:10 |
| Ulster Rugby | P - P | Ospreys | Ravenhill | BBCw |
|
| Fri 26th Mar 10 | 19:05 |
| Cardiff Blues | v | Ulster Rugby | Cardiff City Stadium | BBCw |
|
| Fri 26th Mar 10 | 19:30 |
| Edinburgh | v | Scarlets | Murrayfield |
|
|
| Fri 26th Mar 10 | 20:00 |
| Munster | v | Glasgow Warriors | Thomond Park Stadium | Setanta(I) |
|
| Sat 27th Mar 10 | 16:30 |
| Leinster | v | Connacht Rugby | Royal Dublin Society | Setanta(I) |
|
| Sat 27th Mar 10 | 18:30 |
| Newport Gwent Dragons | v | Ospreys | Rodney Parade | S4C |
|
| Fri 2nd Apr 10 | 18:00 |
| Connacht Rugby | v | Edinburgh | Sportsground |
|
|
| Fri 2nd Apr 10 | 19:05 |
| Ospreys | v | Scarlets | Liberty Stadium | BBCw/Set(I) |
|
| Fri 2nd Apr 10 | 20:05 |
| Munster | v | Leinster | Thomond Park Stadium | Setanta |
|
| Sat 3rd Apr 10 | 19:30 |
| Ulster Rugby | v | Cardiff Blues | Ravenhill | S4C/Set(I) |
|
| Sun 4th Apr 10 | 15:05 |
| Glasgow Warriors | v | Newport Gwent Dragons | Firhill Arena | BBCw/Set(I) |
|
| Fri 16th Apr 10 | 19:05 |
| Glasgow Warriors | v | Ulster Rugby | Firhill Arena | Setanta(I) |
|
| Fri 16th Apr 10 | 19:05 |
| Leinster | v | Ospreys | Royal Dublin Society | BBCw/Setant1 |
|
| Sat 17th Apr 10 | 18:30 |
| Scarlets | v | Cardiff Blues | Parc y Scarlets | S4C/Setanta1 |
|
| Sun 18th Apr 10 | 17:05 |
| Connacht Rugby | v | Munster | Sportsground | Setanta(I) |
|
| Sun 18th Apr 10 | 17:05 |
| Newport Gwent Dragons | v | Edinburgh | Rodney Parade | S4C/Set(I) |
|
| 23/24/25 Apr |
|
| Edinburgh | v | Ulster Rugby | Murrayfield |
|
|
| 23/24/25 Apr |
|
| Glasgow Warriors | v | Leinster | Firhill Arena |
|
|
| 23/24/25 Apr |
|
| Munster | v | Ospreys | Thomond Park Stadium |
|
|
| 23/24/25 Apr |
|
| Newport Gwent Dragons | v | Cardiff Blues | Rodney Parade |
|
|
| 23/24/25 Apr |
|
| Scarlets | v | Connacht Rugby | Parc y Scarlets |
|
|
| 7/8/9 May |
|
| Cardiff Blues | v | Munster | Cardiff City Stadium |
|
|
| 7/8/9 May |
|
| Leinster | v | Edinburgh | Royal Dublin Society |
|
|
| 7/8/9 May |
|
| Ospreys | v | Newport Gwent Dragons | Liberty Stadium |
|
|
| 7/8/9 May |
|
| Scarlets | v | Glasgow Warriors | Parc y Scarlets |
|
|
| 7/8/9 May |
|
| Ulster Rugby | v | Connacht Rugby | Ravenhill |
|
|
| 14/15/16 May |
| SF |
| v |
| TBA |
|
|
| 14/15/16 May |
| SF |
| v |
| TBA |
|
|
| Sat 29th May 10 | 18:30 | F |
| v |
| TBA |
|
|
|
|
| Click here to download this fixture list |
|
|