Aller au contenu   Aller au menu   Aller à la recherche   Accessibilité

Badminton et tournois sur badiste




Erreur SQL

SELECT EVN_DEBUT,EVN_ID,EVN_NOM, EMA_TDI_ID, MIN(TST_ID) AS stade, SUM(EPA_IS_VICTOIRE) AS victoires, COUNT(EPA_ID) AS matches, EPA_LICENCE, EPA_PRENOM, EPA_NOM, MAX(IF(TST_ID=1, EPA_IS_VICTOIRE,0)), EPA_TCL_ID,COUNT(EPA_ID)-SUM(EPA_IS_VICTOIRE) AS defaites, EPA_JOC_ID FROM `poona_2025-2026`.EVENEMENT_MATCH LEFT JOIN `poona_2025-2026`.EVENEMENT_PARTICIPANT ON EPA_EMA_ID=EMA_ID LEFT JOIN `poona_permanent`.PERSONNE ON EPA_LICENCE=PERSONNE.PER_LICENCE LEFT JOIN `poona_2025-2026`.JOUEUR ON PER_ID=JOU_PER_ID LEFT JOIN `poona_permanent`.TYPE_STADE_COMPETITION ON EMA_TST_ID=TST_ID LEFT JOIN `poona_2025-2026`.EVENEMENT ON EMA_EVN_ID=EVN_ID WHERE JOU_INS_ID=3453 AND EVN_DEBUT>'2025-08-31' AND EVN_FIN<='2026-08-31' GROUP BY EVN_ID,EPA_LICENCE,EMA_TDI_ID ORDER BY EVN_DEBUT DESC,EVN_ID,stade,defaites,matches DESC,victoires DESC,EPA_NOM

Query failed: Array