SELECT SQL_CALC_FOUND_ROWS A.*,(case when A.paid_exp>CURDATE() then 1 else 0 end) cur_paid, B.cname,B.id as cat_id, C.iname, D.logo,D.name,D.login_type,D.seo_url,MATCH (A.title) AGAINST ('"strategic planning and intelligence"') as Relevance FROM vacancies A LEFT JOIN category B ON A.category_id = B.id LEFT JOIN industry C ON A.industry_id = C.id LEFT JOIN recruiters D ON A.recruiters_id = D.id WHERE ((MATCH (A.search_title,A.description,A.title) AGAINST ('"strategic planning and intelligence"' IN BOOLEAN MODE) OR A.search_title LIKE '%strategic planning and intelligence%') OR A.category_id IN (611) ) AND ( A.country IN ('England','Scotland','Northern Ireland','Wales') OR A.country='' OR A.country='United Kingdom') AND (A.date_expired>=NOW() OR date_expired='' OR date_expired='0000-00-00 00:00:00') GROUP BY title,city,county,category_id ORDER BY (case when paid_exp>CURDATE() then 1 else 0 end) desc, Relevance DESC,A.title='"strategic planning and intelligence"', A.date_posted DESC LIMIT 0, 21<br>FTS query exceeds result cache limit