Добрый день. Скажите пожалуйста можно ли оптимизировать запрос:
SELECT * FROM sites AS s1, site_cash AS s2 WHERE s1.id = s2.id_site AND MATCH(cash) AGAINST('авва') = (SELECT MAX(MATCH(cash) AGAINST('авва')) FROM site_cash WHERE id_site=s2.id_site) GROUP BY id_site ORDER BY MATCH(cash) AGAINST('авва')