Which team will host a Heineken Cup quarter-final?
Munster(37%)
Toulouse(22%)
Leinster(15%)
Biarritz(17%)
Ospreys(4%)
Leicester Tigers(2%)
Stade Français Paris(3%)
Munster used all their experience and skill to hit back from a fifth minute set-back and reach their fourth Heineken Cup final.
In their seventh semi-final in nine seasons, the 2006 champions booked their return to the Millennium Stadium thanks to two first-half tries. They will now meet Toulouse in the Welsh capital on Saturday, 24 May.
Saracens were looking to not only book their first trip to a European final, but also to clinch their ticket into next season’s Heineken Cup competition by reaching the last round in Cardiff.
And the English Premiership outfit started superbly well at a near packed Ricoh Arena when full back Richard Haughton turned desperate defence into blistering attack in the opening few minutes.
After fielding the ball at the feet of Alan Quinlan deep in his 22, Haughton raced up to the 22. Sarries recycled and Glen Jackson cleverly kicked through on the narrow side of the ruck for his wing Kameli Ratuvou to chase and retrieve up the left touchline. He raced over half-way, passed inside to skipper Neil De Kock who in turn passed on to centre Adam Powell.
Powell headed for the posts, but was hauled down just short by Doug Howlett. The ball came back on the Sarries side and Ratuvou was on hand to pick up and drive over for a try which Glen Jackson converted.
The Munster response came two minutes later from the boot of Ronan O’Gara with a simple penalty and then the Irish outside half edged hi side in front with a great dummying try at the posts at the end of the first quarter.
The game ebbed and flowed until the last move of the first-half when Howlett exploded from half-way to the edge of the Sarries 22 and the ever present Quinlan arrived to pick up and race unopposed to the posts for a try which O’Gara converted.
That gave Munster a handy lead to take into the interval, but the eight point gap was cut to two in the third quarter as Jackson knocked over two more penalties.
The latter came after Welsh referee Nigel Owens had sent Ruo Tipoki to the sin-bin for holding on in the tackle, but the yellow cards didn’t stop there.
In the space of two minutes Mr Owens dispatched both Saracens props – Nick Lloyd for punching and replacement Census Johnston for lying on in the tackle – and the game became 14-v 13 and then 15 v 13 for a short while.
Cobus Visagie briefly returned to the Saracens front row, but when he limped off with a leg injury Mr Owens had to order passive scrums for a short time.
O’Gara punished Johnston’s offence with a 62nd minute penalty that gave his side a five point lead, but Jackson was on target with 10 minutes to go with his third penalty to cut the gap to two points.
That set-up a tense final 10 minutes, but Munster were able to stand firm and take their place in their fourth Heineken Cup final at the end of next month.
Sarries regain Jackson's perfectly weighted kick-off and attack at Munster immediately. Jackson receives the ball again and kicks cross field for Ratuvou. Howlett gathers and is taken into touch.
2
Saracens
Sarries win the lineout but as they attack up the middle, Kris Chesney is picked up by the linesman for illegal use of the elbow. Nigel Owens has a word and Munster clear their lines.
3
Saracens
Munster claim their first ball from the lineout and O'Leary kicks into the box. Jackson tries to clear but is snagged and loses the ball. Hurley kicks through but Haughton counters brilliantly.
5
Saracens
Try - K Ratuvou
Jackson continues the moves down the blind side and his grubber is gathered by Ratuvou. He feeds Powell who looks as if he'll score but as Howlett hauls him down, Ratuvou is on hand to pick up and score.
5
Saracens
Conversion - G Jackson
7
Munster
Munster respond well and after reclaiming the restart are soon hammering at the Sarries line. The ball goes left and Dowling is put over in the corner only to be called back for a forward pass.
8
Munster
Penalty kick - R O'Gara
Munster have the consolation of a penalty in midfield for Hugh Vyvyan coming off his feet and O'Gara narrow the gap to three.
9
Munster
Another messy restart, and Munster win the penalty for the jumper being taken out in the air. O'Gara punts up the line for territory.
11
Munster
Munster secure their ball and go through multiple phases with no reward and are eventually penalised at the ruck for holding on. Good early signs for the Saracens defensive line.
13
Saracens
Sarries endure a similar fate with their ball as they attack fruitlessly and are eventually turned over and O'Gara hoofs down field. Some kicking tennis ensues and Haughton marks and clears.
15
Saracens
Ratuvou the Fijian is flying again. After receiving the ball on the left he leaves tow defenders standing and chips past the third. Only the scrambling defence of Howlett denies the winger his second score.
16
Saracens
From the lineout Sorrell comes back on a short ball but loses the ball. At the scrum though, Visagie destroys Horan to win the put in and Sarries again go wide from first phase.
17
Saracens
Ratuvou again runs hard and when De Kock spills the ball and Mr Owens brings play back for a Munster scrum . De Kock needs treatment after the huge hit from Howlett.
20
Munster
Munster win a penalty at the scrum and the front five are delighted after crumpling only minutes earlier. O'Gara gives the Irishmen good field position.
21
Munster
Munster attack and Horan drives powerfully in midfield. The quick ball is spread left and first Mafi, then Dowling surge for the line. The chance goes begging though as the ball is knocked on only metres short.
23
Munster
The Munster were obviously hurt by the poor scrimmage earlier and the men in red walk right over the Sarries eight to rapturous applause from their army of fans. They now have the put in.
24
Saracens
Unbelievably, Sarries take it against the head in this topsy turvy set piece battle and Jackson clears well.
25
Munster
Try - R O'Gara
Try time. O'Connell wins the lineout and O'Gara takes a flat ball at pace to ghost past Nick Lloyd and slide in to the right of the posts.
26
Munster
Nigel Owens is ready to overrule his touch judges who say that the conversion was missed, but TMO Derek Bevan confirms that O'Gara's effort was wide.
26
Munster
Missed conversion: O'Gara
28
Saracens
Munster take the ball up to halfway from the restart and O'Leary kicks to the corner. Some back and forth kicking follows, before Jackson eventually puts the ball out of play back on halfway.
30
Saracens
Leonelli hammers Mafi in midfield form the lineout and wins a penalty to boot to the visible joy of his teammates. A real up lifting moment for Sarries.
32
Saracens
Substitution - T Ryder on for B Skirving
35
Saracens
Jackson drills a pin point kick into the corner. The ball comes off the top and Leonelli and Vyvyan carry well up the middle. The ball is worked left and Sarries are awarded a scrum.
37
Saracens
De Kock takes the ball from Ryder and is unceremoniously hammered by opposite number O'Leary. Tough day at the office so far for the skipper.
38
Saracens
Sarries retain the ball, but Sorrell is pinged by Owens for holding on after a powerful surge.
40
Munster
Try - A Quinlan
Tipoki makes a break on halfway and offloads to Howlett. He is well caught by Leonelli and from the ruck, Quinlan picks up and goes straight through the middle and streaks over unopposed to score.
40
Munster
Conversion - R O'Gara
O'Gara adds the extras and what a time to put seven points on the board. Huge psychological blow on the stroke of half time.
Second half timeline
41
Munster
The rain has arrived in Coventry and that could play into the hands of the wily Munstermen who are masters at the art of wet weather tussles.
41
Saracens
Sarries face an uphill struggle if they are to take this one, but with the rewards at stake they certainly won't be giving up the ghost. First second half score will be vital.
41
Munster
Kick-off from O'Gara goes out on the full. Scrum back on half way.
42
Saracens
Jackson kicks deep and O'Leary clears. From the lineout, Ratuvou takes it up the middle, as then do Gustard and Sorrell and Owens penalises O'Callaghan in the shadow of the posts for hands in the ruck.
43
Saracens
Penalty kick - G Jackson
The kiwi makes no mistake and the lead is vitally reduced to five points.
44
Munster
Munster look to strike back immediately after regaining the restart, but the conditions begin to take their toll as the ball slips from O'Leary's grasp at the base.
46
Munster
More hands in the ruck from Munster allow Jackson to kick up the line to safety. Gustard carries from the ensuing play and once again the slippery ball is spilled.
47
Saracens
Substitution - C Johnston on for C Visagie
50
Saracens
Both sides enjoy periods of possession and predictably the game is tightening up as play becomes dominated by pick and gos. This is turning into a war of attrition.
52
Munster
O'Gara slides a low skiddy kick into the corner to give Munster good territory. Sarries win a penalty from the lineout though as Leamy is caught offiside. Jackson returns play to the Munster half.
54
Saracens
Cairns throw is not straight as more and more errors creep into the match and in that vein, O'Leary kicks the ball straight out on the full to give Cairns a second bite at the cherry.
55
Saracens
He gets it right and Sarries continue to keep it tight and take the pace right out of the tie. They do eventually go wide though and Ratuvou breaks the line
57
Saracens
The ball comes left where the forwards take over again, hammering towards the whitewash. When the ball is freed to Ratuvou once more, Tipoki kills the ball conceding a penalty under the sticks.
57
Munster
Yellow card - R Tipoki
The kiwi gets ten minutes for his troubles as Sarries manfully scrap their way back into the semi final.
57
Saracens
Penalty kick - G Jackson
Jackson slots the easy kick to narrow the gap further.
59
Saracens
Yellow card - N Lloyd
Tempers are getting frayed in this pressure cauldron and Nick Lloyd is picked out by the touch judge and gets 10 minutes of his own for punching at the scrum to level the numbers.
60
Munster
Missed penalty: O'Gara
62
Saracens
Yellow card - C Johnston
Jackson clears a missed O'Gara penalty, but his kick is infield and first Wallace then O'Connell carry back Census Johnson kills the ball and Mr Owens sends him the same way as Lloyd.
62
Munster
Penalty kick - R O'Gara
O'Gara makes Sarries pay for their indiscipline.
63
Saracens
Temporary sub - C Visagie on for P Gustard
64
Saracens
Confusion amongst referee and player as the sides attempt to pack down for a scrum with Sarries having both their props in the bin. Visagie comes back on despite at first claiming he was injured.
64
Saracens
Temporary sub - P Gustard on for C Visagie
65
Munster
Munster eventually come up with the ball and O'Gara weights a beautiful grubber to the posts only to be pulled back by Owens for a marginal penalty for a man being in front of the ball.
67
Munster
After a period of loose kicking, O'Leary slips a flat pass to Howlett inside his 22. Howlett races away but when he hits contact the wet ball slips from his hands in Sarries get some respite.
69
Saracens
Sarries get some good field position through strong carrying from Ratuvou but the move is ended by a forward pass. The match now error and the winner could be the side who make the least from now on in
71
Saracens
Penalty kick - G Jackson
An indiscretion at an ensuing breakdown gives Jackson a kickable penalty and the reliable Kiwi strikes it cleanly. This game is going to the wire.
73
Saracens
Jackson's influence is growing at just the right time. The fly half delivers a perfectly executed corner kick to pile the pressure on Munster and after an infield clearance Sarries attack.
74
Munster
Substitution - D Ryan on for D O'Callaghan
75
Saracens
They are scuppered by the slippery ball yet again though just as Jackson had slipped into the pocket for a dropped goal attempt. Munster have a long five minutes ahead of them.
76
Saracens
Sarries win a lineout and Sarries attack left. Ratuvou chip ahead but Mafi gathers and it is Munster's turn to break away. Hurley takes it up the left and Hill is penalised for coming off his feet at the ruck.
77
Saracens
Substitution - M Rauluni on for N de Kock
79
Munster
Leamy is penalised from the lineout and Jackson puts Sarries in range with a good touch finder. Johnson breaks though and Raulini almost breaks clear but Munster snaffle the ball and win the penalty.
80
Munster
With 80 minutes on the clock, the Irishmen put the ball out of play and Nigel Owens blows the whistle which sends Munster to Cardiff, the scene of their greatest day, for an epic final with Toulouse.
Results so far
Saracens
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 = '11' OR FixTeamB = '11') AND FixCompId = '1277' 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
27/4/08
Semi Finals
Munster
L 16-18
6/4/08
Quarter Finals
Ospreys
W 19-10
18/1/08
Pool 4
Glasgow Warriors
W 21-17
12/1/08
Pool 4
Biarritz Olympique Pays Basque
W 45-16
15/12/07
Pool 4
Viadana
W 34-26
8/12/07
Pool 4
Viadana
W 71-7
17/11/07
Pool 4
Biarritz Olympique Pays Basque
L 21-22
11/11/07
Pool 4
Glasgow Warriors
W 33-31
Munster
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 = '22' OR FixTeamB = '22') AND FixCompId = '1277' 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
24/5/08
Final
Toulouse
W 16-13
27/4/08
Semi Finals
Saracens
W 18-16
5/4/08
Quarter Finals
Gloucester Rugby
W 16-3
19/1/08
Pool 5
London Wasps
W 19-3
13/1/08
Pool 5
ASM Clermont Auvergne
L 19-26
16/12/07
Pool 5
Llanelli Scarlets
W 22-13
8/12/07
Pool 5
Llanelli Scarlets
W 29-16
18/11/07
Pool 5
ASM Clermont Auvergne
W 36-13
10/11/07
Pool 5
London Wasps
L 23-24
Previous Heineken 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 = '11' OR FixTeamB = '11') AND (FixTeamA = '22' OR FixTeamB = '22') AND (0 OR CompGroup = 'euroclub') AND CompSubGroup = 'cup' AND (CompVisible = 'Yes' OR CompVisible IS NULL) AND FixStatus = 'Res'
GROUP BY FixId, FixSource
ORDER BY FixDate DESC, Ord, FixTime, HomeDisplay, AwayDisplay, Ord
