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 're looking for even more free tv sites then this <strong><a href="http://www.one' at line 1]
SELECT ID, post_title, post_date, post_content, (MATCH (post_content) AGAINST ('watching tv online is getting easier and easier with the launch of cool services like <a href="http://www.connectedinternet.co.uk/2006/11/27/watch-more-free-tv-online-tvlinks/" title="tvlinks"><strong>tvlinks</strong></a>, <a href="http://www.connectedinternet.co.uk/2005/12/19/watch-free-tv-with-your-pc/" title="pplive"><strong>pplive</strong></a> and <a href="http://www.connectedinternet.co.uk/2007/01/10/i-have-4-invites-for-tape-it-off-the-internet-tioti-to-share-with-readers/" title="tape it off the internet"><strong>tape it off the internet</strong></a>.if you're looking for even more free tv sites then this <strong><a href="http://www.onetipaday.com/2007/02/14/updated-list-of-places-to-watch-tv-for-free-online/" title="list of free tv sites" target="_blank">list of free tv sites from onetipaday.com</a></strong> is the largest i've come across. <strike><a href="http://tech.cybernetnews.com/2007/01/26/cybernotes-watch-all-your-favorite-tv-shows-music-and-videos-with-peekvid/" title="ryan on peekvid" target="_blank">ryan</a></strike> ashley from cybernotes has featured another great free online tv service called <strong>peekvid</strong>,a website with over 20,000 movies, tv shows, cartoons, and the like. it looks like it aggregates videos from youtube and dailymotion, and just makes it a more organized index of the popular, most wanted selections. there are definitely some legal issues here, like copyright infringement, but we’ll get to that later. if you do want to try out peekvid, then ryan has even very kindly put together a selection of the free videos and tv shows that are available on peekvid: <!--more--> <ul> <li>borat (6 videos): <a href="http://movies.peekvid.com/s4059/" onclick="javascript:urchintracker ('/outgoing/movies.peekvid.com/s4059/');">http://movies.peekvid.com/s4059/</a></li> <li>deja vu (12 videos): <a href="http://movies.peekvid.com/s4074/" onclick="javascript:urchintracker ('/outgoing/movies.peekvid.com/s4074/');">http://movies.peekvid.com/s4074/</a></li> <li>children of men (3 videos): <a href="http://movies.peekvid.com/s4065/" onclick="javascript:urchintracker ('/outgoing/movies.peekvid.com/s4065/');">http://movies.peekvid.com/s4065/</a></li> <li>the pursuit of happyness (6 videos):<a href="http://movies.peekvid.com/s4141/" onclick="javascript:urchintracker ('/outgoing/movies.peekvid.com/s4141/');">http://movies.peekvid.com/s4141/</a></li> <li>night at the museum (4 videos): <a href="http://movies.peekvid.com/s4196/" onclick="javascript:urchintracker ('/outgoing/movies.peekvid.com/s4196/');">http://movies.peekvid.com/s4196/</a></li> <li>stomp the yard (4 videos): <a href="http://movies.peekvid.com/s4313/" onclick="javascript:urchintracker ('/outgoing/movies.peekvid.com/s4313/');">http://movies.peekvid.com/s4313/</a></li> <li>we are marshall (2 videos): <a href="http://movies.peekvid.com/s4024/" onclick="javascript:urchintracker ('/outgoing/movies.peekvid.com/s4024/');">http://movies.peekvid.com/s4024/</a></li> </ul> i'm not condoning copyright piracy, but i really can't blame the millions of users who are downloading illegal content everyday. it's no longer just about getting stuff for free, it's about convienience. why wait months for the content you want to become available, only to find that you can't play it on your chosen device? if the media companies got their act together and were as innovative and forward thinking as people like <a href="http://www.connectedinternet.co.uk/tag/tioti" title="tape it off the internet">tioti</a>, <a href="http://www.connectedinternet.co.uk/2006/11/27/1108/" title="tvlinks">tvlinks</a> and now peekvid the piracy problem wouldn't be as bad. more: <a href="http://www.peekvid.com/" title="peekvid" target="_blank">peekvid</a>')) as bodyscore, (MATCH (post_title) AGAINST ('peekvid: watch more free tv shows, music and videos online')) as titlescore, COUNT( DISTINCT tagtax.term_taxonomy_id ) as tagscore, COUNT( DISTINCT cattax.term_taxonomy_id ) as catscore, (0+ (MATCH (post_content) AGAINST ('watching tv online is getting easier and easier with the launch of cool services like <a href="http://www.connectedinternet.co.uk/2006/11/27/watch-more-free-tv-online-tvlinks/" title="tvlinks"><strong>tvlinks</strong></a>, <a href="http://www.connectedinternet.co.uk/2005/12/19/watch-free-tv-with-your-pc/" title="pplive"><strong>pplive</strong></a> and <a href="http://www.connectedinternet.co.uk/2007/01/10/i-have-4-invites-for-tape-it-off-the-internet-tioti-to-share-with-readers/" title="tape it off the internet"><strong>tape it off the internet</strong></a>.if you're looking for even more free tv sites then this <strong><a href="http://www.onetipaday.com/2007/02/14/updated-list-of-places-to-watch-tv-for-free-online/" title="list of free tv sites" target="_blank">list of free tv sites from onetipaday.com</a></strong> is the largest i've come across. <strike><a href="http://tech.cybernetnews.com/2007/01/26/cybernotes-watch-all-your-favorite-tv-shows-music-and-videos-with-peekvid/" title="ryan on peekvid" target="_blank">ryan</a></strike> ashley from cybernotes has featured another great free online tv service called <strong>peekvid</strong>,a website with over 20,000 movies, tv shows, cartoons, and the like. it looks like it aggregates videos from youtube and dailymotion, and just makes it a more organized index of the popular, most wanted selections. there are definitely some legal issues here, like copyright infringement, but we’ll get to that later. if you do want to try out peekvid, then ryan has even very kindly put together a selection of the free videos and tv shows that are available on peekvid: <!--more--> <ul> <li>borat (6 videos): <a href="http://movies.peekvid.com/s4059/" onclick="javascript:urchintracker ('/outgoing/movies.peekvid.com/s4059/');">http://movies.peekvid.com/s4059/</a></li> <li>deja vu (12 videos): <a href="http://movies.peekvid.com/s4074/" onclick="javascript:urchintracker ('/outgoing/movies.peekvid.com/s4074/');">http://movies.peekvid.com/s4074/</a></li> <li>children of men (3 videos): <a href="http://movies.peekvid.com/s4065/" onclick="javascript:urchintracker ('/outgoing/movies.peekvid.com/s4065/');">http://movies.peekvid.com/s4065/</a></li> <li>the pursuit of happyness (6 videos):<a href="http://movies.peekvid.com/s4141/" onclick="javascript:urchintracker ('/outgoing/movies.peekvid.com/s4141/');">http://movies.peekvid.com/s4141/</a></li> <li>night at the museum (4 videos): <a href="http://movies.peekvid.com/s4196/" onclick="javascript:urchintracker ('/outgoing/movies.peekvid.com/s4196/');">http://movies.peekvid.com/s4196/</a></li> <li>stomp the yard (4 videos): <a href="http://movies.peekvid.com/s4313/" onclick="javascript:urchintracker ('/outgoing/movies.peekvid.com/s4313/');">http://movies.peekvid.com/s4313/</a></li> <li>we are marshall (2 videos): <a href="http://movies.peekvid.com/s4024/" onclick="javascript:urchintracker ('/outgoing/movies.peekvid.com/s4024/');">http://movies.peekvid.com/s4024/</a></li> </ul> i'm not condoning copyright piracy, but i really can't blame the millions of users who are downloading illegal content everyday. it's no longer just about getting stuff for free, it's about convienience. why wait months for the content you want to become available, only to find that you can't play it on your chosen device? if the media companies got their act together and were as innovative and forward thinking as people like <a href="http://www.connectedinternet.co.uk/tag/tioti" title="tape it off the internet">tioti</a>, <a href="http://www.connectedinternet.co.uk/2006/11/27/1108/" title="tvlinks">tvlinks</a> and now peekvid the piracy problem wouldn't be as bad. more: <a href="http://www.peekvid.com/" title="peekvid" target="_blank">peekvid</a>')) * 1+ (MATCH (post_title) AGAINST ('peekvid: watch more free tv shows, music and videos online')) * 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 = 1388 ) 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 = 1388 ) 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 != '1388') and post_password ='' and post_type IN ('post', 'page') group by id having score >= 6 order by score DESC limit 7