SELECT SQL_CALC_FOUND_ROWS A.*,(case when A.paid_exp>CURDATE() then 1 else 0 end) cur_paid, B.cname, as cat_id, C.iname, D.logo,,D.login_type,D.seo_url,MATCH (A.title) AGAINST ('"consulting civil engineer"') as Relevance FROM vacancies A LEFT JOIN category B ON A.category_id = LEFT JOIN industry C ON A.industry_id = LEFT JOIN recruiters D ON A.recruiters_id = WHERE MATCH (A.search_title,B.cname,B.cpath,A.description) AGAINST ('"consulting civil engineer"' IN BOOLEAN MODE) AND ( IN ('England','Scotland','Northern Ireland','Wales') OR'' OR'United Kingdom') AND (A.date_expired>=NOW() AND A.date_posted>= CURDATE()-30) GROUP BY title,city,county,category_id ORDER BY (case when paid_exp>CURDATE() then 1 else 0 end) desc, Relevance DESC,A.title='"consulting civil engineer"', A.date_posted DESC LIMIT 0, 21
Incorrect arguments to MATCH