CS Noisy Roller » Classement D1

Voici le classement de la Nationale 1 Élite.

WordPress database error: [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 'OR `away_team` = ) AND DATEDIFF(NOW(), `date`) <= 0 ORDER BY `date` ASC' at line 1]
SELECT `group`, `home_team`, `away_team`, DATE_FORMAT(`date`, '%Y-%m-%d %H:%i') AS date, DATE_FORMAT(`date`, '%e') AS day, DATE_FORMAT(`date`, '%c') AS month, DATE_FORMAT(`date`, '%Y') AS year, DATE_FORMAT(`date`, '%H') AS `hour`, DATE_FORMAT(`date`, '%i') AS `minutes`, `match_day`, `location`, `league_id`, `home_points`, `away_points`, `winner_id`, `loser_id`, `post_id`, `season`, `id`, `custom` FROM wp_leaguemanager_matches WHERE ( `home_team` = OR `away_team` = ) AND DATEDIFF(NOW(), `date`) <= 0 ORDER BY `date` ASC

WordPress database error: [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 'OR `away_team` = ) AND DATEDIFF(NOW(), `date`) > 0 ORDER BY `date` DESC LIMIT 0' at line 1]
SELECT `group`, `home_team`, `away_team`, DATE_FORMAT(`date`, '%Y-%m-%d %H:%i') AS date, DATE_FORMAT(`date`, '%e') AS day, DATE_FORMAT(`date`, '%c') AS month, DATE_FORMAT(`date`, '%Y') AS year, DATE_FORMAT(`date`, '%H') AS `hour`, DATE_FORMAT(`date`, '%i') AS `minutes`, `match_day`, `location`, `league_id`, `home_points`, `away_points`, `winner_id`, `loser_id`, `post_id`, `season`, `id`, `custom` FROM wp_leaguemanager_matches WHERE ( `home_team` = OR `away_team` = ) AND DATEDIFF(NOW(), `date`) > 0 ORDER BY `date` DESC LIMIT 0,1

Position
Matches
Won
Tied
Lost
Entraineur
Site Internet

Tous les résultats de Noisy :

Match	Score
29 septembre 2012 20 h 30 min RH Gleizé – CS Noisy le Grand	6 - 4
6 octobre 2012 20 h 30 min CS Noisy le Grand – SPRS Ploufragan	9 - 4
12 octobre 2012 20 h 30 min SA Mérignac – CS Noisy le Grand	8 - 3
20 octobre 2012 20 h 30 min CS Noisy le Grand – HC Quévert	2 - 6
27 octobre 2012 20 h 30 min Biarritz BO – CS Noisy le Grand	6 - 0
17 novembre 2012 20 h 30 min CS Noisy le Grand – SCRA St Omer	5 - 8
1 décembre 2012 20 h 30 min SA Gazinet Cestas – CS Noisy le Grand	9 - 5
12 janvier 2013 20 h 30 min La Roche sur Yon – CS Noisy le Grand	2 - 2
26 janvier 2013 20 h 30 min CS Noisy le Grand – RAC St Brieuc	0 - 8
2 février 2013 20 h 30 min CS Noisy le Grand – US Coutras	7 - 5
23 février 2013 SPRS Ploufragan – CS Noisy le Grand	4 - 5
2 mars 2013 CS Noisy le Grand – SA Mérignac	3 - 3
9 mars 2013 HC Quévert – CS Noisy le Grand	4 - 4
16 mars 2013 20 h 30 min NOISY LE GRAND CS Noisy le Grand – RHC Lyon	4 - 3
6 avril 2013 CS Noisy le Grand – Biarritz BO	7 - 3
13 avril 2013 SCRA St Omer – CS Noisy le Grand	7 - 3
20 avril 2013 CS Noisy le Grand – SA Gazinet Cestas	5 - 0
27 avril 2013 RHC Lyon – CS Noisy le Grand	0 - 4
11 mai 2013 CS Noisy le Grand – La Roche sur Yon	3 - 6
25 mai 2013 RAC St Brieuc – CS Noisy le Grand	-:-
1 juin 2013 US Coutras – CS Noisy le Grand	-:-
8 juin 2013 CS Noisy le Grand – RH Gleizé	-:-

Toutes les journées ici:

Match	Score
25 mai 2013 La Roche sur Yon – US Coutras	-:-
25 mai 2013 SA Gazinet Cestas – SPRS Ploufragan	-:-
25 mai 2013 Biarritz BO – RH Gleizé	-:-
25 mai 2013 RHC Lyon – SCRA St Omer	-:-
25 mai 2013 HC Quévert – SA Mérignac	-:-
25 mai 2013 RAC St Brieuc – CS Noisy le Grand	-:-