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('Сomodex') 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('Сomodex' IN BOOLEAN MODE) AND p.allow_who = 'all' AND b.allow_who = 'all' AND b.owner = 'user' AND p.id NOT IN(96, 153, 151) GROUP BY p.id ORDER BY rel DESC LIMIT 4
Can't find FULLTEXT index matching the column list