( SELECT SQL_CALC_FOUND_ROWS c.titre_contenu AS titre, CONCAT('/lire/',c.url_rew_contenu, ',', c.id_contenu, '?surligner=maison') AS url, CONVERT( COALESCE( (SELECT m.url_vignette FROM medias m WHERE m.id_externe = c.id_contenu AND m.type_media = 'img' AND m.type_liaison = 'contenu' AND m.url_vignette != '' ORDER BY m.id_media DESC LIMIT 1), '/_design/default/no_vignette_small.jpg' ) USING latin1) AS vignette, 'article' AS type, CONVERT(COALESCE((SELECT m.alt_media FROM medias m WHERE m.id_externe = c.id_contenu AND m.type_media = 'img' AND m.type_liaison = 'contenu' AND m.url_vignette != '' ORDER BY m.id_media DESC LIMIT 1), c.titre_contenu) USING latin1) AS alt, '2' AS pertinence, '' AS pictoplus, c.txt1_contenu AS texte FROM contenus c WHERE c.actif_contenu = '1' AND (c.titre_contenu REGEXP '[[:<:]]m[aàáâãäå][iìíîï]s[oðòóôõö]n[[:>:]]' OR c.titre_contenu REGEXP '[[:<:]]m[aàáâãäå][iìíîï]s[oðòóôõö]ns[[:>:]]' OR c.txt1_contenu REGEXP '[[:<:]]m[aàáâãäå][iìíîï]s[oðòóôõö]n[[:>:]]' OR c.txt1_contenu REGEXP '[[:<:]]m[aàáâãäå][iìíîï]s[oðòóôõö]ns[[:>:]]' ) OR c.id_contenu IN (56,126,141,149,242,252,266,281,437,470,470,472,480,482,538,538,538,537,537,537,536,536,536,577,616,630,679,729,778,1097,1379,1260,1432,1556,1569, 0) OR c.id_rubrique IN ( 0) GROUP BY c.id_contenu ) UNION ( SELECT r.titre_rubrique AS titre, CONCAT('/', r.url_rew_rubrique, ',r', r.id_rubrique) AS url, CONVERT(COALESCE( r.url_vignette_defaut, m.url_vignette, ( SELECT m2.url_vignette FROM medias m2, contenus c WHERE m2.id_externe = c.id_contenu AND m2.type_media = 'img' AND m2.type_liaison = 'contenu' AND c.id_rubrique = r.id_rubrique AND c.actif_contenu = '1' AND m2.url_vignette != '' LIMIT 1 ) , '/_design/default/no_vignette_small.jpg') USING latin1) AS vignette, 'rubrique' AS type, CONVERT(COALESCE(m.alt_media, r.titre_rubrique) USING latin1) AS alt, '3' AS pertinence, '' AS pictoplus, CONCAT('Tous les articles de la rubrique ', r.titre_rubrique, ' sur Marcel Green') AS texte FROM rubriques r LEFT JOIN medias m ON m.id_externe = r.id_rubrique AND m.type_media = 'img' AND m.type_liaison = 'rubrique' WHERE 1=1 AND r.actif_rubrique = '1' AND (r.titre_rubrique REGEXP '[[:<:]]m[aàáâãäå][iìíîï]s[oðòóôõö]n[[:>:]]' OR r.titre_rubrique REGEXP '[[:<:]]m[aàáâãäå][iìíîï]s[oðòóôõö]ns[[:>:]]' ) OR r.id_rubrique IN ( 0) GROUP BY r.id_rubrique ORDER BY m.id_media DESC ) ORDER BY pertinence DESC, titre LIMIT 120, 20
Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation 'regexp'