| Dernières infos |
 |
Les Italiens intègrent la Ligue Celte |
| 8 Mar, 17h12 |
| La Ligue Celtique a annoncé que deux équipes italiennes joueront le championnat celte la saison prochaine. Le Benetton Treviso et les Hérons de Vidanas ont gangé leurs tickets pour intégrer la Magners League. |
 |
Jérôme Thion acquitté |
| 2 Fév, 15h10 |
| Le deuxième ligne de Biarritz Jérôme Thion (Num 4), comparaissait aujourd'hui à Dublin (mardi 2 février 2010) devant la Commission Indépendante de Discipline en raison d'une citation survenue lors de la rencontre de la poule 2 contre les Glasgow Warriors le dimanche 24 janvier 2010 au Parc des Sports d'Aguilera. |
 |
Jean-Pierre Lux Président de l'ERC: "Le rugby français est à l'honneur" |
| 28 Jan, 14h57 |
| Le Président de l'ERC Jean-Pierre Lux se félicite de la réussite des clubs français dans les tournois de la H Cup et de l'Amlin Challenge Cup. Avec quatre clubs qualifiés en quart de finale de la H Cup, plus Bourgoin et Toulon en quart de finale de l'Amlin Challenge Cup, l'année 2010 s'annonce Tricolore. |
|
| Calendrier / résultats |
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='westgate',0,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 = 'westgate')
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 = 'erc'
LEFT JOIN stats_rugby.teams ON TeamId = FixTeamA AND (TeamSource = 'westgate')
WHERE FcmpSource = FixSource AND FcmpFixId = FixId AND FcmpCompId = CompId AND FcmpStgId = StgId AND StgCompId = CompId AND FixDate IS NOT NULL AND (FixSource = 'westgate') AND FixCompId = '2229' AND FixStgId = 'P2' AND (CompVisible = 'Yes' OR CompVisible IS NULL)
GROUP BY FixId, FixSource
ORDER BY FixDate ASC, Ord, FixTime, HomeDisplay, AwayDisplay, Ord
| Date | Matchs |
|---|
| 9/10/09 | Gloucester 19 - 17 Dragons |
| 10/10/09 | Warriors 18 - 22 Biarritz |
| 16/10/09 | Dragons 22 - 14 Warriors |
| 17/10/09 | Biarritz 42 - 15 Gloucester |
| 11/12/09 | Warriors 33 - 11 Gloucester |
| 13/12/09 | Biarritz 49 - 13 Dragons |
| 19/12/09 | Dragons 8 - 26 Biarritz |
| 20/12/09 | Gloucester 19 - 6 Warriors |
| 15/1/10 | Warriors 29 - 25 Dragons |
| 16/1/10 | Gloucester 23 - 8 Biarritz |
| 24/1/10 | Dragons 23 - 32 Gloucester |
| 24/1/10 | Biarritz 41 - 20 Warriors |
|
|
|
