 |
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='wru',1,0)+IF(FixSource='writemedia',2,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 = 'wru' OR VenSource = 'writemedia')
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 = 'wru'
LEFT JOIN stats_rugby.teams ON TeamId = FixTeamA AND (TeamSource = 'sfms' OR TeamSource = 'wru' OR TeamSource = 'writemedia')
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 = 'wru' OR FixSource = 'writemedia') AND (0 OR FixTeamA = '1008' OR FixTeamB = '1008' OR (FixTeamA = 0 AND FixTeamB = 0 AND (0 OR FixCompId = '115' OR FixCompId = '1318' OR FixCompId = '1318' OR FixCompId = '2006' OR FixCompId = '2358'))) AND FixStgId = 'U20' AND CompSubGroup = 'regional' AND (CompVisible = 'Yes' OR CompVisible IS NULL) AND (0 OR FixTeamA = '1008' OR FixTeamB = '1008' OR (FixTeamA = 0 AND FixTeamB = 0 AND (0 OR FixCompId = '115' OR FixCompId = '1318' OR FixCompId = '1318' OR FixCompId = '2006' OR FixCompId = '2358'))) AND FixStgId = 'U20' AND CompSubGroup = 'regional' AND (CompVisible = 'Yes' OR CompVisible IS NULL) AND (((CompSeason = '2008' AND CompSeasonEnd = '2009')) OR CompId IS NULL)
GROUP BY FixId, FixSource
ORDER BY FixDate ASC, Ord, FixTime, HomeDisplay, AwayDisplay, Ord
|
| Date | Time | Home | Score | Away |
|---|
| 29/10/2008 | 19:15 | Ospreys U20 | v | Scarlets U20 |
| 05/11/2008 | 19:15 | Blues U20 | v | Ospreys U20 |
| 19/11/2008 | 19:15 | Dragons U20 | v | Ospreys U20 |
|
|
 |
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='wru',1,0)+IF(FixSource='writemedia',2,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 = 'wru' OR VenSource = 'writemedia')
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 = 'wru'
LEFT JOIN stats_rugby.teams ON TeamId = FixTeamA AND (TeamSource = 'sfms' OR TeamSource = 'wru' OR TeamSource = 'writemedia')
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 = 'wru' OR FixSource = 'writemedia') AND (0 OR FixTeamA = '1000' OR FixTeamB = '1000' OR (FixTeamA = 0 AND FixTeamB = 0 AND (0 OR FixCompId = '115' OR FixCompId = '1318' OR FixCompId = '1318' OR FixCompId = '2006' OR FixCompId = '2318' OR FixCompId = '2358'))) AND FixStgId = 'U18' AND CompSubGroup = 'regional' AND (CompVisible = 'Yes' OR CompVisible IS NULL) AND (0 OR FixTeamA = '1000' OR FixTeamB = '1000' OR (FixTeamA = 0 AND FixTeamB = 0 AND (0 OR FixCompId = '115' OR FixCompId = '1318' OR FixCompId = '1318' OR FixCompId = '2006' OR FixCompId = '2318' OR FixCompId = '2358'))) AND FixStgId = 'U18' AND CompSubGroup = 'regional' AND (CompVisible = 'Yes' OR CompVisible IS NULL) AND (((CompSeason = '2009' AND CompSeasonEnd = '2010')) OR CompId IS NULL)
GROUP BY FixId, FixSource
ORDER BY FixDate ASC, Ord, FixTime, HomeDisplay, AwayDisplay, Ord
|
| Date | Time | Home | Score | Away |
|---|
| September 2009 |
| 12/09/2009 |
| RGC 1404 U18 | 12 - 37 | Ospreys U18 |
| 30/09/2009 |
| Dragons U18 | 16 - 28 | Ospreys U18 |
| October 2009 |
| 07/10/2009 |
| Ospreys U18 | 6 - 21 | Blues U18 |
| 21/10/2009 |
| Ospreys U18 | 14 - 27 | Dragons U18 |
| 28/10/2009 |
| Ospreys U18 | 16 - 22 | Scarlets U18 |
| November 2009 |
| 04/11/2009 |
| Scarlets U18 | 40 - 27 | Ospreys U18 |
| 22/11/2009 |
| Ospreys U18 | 31 - 0 | RGC 1404 U18 |
| December 2009 |
| 21/12/2009 | 19:15 | Blues U18 | v | Ospreys U18 |
|
|
 |
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='wru',1,0)+IF(FixSource='writemedia',2,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 = 'wru' OR VenSource = 'writemedia')
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 = 'wru'
LEFT JOIN stats_rugby.teams ON TeamId = FixTeamA AND (TeamSource = 'sfms' OR TeamSource = 'wru' OR TeamSource = 'writemedia')
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 = 'wru' OR FixSource = 'writemedia') AND (0 OR FixTeamA = '1005' OR FixTeamB = '1005' OR (FixTeamA = 0 AND FixTeamB = 0 AND (0 OR FixCompId = '115' OR FixCompId = '1318' OR FixCompId = '1318' OR FixCompId = '2006' OR FixCompId = '2318' OR FixCompId = '2358'))) AND FixStgId = 'U16' AND CompSubGroup = 'regional' AND (CompVisible = 'Yes' OR CompVisible IS NULL) AND (0 OR FixTeamA = '1005' OR FixTeamB = '1005' OR (FixTeamA = 0 AND FixTeamB = 0 AND (0 OR FixCompId = '115' OR FixCompId = '1318' OR FixCompId = '1318' OR FixCompId = '2006' OR FixCompId = '2318' OR FixCompId = '2358'))) AND FixStgId = 'U16' AND CompSubGroup = 'regional' AND (CompVisible = 'Yes' OR CompVisible IS NULL) AND (((CompSeason = '2009' AND CompSeasonEnd = '2010')) OR CompId IS NULL)
GROUP BY FixId, FixSource
ORDER BY FixDate ASC, Ord, FixTime, HomeDisplay, AwayDisplay, Ord
|
| Date | Time | Home | Score | Away |
|---|
| September 2009 |
| 02/09/2009 |
| Ospreys U16 | 31 - 7 | Blues South U16 |
| 16/09/2009 |
| Dragons U16 | 12 - 15 | Ospreys U16 |
| October 2009 |
| 14/10/2009 |
| Blues North U16 | 19 - 17 | Ospreys U16 |
| 28/10/2009 |
| Scarlets U16 | 17 - 13 | Ospreys U16 |
| November 2009 |
| 11/11/2009 |
| Blues South U16 | 24 - 18 | Ospreys U16 |
| 22/11/2009 |
| Ospreys U16 | 27 - 20 | RGC 1404 U16 |
| December 2009 |
| 02/12/2009 |
| Ospreys U16 | 20 - 3 | Dragons U16 |
| 13/12/2009 |
| RGC 1404 U16 | 12 - 19 | Ospreys U16 |
| January 2010 |
| 20/01/2010 |
| Ospreys U16 | 12 - 20 | Scarlets U16 |
| 27/01/2010 |
| Ospreys U16 | 35 - 3 | Blues North U16 |
|
|
|
|
