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

Badminton et tournois sur badiste




Erreur SQL

select PER_ID, PER_LICENCE, PER_NOM, PER_PRENOM, PER_NAISSANCE, PER_PES_ID, JOU_DATE_AUTO_COMPET, JOU_IS_ASSIMILE, JOU_IS_COMPET, JOU_IS_CORPO, JOU_IS_UNSS, JOU_IS_MUTE, JOU_IS_FNSU, JOU_MOYENNE_MONTEE_SIMPLE, JOU_TCL_ID_SIMPLE_OFF, JOU_CPPP_SIMPLE_OFF, JOU_MOYENNE_MONTEE_DOUBLE, JOU_TCL_ID_DOUBLE_OFF, JOU_CPPP_DOUBLE_OFF, JOU_MOYENNE_MONTEE_MIXTE, JOU_TCL_ID_MIXTE_OFF, JOU_CPPP_MIXTE_OFF, INS_ID, INS_NOM, INS_SIGLE, INS_NUMERO_DEPT, INS_INS_ID_CODEP, INS_INS_ID_LIGUE, PER_PAN_ID, PAY_NOM, PAY_ISO2, PAY_ISO3, JOC_NOM_LONG, JOC_NOM_COURT, TSC_NOM_LONG, TSC_NOM_COURT, JOU_DATE_SURCLAS, SUM(POW(2,IF(PLU_PLT_ID=5,1,PLU_PLT_ID+1))) AS PL, PER_IS_DATA_PUBLIC FROM `poona_permanent`.PERSONNE LEFT JOIN `poona_2018-2019`.JOUEUR ON JOU_PER_ID=PER_ID LEFT JOIN `poona_permanent`.INSTANCE ON JOU_INS_ID=INS_ID LEFT JOIN `poona_permanent`.PAYS_NATIONALITE ON PER_PAN_ID=PAN_ID LEFT JOIN `poona_permanent`.PAYS ON PAN_ID=PAY_ID LEFT JOIN `poona_permanent`.JOUEUR_CATEGORIE ON JOU_JOC_ID=JOC_ID LEFT JOIN `poona_permanent`.TYPE_SURCLASS ON JOU_TSC_ID=TSC_ID LEFT JOIN `poona_permanent`.PLUME ON PLU_PER_ID=PER_ID where INS_ID=147 GROUP BY PER_ID ORDER BY (JOU_MOYENNE_MONTEE_SIMPLE+JOU_MOYENNE_MONTEE_DOUBLE+JOU_MOYENNE_MONTEE_MIXTE) DESC, PER_NAISSANCE DESC, FIELD(JOU_TCL_ID_SIMPLE_OFF,1,114,127,126,125,124,123,122,121,120,119,118,117,116,115) DESC, FIELD(JOU_TCL_ID_DOUBLE_OFF,1,114,127,126,125,124,123,122,121,120,119,118,117,116,115) DESC, FIELD(JOU_TCL_ID_MIXTE_OFF,1,114,127,126,125,124,123,122,121,120,119,118,117,116,115) DESC LIMIT 0,1000

Query failed: Array