FRANCE SERVICES - 60 rue Corse / 95 130 FRANCONVILLE - Tél : 01 34 15 47 78 - Fax : 01 34 15 67 25

 Erreur ! 

La requête a échoué [1267 - Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '=']
SQL = SELECT DISTINCT artic.CODE, artic.IDENT, artic.IMAGE, artic.CODE_PROMO_NOUVEAUTE, artic.PU, artic.COLISAGE, artic.SOUMIS_REM, artic.SOMMEIL, artic.CODESFAM, artic.CODEMARQUE, artic.LONGUEUR, sfamart.CODEFAM, unite.DESIG AS DESIGUNITE, libunite.DESIG AS DESIGUNITELANG, famart.DESIG AS DESIGFAM, sfamart.DESIG AS DESIGSFAM, libfamart.DESIG AS DESIGFAMLANG, libsfamart.DESIG AS DESIGSFAMLANG, artic.DESIG AS DESIG, artic.DESIG1 AS DESIG1, libartic.DESIG AS DESIGLANG, libartic.DESIG1 AS DESIG1LANG, artic.INFO, libartic.INFO AS INFOLANG, marque.DESIG AS DESIGMARQUE FROM `artic` LEFT JOIN `unite` ON artic.CODEUNITE=unite.CODE LEFT JOIN `libunite` ON artic.CODEUNITE=libunite.CODE AND libunite.CODELANG='fr' LEFT JOIN `sfamart` ON artic.CODESFAM=sfamart.CODE LEFT JOIN `famart` ON sfamart.CODEFAM=famart.CODE LEFT JOIN `libartic` ON artic.CODE=libartic.CODEART AND libartic.CODELANG='fr' LEFT JOIN `libfamart` ON sfamart.CODEFAM=libfamart.CODEFAM AND libfamart.CODELANG='fr' LEFT JOIN `libsfamart` ON artic.CODESFAM=libsfamart.CODESFAM AND libsfamart.CODELANG='fr' LEFT JOIN `marque` ON artic.CODEMARQUE=marque.CODE LEFT JOIN `articsfamart` ON artic.CODE=articsfamart.CODEART AND articsfamart.CODESFAM = sfamart.CODE WHERE artic.SOMMEIL = 'N' AND ( (artic.CODESFAM = 'manitub Ø40mm' AND artic.CODESFAM = sfamart.CODE) OR (articsfamart.CODESFAM = 'manitub Ø40mm'))