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 family solicitor rare opportunity september start "') 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 family solicitor rare opportunity september start "' 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 family solicitor rare opportunity september start "', A.date_posted DESC LIMIT 0, 21<br>Incorrect arguments to MATCH