| Olympus Rugby XV Madrid v Montpellier |
|
|
|
|
|
|
| First half timeline |
| 6 | Montpellier | Try - F Nicot |
| 7 | Montpellier | Conversion - A Tomas |
| 11 | Olympus Rugby XV Madrid | Penalty kick - C Sempere |
| 13 | Montpellier | Try - G Chkhaidze |
| 14 | Montpellier | Conversion - A Tomas |
| 21 | Montpellier | Try - G Chkhaidze |
| 22 | Montpellier | Conversion - A Tomas |
| 24 | Olympus Rugby XV Madrid | Drop kick - C Sempere |
| 37 | Montpellier | Try - G Doumayrou |
| 38 | Montpellier | Conversion - A Tomas |
| Second half timeline |
| 41 | Olympus Rugby XV Madrid | Substitution - D Gurgenazde on for S Hattori |
| 41 | Olympus Rugby XV Madrid | Substitution - I Gutierrez on for H Quirelli |
| 41 | Olympus Rugby XV Madrid | Substitution - C Bernasconi on for S Souto |
| 41 | Olympus Rugby XV Madrid | Substitution - M Acena on for J Gonzalez |
| 42 | Montpellier | Substitution - M Castell on for A Tomas |
| 45 | Montpellier | Substitution - M Macurdy on for M Gorgodze |
| 47 | Olympus Rugby XV Madrid | Substitution - J Arbelaitz on for C Bohorquez |
| 48 | Montpellier | Substitution - K Kervarec on for J Figallo |
| 49 | Olympus Rugby XV Madrid | Substitution - I Criado on for R Camacho |
| 51 | Montpellier | Try - G Doumayrou |
| 52 | Montpellier | Conversion - J Schutte |
| 54 | Montpellier | Substitution - R Solana on for J Schutte |
| 57 | Olympus Rugby XV Madrid | Substitution - A Onega Camacho on for I Insausti |
| 58 | Montpellier | Substitution - S Matadigo on for G Chkhaidze |
| 61 | Montpellier | Substitution - N Leleimalefaga on for O Tissot |
| 62 | Montpellier | Substitution - M Ladhuie on for J Caudullo |
| 65 | Montpellier | Substitution - O Smith on for G Doumayrou |
| 66 | Olympus Rugby XV Madrid | Substitution - C Arenas on for M Mazo |
| 78 | Montpellier | Try - S Matadigo |
| 79 | Montpellier | Conversion - J Schutte |
|
| Results so far |
| Olympus Rugby XV Madrid |
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 (0 OR FixTeamA = '5733' OR FixTeamB = '5733') AND FixCompId = '2230' AND (CompVisible = 'Yes' OR CompVisible IS NULL) AND FixStatus = 'Res'
GROUP BY FixId, FixSource
ORDER BY FixDate DESC, Ord, FixTime, HomeDisplay, AwayDisplay, Ord
| Date | Stage | Opposition | Score |
|---|
| 23/1/10 | Pool 2 | Connacht Rugby | L 0-66 |
| 16/1/10 | Pool 2 | Worcester Warriors | L 3-54 |
| 19/12/09 | Pool 2 | Montpellier | L 6-42 |
| 11/12/09 | Pool 2 | Montpellier | L 24-57 |
| 17/10/09 | Pool 2 | Worcester Warriors | L 5-38 |
| 9/10/09 | Pool 2 | Connacht Rugby | L 6-46 |
|
|
|
| Montpellier |
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 (0 OR FixTeamA = '72' OR FixTeamB = '72') AND FixCompId = '2230' AND (CompVisible = 'Yes' OR CompVisible IS NULL) AND FixStatus = 'Res'
GROUP BY FixId, FixSource
ORDER BY FixDate DESC, Ord, FixTime, HomeDisplay, AwayDisplay, Ord
| Date | Stage | Opposition | Score |
|---|
| 22/1/10 | Pool 2 | Worcester Warriors | W 8-3 |
| 15/1/10 | Pool 2 | Connacht Rugby | L 10-20 |
| 19/12/09 | Pool 2 | Olympus Rugby XV Madrid | W 42-6 |
| 11/12/09 | Pool 2 | Olympus Rugby XV Madrid | W 57-24 |
| 16/10/09 | Pool 2 | Connacht Rugby | L 19-22 |
| 8/10/09 | Pool 2 | Worcester Warriors | W 22-17 |
|
|
|
| Previous Amlin Challenge Cup meetings |
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 (FixTeamA = '5733' OR FixTeamB = '5733') AND (FixTeamA = '72' OR FixTeamB = '72') AND (0 OR CompGroup = 'euroclub') AND CompSubGroup = 'challenge' AND (CompVisible = 'Yes' OR CompVisible IS NULL) AND FixStatus = 'Res'
GROUP BY FixId, FixSource
ORDER BY FixDate DESC, Ord, FixTime, HomeDisplay, AwayDisplay, Ord
| Date | Stage | Home | Score | Away |
|---|
| Sat 19th Dec 09 | Pool 2 | Olympus Rugby XV Madrid | 6 - 42 | Montpellier |
| Fri 11th Dec 09 | Pool 2 | Montpellier | 57 - 24 | Olympus Rugby XV Madrid |
|
|
|
| Amlin Challenge CupHistory |
|
|
| Montpellier |
| 2008/09 - Pool 2 |
| 2007/08 - Quarter Finals |
| 2006/07 - Pool 4 |
| 2005/06 - Pool 5 |
| 2004/05 - Round 2 |
| 2003/04 - Round 1 |
| 1997/98 - Pool 2 |
|
|
|
|
|
|
|
|
Did You Know?
There were a record 281,243 fans at the 67 Challenge Cup matches last season at an average of 4,197 per game.
|
