 |
Pay Subs On-Line |
 |
|
 |
Contents |
 |
|
 |
Who's Online |
 |
There are currently, 36 guest(s) and 6 member(s) that are online.
You are Anonymous user. You can register for free by clicking here |
|
|
|
|
 |
Forthcoming Fixtures |
 |
|
 |
1871 Club |
 |
|
 |
Player Registration |
 |
|
 |
Latest Results |
 |
20 April (RFU week 31)
|
| London Irish Vets | | 31 |
| B XV | | 10 |
|
All results |
|
|
|
|
|
 |
|
 |
Invalid query--error 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ORDER
BY sat DESC,
our_side_number' at line 50 SELECT oppo_side.side_club_id oppo_club_id,
oppo_side.side_number oppo_side_number,
oppo_side.side_desc oppo_side_desc,
their_side.side_club_id their_club_id,
their_side.side_number their_side_number,
their_side.side_desc their_side_desc,
my_side.side_club_id my_club_id,
my_side.side_number my_side_number,
my_side.side_desc my_side_desc,
our_side.side_club_id our_club_id,
our_side.side_number our_side_number,
our_side.side_desc our_side_desc,
my_club.club_desc my_club_desc,
oppo_club.club_desc oppo_club_desc,
location.location_adj,
location.location_code,
game1.game_score,
game1.game_oppo_score,
DATE_ADD(week1.week_date, INTERVAL game1.game_date_inc DAY) sat,
week0.week_id my_week_id,
week1.week_id week_id
FROM club_side oppo_side,
club_side my_side,
club_side our_side,
club_side their_side,
club my_club,
club oppo_club,
game game0,
game game1,
location,
week week1,
week week0
WHERE oppo_side.side_club_id = game0.game_oppo_side_club_id
AND oppo_side.side_number = game0.game_oppo_side_number
AND their_side.side_club_id = game1.game_oppo_side_club_id
AND their_side.side_number = game1.game_oppo_side_number
AND game1.game_oppo_side_club_id = game0.game_oppo_side_club_id
AND game1.game_cancel_reason_code IS NULL
AND my_side.side_club_id = game0.game_side_club_id
AND my_side.side_number = game0.game_side_number
AND our_side.side_club_id = game1.game_side_club_id
AND our_side.side_number = game1.game_side_number
AND my_club.club_id = game0.game_side_club_id
AND oppo_club.club_id = game0.game_oppo_side_club_id
AND location.location_code = game1.game_location_code
AND week1.week_id = game1.game_week_id
AND week0.week_id = game0.game_week_id
AND week1.week_date <= week0.week_date
AND game0.game_number =
ORDER
BY sat DESC,
our_side_number |
|
|
|
|
|