SELECT *, `projects`.`id` AS `pid`, `currencies`.`name` AS `cname`,
(SELECT count(*) FROM `answers` WHERE `answers`.`project_id`=`projects`.`id`) AS `answers_count`,
MATCH(projects_mirror.title, projects_mirror.content)  AGAINST('создать' IN NATURAL LANGUAGE MODE) AS score
FROM projects JOIN projects_mirror ON projects.id = projects_mirror.id
JOIN razdels_podrazdels ON projects.razdel_podrazdel_id = razdels_podrazdels.id
JOIN `currencies` ON `projects`.`currency_id`=`currencies`.`id`
JOIN `types` ON `types`.`id`=`projects`.`type_id`
WHERE TRUE AND MATCH(projects_mirror.title, projects_mirror.content)  AGAINST('создать' IN NATURAL LANGUAGE MODE) ORDER BY score DESC LIMIT 10;