date = 2019-07-19
source des données: Société Mycologique de France

Liste des espèces récoltées:
date = 2019-07-19 et lieu = MontmorencyErreur dans l'execution de la requete 'select distinct `tabrecoltes`.`numChamp` AS`numChamp`, `tablechamp`.`N°champ` AS `N°champ`, `tablechamp`.`G_SG_VAL` AS `G_SG_VAL`, `tablechamp`.`espVAL` AS `espVAL`, `tablechamp`.`autVal` AS `autVAL`, `tablechamp`.`espUS` AS `espUS`, `tablechamp`.`autUs` AS `autUs`, `tablechamp`.`espSyn1` AS `espSyn1`, `tablechamp`.`espSyn2` AS `espSyn2`, `tablechamp`.`nomFr` AS `nomFr`, `tabcaractesp`.`numeroChamp` AS `numeroChamp`, `tabcaractesp`.`idFiche` AS `idFiche`, `tabcaractesp`.`etat` AS `etat`, `tabcaractesp`.`photoEsp1` AS `photoEsp1`, `tabclassif`.`division` AS `division`, `tabclassif`.`sousClasse` AS `sousClasse`, `tabclassif`.`ordre` AS `ordre`, `tablechamp`.`écologie` AS `écologie` from (`tabrecoltes` join `tablechamp` on((`tabrecoltes`.`numChamp` = `tablechamp`.`N°champ`)) left join `tabcaractesp` on((`tabcaractesp`.`numeroChamp` = `tabrecoltes`.`numChamp`)) inner join `tabclassif` on((`tablechamp`.`G_SG_VAL` = `tabclassif`.`G_SG_VAL`)) ) where `division` like 'ascomycota' and `sousClasse` like 'pezizomycetideae' and`tabrecoltes`.`recolte` like '2019-07-19%' and `tabrecoltes`.`lieu` like 'Montmorency' ORDER BY `espVAL`'.
Message de MySQL :Invalid utf8mb4 character string: 'N\xB0champ'