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 't think that serenity was that interesting, although i've never watched the fire' at line 1]
SELECT ID, post_title, post_date, post_content, (MATCH (post_content) AGAINST ('i was stunned to read that serenity won the poll of 3,000 sfx magazine readers as the best sci-fi movie of all time, receiving 61% of the vote. star wars was pushed into second place and blade runner came third. i didn't think that serenity was that interesting, although i've never watched the firefly tv series so maybe parts of the film were lost on me. here's the full top ten: <!--more--> <ol> <li>serenity</li> <li>star wars</li> <li>blade runner</li> <li>planet of the apes</li> <li>the matrix</li> <li>alien</li> <li>forbidden planet</li> <li>2001: a space odyssey</li> <li>the terminator</li> <li>back to the future</li> </ol> any major omissions?')) as bodyscore, (MATCH (post_title) AGAINST ('serenity named top sci-fi movie')) as titlescore, COUNT( DISTINCT tagtax.term_taxonomy_id ) as tagscore, COUNT( DISTINCT cattax.term_taxonomy_id ) as catscore, (0+ (MATCH (post_content) AGAINST ('i was stunned to read that serenity won the poll of 3,000 sfx magazine readers as the best sci-fi movie of all time, receiving 61% of the vote. star wars was pushed into second place and blade runner came third. i didn't think that serenity was that interesting, although i've never watched the firefly tv series so maybe parts of the film were lost on me. here's the full top ten: <!--more--> <ol> <li>serenity</li> <li>star wars</li> <li>blade runner</li> <li>planet of the apes</li> <li>the matrix</li> <li>alien</li> <li>forbidden planet</li> <li>2001: a space odyssey</li> <li>the terminator</li> <li>back to the future</li> </ol> any major omissions?')) * 1+ (MATCH (post_title) AGAINST ('serenity named top sci-fi movie')) * 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 = 1879 ) 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 = 1879 ) 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 != '1879') and post_password ='' and post_type IN ('post', 'page') group by id having score >= 6 order by score DESC limit 7