Addressing Duplicate Content: Part 2
Posted by Guru as Linking, Marketing and Search Optimization, SEO Features, TipsWordPress database error: [Table 'blogtut_tutordb.wp_yarpp_related_cache' doesn't exist]
select min(ID) as min_id from wp_yarpp_related_cache where reference_ID = 393
WordPress database error: [Table 'blogtut_tutordb.wp_yarpp_related_cache' doesn't exist]
select distinct ID from wp_yarpp_related_cache where reference_ID = 393 and ID != 0
WordPress database error: [Table 'blogtut_tutordb.wp_yarpp_related_cache' doesn't exist]
delete from wp_yarpp_related_cache where reference_ID = 393
WordPress database error: [Table 'blogtut_tutordb.wp_yarpp_keyword_cache' doesn't exist]
delete from wp_yarpp_keyword_cache where ID = 393
WordPress database error: [Table 'blogtut_tutordb.wp_yarpp_keyword_cache' doesn't exist]
select body, title from wp_yarpp_keyword_cache where ID = 393
WordPress database error: [Table 'blogtut_tutordb.wp_yarpp_keyword_cache' doesn't exist]
insert into wp_yarpp_keyword_cache (ID,body,title) values (393,'www http com the blog tutorials category to features use content louisvuitton same for seo index that sony flash buy ','part content duplicate addressing ') on duplicate key update date = now(), body = 'www http com the blog tutorials category to features use content louisvuitton same for seo index that sony flash buy ', title = 'part content duplicate addressing '
WordPress database error: [Table 'blogtut_tutordb.wp_yarpp_related_cache' doesn't exist]
insert into wp_yarpp_related_cache (reference_ID,ID,score) (SELECT 393 as reference_ID, ID, ROUND(0 + (MATCH (post_content) AGAINST ('www http com the blog tutorials category to features use content louisvuitton same for seo index that sony flash buy')) * 1 + (MATCH (post_title) AGAINST ('part content duplicate addressing')) * 1 + count(distinct if( termtax.taxonomy = 'category', refterms.term_taxonomy_id, null )) + count(distinct if( termtax.taxonomy = 'post_tag', refterms.term_taxonomy_id, null )),1) as score
from wp_posts
left join wp_term_relationships as terms on ( terms.object_id = wp_posts.ID )
left join wp_term_taxonomy as termtax on ( terms.term_taxonomy_id = termtax.term_taxonomy_id )
left join wp_term_relationships as refterms on ( terms.term_taxonomy_id = refterms.term_taxonomy_id and refterms.object_id = 393 )
where post_status in ( 'publish', 'static' ) and ID != '393' and post_date <= '2007-09-30 09:16:47' and post_password ='' and post_type = 'post'
group by ID
having score >= 5.00 and bit_or(termtax.term_id in (0)) = 0 order by score desc limit 5) union (SELECT 393 as reference_ID, ID, ROUND(0 + (MATCH (post_content) AGAINST ('www http com the blog tutorials category to features use content louisvuitton same for seo index that sony flash buy')) * 1 + (MATCH (post_title) AGAINST ('part content duplicate addressing')) * 1 + count(distinct if( termtax.taxonomy = 'category', refterms.term_taxonomy_id, null )) + count(distinct if( termtax.taxonomy = 'post_tag', refterms.term_taxonomy_id, null )),1) as score
from wp_posts
left join wp_term_relationships as terms on ( terms.object_id = wp_posts.ID )
left join wp_term_taxonomy as termtax on ( terms.term_taxonomy_id = termtax.term_taxonomy_id )
left join wp_term_relationships as refterms on ( terms.term_taxonomy_id = refterms.term_taxonomy_id and refterms.object_id = 393 )
where post_status in ( 'publish', 'static' ) and ID != '393' and post_date <= '2007-09-30 09:16:47' and post_password ='' and post_type = 'page'
group by ID
having score >= 5.00 and bit_or(termtax.term_id in (0)) = 0 order by score desc limit 5) on duplicate key update date = now()
WordPress database error: [Table 'blogtut_tutordb.wp_yarpp_related_cache' doesn't exist]
insert into wp_yarpp_related_cache (reference_ID,ID,score) values (393,0,0) on duplicate key update date = now()
Addressing Duplicate Content continued…
4. Be consistent when it comes to internal links – When linking to other pages un your website make sure you use the same format for indicating the links. For example, if you use the link
http://www.blog-tutorials.com/category/features/seo/
next time in another page make sure you don’t link to the same article using either of the next two ways given below
http://www.blog-tutorials.com/category/features/seo
http://www.blog-tutorials.com/category/features/seo/index.htm
Be consistent throughout the website.
http://www.blog-tutorials.com/category/features/seo/
http://www.blog-tutorials.com/category/features/monetization/
http://www.blog-tutorials.com/category/featured/software/
http://www.blog-tutorials.com/blogging-news/googles-birthday/
Notice that throughout BlogTutorials the same format is used. This lessens that chance of the spider to interpret the same page as different pages.
5. Use Top Level Domains (TLDs) - Use TLDs as much as possible for country-specific content. A good example would be Sony’s websites.
-
http://www.sony.com/ (US)
http://www.sony.co.uk/ (UK)
http://www.sony.co.jp/ (Japan)
http://www.sony.com.ph/ (Philippines)
Louis Vuitton on the other hand does not use TLDs.
http://www.louisvuitton.com/ (Main page)
http://www.louisvuitton.com/web/flash/index.jsp;jsessionid=AJUC5VZH0PWFGCRBXUFFAGIKEG4RAUPU?buy=1&langue=fr_FR (Fance)
http://www.louisvuitton.com/web/flash/index.jsp;jsessionid=XKKWICPUA41J0CRBXUFFAGIKEG4RAUPU?buy=0&langue=ko_KR (Korea)
http://www.louisvuitton.com/web/flash/index.jsp;jsessionid=RAV5355OI0TPSCRBXUFFAGIKEG4RAUPU?buy=1&langue=en_GB (UK)
It makes it harder for search engines to “realize” that these pages (aside from the fact that it’s in flash) contain country-specific content.
Source: Webmaster Central Blog (Deftly dealing with duplicate content)
No related posts.
Related Articles
WordPress database error: [Table 'blogtut_tutordb.wp_yarpp_related_cache' doesn't exist]
select min(ID) as min_id from wp_yarpp_related_cache where reference_ID = 393
WordPress database error: [Table 'blogtut_tutordb.wp_yarpp_related_cache' doesn't exist]
select distinct ID from wp_yarpp_related_cache where reference_ID = 393 and ID != 0
WordPress database error: [Table 'blogtut_tutordb.wp_yarpp_related_cache' doesn't exist]
delete from wp_yarpp_related_cache where reference_ID = 393
WordPress database error: [Table 'blogtut_tutordb.wp_yarpp_keyword_cache' doesn't exist]
delete from wp_yarpp_keyword_cache where ID = 393
WordPress database error: [Table 'blogtut_tutordb.wp_yarpp_keyword_cache' doesn't exist]
select body, title from wp_yarpp_keyword_cache where ID = 393
WordPress database error: [Table 'blogtut_tutordb.wp_yarpp_keyword_cache' doesn't exist]
insert into wp_yarpp_keyword_cache (ID,body,title) values (393,'www http com the blog tutorials category to features use content louisvuitton same for seo index that sony flash buy ','part content duplicate addressing ') on duplicate key update date = now(), body = 'www http com the blog tutorials category to features use content louisvuitton same for seo index that sony flash buy ', title = 'part content duplicate addressing '
WordPress database error: [Table 'blogtut_tutordb.wp_yarpp_related_cache' doesn't exist]
insert into wp_yarpp_related_cache (reference_ID,ID,score) (SELECT 393 as reference_ID, ID, ROUND(0 + (MATCH (post_content) AGAINST ('www http com the blog tutorials category to features use content louisvuitton same for seo index that sony flash buy')) * 1 + (MATCH (post_title) AGAINST ('part content duplicate addressing')) * 1 + count(distinct if( termtax.taxonomy = 'category', refterms.term_taxonomy_id, null )) + count(distinct if( termtax.taxonomy = 'post_tag', refterms.term_taxonomy_id, null )),1) as score
from wp_posts
left join wp_term_relationships as terms on ( terms.object_id = wp_posts.ID )
left join wp_term_taxonomy as termtax on ( terms.term_taxonomy_id = termtax.term_taxonomy_id )
left join wp_term_relationships as refterms on ( terms.term_taxonomy_id = refterms.term_taxonomy_id and refterms.object_id = 393 )
where post_status in ( 'publish', 'static' ) and ID != '393' and post_date <= '2007-09-30 09:16:47' and post_password ='' and post_type = 'post'
group by ID
having score >= 5.00 and bit_or(termtax.term_id in (0)) = 0 order by score desc limit 5) union (SELECT 393 as reference_ID, ID, ROUND(0 + (MATCH (post_content) AGAINST ('www http com the blog tutorials category to features use content louisvuitton same for seo index that sony flash buy')) * 1 + (MATCH (post_title) AGAINST ('part content duplicate addressing')) * 1 + count(distinct if( termtax.taxonomy = 'category', refterms.term_taxonomy_id, null )) + count(distinct if( termtax.taxonomy = 'post_tag', refterms.term_taxonomy_id, null )),1) as score
from wp_posts
left join wp_term_relationships as terms on ( terms.object_id = wp_posts.ID )
left join wp_term_taxonomy as termtax on ( terms.term_taxonomy_id = termtax.term_taxonomy_id )
left join wp_term_relationships as refterms on ( terms.term_taxonomy_id = refterms.term_taxonomy_id and refterms.object_id = 393 )
where post_status in ( 'publish', 'static' ) and ID != '393' and post_date <= '2007-09-30 09:16:47' and post_password ='' and post_type = 'page'
group by ID
having score >= 5.00 and bit_or(termtax.term_id in (0)) = 0 order by score desc limit 5) on duplicate key update date = now()
WordPress database error: [Table 'blogtut_tutordb.wp_yarpp_related_cache' doesn't exist]
insert into wp_yarpp_related_cache (reference_ID,ID,score) values (393,0,0) on duplicate key update date = now()
No related posts.
Our Features
-
Design and Themes
The Modern and Creative Design and Themes
In order to design a website you can organize web design contests which are meant for the designers who are best in this field. This is one of the best way by which you can get the best designs and then you can pick any of them. You can use internet that is the ideal [...]
Read on
More Design and Themes Features -
Software and Widgets
WordPress Plug-ins
If you blog using WordPress and can’t do something that you want done like adding Sphere-related content at the end of your blog posts you might be surprised to find out that there are already plug-ins available that make it happen. To find good WordPress plug-ins all you need to do is search for “wordpress [...]
Read on
More Software and Widgets Features -
Reviews
A Friend In Need
I’m helping out my friends from the UA&P – IShareHappiness Blog Team. Whenever you feel pessimistic, angry, troubled, frustrated, and depressed – what have you – you need someone to talk to. Someone who could help you be more optimistic and help make you feel that there is hope. Sometimes it’s hard to talk to [...]
Read on
More Blog Reviews -
Monetization
The Modern and Creative Design and Themes
In order to design a website you can organize web design contests which are meant for the designers who are best in this field. This is one of the best way by which you can get the best designs and then you can pick any of them. You can use internet that is the ideal [...]
Read on
More Monetization Features -
Marketing and Search Optimization
The Importance of SEO Consulting in Creating Online Businesses
Due to the reception and acceptance of SEO as a business process for assuring successful profit generation, many blogs, article contents, and forums have been discussing this matter, even providing some tips and tricks for everyone who is interested to know what is behind the trend and the system. People who would like to achieve [...]
Read on
More Marketing and SEO Features -
Blog Resources
SUBSCRIBE
Via RSS Feed
Via Email
Via Mobile Phone
CATEGORIES
- Blog Tutorials News
- Design and Themes
- Featured Articles
- Marketing and Search Optimization
- Monetization
- Software and Widgets
- Writing
Friends
-
Freelance writing jobs
- SEO Copywriting Service
- SEO web hosting
- iPage
- FatCow
- Face to Face Sales
- China Wholesale
- For wordpress installation help, you could check 1-click Wordpress Setup on iPage.
Bloggy Awards
- CaptainCupid
- Higher Pound: Lessons on Recovery Learned From a Pack of Dogs
- The Freaky
- The Fertility Guide
- Daddy Dazed UK
Blogger Jobs
- Need a Break From Blogging? Cook With Recipe Finder!
- Screencast/video blogger with wordpress/web 2.0 experience
- Android App Review/Blogger Wanted
- Canadian Business Blogger Wanted
- Fashion Writers Wanted at Pumpsicle

CONTRIBUTORS
RESOURCES
- Blog Herald
- Blog Network Watch
- Copyblogger
- Daily Blog Tips
- Japanese Blogs
- Lorelle on WordPress
- Problogger
3 Responses
Used Cars
30|Sep|2007I never knew that. Helpfull for me.
trocricol
26|Oct|2007elcasitbocze
roeltpaser
17|Nov|2007ricdomtrb