Schedules and Tables

Chilliwack

 
Player Profiles

SELECT divisionName, year, date, playByDate, gamePlayedOn, CONVERT( nvarchar(36), matchID ) AS matchID, CAST( REPLACE( matchName, 'Match ', '') AS INT ) AS matchName, homePlayerName, hPlayer, hPoints, hBonus, CONVERT( nvarchar(36), homePlayerID ) as hPlayerID, awayPlayerName, aPlayer, aPoints, aBonus, CONVERT( nvarchar(36), awayPlayerID ) as aPlayerID, CONVERT( nvarchar(36), clubID ) as clubID, clubName FROM listMatches WHERE divisionName = 'Ace' and year = 2019 AND homeIsActive = 1 AND awayIsActive = 1 ORDER BY matchName;;