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

2008-20092007-20082006-2007 ULSTER - Newforge Country Club Wed - Mixed Social B1 (Wednesday)Wed - Mixed Social B2 (Wednesday)Wed - Mixed Social C1 (Wednesday)Thurs - Mixed Social A (Thursday)Thurs - Mixed Social B (Thursday)Thurs - Mixed Social C1 (Thursday)Thurs - Mixed Social C2 (Thursday)Mixed Social A Cup Finals (Thursday)Mixed Social A Bowl Finals (Thursday)Mixed Social B Cup Finals (Thursday)Mixed Social B Bowl Finals (Thursday)Mixed Social C Cup Finals (Thursday)Mixed Social C Bowl Finals (Thursday)Mixed Social C Plate Finals (Thursday)Mixed Social C Spoon Finals (Thursday)Mixed Social B Cup Finals (Wednesday)Mixed Social B Bowl Finals (Wednesday)Mixed Social B Plate Finals (Wednesday)Mixed Social B Spoon Finals (Wednesday)Mixed Social C Cup Finals (Wednesday)Mixed Social C Bowl Finals (Wednesday) Round 1

Date Time Team A Score Team B 13/05/2009 19:45 Belfast Harlequins Ladies 14 - 12 Count Tagula 13/05/2009 19:45 City Slickers 19 - 28 Hands Like Feet 13/05/2009 19:45 Club de Racing, Belfast 17 - 26 Tropics 13/05/2009 19:45 PwC 19 - 20 Scrumbags 03/06/2009 19:45 Belfast Harlequins Ladies 15 - 36 Club de Racing, Belfast 03/06/2009 19:45 City Slickers 27 - 5 PwC 03/06/2009 19:45 Count Tagula 15 - 22 Tropics 03/06/2009 19:45 Hands Like Feet 22 - 11 Scrumbags 10/06/2009 19:00 Belfast Harlequins Ladies 9 - 19 PwC 10/06/2009 19:00 City Slickers 17 - 18 Club de Racing, Belfast 10/06/2009 20:30 Belfast Harlequins Ladies 13 - 22 Scrumbags 10/06/2009 20:30 City Slickers 23 - 18 Tropics 10/06/2009 20:30 Count Tagula 16 - 17 PwC 10/06/2009 20:30 Hands Like Feet 20 - 8 Club de Racing, Belfast 24/06/2009 19:00 Belfast Harlequins Ladies 21 - 20 City Slickers 24/06/2009 19:00 Count Tagula 3 - 38 Hands Like Feet 24/06/2009 19:00 PwC 24 - 22 Club de Racing, Belfast 24/06/2009 19:00 Scrumbags 6 - 20 Tropics 01/07/2009 20:30 Belfast Harlequins Ladies 10 - 34 Hands Like Feet 01/07/2009 20:30 City Slickers 10 - 0 Count Tagula 01/07/2009 20:30 Club de Racing, Belfast 24 - 12 Scrumbags 01/07/2009 20:30 PwC 8 - 32 Tropics 08/07/2009 19:00 Belfast Harlequins Ladies 19 - 40 Tropics 08/07/2009 19:00 City Slickers 21 - 28 Scrumbags 08/07/2009 19:00 Count Tagula 10 - 12 Club de Racing, Belfast 08/07/2009 19:00 Hands Like Feet 19 - 12 PwC 08/07/2009 20:30 Count Tagula 15 - 22 Scrumbags 08/07/2009 20:30 Hands Like Feet 17 - 11 Tropics