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%)
Gloucester restored some Heineken Cup pride with a morale-boosting win over Glasgow Warriors at Kingsholm.
The 19-6 victory keeps their slim chances of quarter-final qualification alive ahead of the Round 5 encounter with pool leaders Biarritz and the final day trip to Newport Gwent Dragons.
Having been beaten 33-11 in Glasgow lat weekend, it looked as though a similar outcome might be on the cards in the West Country as Gloucester trailed 6-0 after the opening 40 minutes.
But an impressive second-half display changed things around for Gloucester who moved into second place in Pool 2.
Tries from wing Charlie Sharples and second row Alex Brown, together with nine points from the boot of former Cardiff fly-half Nicky Robinson, saw Gloucester bounce back from a comprehensive reverse at Firhill in Round 3.
A 13th-minute penalty and a 26th-minute drop goal from Dan Parks had moved Glasgow in front before Robinson brought Gloucester level with a brace of penalties of his own 10 minutes into the second period.
Sharples then crossed for the game’s opening try seven minutes later after useful contributions from England internationals Olly Morgan and James Simpson-Daniel.
Replacement back row Luke Narraway picked up Robinson’s cut-out pass to carry on the good work, with Simpson-Daniel finding Sharples wide on the right. The 20-year-old then wriggled through three lacklustre tackles for his second score in two games against Glasgow.
Robinson’s missed conversion ensured Glasgow remained within a single score at 11-6 with just over 20 minutes left to play, but not for long as he kicked a 65th-minute penalty.
Glasgow needed the next score to raise hopes of a comeback, but it never happened. Instead it was Gloucester who put the result beyond doubt after 70 minutes when Brown crossed for their second try.
Morgan and Simpson-Daniel were again at the heart of the breakthrough, with Alasdair Strokosch providing the final burst before Brown dived over from close range.
Robinson failed with the conversion once more but the game was now beyond Glasgow who slipped to their third defeat in four European outings this season.
It's a bright day here in Gloucester, the Magners League leaders are in town for this Heineken cup clash between two teams that are desperate for a bonus point win
2
Gloucester Rugby
Gloucester have began well, winning turnover ball at the first ruck and winning the first lineout and scrum showing just how good their set piece is
3
Gloucester Rugby
Simpson-Daniel takes the ball in hand and takes the outside line before Max Evans dragged him into touch
3
Gloucester Rugby
Gloucester lose their second lineout, and Glasgow put boot to ball to clear to halfway
5
Gloucester Rugby
Gloucester win turnover ball from the scrum, but can't find a way through the visitors defence before kicking possession away
8
Glasgow Warriors
Clever kicking from Parks gains his side ground, Glasgow will be happy with the start they have made
8
Gloucester Rugby
Blood sub - L Narraway on for A Strokosch
9
Gloucester Rugby
Glasgow concede a penalty and all of a sudden its Gloucester who are on the front foot. They are up the 22, but indiscipline from Lawson as he comes in to the side of a ruck means the attack is over
12
Glasgow Warriors
Loose ball, and Vernon makes a break behind the Gloucester line, he hasn't got the gas to make it to the tryline
12
Gloucester Rugby
Blood sub - A Strokosch on for L Narraway
13
Gloucester Rugby
Yellow card - A Hazell
Cynical play from the flanker, he kicks the ball from the hands of the Glasgow scrum half Chris Cusiter and earns 10minutes for his actions
14
Glasgow Warriors
Penalty kick - D Parks
16
Gloucester Rugby
Excellent broken field running from Gloucester, with Robinson and Simpson-Daniel and just as it looks like there will be a try A Glasgow defender intercepts the pass and the danger is cleared
18
Glasgow Warriors
Kellock steals lineout ball for his side, and Parks puts boot to ball
19
Gloucester Rugby
Gloucester really cooking now, with another free-flowing attacking move, it's only down to Glasgow's skill at the ruck, forcing turnovers, that Gloucester haven't been able to score
22
Gloucester Rugby
Hazell's sin bin session is over, and his side have largely dominated the 10 minute period of his absence
24
Glasgow Warriors
Clever play from Parks, who is using the boot well and running fine lines as his side make yards and are up into the 22
25
Glasgow Warriors
Great continuity from the Scots, Parks is in the pocket eyeing a drop goal
26
Glasgow Warriors
Drop kick - D Parks
A sweet strike from inside the 22 doubles the visitors' lead
27
Glasgow Warriors
Parks is really running the show, his touchfinder means Gloucester has a lineout 5m from their own line
28
Gloucester Rugby
Morgan takes a mark just inside his 22 as Parks attempts a cross field up ''n' under
31
Glasgow Warriors
Glasgow guilty of holding on to the tackler, and Robinson puts his penalty kick to the 22, it means his side can set up an attacking lineout
32
Glasgow Warriors
Gloiucester's attack falters as the visitors commit at least three men to every ruck, it results in a penalty for Scots and a talking to from the ref to Gloucester skipper Gareth Delve
35
Glasgow Warriors
Yet another penalty goes to Glasgow at the breakdown, Barclay is dominating proceedings and it is resulting in illegal play by the home side
36
Glasgow Warriors
Parks' kick is just short, and the lead remains at six
36
Gloucester Rugby
Roninson misjudges a kick ahead, and it bounces in goal.
38
Gloucester Rugby
Glasgow are on top in every aspect of this game, and the fans boo their disapproval from the Shedl
40
Gloucester Rugby
Gloucester rally and are up to the 22, but slow ruck ball again puts paid to that attack
Second half timeline
41
Glasgow Warriors
Kellock gathers the kick off superbly, its just another example of how well drilled the Scottish side are
42
Gloucester Rugby
Gray is offside as Parks puts up a high kick, its not good play from the second row man, and Robinson lines up a mid range shot at goal
43
Gloucester Rugby
Penalty kick - N Robinson
Robinson's shot bounces off the upright and is over - a spot of luck for the home team
45
Glasgow Warriors
It;s not all going the way of the Scottish side as Morrison is called for crossing
46
Gloucester Rugby
Flowing rugby from Gloucester the ball goes through hands and an attack build at pace, they are within five and spin the ball across field - but Hazell can't grab the long pass and the attack fizzles out
46
Gloucester Rugby
Substitution - G Somerville on for P Doran-Jones
47
Gloucester Rugby
It's on again, Voyce is just stopped short and, on 10th phase Delve tries to bundle his way over
48
Glasgow Warriors
Glasgow win turnover ball, good discipline saving them from conceding a try
49
Gloucester Rugby
Dominant scrum from Gloucester and they win a penalty as Glasgow's scrum crumbles
50
Gloucester Rugby
Penalty kick - N Robinson
The sides are level as Robinson slots the three-pointer
50
Gloucester Rugby
Substitution - E Fuimaono-Sapolu on for T Molenaar
50
Glasgow Warriors
Substitution - K Tkachuk on for J Welsh
52
Glasgow Warriors
Substitution - D Turner on for R Gray
53
Gloucester Rugby
Substitution - L Narraway on for A Hazell
56
Gloucester Rugby
Much better by Gloucester, and they are threatening the Scottish line on 1th phase
57
Gloucester Rugby
Try - C Sharples
The wing is on the end of a swift move on the left hand flank
58
Gloucester Rugby
Robinson can't nail the difficult conversion fro the far right hand side
59
Glasgow Warriors
Substitution - J Beattie on for R Vernon
59
Glasgow Warriors
Substitution - C Gregor on for B Stortoni
59
Glasgow Warriors
Substitution - F Thomson on for D Hall
59
Glasgow Warriors
Substitution - M Low on for F Thomson
60
Gloucester Rugby
It's been a different second half as Gloucester's big name players step up, Delve, Simpson-Daniel and Robinson are all beginning to have a major influence in this match
63
Gloucester Rugby
Robinson's high ball is collected by Simpson-Daniel, and as Glasgow defend desperately at a ruck, they do so illegally
65
Gloucester Rugby
Penalty kick - N Robinson
A confident kick from the fly half puts daylight between the sides
65
Glasgow Warriors
Substitution - C Shaw on for M Evans
65
Gloucester Rugby
Substitution - D Lewis on for R Lawson
66
Glasgow Warriors
Substitution - M McMillan on for C Cusiter
67
Glasgow Warriors
Substitution - J Beattie on for R Vernon
68
Gloucester Rugby
Somerville in charge of the scrum as his side win one against the head - its all going the way of the Cherry and Whites at the moment
70
Gloucester Rugby
Try - A Brown
Gloucester assert their dominance with their second score and its starting to look all to easy for the home side as they slice their way through the flailing defenders
70
Glasgow Warriors
Substitution - E Kalman on for M Low
71
Gloucester Rugby
Robinson hooks his conversion attempt wide
72
Glasgow Warriors
Glasgow win a penalty 22m out as Gloucester fail to roll away, but they know three points isn't enough, and take a tap penalty as desperation sets in
72
Gloucester Rugby
Substitution - A Eustace on for D Attwood
73
Glasgow Warriors
The attack comes to nothing with a knock on
75
Glasgow Warriors
Glasgow are back into the home 22, they must score now, but its relief for Gloucester as the ref signals offside at a ruck
77
Glasgow Warriors
Again Glasgow get hands on the ball, but they simply can't find a way through and eventually lose possession as Brown is tackled and spills the ball
78
Gloucester Rugby
Delve is named as Heineken Man of the Match
80
Gloucester Rugby
Sharples is denied a picture book try as the ref spots a forward pass earlier in the move, it doesn't matter as Gloucester seal the win
Results so far
Gloucester Rugby
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 = '2' OR FixTeamB = '2') AND FixCompId = '2229' 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/1/10
Pool 2
Newport Gwent Dragons
W 32-23
16/1/10
Pool 2
Biarritz Olympique Pays Basque
W 23-8
20/12/09
Pool 2
Glasgow Warriors
W 19-6
11/12/09
Pool 2
Glasgow Warriors
L 11-33
17/10/09
Pool 2
Biarritz Olympique Pays Basque
L 15-42
9/10/09
Pool 2
Newport Gwent Dragons
W 19-17
Glasgow Warriors
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 = '18' OR FixTeamB = '18') AND FixCompId = '2229' 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/1/10
Pool 2
Biarritz Olympique Pays Basque
L 20-41
15/1/10
Pool 2
Newport Gwent Dragons
W 29-25
20/12/09
Pool 2
Gloucester Rugby
L 6-19
11/12/09
Pool 2
Gloucester Rugby
W 33-11
16/10/09
Pool 2
Newport Gwent Dragons
L 14-22
10/10/09
Pool 2
Biarritz Olympique Pays Basque
L 18-22
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 = '2' OR FixTeamB = '2') AND (FixTeamA = '18' OR FixTeamB = '18') 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
