Monday Link Menu: Blogs for 4.23.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 = 50 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 blogs commen]
insert into wp_yarpp_keyword_cache (ID,body,title) values (50,'blog blogs commenting comments blogger post commenter builds great traffic classic tizers participation blogging wanted rewarded before weve shortly heard ','07 23 blogs link monday ') on duplicate key update date = now(), body = 'blog blogs commenting comments blogger post commenter builds great traffic classic tizers participation blogging wanted rewarded before weve shortly heard ', title = '07 23 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 = 50 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 = 50
WordPress database error: [Table 'prime_wp2.wp_yarpp_keyword_cache' doesn't exist]
select body from wp_yarpp_keyword_cache where ID = 50
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 blogs commen]
insert into wp_yarpp_keyword_cache (ID,body,title) values (50,'blog blogs commenting comments blogger post commenter builds great traffic classic tizers participation blogging wanted rewarded before weve shortly heard ','07 23 blogs link monday ') on duplicate key update date = now(), body = 'blog blogs commenting comments blogger post commenter builds great traffic classic tizers participation blogging wanted rewarded before weve shortly heard ', title = '07 23 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 = 50
WordPress database error: [Table 'prime_wp2.wp_yarpp_keyword_cache' doesn't exist]
select title from wp_yarpp_keyword_cache where ID = 50
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 blogs commen]
insert into wp_yarpp_keyword_cache (ID,body,title) values (50,'blog blogs commenting comments blogger post commenter builds great traffic classic tizers participation blogging wanted rewarded before weve shortly heard ','07 23 blogs link monday ') on duplicate key update date = now(), body = 'blog blogs commenting comments blogger post commenter builds great traffic classic tizers participation blogging wanted rewarded before weve shortly heard ', title = '07 23 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 = 50
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 50, 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 = 50 )
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 = 50 )
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 != '50') 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 (50,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 = 50 AND wp_posts.post_type = 'post' and post_date > date_sub(now(), interval 12 month) ORDER BY yarpp.score DESC limit 5
I thought I would put some focus on blog commenting today. Participating on blogs by commenting on the posts are of great benefit to both commenter and blogger.
For the blogger, it gives them feedback on their thoughts and post; good, bad or indifferent … it really builds the conversation and the value of the post. I have often learned just as much, if not more, from the string of comments and the information the commenters share and link to.
For the commenter, it builds confidence, makes for new contacts and opens your own mind. It can also build your blog’s or website’s traffic from your linked name. Many blogs are jumping on the no-follow bandwagon (we will shortly too).
We’ve all heard it before … you get more out of anything when you put in more … and that applies especially for blogging and commenting.
Blog-a-tizers:
- Participation Wanted & Rewarded, a classic here on the Prime Blog
- Branding Self in Blog Comments from soho-life.com
- 10 Creative Traffic Building Ideas from TopRank, #3 is to comment!
Main Course:
- 10 Techniques to Get More Comments on Your Blog from Problogger
Have a great week!
No related posts.
Posted on April 23rd, 2007 by Jeff Wagner
Filed under: blogging, monday link menu
If you like what you're reading, please subscribe to this blog.
Hi there, love your blog!
I’ve been thinking of jumping on the “no follow” bandwagon myself, but I’m concerned about the potential for blog spamming if I do – are you planning to require approvals for comments before you move to that model, or are you not worrying about it – or how are you handling it?
Keep up the great blog!
Caroline
Small Business Mavericks
Thanks Caroline, I think we will be installing a WP plug-in requiring some type of human element Q & A … like “What is 4 plus 2?” to weed things out. Other than that the Akismet plug-in for WP provide some great filtering … I would say 95% of our comment spam is caught by that plug-in. Where in MN are you?