LISTE DES MATCHS DE
[Invité]
Filtres :
Type de match :
TOUS
Amical
House Show
Mixtag
Pay Per View
S.N.M.E.
Show
Tournois
U.C. League
Matchs EN COURS Uniquement
Matchs NON AMICAUX Uniquement
0
matchs
Le serveur SQL est dans l'impossibilité d'effectuer la requête
Voici le message d'erreur renvoyé par la base de données :
Code erreur 1064 : Une erreur de syntaxe SQL se trouve dans la requte "AND cd_match.no_match in (0) UNION SELECT *, cd_match.no_match as no_match_or...".
SELECT *, cd_match.no_match as no_match_order, cd_lutteur_team.no_team as no_team_order, cd_lutteur.nom_lutteur as nom_lutteur_order FROM cd_lutteur_team right outer join cd_match_lutteur on cd_match_lutteur.no_team=cd_lutteur_team.no_team, phpbb_users,cd_match,cd_lutteur,cd_match_stipulation,cd_match_type,cd_show_ppv,cd_user_lutteur,cd_brand,cd_federation WHERE phpbb_users.user_id=cd_user_lutteur.user_id AND cd_federation.no_fede=cd_brand.no_fede AND cd_brand.no_brand=cd_lutteur.no_brand AND cd_match_lutteur.no_lutteur=cd_user_lutteur.no_lutteur AND cd_match.no_show_ppv=cd_show_ppv.no_show_ppv AND cd_match.no_type_match=cd_match_type.no_type_match AND cd_match.no_stipu_match=cd_match_stipulation.no_stipu_match AND cd_match.no_match=cd_match_lutteur.no_match AND cd_lutteur.no_lutteur=cd_match_lutteur.no_lutteur AND cd_match.no_match IN (SELECT no_match FROM cd_user_lutteur, cd_match_lutteur WHERE (cd_user_lutteur.date_deb <= UNIX_TIMESTAMP(cd_match.date_match) AND cd_user_lutteur.date_fin is null) AND cd_user_lutteur.no_lutteur = cd_match_lutteur.no_lutteur and user_id = '1') AND termine = 0 AND (cd_user_lutteur.date_deb <= UNIX_TIMESTAMP(cd_match.date_match) AND cd_user_lutteur.date_fin is null) AND termine=0 AND cd_match.no_match in (0) UNION SELECT *, cd_match.no_match as no_match_order, cd_lutteur_team.no_team as no_team_order, cd_lutteur.nom_lutteur as nom_lutteur_order FROM cd_lutteur_team right outer join cd_match_lutteur on cd_match_lutteur.no_team=cd_lutteur_team.no_team, phpbb_users,cd_match,cd_lutteur,cd_match_stipulation,cd_match_type,cd_show_ppv,cd_user_lutteur,cd_brand,cd_federation WHERE phpbb_users.user_id=cd_user_lutteur.user_id AND cd_federation.no_fede=cd_brand.no_fede AND cd_brand.no_brand=cd_lutteur.no_brand AND cd_match_lutteur.no_lutteur=cd_user_lutteur.no_lutteur AND cd_match.no_show_ppv=cd_show_ppv.no_show_ppv AND cd_match.no_type_match=cd_match_type.no_type_match AND cd_match.no_stipu_match=cd_match_stipulation.no_stipu_match AND cd_match.no_match=cd_match_lutteur.no_match AND cd_lutteur.no_lutteur=cd_match_lutteur.no_lutteur AND cd_match.no_match IN (SELECT no_match FROM cd_user_lutteur, cd_match_lutteur WHERE ( (cd_user_lutteur.date_deb <=UNIX_TIMESTAMP((cd_match.date_match))) OR (cd_user_lutteur.date_deb <=UNIX_TIMESTAMP((cd_match.date_match)) AND cd_user_lutteur.date_fin <=UNIX_TIMESTAMP((cd_match.date_match))) ) AND cd_match.no_match in (0) AND cd_user_lutteur.no_lutteur = cd_match_lutteur.no_lutteur and user_id = '1') AND termine = 0 AND ( (cd_user_lutteur.date_deb <=UNIX_TIMESTAMP((cd_match.date_match)) AND cd_user_lutteur.date_fin is null) OR (cd_user_lutteur.date_deb <=UNIX_TIMESTAMP((cd_match.date_match)) AND cd_user_lutteur.date_fin >=UNIX_TIMESTAMP((cd_match.date_match)) ) ) AND termine=1 AND cd_match.no_match in (0) UNION SELECT *, cd_match.no_match as no_match_order, cd_lutteur_team.no_team as no_team_order, cd_lutteur.nom_lutteur as nom_lutteur_order FROM cd_lutteur_team right outer join cd_match_lutteur on cd_match_lutteur.no_team=cd_lutteur_team.no_team, phpbb_users,cd_match,cd_lutteur,cd_match_stipulation,cd_match_type,cd_show_ppv,cd_user_lutteur,cd_brand,cd_federation WHERE phpbb_users.user_id=cd_user_lutteur.user_id AND cd_federation.no_fede=cd_brand.no_fede AND cd_brand.no_brand=cd_lutteur.no_brand AND cd_match_lutteur.no_lutteur=cd_user_lutteur.no_lutteur AND cd_match.no_show_ppv=cd_show_ppv.no_show_ppv AND cd_match.no_type_match=cd_match_type.no_type_match AND cd_match.no_stipu_match=cd_match_stipulation.no_stipu_match AND cd_match.no_match=cd_match_lutteur.no_match AND cd_lutteur.no_lutteur=cd_match_lutteur.no_lutteur AND termine = 0 AND ( (cd_user_lutteur.date_deb <=UNIX_TIMESTAMP((cd_match.date_match)) AND cd_user_lutteur.date_fin is null) OR (cd_user_lutteur.date_deb <=UNIX_TIMESTAMP((cd_match.date_match)) AND cd_user_lutteur.date_fin >=UNIX_TIMESTAMP((cd_match.date_match)) ) ) AND cd_match.no_lutteur_referee = AND cd_match.no_match in (0) UNION SELECT *, cd_match.no_match as no_match_order, cd_lutteur_team.no_team as no_team_order, cd_lutteur.nom_lutteur as nom_lutteur_order FROM cd_lutteur_team right outer join cd_match_lutteur on cd_match_lutteur.no_team=cd_lutteur_team.no_team, phpbb_users,cd_match,cd_lutteur,cd_match_stipulation,cd_match_type,cd_show_ppv,cd_user_lutteur,cd_brand,cd_federation WHERE phpbb_users.user_id=cd_user_lutteur.user_id AND cd_federation.no_fede=cd_brand.no_fede AND cd_brand.no_brand=cd_lutteur.no_brand AND cd_match_lutteur.no_lutteur=cd_user_lutteur.no_lutteur AND cd_match.no_show_ppv=cd_show_ppv.no_show_ppv AND cd_match.no_type_match=cd_match_type.no_type_match AND cd_match.no_stipu_match=cd_match_stipulation.no_stipu_match AND cd_match.no_match=cd_match_lutteur.no_match AND cd_lutteur.no_lutteur=cd_match_lutteur.no_lutteur AND termine = 0 AND (cd_user_lutteur.date_deb <= UNIX_TIMESTAMP(cd_match.date_match) AND cd_user_lutteur.date_fin is null) AND cd_match.no_lutteur_referee = AND cd_match.no_match in (0) UNION SELECT *, cd_match.no_match as no_match_order, cd_lutteur_team.no_team as no_team_order, cd_lutteur.nom_lutteur as nom_lutteur_order FROM cd_lutteur_team right outer join cd_match_lutteur on cd_match_lutteur.no_team=cd_lutteur_team.no_team, phpbb_users,cd_match,cd_lutteur,cd_match_stipulation,cd_match_type,cd_show_ppv,cd_user_lutteur,cd_brand,cd_federation WHERE phpbb_users.user_id=cd_user_lutteur.user_id AND cd_federation.no_fede=cd_brand.no_fede AND cd_brand.no_brand=cd_lutteur.no_brand AND cd_match_lutteur.no_lutteur=cd_user_lutteur.no_lutteur AND cd_match.no_show_ppv=cd_show_ppv.no_show_ppv AND cd_match.no_type_match=cd_match_type.no_type_match AND cd_match.no_stipu_match=cd_match_stipulation.no_stipu_match AND cd_match.no_match=cd_match_lutteur.no_match AND cd_lutteur.no_lutteur=cd_match_lutteur.no_lutteur AND termine = 0 AND (cd_user_lutteur.date_deb <= UNIX_TIMESTAMP(cd_match.date_match) AND cd_user_lutteur.date_fin is null) AND cd_match.no_lutteur_referee = ORDER BY no_match_order DESC, date_match DESC, no_team_order, ordre, nom_lutteur_order
