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 guessing that it took at least a day to put together, maybe longer. i hope yo' at line 1]
SELECT ID, post_title, post_date, post_content, (MATCH (post_content) AGAINST ('this video is worth watching just to appreciate the amount of effort put into creating it. it also happens to be pretty cool. i'm guessing that it took at least a day to put together, maybe longer. i hope youtube launch a way soon for publishers to get paid for thier hard work. i don't think i could ever work in animation as i don't think i have the staying power to spend days just to produce a few minutes of footage. <!--more--> <p align="center"><video>http://www.youtube.com/watch?v=cyvlg--1vv0</video></p>')) as bodyscore, (MATCH (post_title) AGAINST ('friday fun: cool slo-mo video')) as titlescore, COUNT( DISTINCT tagtax.term_taxonomy_id ) as tagscore, COUNT( DISTINCT cattax.term_taxonomy_id ) as catscore, (0+ (MATCH (post_content) AGAINST ('this video is worth watching just to appreciate the amount of effort put into creating it. it also happens to be pretty cool. i'm guessing that it took at least a day to put together, maybe longer. i hope youtube launch a way soon for publishers to get paid for thier hard work. i don't think i could ever work in animation as i don't think i have the staying power to spend days just to produce a few minutes of footage. <!--more--> <p align="center"><video>http://www.youtube.com/watch?v=cyvlg--1vv0</video></p>')) * 1+ (MATCH (post_title) AGAINST ('friday fun: cool slo-mo video')) * 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 = 2000 ) 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 = 2000 ) 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 != '2000') and post_password ='' and post_type IN ('post', 'page') group by id having score >= 6 order by score DESC limit 7