SELECT p.id,
p.title,
p.seolink AS post_link,
p.content_html AS content,
b.seolink AS blog_link,
img.fileurl,
MATCH(p.content_html) AGAINST('Тирания в семье') AS rel
FROM cms_blog_posts p
JOIN cms_blogs b ON b.id = p.blog_id
LEFT JOIN cms_upload_images img ON img.target_id = p.id AND img.target = 'blog_post' AND img.component = 'blogs'
WHERE MATCH(p.content_html) AGAINST('Тирания в семье' IN BOOLEAN MODE)
AND p.allow_who = 'all'
AND b.allow_who = 'all'
AND b.owner = 'user'
AND p.id NOT IN(2054, 2301)
GROUP BY p.id
ORDER BY rel DESC
LIMIT 4Can't find FULLTEXT index matching the column list