CSD Dealers 2018: Deoghar, Deoli, and Deoria

WordPress database error: [Can't find FULLTEXT index matching the column list]
insert into wp_yarpp_related_cache (reference_ID,ID,score) SELECT 23455 AS reference_ID, ID, ROUND(0 + (MATCH (post_content) AGAINST ('adsbygoogle contact dealer csd deoghar window push post gst deoli motors address road 9414029340 dealers details deoria updated 25 06')) * 1 + (MATCH (post_title) AGAINST ('csd dealers 2018 deoghar deoli deoria')) * 1 + COUNT(DISTINCT IF( terms.term_taxonomy_id IN (539), terms.term_taxonomy_id, null )) * 1 + COUNT(DISTINCT IF( terms.term_taxonomy_id IN (543,818,839,840,841), terms.term_taxonomy_id, null )) * 1,4) AS score FROM wp_posts left join wp_term_relationships as terms on ( terms.object_id = wp_posts.ID ) WHERE post_status IN ( 'publish', 'static' ) AND post_password ='' AND post_date > date_sub(now(), INTERVAL 12 month) AND post_type IN ('post') AND wp_posts.ID NOT IN (23455) GROUP BY ID HAVING score >= 4.000000 AND ID != 0 ORDER BY score DESC LIMIT 6 on duplicate key update date = now()