SEO Knowledge: Learning at High Rankings
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 = 28 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 = 'great seo questio]
insert into wp_yarpp_keyword_cache (ID,body,title) values (28,'great seo questions hotel speakers clients yesterday classes close having highlight answering front yesterdays phone fabulous copywriter prime foremost user ','rankings high learning knowledge seo ') on duplicate key update date = now(), body = 'great seo questions hotel speakers clients yesterday classes close having highlight answering front yesterdays phone fabulous copywriter prime foremost user ', title = 'rankings high learning knowledge seo '
WordPress database error: [Table 'prime_wp2.wp_yarpp_related_cache' doesn't exist]
select ID from wp_yarpp_related_cache where reference_ID = 28 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 = 28
WordPress database error: [Table 'prime_wp2.wp_yarpp_keyword_cache' doesn't exist]
select body from wp_yarpp_keyword_cache where ID = 28
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 = 'great seo questio]
insert into wp_yarpp_keyword_cache (ID,body,title) values (28,'great seo questions hotel speakers clients yesterday classes close having highlight answering front yesterdays phone fabulous copywriter prime foremost user ','rankings high learning knowledge seo ') on duplicate key update date = now(), body = 'great seo questions hotel speakers clients yesterday classes close having highlight answering front yesterdays phone fabulous copywriter prime foremost user ', title = 'rankings high learning knowledge seo '
WordPress database error: [Table 'prime_wp2.wp_yarpp_keyword_cache' doesn't exist]
select body from wp_yarpp_keyword_cache where ID = 28
WordPress database error: [Table 'prime_wp2.wp_yarpp_keyword_cache' doesn't exist]
select title from wp_yarpp_keyword_cache where ID = 28
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 = 'great seo questio]
insert into wp_yarpp_keyword_cache (ID,body,title) values (28,'great seo questions hotel speakers clients yesterday classes close having highlight answering front yesterdays phone fabulous copywriter prime foremost user ','rankings high learning knowledge seo ') on duplicate key update date = now(), body = 'great seo questions hotel speakers clients yesterday classes close having highlight answering front yesterdays phone fabulous copywriter prime foremost user ', title = 'rankings high learning knowledge seo '
WordPress database error: [Table 'prime_wp2.wp_yarpp_keyword_cache' doesn't exist]
select title from wp_yarpp_keyword_cache where ID = 28
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 28, 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 = 28 )
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 = 28 )
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 != '28') 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 (28,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 = 28 AND wp_posts.post_type = 'post' and post_date > date_sub(now(), interval 12 month) ORDER BY yarpp.score DESC limit 5
We’re just starting day two at High Rankings Search Engine Optimization seminar and day one was great. The group size is only about 80 so you get to ask more questions and get great personal attention during breaks and lunch. Speakers yesterday covered some good SEO basics that are always smart to review and a few new things came across our minds. Jeff and I had some good discussions on what we can tweak in our SEO approach to gain a bit more leverage for our clients. By far and away the two most valuable speakers were:
- Lee Odden on blogging, social media and pr effecting SEO.
- Karon Thackston on copywriting. Great push of writing content for the user first and foremost. Prime has a FABULOUS copywriter and it is worth every penny to use this service for your website.
Here are a few photos from yesterday off my phone (Treo). The end of yesterdays classes came to a close with all of the speakers up front answering questions. It was the highlight of the day, having that level and spread of SEO expertise grouped together breaking down questions.
On a closing note, we stayed at The Marquette Hotel in Minneapolis last night, one of our great clients. I can honestly say I have never slept on a better bed at a hotel before … great hotel, you should give them a shot next time you stay downtown.
No related posts.
Posted on March 16th, 2007 by Jeff Wagner
Filed under: prime news, seo
If you like what you're reading, please subscribe to this blog.
Thanks for the mention Aaron!
I am glad you enjoyed the sessions and it was good seeing/meeting you again. Please be sure to post about how day two goes if you can.
[...] High Rankings SEO Seminar that Jeff and I attended last Thursday and Friday. You can read the day one recap below this one.Day two started with Matt Bailey offering up some "cool tools" for [...]
An off the wall question for you – I have a Treo phone, too, and I can’t seem to get my pictures from my phone to my PC. Am I missing something obvious?
Anyhow, it sounds like a great conference!
Char- Thanks, it was good brain food on SEO. As far as the Treo, do you have Palm OS? That’s what I have and you can either email the photo (via sprint) to get it or transfer them to your Palm Desktop. Hope that helps!