Monday Link Menu: Blogs for 4.9.07

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 = 42 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 = 'blog benefits lea]
insert into wp_yarpp_keyword_cache (ID,body,title) values (42,'blog benefits learned posts weeks seo darren reasons blogging 18 lessons bloggingrand lee odden rowsebuilding problogger blogs breaks fishkin seomoz ','07 blogs link monday ') on duplicate key update date = now(), body = 'blog benefits learned posts weeks seo darren reasons blogging 18 lessons bloggingrand lee odden rowsebuilding problogger blogs breaks fishkin seomoz ', title = '07 blogs link monday '

WordPress database error: [Table 'prime_wp2.wp_yarpp_related_cache' doesn't exist]
select ID from wp_yarpp_related_cache where reference_ID = 42 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 = 42

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

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 = 'blog benefits lea]
insert into wp_yarpp_keyword_cache (ID,body,title) values (42,'blog benefits learned posts weeks seo darren reasons blogging 18 lessons bloggingrand lee odden rowsebuilding problogger blogs breaks fishkin seomoz ','07 blogs link monday ') on duplicate key update date = now(), body = 'blog benefits learned posts weeks seo darren reasons blogging 18 lessons bloggingrand lee odden rowsebuilding problogger blogs breaks fishkin seomoz ', title = '07 blogs link monday '

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

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

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 = 'blog benefits lea]
insert into wp_yarpp_keyword_cache (ID,body,title) values (42,'blog benefits learned posts weeks seo darren reasons blogging 18 lessons bloggingrand lee odden rowsebuilding problogger blogs breaks fishkin seomoz ','07 blogs link monday ') on duplicate key update date = now(), body = 'blog benefits learned posts weeks seo darren reasons blogging 18 lessons bloggingrand lee odden rowsebuilding problogger blogs breaks fishkin seomoz ', title = '07 blogs link monday '

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

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 42, 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 = 42 ) 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 = 42 ) 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 != '42') 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 (42,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 = 42 AND wp_posts.post_type = 'post' and post_date > date_sub(now(), interval 12 month) ORDER BY yarpp.score DESC limit 5

A few weeks ago I posted on what blogging had taught me in one month of typing away here at the Prime Blog.  It was valuable for me to identify a few of the initial benefits and it will be interesting to see what those top benefits are months from now.  For this weeks Monday Link Menu I thought I would drop some other posts on why others blog (some are out of the blog meme going around) or what they have learned on your plate.  The Main Course looks at SEO benefits to blogging.

Blog-a-tizers:

Main Course


  • Share/Save/Bookmark

No related posts.

Leave a Reply