SET @max_score := (
SELECT MAX(MATCH(title_ru) AGAINST ('μεγάλο πουλί milf' IN NATURAL LANGUAGE MODE))
FROM video WHERE active = 1
);SELECT *, MATCH(title_ru) AGAINST ('μεγάλο πουλί milf' IN NATURAL LANGUAGE MODE) AS score , title_ru AS title FROM video WHERE active = '1' AND MATCH(title_ru) AGAINST ('μεγάλο πουλί milf' IN NATURAL LANGUAGE MODE) HAVING score > 0.7 * @max_score ORDER BY score DESC LIMIT 572, 44
