[Club information for away teams]
Please select your Club and press 'Enter' 106 rq SELECT * FROM Clubs C, Players P where P.SectionID='1' and C.ClubOriginalID=P.ClubOriginalID and C.CountyID='2' and P.ClubOriginalID=C.ClubOriginalID and P.CountyID='2' and C.StateID='1' group by C.ClubOriginalID ORDER by C.ClubNameSort ASC 116 tq select count(*) as tc from Teams T where T.ClubOriginalID='9' and T.TeamStatus='1' and T.LeagueID>'0' and T.SectionID='1' Abshot 116 tq select count(*) as tc from Teams T where T.ClubOriginalID='39' and T.TeamStatus='1' and T.LeagueID>'0' and T.SectionID='1' 116 tq select count(*) as tc from Teams T where T.ClubOriginalID='48' and T.TeamStatus='1' and T.LeagueID>'0' and T.SectionID='1' Alton Squash Academy 116 tq select count(*) as tc from Teams T where T.ClubOriginalID='27' and T.TeamStatus='1' and T.LeagueID>'0' and T.SectionID='1' Alverstoke 116 tq select count(*) as tc from Teams T where T.ClubOriginalID='1' and T.TeamStatus='1' and T.LeagueID>'0' and T.SectionID='1' Avenue 116 tq select count(*) as tc from Teams T where T.ClubOriginalID='33' and T.TeamStatus='1' and T.LeagueID>'0' and T.SectionID='1' 116 tq select count(*) as tc from Teams T where T.ClubOriginalID='10' and T.TeamStatus='1' and T.LeagueID>'0' and T.SectionID='1' 116 tq select count(*) as tc from Teams T where T.ClubOriginalID='38' and T.TeamStatus='1' and T.LeagueID>'0' and T.SectionID='1' Chichester 116 tq select count(*) as tc from Teams T where T.ClubOriginalID='176' and T.TeamStatus='1' and T.LeagueID>'0' and T.SectionID='1' 116 tq select count(*) as tc from Teams T where T.ClubOriginalID='11' and T.TeamStatus='1' and T.LeagueID>'0' and T.SectionID='1' David Lloyd S/ton 116 tq select count(*) as tc from Teams T where T.ClubOriginalID='3' and T.TeamStatus='1' and T.LeagueID>'0' and T.SectionID='1' Fair Oak 116 tq select count(*) as tc from Teams T where T.ClubOriginalID='17' and T.TeamStatus='1' and T.LeagueID>'0' and T.SectionID='1' 116 tq select count(*) as tc from Teams T where T.ClubOriginalID='25' and T.TeamStatus='1' and T.LeagueID>'0' and T.SectionID='1' 116 tq select count(*) as tc from Teams T where T.ClubOriginalID='20' and T.TeamStatus='1' and T.LeagueID>'0' and T.SectionID='1' Five Rivers 116 tq select count(*) as tc from Teams T where T.ClubOriginalID='31' and T.TeamStatus='1' and T.LeagueID>'0' and T.SectionID='1' 116 tq select count(*) as tc from Teams T where T.ClubOriginalID='41' and T.TeamStatus='1' and T.LeagueID>'0' and T.SectionID='1' Isle of Wight 116 tq select count(*) as tc from Teams T where T.ClubOriginalID='4' and T.TeamStatus='1' and T.LeagueID>'0' and T.SectionID='1' Lee-on-Solent 116 tq select count(*) as tc from Teams T where T.ClubOriginalID='2' and T.TeamStatus='1' and T.LeagueID>'0' and T.SectionID='1' Nuffield Health 116 tq select count(*) as tc from Teams T where T.ClubOriginalID='19' and T.TeamStatus='1' and T.LeagueID>'0' and T.SectionID='1' Petersfield 116 tq select count(*) as tc from Teams T where T.ClubOriginalID='24' and T.TeamStatus='1' and T.LeagueID>'0' and T.SectionID='1' Portsmouth Navy 116 tq select count(*) as tc from Teams T where T.ClubOriginalID='5' and T.TeamStatus='1' and T.LeagueID>'0' and T.SectionID='1' Portsmouth Squash 116 tq select count(*) as tc from Teams T where T.ClubOriginalID='177' and T.TeamStatus='1' and T.LeagueID>'0' and T.SectionID='1' 116 tq select count(*) as tc from Teams T where T.ClubOriginalID='44' and T.TeamStatus='1' and T.LeagueID>'0' and T.SectionID='1' 116 tq select count(*) as tc from Teams T where T.ClubOriginalID='13' and T.TeamStatus='1' and T.LeagueID>'0' and T.SectionID='1' 116 tq select count(*) as tc from Teams T where T.ClubOriginalID='43' and T.TeamStatus='1' and T.LeagueID>'0' and T.SectionID='1' Romsey LC 116 tq select count(*) as tc from Teams T where T.ClubOriginalID='7' and T.TeamStatus='1' and T.LeagueID>'0' and T.SectionID='1' S/Ton University 116 tq select count(*) as tc from Teams T where T.ClubOriginalID='12' and T.TeamStatus='1' and T.LeagueID>'0' and T.SectionID='1' Salisbury Nomads 116 tq select count(*) as tc from Teams T where T.ClubOriginalID='29' and T.TeamStatus='1' and T.LeagueID>'0' and T.SectionID='1' Seacourt 116 tq select count(*) as tc from Teams T where T.ClubOriginalID='21' and T.TeamStatus='1' and T.LeagueID>'0' and T.SectionID='1' Totton 116 tq select count(*) as tc from Teams T where T.ClubOriginalID='14' and T.TeamStatus='1' and T.LeagueID>'0' and T.SectionID='1' Trojans 116 tq select count(*) as tc from Teams T where T.ClubOriginalID='36' and T.TeamStatus='1' and T.LeagueID>'0' and T.SectionID='1' West Hants 116 tq select count(*) as tc from Teams T where T.ClubOriginalID='22' and T.TeamStatus='1' and T.LeagueID>'0' and T.SectionID='1' Whitchurch 116 tq select count(*) as tc from Teams T where T.ClubOriginalID='8' and T.TeamStatus='1' and T.LeagueID>'0' and T.SectionID='1' Winchester 116 tq select count(*) as tc from Teams T where T.ClubOriginalID='32' and T.TeamStatus='1' and T.LeagueID>'0' and T.SectionID='1' 116 tq select count(*) as tc from Teams T where T.ClubOriginalID='15' and T.TeamStatus='1' and T.LeagueID>'0' and T.SectionID='1' Wykeham 122
Ranking Period (optional) 160 173 rpq SELECT * FROM RankingPeriods R where R.RankingPeriodStart<='2025-12-06' and R.RankingPeriodEnd>='2018-08-31' and R.RankingPeriodSectionID='1' ORDER by R.RankingPeriodStart August 2018 September 2018
Current Rankings
Click here to see next month's rankings
Players shown in green are those that have not played the required number of matches as shown below and are therefore 'Ghosted' Ghosted players can still play matches and become un-ghosted when they have played the required number of matches. 2 matches must have been played before 01 Nov 2017 3 matches must have been played before 01 Jan 2018 4 matches must have been played before 01 Mar 2018 Currently 4 matches must have been played (i) Squad is the lowest team for which the player is currently eligible to play.
Next Month's Rankings
Click here to see current rankings
Back
