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 ('"do not hesitate to contact me for further information his employment history 012001 122011 graphic designerprinter d impresion san juan spain 012008 122011 draughtsman graphic designer parnaso levantino construccion"') 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 ('"do not hesitate to contact me for further information his employment history 012001 122011 graphic designerprinter d impresion san juan spain 012008 122011 draughtsman graphic designer parnaso levantino construccion"' 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, ' ', '' ), '+', '' ) , '-', '' ) , '/', '' ) , ',', '' ) , '\'', '' ) , '"', '' ) , ';', '' ) , ':', '' ) , '.', '' ) , '_', '' ) , '*', '' ) , '&', '' ) , '^', '' ) , '%', '' ) , '$', '' ) , '#', '' ) , '@', '' ) , '!', '' ) , '''', '' ), '(',''), ')',''), ' ',' '))='do not hesitate to contact me for further information his employment history 012001 122011 graphic designerprinter d impresion san juan spain 012008 122011 draughtsman graphic designer parnaso levantino construccion' 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, ' ', '' ), '+', '' ) , '-', '' ) , '/', '' ) , ',', '' ) , '\'', '' ) , '"', '' ) , ';', '' ) , ':', '' ) , '.', '' ) , '_', '' ) , '*', '' ) , '&', '' ) , '^', '' ) , '%', '' ) , '$', '' ) , '#', '' ) , '@', '' ) , '!', '' ) , '''', '' ), '(',''), ')',''), ' ',' '))='do not hesitate to contact me for further information his employment history 012001 122011 graphic designerprinter d impresion san juan spain 012008 122011 draughtsman graphic designer parnaso levantino construccion' 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, ' ', '' ), '+', '' ) , '-', '' ) , '/', '' ) , ',', '' ) , '\'', '' ) , '"', '' ) , ';', '' ) , ':', '' ) , '.', '' ) , '_', '' ) , '*', '' ) , '&', '' ) , '^', '' ) , '%', '' ) , '$', '' ) , '#', '' ) , '@', '' ) , '!', '' ) , '''', '' ), '(',''), ')',''), ' ',' '))='do not hesitate to contact me for further information his employment history 012001 122011 graphic designerprinter d impresion san juan spain 012008 122011 draughtsman graphic designer parnaso levantino construccion') 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='"do not hesitate to contact me for further information his employment history 012001 122011 graphic designerprinter d impresion san juan spain 012008 122011 draughtsman graphic designer parnaso levantino construccion"', A.date_posted DESC LIMIT 0, 21<br>Incorrect arguments to MATCH