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 = "75"
Illegal mix of collations (utf8mb3_unicode_ci,IMPLICIT) and (utf8mb3_general_ci,IMPLICIT) for operation '='