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 accounts assistant finance assistant sales admin"') 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 accounts assistant finance assistant sales admin"' 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 accounts assistant finance assistant sales admin"', A.date_posted DESC LIMIT 0, 21<br>Incorrect arguments to MATCH