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='sfms',0,0)+IF(FixSource='irfu',1,0)+IF(FixSource='irfutag',2,0)+IF(FixSource='irfu18',3,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 = 'sfms' OR VenSource = 'irfu' OR VenSource = 'irfutag' 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 = 'irfu' LEFT JOIN stats_rugby.teams ON TeamId = FixTeamA AND (TeamSource = 'sfms' OR TeamSource = 'irfu' OR TeamSource = 'irfutag' 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 = 'sfms' OR FixSource = 'irfu' OR FixSource = 'irfutag' OR FixSource = 'irfu18') AND (0 OR CompGroup = 'irfutag') AND CompSubGroup = 'belvedere' AND (CompVisible = 'Yes' OR CompVisible IS NULL) AND (0 OR CompGroup = 'irfutag') AND CompSubGroup = 'belvedere' AND (CompVisible = 'Yes' OR CompVisible IS NULL) AND (((CompSeason = '2008' AND CompSeasonEnd = '2009')) OR CompId IS NULL) AND CompId = '2074' AND StgId = '' AND StgType = 'elimination' GROUP BY FixId, FixSource ORDER BY FixDate ASC, Ord, FixTime, HomeDisplay, AwayDisplay, Ord

2008-20092007-20082006-2007 LEINSTER - Old Belvedere RFC Vets Group One - Cup (Wednesday)Vets Group Two - Cup (Wednesday)Vets Group One - Bowl (Wednesday)Vets Group Two - Bowl (Wednesday)Vets Group Two - Plate (Wednesday)Mixed Social Grade C - Cup (Wednesday)Mixed Social Grade C - Bowl (Wednesday)Mixed Social Grade C - Plate (Wednesday)Mixed Social Grade C - Spoon (Wednesday)Wed - Mixed Social Weekly Inter-GroupMixed Social B Grade Cup (Thursday)Mixed Social B Grade Bowl (Thursday)Mixed Social C Grade Cup (Thursday)Mixed Social C Grsde Bowl (Thursday)Mixed Social C Grade Plate (Thursday)Mixed Social C Grade Spoon (Thursday)Mixed Social Beginners Cup (Thursday)Wed - Mixed Social Grade C1 (Wednesday)Mixed Social Beginners Bowl (Thursday)Wed - Mixed Social Grade C2 (Wednesday)Vets Group One (Men - 33 yrs and over) (Vets Group Two (Men - 33 yrs and over) (Thurs - Mixed Social Grade B (Thursday)Thurs - Mixed Social Grade C1 (Thursday)Thurs - Mixed Social Grade C2 (Thursday)Thurs - Mixed Social Beginners (Thursday Knock-out stages

Date Time Team A Score Team B 06/05/2009 20:55 Hoof Hearted C - C G'O2 13/05/2009 18:40 02 C - C Maple Lions 27/05/2009 20:10 Swifties C - C Tag mo Thoin 03/06/2009 20:55 Swoop Unit 8 - 16 The Fear 08/06/2009 19:25 Butter's Allstar Seven C - C Slatterys 10/06/2009 18:40 KSN Redbacks 12 - 5 The Titans 17/06/2009 19:25 RTE Sport 14 - 15 The Tagables