The Monday Menu: Blogs to consume for the week of 2.19.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 = 9 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 = 'search business m]
insert into wp_yarpp_keyword_cache (ID,body,title) values (9,'search business monday engine opinion information news blogs bring categories discussion open explores mcdonalds responsibility corporate newsmcdonalds twin gm fast ','19 07 week consume blogs monday ') on duplicate key update date = now(), body = 'search business monday engine opinion information news blogs bring categories discussion open explores mcdonalds responsibility corporate newsmcdonalds twin gm fast ', title = '19 07 week consume blogs monday '
WordPress database error: [Table 'prime_wp2.wp_yarpp_related_cache' doesn't exist]
select ID from wp_yarpp_related_cache where reference_ID = 9 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 = 9
WordPress database error: [Table 'prime_wp2.wp_yarpp_keyword_cache' doesn't exist]
select body from wp_yarpp_keyword_cache where ID = 9
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 = 'search business m]
insert into wp_yarpp_keyword_cache (ID,body,title) values (9,'search business monday engine opinion information news blogs bring categories discussion open explores mcdonalds responsibility corporate newsmcdonalds twin gm fast ','19 07 week consume blogs monday ') on duplicate key update date = now(), body = 'search business monday engine opinion information news blogs bring categories discussion open explores mcdonalds responsibility corporate newsmcdonalds twin gm fast ', title = '19 07 week consume blogs monday '
WordPress database error: [Table 'prime_wp2.wp_yarpp_keyword_cache' doesn't exist]
select body from wp_yarpp_keyword_cache where ID = 9
WordPress database error: [Table 'prime_wp2.wp_yarpp_keyword_cache' doesn't exist]
select title from wp_yarpp_keyword_cache where ID = 9
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 = 'search business m]
insert into wp_yarpp_keyword_cache (ID,body,title) values (9,'search business monday engine opinion information news blogs bring categories discussion open explores mcdonalds responsibility corporate newsmcdonalds twin gm fast ','19 07 week consume blogs monday ') on duplicate key update date = now(), body = 'search business monday engine opinion information news blogs bring categories discussion open explores mcdonalds responsibility corporate newsmcdonalds twin gm fast ', title = '19 07 week consume blogs monday '
WordPress database error: [Table 'prime_wp2.wp_yarpp_keyword_cache' doesn't exist]
select title from wp_yarpp_keyword_cache where ID = 9
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 9, 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 = 9 )
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 = 9 )
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 != '9') 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 (9,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 = 9 AND wp_posts.post_type = 'post' and post_date > date_sub(now(), interval 12 month) ORDER BY yarpp.score DESC limit 5
In establishing some constant features, The "Monday Menu" will be my first. Each Monday morning we’ll put together a list of blogs worth reading or stopping by from various categories, ranging from small business to big tips to pure entertainment. We’d love to hear from you as well with your suggestions (categories or blogs), so feel free to comment or drop us a line. So bring an appetite for some knowledge, opinion and musings and we’ll supply the food for thought.
Marketing
AdPulp : Daily takes and “juice” from the ad business.
BizThreads : Business information for entrepreneurs and small business.
Search & SEO
Search Engine Roundtable : A collection of Search Engine Marketing posts and threads
SearchNewz : Search engine news and information
Fortune 500 Companies
General Motors: Fast lane Blog has GM and auto industry news
McDonalds: "Open for Discussion" explores McDonalds corporate responsibility.
Twin Cities Blogs
Metroblogging Minneapolis: Local news, opinion and flare.
Star Tribune Web Search: Randy Salas of the Strip pionts our interesting, cool and fun sites on the net.
OK , eat ‘em up and we’ll bring you a new menu next Monday for take out or dine in.
No related posts.
Posted on February 19th, 2007 by Jeff Wagner
Filed under: blogging, monday link menu
If you like what you're reading, please subscribe to this blog.





Leave a Reply