Recherche : energie

( SELECT SQL_CALC_FOUND_ROWS c.titre_contenu AS titre, CONCAT('/lire/',c.url_rew_contenu, ',', c.id_contenu, '?surligner=energie') 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 '[[:<:]][e]n[e]rg[i][e][[:>:]]' OR c.titre_contenu REGEXP '[[:<:]][e]n[e]rg[i][e]s[[:>:]]' OR c.txt1_contenu REGEXP '[[:<:]][e]n[e]rg[i][e][[:>:]]' OR c.txt1_contenu REGEXP '[[:<:]][e]n[e]rg[i][e]s[[:>:]]' ) OR c.id_contenu IN (78,927,491,221,1703,107,219,29,32,567,55,295,263,307,661,628,358,423,409,370,378,404,496,468,512,451,469,500,531,512,563,566,566,563,563,566,566,563,565,565,564,698,359,653,661,661,677,692,56,689,704,778,782,811,927,927,807,935,936,936,947,947,959,975,978,978,993,1002,1018,1020,1022,1032,1044,1046,1047,1047,1064,1093,1111,1111,1126,1126,1148,1179,1183,1194,1391,1316,1316,1304,1295,1288,1341,1262,1329,1276,1285,1288,1285,1313,1370,1279,1295,1373,1328,1279,1248,1241,1228,1426,1432,1436,1441,1468,1542,1563,1570,1604,1604,1619,1626,1666,1689,1697, 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 '[[:<:]][e]n[e]rg[i][e][[:>:]]' OR r.titre_rubrique REGEXP '[[:<:]][e]n[e]rg[i][e]s[[:>:]]' ) 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'