WHERE ( descr LIKE _utf8"%hexagono%" collate utf8_general_ci AND descr LIKE _utf8"%fingal%" collate utf8_general_ci ) |

|

WHERE ( match (descr,nomweb,nomserie) against ('hexagono* fingal*' in BOOLEAN MODE) OR match (descr,nomweb,nomserie) against ('hexagono fingal') ) > 0 |

SELECT MAX(`search`.`idserie`) idserie, `search`.`cod04`, MAX(`search`.`id_tm`) id_tm, MAX(`search`.`codprecio`) codprecio, MAX(`search`.`tipomaterial_es`) tipomaterial_es, MAX(`search`.`tipomaterial_en`) tipomaterial_en, MAX(`search`.`tipomaterial_fr`) tipomaterial_fr, MAX(`search`.`tipomaterial_de`) tipomaterial_de, MAX(`search`.`id_stm`) id_stm, MAX(`search`.`subtipo_es`) subtipo_es, MAX(`search`.`subtipo_en`) subtipo_en, MAX(`search`.`subtipo_fr`) subtipo_fr, MAX(`search`.`subtipo_de`) subtipo_de, MAX(`search`.`nomserie`) nomserie, MAX(`search`.`nomweb`) nomweb, MAX(`search`.`fmtpieza`) fmtpieza, MAX(`search`.`fmtserie`) fmtserie, MAX(`search`.`fmtserie_in`) fmtserie_in, MAX(`search`.`id_tp`) id_tp, MAX(`search`.`orden`) orden, MAX(`search`.`tp_orden`) tp_orden, MAX(`search`.`visualizacion`) visualizacion, MAX(`search`.`serie_w`) serie_w, MAX(`search`.`serie_h`) serie_h, MAX(`search`.`fmt_h`) fmt_h, MAX(`search`.`fmt_w`) fmt_w, MAX(`search`.`descr`) descr, MAX(match (descr,nomweb,nomserie) against ('hexagono* fingal*' in BOOLEAN MODE) + match (descr,nomweb,nomserie) against ('hexagono fingal') ) AS priority FROM `vives_db`.`search` WHERE ( match (descr,nomweb,nomserie) against ('hexagono* fingal*' in BOOLEAN MODE) OR match (descr,nomweb,nomserie) against ('hexagono fingal') ) > 0 GROUP BY cod04 ORDER BY priority DESC , id_tp ASC , idserie DESC , fmtserie DESC , nomserie ASC , tp_orden , nomweb , id_tm ASC;