Avis Pikmin Bloom

Erreur SQL !
SELECT blog_page_fiche_jeu_avis.bpfja_id, blog_page_fiche_jeu_avis.bpfja_jeu_id, blog_page_fiche_jeu_avis.bpfja_avis_texte, blog_page_fiche_jeu_avis.bpfja_avis_note, blog_page_fiche_jeu_avis.bpfja_membre_id_crypt, blog_page_fiche_jeu_avis.bpfja_date_creation, membre.membre_id_crypt, membre.membre_pseudo, membre.membre_avatar_bp_id, blog_photo.bp_id, blog_photo.bp_filename, blog_photo.bp_filename_ext, blog_photo.bp_alt, blog_photo.bp_directory_date_y, blog_photo.bp_directory_date_m, blog_photo.bp_directory_date_d, blog_photo.bp_directory_date_h, blog_photo.bp_directory_date_i, blog_photo.bp_directory_date_s FROM blog_page_fiche_jeu_avis LEFT JOIN membre ON blog_page_fiche_jeu_avis.bpfja_membre_id_crypt = membre.membre_id_crypt LEFT JOIN blog_photo ON membre.membre_avatar_bp_id = blog_photo.bp_id WHERE blog_page_fiche_jeu_avis.bpfja_jeu_id = "140"
Illegal mix of collations (utf8mb3_unicode_ci,IMPLICIT) and (utf8mb3_general_ci,IMPLICIT) for operation '='