Recherche : jeux olympiques

( SELECT SQL_CALC_FOUND_ROWS c.titre_contenu AS titre, CONCAT('/lire/',c.url_rew_contenu, ',', c.id_contenu, '?surligner=jeux olympiques') 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 '[[:<:]]j[e][u]x[[:>:]]' OR c.titre_contenu REGEXP '[[:<:]]j[e][u]xs[[:>:]]' OR c.txt1_contenu REGEXP '[[:<:]]j[e][u]x[[:>:]]' OR c.txt1_contenu REGEXP '[[:<:]]j[e][u]xs[[:>:]]' ) AND (c.titre_contenu REGEXP '[[:<:]][o]l[y]mp[i]q[u][e]s[[:>:]]' OR c.titre_contenu REGEXP '[[:<:]][o]l[y]mp[i]q[u][e]ss[[:>:]]' OR c.titre_contenu REGEXP '[[:<:]]olympique[[:>:]]' OR c.txt1_contenu REGEXP '[[:<:]][o]l[y]mp[i]q[u][e]s[[:>:]]' OR c.txt1_contenu REGEXP '[[:<:]][o]l[y]mp[i]q[u][e]ss[[:>:]]' OR c.txt1_contenu REGEXP '[[:<:]]olympique[[:>:]]' ) OR c.id_contenu IN (671,989,1002,1007,1014, 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 '[[:<:]]j[e][u]x[[:>:]]' OR r.titre_rubrique REGEXP '[[:<:]]j[e][u]xs[[:>:]]' ) AND (r.titre_rubrique REGEXP '[[:<:]][o]l[y]mp[i]q[u][e]s[[:>:]]' OR r.titre_rubrique REGEXP '[[:<:]][o]l[y]mp[i]q[u][e]ss[[:>:]]' OR r.titre_rubrique REGEXP '[[:<:]]olympique[[:>:]]' ) OR r.id_rubrique IN ( 0) GROUP BY r.id_rubrique ORDER BY m.id_media DESC ) ORDER BY pertinence DESC, titre LIMIT 0, 20
Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation 'regexp'