WordPress database error: [You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 've just found the hack and fixed it.  i would like to apologise to anyone who h' at line 1]
SELECT ID, post_title, post_date, post_content, (MATCH (post_content) AGAINST ('anyone who has tried to use connected internet over the last couple of days will have noticed that all pages were being redirected to a dodgy site.  we've just found the hack and fixed it.  i would like to apologise to anyone who has been affected by the hack. what actually happened was someone logged in using my password and changed some settings and key files.  i've learnt a lesson here as whenever i've had somebody working on my site i've given them my details, rather than creating a temporary account.  even though i have a pretty good idea who did this, i can't prove it, although i have their ip address, so i might get lucky.')) as bodyscore, (MATCH (post_title) AGAINST ('apologies to anyone who suffered from my site getting hacked')) as titlescore, COUNT( DISTINCT tagtax.term_taxonomy_id ) as tagscore, COUNT( DISTINCT cattax.term_taxonomy_id ) as catscore, (0+ (MATCH (post_content) AGAINST ('anyone who has tried to use connected internet over the last couple of days will have noticed that all pages were being redirected to a dodgy site.  we've just found the hack and fixed it.  i would like to apologise to anyone who has been affected by the hack. what actually happened was someone logged in using my password and changed some settings and key files.  i've learnt a lesson here as whenever i've had somebody working on my site i've given them my details, rather than creating a temporary account.  even though i have a pretty good idea who did this, i can't prove it, although i have their ip address, so i might get lucky.')) * 1+ (MATCH (post_title) AGAINST ('apologies to anyone who suffered from my site getting hacked')) * 1+ COUNT( DISTINCT tagtax.term_taxonomy_id ) * 1+ COUNT( DISTINCT cattax.term_taxonomy_id ) * 1) as score from wp_posts left JOIN wp_term_relationships AS thistag ON (thistag.object_id = 4083 ) left JOIN wp_term_relationships AS tagrel on (tagrel.term_taxonomy_id = thistag.term_taxonomy_id AND tagrel.object_id = wp_posts.ID) left JOIN wp_term_taxonomy AS tagtax ON ( tagrel.term_taxonomy_id = tagtax.term_taxonomy_id AND tagtax.taxonomy = 'post_tag') left JOIN wp_term_relationships AS thiscat ON (thiscat.object_id = 4083 ) left JOIN wp_term_relationships AS catrel on (catrel.term_taxonomy_id = thiscat.term_taxonomy_id AND catrel.object_id = wp_posts.ID) left JOIN wp_term_taxonomy AS cattax ON ( catrel.term_taxonomy_id = cattax.term_taxonomy_id AND cattax.taxonomy = 'category') where (post_status IN ( 'publish', 'static' ) and ID != '4083') and post_password ='' and post_type IN ('post', 'page') group by id having score >= 6 order by score DESC limit 7