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

2008-20092007-2008 LEINSTER - Enniscorthy RFC Mixed Social Grade B (Thursday)Mixed Social Grade C (Thursday)Mixed Social Beginners (Thursday)Mixed Social Grade B Finals (Thursday)Mixed Social Grade C Finals (Thursday)Mixed Social Beginners Finals (Thursday) Round 1

Date Time Team A Score Team B 04/06/2009 19:00 Tagtastic 13 - 7 The Pretenders 04/06/2009 19:45 Pump Palace Pimps 6 - 10 Karmasutra Kings 04/06/2009 19:45 Who's Ya Daddy 11 - 8 Slaney Sirloins 04/06/2009 20:30 Tagliatelle 5 - 8 D'Unbelievables 11/06/2009 19:00 Slaney Sirloins 9 - 13 D'Unbelievables 11/06/2009 19:00 Who's Ya Daddy 6 - 7 Tagliatelle 11/06/2009 19:45 Tagtastic 12 - 5 Pump Palace Pimps 11/06/2009 20:30 The Pretenders 11 - 29 Karmasutra Kings 18/06/2009 19:00 Tagtastic 7 - 11 Karmasutra Kings 18/06/2009 19:00 The Pretenders 5 - 9 Pump Palace Pimps 18/06/2009 19:45 Who's Ya Daddy 10 - 15 D'Unbelievables 18/06/2009 20:30 Slaney Sirloins 20 - 16 Tagliatelle 25/06/2009 19:00 Karmasutra Kings 16 - 8 D'Unbelievables 25/06/2009 19:45 Pump Palace Pimps 10 - 9 Tagliatelle 25/06/2009 20:30 Tagtastic 14 - 11 Who's Ya Daddy 25/06/2009 20:30 The Pretenders 14 - 12 Slaney Sirloins 02/07/2009 19:00 The Pretenders 10 - 12 Who's Ya Daddy 02/07/2009 19:45 Karmasutra Kings 25 - 5 Tagliatelle 02/07/2009 19:45 Tagtastic 23 - 9 Slaney Sirloins 02/07/2009 20:30 Pump Palace Pimps 12 - 5 D'Unbelievables 09/07/2009 19:00 Pump Palace Pimps 8 - 11 Who's Ya Daddy 09/07/2009 19:00 Tagtastic 13 - 6 Tagliatelle 09/07/2009 20:30 Karmasutra Kings 27 - 14 Slaney Sirloins 09/07/2009 20:30 The Pretenders 22 - 17 D'Unbelievables 16/07/2009 19:00 Karmasutra Kings 13 - 10 Who's Ya Daddy 16/07/2009 19:00 The Pretenders 14 - 12 Tagliatelle 16/07/2009 19:45 Tagtastic 15 - 14 D'Unbelievables 16/07/2009 20:30 Pump Palace Pimps 11 - 8 Slaney Sirloins