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 ('"customer support and client care"') 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 ('"customer support and client care"' IN BOOLEAN MODE) OR A.search_title LIKE '%customer support and client care%') OR A.category_id IN (623,624,625,626,627,628,629,630,631,632,982,983,984,985,1101) ) 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='"customer support and client care"', A.date_posted DESC LIMIT 0, 21<br>FTS query exceeds result cache limit