Sep | 30 | 2007

Addressing Duplicate Content: Part 2

Posted by Guru as Linking, Marketing and Search Optimization, SEO Features, Tips

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()

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.

Comments (3)

3 Responses

  1. Used Cars

    30|Sep|2007

    I never knew that. Helpfull for me.

  2. trocricol

    26|Oct|2007

    elcasitbocze

  3. roeltpaser

    17|Nov|2007

    ricdomtrb

  


Our Features

SUBSCRIBE

CATEGORIES

Friends

Bloggy Awards

Blogger Jobs

CONTRIBUTORS

RESOURCES

BLOG METRICS