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 'a-la-digg', with the top content being promoted to the homepage. one feature t' at line 1]
SELECT ID, post_title, post_date, post_content, (MATCH (post_content) AGAINST ('<a href="http://www.famesource.com" title="famesource"><img src="http://www.connectedinternet.co.uk/wp-content/uploads/logo_beta.gif" title="famesource" alt="famesource" width="180" /></a> i just got contacted by allen vartazarian the ceo of <strong><a href="http://www.famesource.com/default.aspx" title="famesource.com" target="_blank">famesource.com</a></strong>, a new website which is still in beta which provides a platform for talented individuals to showcase their talent. categories include music, acting, sports, comedy, modeling, dance, and other. <!--more-->the free portal allows users to upload videos, images, and audio for visitors to vote on 'a-la-digg', with the top content being promoted to the homepage. one feature that i think could cause problems though is that users can buy their 'fame' using 'famebucks', a pseudo-currency that is purchased with real money that allows users to buy certain slots on the site to gain exposure. all that would be needed is for a few record companies to out-bid normal individuals to totally ruin the system. i think the site could become an interesting destination site for individuals who just want to be entertained, but also for people in the performing industries looking for new talent. the site is still a bit light on content and has been seeded with content to get it going, including my favourite breakdancing video. everytime i watch it i can't believe how strong he is or his balance, and how on earth his back doesn't break! <p align="center"><video>http://www.youtube.com/watch?v=fo3ehyty1g0</video></p> one to watch i think. i wonder how long it will be before someone is 'discovered' on famesource?')) as bodyscore, (MATCH (post_title) AGAINST ('famesource.com - when will i be famous?')) as titlescore, COUNT( DISTINCT tagtax.term_taxonomy_id ) as tagscore, COUNT( DISTINCT cattax.term_taxonomy_id ) as catscore, (0+ (MATCH (post_content) AGAINST ('<a href="http://www.famesource.com" title="famesource"><img src="http://www.connectedinternet.co.uk/wp-content/uploads/logo_beta.gif" title="famesource" alt="famesource" width="180" /></a> i just got contacted by allen vartazarian the ceo of <strong><a href="http://www.famesource.com/default.aspx" title="famesource.com" target="_blank">famesource.com</a></strong>, a new website which is still in beta which provides a platform for talented individuals to showcase their talent. categories include music, acting, sports, comedy, modeling, dance, and other. <!--more-->the free portal allows users to upload videos, images, and audio for visitors to vote on 'a-la-digg', with the top content being promoted to the homepage. one feature that i think could cause problems though is that users can buy their 'fame' using 'famebucks', a pseudo-currency that is purchased with real money that allows users to buy certain slots on the site to gain exposure. all that would be needed is for a few record companies to out-bid normal individuals to totally ruin the system. i think the site could become an interesting destination site for individuals who just want to be entertained, but also for people in the performing industries looking for new talent. the site is still a bit light on content and has been seeded with content to get it going, including my favourite breakdancing video. everytime i watch it i can't believe how strong he is or his balance, and how on earth his back doesn't break! <p align="center"><video>http://www.youtube.com/watch?v=fo3ehyty1g0</video></p> one to watch i think. i wonder how long it will be before someone is 'discovered' on famesource?')) * 1+ (MATCH (post_title) AGAINST ('famesource.com - when will i be famous?')) * 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 = 1856 ) 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 = 1856 ) 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 != '1856') and post_password ='' and post_type IN ('post', 'page') group by id having score >= 6 order by score DESC limit 7