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 'm sure you'll find this <strong>keyboard shortcut useful which will re-open tabs' at line 1]
SELECT ID, post_title, post_date, post_content, (MATCH (post_content) AGAINST ('if you use <strong>firefox</strong> then i'm sure you'll find this <strong>keyboard shortcut useful which will re-open tabs</strong> that have been closed. many of you know that you can open a new firefox tab by using the 'ctrl+t' keyboard shortcut, and 'ctrl+w' to close a tab. but did you know you can re-open old tabs by using 'ctrl+shift+t'? very handy if you are like me and you prefer using a keyboard to a mouse.')) as bodyscore, (MATCH (post_title) AGAINST ('useful firefox shortcut to reopen old tabs')) as titlescore, COUNT( DISTINCT tagtax.term_taxonomy_id ) as tagscore, COUNT( DISTINCT cattax.term_taxonomy_id ) as catscore, (0+ (MATCH (post_content) AGAINST ('if you use <strong>firefox</strong> then i'm sure you'll find this <strong>keyboard shortcut useful which will re-open tabs</strong> that have been closed. many of you know that you can open a new firefox tab by using the 'ctrl+t' keyboard shortcut, and 'ctrl+w' to close a tab. but did you know you can re-open old tabs by using 'ctrl+shift+t'? very handy if you are like me and you prefer using a keyboard to a mouse.')) * 3+ (MATCH (post_title) AGAINST ('useful firefox shortcut to reopen old tabs')) * 3+ 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 = 399 ) 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 = 399 ) 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 != '399') and post_password ='' and post_type IN ('post', 'page') group by id having score >= 8 order by score DESC limit 6