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 = 'nenagh' AND (CompVisible = 'Yes' OR CompVisible IS NULL) AND (0 OR CompGroup = 'irfutag') AND CompSubGroup = 'nenagh' AND (CompVisible = 'Yes' OR CompVisible IS NULL) AND (((CompSeason = '2008' AND CompSeasonEnd = '2009')) OR CompId IS NULL) AND CompId = '2082' AND StgId = '499' AND StgType = 'league' GROUP BY FixId, FixSource ORDER BY FixDate ASC, Ord, FixTime, HomeDisplay, AwayDisplay, Ord

2008-20092007-20082006-2007 MUNSTER - Nenagh Ormond RFC Mixed Social Grade A (Friday)Mixed Social Grade B (Friday)Mixed Social Beginners (Friday)Mixed Social Grade A Finals (Friday)Mixed Social Grade B Finals (Friday)Mixed Social Beginners Finals (Friday) Pool stages

Date Time Team A Score Team B 29/05/2009 19:05 Crushers 22 - 12 O'Dwyer Construction Thurles 29/05/2009 19:05 Newport 4 - 21 Paddys Bar 29/05/2009 19:05 Team Maximus 9 - 16 Ryan Windows 29/05/2009 19:05 The Real Farmers 13 - 13 The Talbot 05/06/2009 19:55 Crushers 8 - 21 The Real Farmers 05/06/2009 19:55 O'Dwyer Construction Thurles 8 - 23 The Talbot 05/06/2009 19:55 Ryan Windows 11 - 16 Paddys Bar 05/06/2009 19:55 Team Maximus 14 - 16 Newport 12/06/2009 20:45 Crushers 13 - 20 The Talbot 12/06/2009 20:45 O'Dwyer Construction Thurles 13 - 24 The Real Farmers 12/06/2009 20:45 Ryan Windows 25 - 8 Newport 12/06/2009 20:45 Team Maximus 19 - 20 Paddys Bar 19/06/2009 19:05 Newport 14 - 33 The Real Farmers 19/06/2009 19:05 Paddys Bar 13 - 16 The Talbot 19/06/2009 19:05 Ryan Windows 18 - 3 O'Dwyer Construction Thurles 19/06/2009 19:05 Team Maximus 15 - 17 Crushers 26/06/2009 19:55 Newport 7 - 21 The Talbot 26/06/2009 19:55 Paddys Bar 15 - 21 The Real Farmers 26/06/2009 19:55 Ryan Windows 9 - 11 Crushers 26/06/2009 19:55 Team Maximus 19 - 19 O'Dwyer Construction Thurles 03/07/2009 20:45 Newport 9 - 13 Crushers 03/07/2009 20:45 Paddys Bar 9 - 4 O'Dwyer Construction Thurles 03/07/2009 20:45 Ryan Windows 11 - 15 The Talbot 03/07/2009 20:45 Team Maximus 8 - 18 The Real Farmers 10/07/2009 19:05 Newport   - W O'Dwyer Construction Thurles 10/07/2009 19:05 Paddys Bar   - W Crushers 10/07/2009 19:05 Ryan Windows 13 - 14 The Real Farmers 10/07/2009 19:05 Team Maximus 9 - 10 The Talbot