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 tip was sent in by al from <a href="http://vistarewired.com/" title="vistarewi' at line 1]
SELECT ID, post_title, post_date, post_content, (MATCH (post_content) AGAINST ('today's tip was sent in by al from <a href="http://vistarewired.com/" title="vistarewired" target="_blank">vistarewired</a>. al has put together a list of <a href="http://vistarewired.com/2007/03/14/10-things-you-wished-you-had-known-about-vista/" style="font-weight: bold" title="ten tips and tricks every vista user should know" target="_blank">ten tips and tricks every vista user should know</a>. although some of these aren't strictly 'tips' they do provide interesting information. for instance, i finally discovered why my memory utilization is always high even though i have 4gb of memory. below are the ten vista tips &amp; tricks: <!--more-->1. <a href="http://vistarewired.com/2007/03/15/bypass-windows-activation/">delay vista activation for at least a year </a> 2. <a href="http://vistarewired.com/2007/02/15/defragment-10x-faster-than-normal/">what to do when windows defragment tool hangs or takes forever</a> 3. <a href="http://vistarewired.com/2007/03/08/dreamscene-on-any-computer">get video wallpapers (dreamscene effect) without getting vista ultimate</a> 4. <a href="http://vistarewired.com/2007/03/03/how-to-create-icons-without-text/">create icons without text </a> 5. <a href="http://www.speedyvista.com/services.html" onclick="javascript:urchintracker ('/outbound/article/www.speedyvista.com');" target="_blank">disable useless services from a list of every vista service that ever existed</a> 6. <a href="http://www.jjmelo.com/blog/archives/24" onclick="javascript:urchintracker ('/outbound/article/www.jjmelo.com');" target="_blank">how to build a powerful and cheap vista pc (around $500)</a> 7. <a href="http://hevnikov.com/blog/2006/11/13/triple-boot-xp-vista-ubuntu-with-single-boot-screen/" onclick="javascript:urchintracker ('/outbound/article/hevnikov.com');" target="_blank">how to triple boot (xp, vista, ubuntu)</a> 8. <a href="http://vistarewired.com/2007/02/16/how-to-resize-a-partition-in-windows-vista/">resize your windows partition for free</a> 9. <a href="http://vistarewired.com/2007/02/28/perform-a-clean-install-with-a-vista-upgrade-disc/">perform a clean install with a vista upgrade disk</a> 10. <a href="http://vistarewired.com/2007/03/01/convert-web-widgets-videos-flash-games-into-sidebar-gadgets/">convert web widgets, videos, and games into sidebar gadgets </a>')) as bodyscore, (MATCH (post_title) AGAINST ('ten tips and tricks every vista user should know')) as titlescore, COUNT( DISTINCT tagtax.term_taxonomy_id ) as tagscore, COUNT( DISTINCT cattax.term_taxonomy_id ) as catscore, (0+ (MATCH (post_content) AGAINST ('today's tip was sent in by al from <a href="http://vistarewired.com/" title="vistarewired" target="_blank">vistarewired</a>. al has put together a list of <a href="http://vistarewired.com/2007/03/14/10-things-you-wished-you-had-known-about-vista/" style="font-weight: bold" title="ten tips and tricks every vista user should know" target="_blank">ten tips and tricks every vista user should know</a>. although some of these aren't strictly 'tips' they do provide interesting information. for instance, i finally discovered why my memory utilization is always high even though i have 4gb of memory. below are the ten vista tips &amp; tricks: <!--more-->1. <a href="http://vistarewired.com/2007/03/15/bypass-windows-activation/">delay vista activation for at least a year </a> 2. <a href="http://vistarewired.com/2007/02/15/defragment-10x-faster-than-normal/">what to do when windows defragment tool hangs or takes forever</a> 3. <a href="http://vistarewired.com/2007/03/08/dreamscene-on-any-computer">get video wallpapers (dreamscene effect) without getting vista ultimate</a> 4. <a href="http://vistarewired.com/2007/03/03/how-to-create-icons-without-text/">create icons without text </a> 5. <a href="http://www.speedyvista.com/services.html" onclick="javascript:urchintracker ('/outbound/article/www.speedyvista.com');" target="_blank">disable useless services from a list of every vista service that ever existed</a> 6. <a href="http://www.jjmelo.com/blog/archives/24" onclick="javascript:urchintracker ('/outbound/article/www.jjmelo.com');" target="_blank">how to build a powerful and cheap vista pc (around $500)</a> 7. <a href="http://hevnikov.com/blog/2006/11/13/triple-boot-xp-vista-ubuntu-with-single-boot-screen/" onclick="javascript:urchintracker ('/outbound/article/hevnikov.com');" target="_blank">how to triple boot (xp, vista, ubuntu)</a> 8. <a href="http://vistarewired.com/2007/02/16/how-to-resize-a-partition-in-windows-vista/">resize your windows partition for free</a> 9. <a href="http://vistarewired.com/2007/02/28/perform-a-clean-install-with-a-vista-upgrade-disc/">perform a clean install with a vista upgrade disk</a> 10. <a href="http://vistarewired.com/2007/03/01/convert-web-widgets-videos-flash-games-into-sidebar-gadgets/">convert web widgets, videos, and games into sidebar gadgets </a>')) * 3+ (MATCH (post_title) AGAINST ('ten tips and tricks every vista user should know')) * 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 = 300 ) 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 = 300 ) 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 != '300') and post_password ='' and post_type IN ('post', 'page') group by id having score >= 8 order by score DESC limit 6