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 ('"junior sales executive materials handling 21k 15 bonus"') 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,B.cname,B.cpath,A.description) AGAINST ('"junior sales executive materials handling 21k 15 bonus"' IN BOOLEAN MODE) AND (trim(replace(replace(replace(replace( replace( replace( replace( replace( replace( replace( replace( replace( replace( replace( replace( replace( replace( replace( replace( replace( replace( replace( replace(A.city, ' ', '' ), '+', '' ) , '-', '' ) , '/', '' ) , ',', '' ) , '\'', '' ) , '"', '' ) , ';', '' ) , ':', '' ) , '.', '' ) , '_', '' ) , '*', '' ) , '&', '' ) , '^', '' ) , '%', '' ) , '$', '' ) , '#', '' ) , '@', '' ) , '!', '' ) , '''', '' ), '(',''), ')',''), ' ',' '))='javascriptvoid0' OR trim(replace(replace(replace(replace( replace( replace( replace( replace( replace( replace( replace( replace( replace( replace( replace( replace( replace( replace( replace( replace( replace( replace( replace(A.county, ' ', '' ), '+', '' ) , '-', '' ) , '/', '' ) , ',', '' ) , '\'', '' ) , '"', '' ) , ';', '' ) , ':', '' ) , '.', '' ) , '_', '' ) , '*', '' ) , '&', '' ) , '^', '' ) , '%', '' ) , '$', '' ) , '#', '' ) , '@', '' ) , '!', '' ) , '''', '' ), '(',''), ')',''), ' ',' '))='javascriptvoid0' OR trim(replace(replace(replace(replace( replace( replace( replace( replace( replace( replace( replace( replace( replace( replace( replace( replace( replace( replace( replace( replace( replace( replace( replace(A.region, ' ', '' ), '+', '' ) , '-', '' ) , '/', '' ) , ',', '' ) , '\'', '' ) , '"', '' ) , ';', '' ) , ':', '' ) , '.', '' ) , '_', '' ) , '*', '' ) , '&', '' ) , '^', '' ) , '%', '' ) , '$', '' ) , '#', '' ) , '@', '' ) , '!', '' ) , '''', '' ), '(',''), ')',''), ' ',' '))='javascriptvoid0') AND ( A.country IN ('England','Scotland','Northern Ireland','Wales') OR A.country='' OR A.country='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='"junior sales executive materials handling 21k 15 bonus"', A.date_posted DESC LIMIT 0, 21<br>Incorrect arguments to MATCH