Get A Few SEO Tips & Understand Search Results From Google & Matt Cutts

WordPress database error: [Table 'prime_wp2.wp_yarpp_related_cache' doesn't exist]
select count(*) as count from wp_yarpp_related_cache where reference_ID = 144 and date > date_sub(now(),interval 600 minute)

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 'on duplicate key update date = now(), body = 'video search goog]
insert into wp_yarpp_keyword_cache (ID,body,title) values (144,'video search google matt result blog tips seomoz value great starting breaks info team his rand segment searcher gets weekly ','matt cutts google search tips understand seo ') on duplicate key update date = now(), body = 'video search google matt result blog tips seomoz value great starting breaks info team his rand segment searcher gets weekly ', title = 'matt cutts google search tips understand seo '

WordPress database error: [Table 'prime_wp2.wp_yarpp_related_cache' doesn't exist]
select ID from wp_yarpp_related_cache where reference_ID = 144 and ID != 0

WordPress database error: [Table 'prime_wp2.wp_yarpp_related_cache' doesn't exist]
delete from wp_yarpp_related_cache where reference_ID = 144

WordPress database error: [Table 'prime_wp2.wp_yarpp_keyword_cache' doesn't exist]
select body from wp_yarpp_keyword_cache where ID = 144

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 'on duplicate key update date = now(), body = 'video search goog]
insert into wp_yarpp_keyword_cache (ID,body,title) values (144,'video search google matt result blog tips seomoz value great starting breaks info team his rand segment searcher gets weekly ','matt cutts google search tips understand seo ') on duplicate key update date = now(), body = 'video search google matt result blog tips seomoz value great starting breaks info team his rand segment searcher gets weekly ', title = 'matt cutts google search tips understand seo '

WordPress database error: [Table 'prime_wp2.wp_yarpp_keyword_cache' doesn't exist]
select body from wp_yarpp_keyword_cache where ID = 144

WordPress database error: [Table 'prime_wp2.wp_yarpp_keyword_cache' doesn't exist]
select title from wp_yarpp_keyword_cache where ID = 144

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 'on duplicate key update date = now(), body = 'video search goog]
insert into wp_yarpp_keyword_cache (ID,body,title) values (144,'video search google matt result blog tips seomoz value great starting breaks info team his rand segment searcher gets weekly ','matt cutts google search tips understand seo ') on duplicate key update date = now(), body = 'video search google matt result blog tips seomoz value great starting breaks info team his rand segment searcher gets weekly ', title = 'matt cutts google search tips understand seo '

WordPress database error: [Table 'prime_wp2.wp_yarpp_keyword_cache' doesn't exist]
select title from wp_yarpp_keyword_cache where ID = 144

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 'on duplicate key update date = now()' at line 15]
insert into wp_yarpp_related_cache (reference_ID,ID,score) SELECT 144, ID, (0+ 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 = 144 ) 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 = 144 ) 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 != '144') and post_date <= NOW() and post_password ='' and post_date > date_sub(now(), interval 12 month) and post_type IN ('post', 'page') group by id having score >= 2.5 order by score desc limit 5 on duplicate key update date = now()

WordPress database error: [Table 'prime_wp2.wp_yarpp_related_cache' doesn't exist]
insert into wp_yarpp_related_cache (reference_ID,ID,score) values (144,0,0)

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 'using (ID) WHERE 1=1 AND yarpp.score > 5 and yarpp.reference_I]
SELECT SQL_CALC_FOUND_ROWS wp_posts.*, yarpp.score FROM wp_posts join wp_yarpp_related_cache as yarpp using (ID) WHERE 1=1 AND yarpp.score > 5 and yarpp.reference_ID = 144 AND wp_posts.post_type = 'post' and post_date > date_sub(now(), interval 12 month) ORDER BY yarpp.score DESC limit 5

Luke in our web department forwarded me this post on The Anatomy of a Search Result that contains a video of Google’s Matt Cutts.  I’ve embedded the video below in which Matt breaks down a search engine result in Google using Starbucks as an example and points out where Google takes this info from, why and also drops in some good basic SEO tips.

  

 

For anyone just starting to try and understand the world of search, this is a great starting point.  So many people only focus on rank, but there are some very solid tips on the value of how your search result (SERP) reads (and attracts clicks) in this video.  If you grasp the concepts in Matt’s video above and like the visual learning format, then check out the SEOmoz Whiteboard Friday videos.  Rand and his team put together a great video segment weekly that gets our attention with all of their value and info.  It would also be a good idea to subscribe or bookmark the Google Webmaster blog and SEOmoz blog for more good stuff.

You’ll also notice the video breaks down the "sitelink" results that some SERPS offer, we’ve discussed sitelinks from Google here before and Matt reinforces that they are algorithm results to help the searcher, not a paid item.

  • Share/Save/Bookmark

No related posts.

Leave a Reply