SELECT ROUND(MATCH(manufacturers_name) AGAINST ('(+beverly) ("beverly*")' IN NATURAL LANGUAGE MODE), 2) AS score_m, ((IF(title LIKE "%beverly%" != '', 1, 0)) + MATCH(title) AGAINST ('(+beverly) ("beverly")' IN BOOLEAN MODE)) AS score_total_title, ((IF(content LIKE "%beverly%" != '', 1, 0)) + MATCH(content) AGAINST ('(+beverly) ("beverly")' IN BOOLEAN MODE)) AS score_total_content, MATCH(title, content) AGAINST ('(+beverly) ("beverly*")' IN NATURAL LANGUAGE MODE) AS score_last_sort, hey_searching.id, hey_searching.url, hey_searching.img, hey_searching.title, hey_searching.ref_colum_id, hey_searching.manufacturer_id, hey_searching.category_pad, hey_searching.products_model, hey_searching.show_in_results, p.filters, p.products_quantity FROM hey_searching LEFT OUTER JOIN products AS p ON p.products_id = hey_searching.ref_colum_id WHERE ((CONVERT(title USING utf8) LIKE "%beverly%" OR CONVERT(content USING utf8) LIKE "%beverly%")) AND lang_id = 4 AND active = 1 AND category_pad != '' AND category_pad NOT IN(890470, 890476, 890477) HAVING score_total_title >= 0.8 || score_total_content >= 1.8 ORDER BY score_m DESC, score_total_title DESC, score_total_content DESC, show_in_results DESC, score_last_sort DESC;