Online Store
For everything a fan of the RBS 6 Nations could want! Get all the rugby merchandise and official licensed products online now!
Official Online Store
RBS 6 Nations iPhone App
RBS 6 Nations Video
Official iPhone App
Keep on top of all the action wherever you are through the official iPhone app! Featurs include video, news, history, stats and more.
Click here for details and to download the app to your iPhone
RBS 6 Nations
Match Highlights
Catch all the match action from this years RBS 6 Nations here on the official website. See the latest clips to the right or click below for all previous games
Multimedia
15 Mar, 17:00
Highlights of France's 46-20 defeat of Italy at the Stade de France
15 Mar, 00:00
Highlights of Ireland's 27-12 defeat of Wales at Croke Park
15 Mar, 00:00
Highlights of Scotland's 15-15 draw with England at Murrayfield
RBS RugbyForce - Your club needs your support
Whether your club needs a fresh coat of paint or an improved pitch, RBS RugbyForce can help you prepare your club facilities for the season ahead. From practical advice, guidance and other fun-filled ideas, RBS provides the resources you need to bring your plans to life. It all comes together on the RugbyForce Weekend on 5th & 6th June where volunteers at clubs across Great Britain will be out in force for a weekend of work and fun. To ensure a true team effort, the first 100 clubs to register will receive an RBS RugbyForce pack containing T shirts, DIY vouchers and BBQ food vouchers to kick off the weekend.
Fanzone
Stade de France
City Information
Ground Guide
Fixtures
Stade de France
Stade de France was built for the 1998 football World Cup, and was the setting for the nation’s greatest sporting achievement – the 3-0 win over Brazil in the final.
The stunning venue had been officially opened in January of that year when the hosts beat Spain 1-0 at football. A month later, France beat England 24-17 in the first rugby international there.
The first international try at Stade de France was scored by Philippe Bernat-Salles for France, while Neil Back scored England’s first try there.
With a capacity of 80,000, it replaced the Parc des Princes as the home of French rugby, although the old stadium is still used by Paris St Germain football club.
Located a few kilometres north of Paris in St Denis, it played host to the 2007 Rugby World Cup final on October 20, when South Africa were crowned champions with victory over England.
The stunning venue had been officially opened in January of that year when the hosts beat Spain 1-0 at football. A month later, France beat England 24-17 in the first rugby international there.
The first international try at Stade de France was scored by Philippe Bernat-Salles for France, while Neil Back scored England’s first try there.
With a capacity of 80,000, it replaced the Parc des Princes as the home of French rugby, although the old stadium is still used by Paris St Germain football club.
Located a few kilometres north of Paris in St Denis, it played host to the 2007 Rugby World Cup final on October 20, when South Africa were crowned champions with victory over England.
Paris
The city of romance is also, for lovers of rugby, one of the RBS 6 Nations venues that simply must be experienced. Once would be good... or a thousand times? Perfect.
If you have tens of thousands in the bank, meanwhile, then let go a little and book yourselves into the George V, one of the world's greatest (and most expensive) hotels. But, even if you can't afford that kind of extravagance, then Paris has something for everyone.
There are, literally, hundreds of small and perfectly comfortable hotels to choose from, all either a short walk or Metro ride from the centre of this wonderful city. And, when it comes to going out, what a choice there is: hundreds and hundreds of bars, cafes, brasseries and restaurants. We haven't even mentioned the sights and shops yet, either.
Boat trips along the River Seine, meanwhile, serve only to emphasise the (comparatively) small size of Paris's historic centre... and its beauty. A rugby weekend spent here is not just as memorable as any old Paris weekend. It's far, far better than that!
The city of romance is also, for lovers of rugby, one of the RBS 6 Nations venues that simply must be experienced. Once would be good... or a thousand times? Perfect.
If you have tens of thousands in the bank, meanwhile, then let go a little and book yourselves into the George V, one of the world's greatest (and most expensive) hotels. But, even if you can't afford that kind of extravagance, then Paris has something for everyone.
There are, literally, hundreds of small and perfectly comfortable hotels to choose from, all either a short walk or Metro ride from the centre of this wonderful city. And, when it comes to going out, what a choice there is: hundreds and hundreds of bars, cafes, brasseries and restaurants. We haven't even mentioned the sights and shops yet, either.
Boat trips along the River Seine, meanwhile, serve only to emphasise the (comparatively) small size of Paris's historic centre... and its beauty. A rugby weekend spent here is not just as memorable as any old Paris weekend. It's far, far better than that!
Stade de France
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='hgvision',0,0)+IF(FixSource='sixnations',1,0)+IF(FixSource='irfu18',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 = 'hgvision' OR VenSource = 'sixnations' 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 = 'sixnations'
LEFT JOIN stats_rugby.teams ON TeamId = FixTeamA AND (TeamSource = 'hgvision' OR TeamSource = 'sixnations' 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 = 'hgvision' OR FixSource = 'sixnations' OR FixSource = 'irfu18') AND (0 OR CompGroup = 'tests') AND FixVenId = '1622' AND CompSubGroup = 'sixnations' AND (CompVisible = 'Yes' OR CompVisible IS NULL) AND (0 OR CompGroup = 'tests') AND FixVenId = '1622' AND CompSubGroup = 'sixnations' 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
| |||||||||||||||||||||||||||||||||
