High Rankings SEO Seminar: Day 2 & Final Summary
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 = 29 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 = 'seo website high ]
insert into wp_yarpp_keyword_cache (ID,body,title) values (29,'seo website high seminar rankings knowledge great diagnosing room elements having wanted matt involves jeff process speakers faithful strategies brought ','final summary seminar seo rankings high ') on duplicate key update date = now(), body = 'seo website high seminar rankings knowledge great diagnosing room elements having wanted matt involves jeff process speakers faithful strategies brought ', title = 'final summary seminar seo rankings high '
WordPress database error: [Table 'prime_wp2.wp_yarpp_related_cache' doesn't exist]
select ID from wp_yarpp_related_cache where reference_ID = 29 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 = 29
WordPress database error: [Table 'prime_wp2.wp_yarpp_keyword_cache' doesn't exist]
select body from wp_yarpp_keyword_cache where ID = 29
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 = 'seo website high ]
insert into wp_yarpp_keyword_cache (ID,body,title) values (29,'seo website high seminar rankings knowledge great diagnosing room elements having wanted matt involves jeff process speakers faithful strategies brought ','final summary seminar seo rankings high ') on duplicate key update date = now(), body = 'seo website high seminar rankings knowledge great diagnosing room elements having wanted matt involves jeff process speakers faithful strategies brought ', title = 'final summary seminar seo rankings high '
WordPress database error: [Table 'prime_wp2.wp_yarpp_keyword_cache' doesn't exist]
select body from wp_yarpp_keyword_cache where ID = 29
WordPress database error: [Table 'prime_wp2.wp_yarpp_keyword_cache' doesn't exist]
select title from wp_yarpp_keyword_cache where ID = 29
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 = 'seo website high ]
insert into wp_yarpp_keyword_cache (ID,body,title) values (29,'seo website high seminar rankings knowledge great diagnosing room elements having wanted matt involves jeff process speakers faithful strategies brought ','final summary seminar seo rankings high ') on duplicate key update date = now(), body = 'seo website high seminar rankings knowledge great diagnosing room elements having wanted matt involves jeff process speakers faithful strategies brought ', title = 'final summary seminar seo rankings high '
WordPress database error: [Table 'prime_wp2.wp_yarpp_keyword_cache' doesn't exist]
select title from wp_yarpp_keyword_cache where ID = 29
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 29, 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 = 29 )
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 = 29 )
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 != '29') 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 (29,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 = 29 AND wp_posts.post_type = 'post' and post_date > date_sub(now(), interval 12 month) ORDER BY yarpp.score DESC limit 5
I apologize to you faithful Monday Link Menu peeps, but I needed to complete the summary of the 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 diagnosing your website problems. While Matt offered many helpful sites and methods for diagnosing possible website issues regarding search engine optimization and conversion … rule #1 was "Don’t Panic", a true classic.
In the afternoon Scottie Claiborne went through basic website usability and SEO practices and then moved into evaluating websites that belonged to members of the audience. I would bet that 50% of the room wanted to have this group audit, but we only had time to get to a few. Expanding on the time to get in those who wanted to be reviewed would be a great tweak to the seminar. If good SEO involves analytics and measurement, then a good seminar involves having a clear definition of where you (or your website) is at.
Overall, I would recommend the High Rankings seminar to anyone, especially those with beginner to intermediate SEO knowledge. They do a fantastic job of moving you up the SEO knowledge ladder at a steady pace. The two days was worth the money/time for Jeff and I and cemented much of our current strategies but also brought some new elements to our process. The speakers in Minneapolis were all high energy, full of info and presented well. Having them at your table for lunch to focus on more specific questions was a great bonus you won’t find at larger venues. I would have liked to see more site reviews as mentioned, but also time focused on attendee interaction as there was plenty of knowledge and experience to be shared in the room as well.
Good SEO is about executing 20+ different elements correctly, not any one magic trick, easy button or secret weapon. The High Rankings crew provided great information and put the ball in our court, to get out there and put things into practice.
No related posts.
Posted on March 19th, 2007 by Jeff Wagner
Filed under: prime news, seo
If you like what you're reading, please subscribe to this blog.
[...] Weiche summarizes the Minneapolis High Rankings Seminar. I also received emails from several people that were very [...]
[...] Weiche summarizes the Minneapolis High Rankings Seminar. I also received emails from several people that were very [...]
[...] Weiche summarizes the Minneapolis High Rankings Seminar. I also received emails from several people that were very [...]