Monday Link Menu: Blogs for 7.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 = 91 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 = 'google maps map m]
insert into wp_yarpp_keyword_cache (ID,body,title) values (91,'google maps map mash blog street adds tizers website offering enhance efficient case future near next sales possibly shorter call ','07 blogs link monday ') on duplicate key update date = now(), body = 'google maps map mash blog street adds tizers website offering enhance efficient case future near next sales possibly shorter call ', 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 = 91 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 = 91
WordPress database error: [Table 'prime_wp2.wp_yarpp_keyword_cache' doesn't exist]
select body from wp_yarpp_keyword_cache where ID = 91
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 = 'google maps map m]
insert into wp_yarpp_keyword_cache (ID,body,title) values (91,'google maps map mash blog street adds tizers website offering enhance efficient case future near next sales possibly shorter call ','07 blogs link monday ') on duplicate key update date = now(), body = 'google maps map mash blog street adds tizers website offering enhance efficient case future near next sales possibly shorter call ', 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 = 91
WordPress database error: [Table 'prime_wp2.wp_yarpp_keyword_cache' doesn't exist]
select title from wp_yarpp_keyword_cache where ID = 91
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 = 'google maps map m]
insert into wp_yarpp_keyword_cache (ID,body,title) values (91,'google maps map mash blog street adds tizers website offering enhance efficient case future near next sales possibly shorter call ','07 blogs link monday ') on duplicate key update date = now(), body = 'google maps map mash blog street adds tizers website offering enhance efficient case future near next sales possibly shorter call ', 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 = 91
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 91, 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 = 91 )
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 = 91 )
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 != '91') 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 (91,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 = 91 AND wp_posts.post_type = 'post' and post_date > date_sub(now(), interval 12 month) ORDER BY yarpp.score DESC limit 5
After a few week absence the Monday Link Menu is back, aiming to broaden your horizons and bring you some new information from around the web. I thought I would give this weeks menu to Google Maps.
It might be the constant iPhone commercials subliminally keeping maps on my mind … or just the fact that I never know where I’m going and can use the help. Here at Prime we are starting to implement more map mash-ups in to sites. Luke has been mashing away and we’ll have some things to reveal for real estate, home builders and our community websites in the near future. In any case, Google Maps can make your day more efficient, your drive to your next sales call shorter and possibly enhance your website and offering.
Blog-a-tizers:
- Google maps adds Street View
- For you workout die-hards, Google maps for your running route
- New Google maps mash-up produces taxi fare finder
- If you’re a Google Map maniac, this blog has all your fix covered
Main Course:
No related posts.
Posted on July 9th, 2007 by Jeff Wagner
Filed under: monday link menu, technology
If you like what you're reading, please subscribe to this blog.





Leave a Reply