[\s][aeiou](l|r)(b|v)[aeiou](r|rr)t?[aeiou]?n?,[\s]60x60,[\s][aeiou](r|rr)[aeiou](n|nn|m)[aeiou]alberton 60x60 arena SELECT `search`.`idserie`, `search`.`cod04`, `search`.`id_tm`, `search`.`codprecio`, `search`.`tipomaterial_es`, `search`.`tipomaterial_en`, `search`.`tipomaterial_fr`, `search`.`tipomaterial_de`, `search`.`id_stm`, `search`.`subtipo_es`, `search`.`subtipo_en`, `search`.`subtipo_fr`, `search`.`subtipo_de`, `search`.`nomserie`, `search`.`nomweb`, `search`.`fmtpieza`, `search`.`fmtserie`, `search`.`fmtserie_in`, `search`.`id_tp`, `search`.`orden`, `search`.`tp_orden`, `search`.`visualizacion`, `search`.`serie_w`, `search`.`serie_h`, `search`.`fmt_h`, `search`.`fmt_w`, `search`.`descr`, ( (nomweb regexp "albert?o?n?") + (nomserie regexp "albert?o?n?") + (descr regexp "albert?o?n?") + (nomweb regexp "[aeiou](l|r)(b|v)[aeiou](r|rr)t?[aeiou]?n?") + (nomserie regexp "[aeiou](l|r)(b|v)[aeiou](r|rr)t?[aeiou]?n?") + (descr regexp "[aeiou](l|r)(b|v)[aeiou](r|rr)t?[aeiou]?n?") + (nomweb regexp "60x60") + (nomserie regexp "60x60") + (descr regexp "60x60") + (nomweb regexp "60x60") + (nomserie regexp "60x60") + (descr regexp "60x60") + (nomweb regexp "arena") + (nomserie regexp "arena") + (descr regexp "arena") + (nomweb regexp "[aeiou](r|rr)[aeiou](n|nn|m)[aeiou]") + (nomserie regexp "[aeiou](r|rr)[aeiou](n|nn|m)[aeiou]") + (descr regexp "[aeiou](r|rr)[aeiou](n|nn|m)[aeiou]") + (match (nomweb) against("(alb*) (60x*) (are*)" IN BOOLEAN MODE)) + (match (nomweb) against("(alber*) (60x60*) (arena*)" IN BOOLEAN MODE)) + (match (nomserie) against("(alb*) (60x*) (are*)" IN BOOLEAN MODE)) + (match (nomserie) against("(alber*) (60x60*) (arena*)" IN BOOLEAN MODE)) ) AS d1 FROM `vives_db`.`search` WHERE ( descr like "% a%" OR descr like "% 6%" OR descr like "% a%") AND descr REGEXP "[\s][aeiou](l|r)(b|v)[aeiou](r|rr)t?[aeiou]?n?|[\s]60x60|[\s][aeiou](r|rr)[aeiou](n|nn|m)[aeiou]" ORDER BY d1 desc LIMIT 50;