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 's site and the times, but for a so-called quality broadsheet (i think it's the o' at line 1]
SELECT ID, post_title, post_date, post_content, (MATCH (post_content) AGAINST ('my real introduction to the internet began in 1997 when i got transferred to the us. although we had one pc (!!) in the london office of my firm that was connected to the internet, nobody really knew what it was for. just after i got to the us office they got a t1 line installed which seemed unbelievably fast back then, and every pc had net access. i quickly figured out that i could use the internet to stay in touch with what was happening back home, with sites like <strong><a href="http://www.timesonline.co.uk/tol/news" title="the times" target="_blank">the times</a> </strong> and <strong><a href="http://news.bbc.co.uk/" title="bbc news" target="_blank">the bbc</a></strong>. i could even watch all the weekends football goals on rete.com, which sadly got shut down a few years ago. <!--more-->i still use the bbc's site and the times, but for a so-called quality broadsheet (i think it's the oldest newspaper still in circulation), the times has the worst online ads policy ever. i have never seen a site use so many popups, pop-unders, flash etc ads. everytime i visit a new page i always worry about what crap is suddenly going to appear that i have to watch before i can read the stories. which site that you read regularly do you think has the worst ad policy? i can tell what's the best ad i've ever seen though. if you quickly head on over to <a href="http://www.engadget.com/" title="engadget" target="_blank">engadget</a>, they've got an amazing apple ipod campaign running at the moment where the dancers somehow manage to leave the banner space and dance on the rest of the page!')) as bodyscore, (MATCH (post_title) AGAINST ('which mainstream site has the worst adverts?')) as titlescore, COUNT( DISTINCT tagtax.term_taxonomy_id ) as tagscore, COUNT( DISTINCT cattax.term_taxonomy_id ) as catscore, (0+ (MATCH (post_content) AGAINST ('my real introduction to the internet began in 1997 when i got transferred to the us. although we had one pc (!!) in the london office of my firm that was connected to the internet, nobody really knew what it was for. just after i got to the us office they got a t1 line installed which seemed unbelievably fast back then, and every pc had net access. i quickly figured out that i could use the internet to stay in touch with what was happening back home, with sites like <strong><a href="http://www.timesonline.co.uk/tol/news" title="the times" target="_blank">the times</a> </strong> and <strong><a href="http://news.bbc.co.uk/" title="bbc news" target="_blank">the bbc</a></strong>. i could even watch all the weekends football goals on rete.com, which sadly got shut down a few years ago. <!--more-->i still use the bbc's site and the times, but for a so-called quality broadsheet (i think it's the oldest newspaper still in circulation), the times has the worst online ads policy ever. i have never seen a site use so many popups, pop-unders, flash etc ads. everytime i visit a new page i always worry about what crap is suddenly going to appear that i have to watch before i can read the stories. which site that you read regularly do you think has the worst ad policy? i can tell what's the best ad i've ever seen though. if you quickly head on over to <a href="http://www.engadget.com/" title="engadget" target="_blank">engadget</a>, they've got an amazing apple ipod campaign running at the moment where the dancers somehow manage to leave the banner space and dance on the rest of the page!')) * 1+ (MATCH (post_title) AGAINST ('which mainstream site has the worst adverts?')) * 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 = 2169 ) 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 = 2169 ) 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 != '2169') and post_password ='' and post_type IN ('post', 'page') group by id having score >= 6 order by score DESC limit 7