Mike Rowe Encourages Americans to Get Dirty on National Trails Day®
WordPress database error: [Table 'gemini60_9ffbd1.wp_yarpp_related_cache' doesn't exist]
select min(ID) as min_id from wp_yarpp_related_cache where reference_ID = 269
WordPress database error: [Table 'gemini60_9ffbd1.wp_yarpp_related_cache' doesn't exist]
select distinct ID from wp_yarpp_related_cache where reference_ID = 269 and ID != 0
WordPress database error: [Table 'gemini60_9ffbd1.wp_yarpp_related_cache' doesn't exist]
delete from wp_yarpp_related_cache where reference_ID = 269
WordPress database error: [Table 'gemini60_9ffbd1.wp_yarpp_keyword_cache' doesn't exist]
delete from wp_yarpp_keyword_cache where ID = 269
WordPress database error: [Table 'gemini60_9ffbd1.wp_yarpp_keyword_cache' doesn't exist]
select body, title from wp_yarpp_keyword_cache where ID = 269
WordPress database error: [Table 'gemini60_9ffbd1.wp_yarpp_keyword_cache' doesn't exist]
insert into wp_yarpp_keyword_cache (ID,body,title) values (269,'trails national com rowe mike day http encourages americans technorati tags 2f269 addthis_title to addthis_pub on ae 2fhiking dirty get ','on national trails day dirty get rowe encourages americans to mike ') on duplicate key update date = now(), body = 'trails national com rowe mike day http encourages americans technorati tags 2f269 addthis_title to addthis_pub on ae 2fhiking dirty get ', title = 'on national trails day dirty get rowe encourages americans to mike '
WordPress database error: [Table 'gemini60_9ffbd1.wp_yarpp_related_cache' doesn't exist]
insert into wp_yarpp_related_cache (reference_ID,ID,score) (SELECT 269 as reference_ID, ID, ROUND(0 + (MATCH (post_content) AGAINST ('trails national com rowe mike day http encourages americans technorati tags 2f269 addthis_title to addthis_pub on ae 2fhiking dirty get')) * 1 + (MATCH (post_title) AGAINST ('on national trails day dirty get rowe encourages americans to mike')) * 1 + count(distinct if( termtax.taxonomy = 'category', refterms.term_taxonomy_id, null )) + count(distinct if( termtax.taxonomy = 'post_tag', refterms.term_taxonomy_id, null )),1) as score
from wp_posts
left join wp_term_relationships as terms on ( terms.object_id = wp_posts.ID )
left join wp_term_taxonomy as termtax on ( terms.term_taxonomy_id = termtax.term_taxonomy_id )
left join wp_term_relationships as refterms on ( terms.term_taxonomy_id = refterms.term_taxonomy_id and refterms.object_id = 269 )
where post_status in ( 'publish', 'static' ) and ID != '269' and post_date <= '2011-05-12 17:23:29' and post_password ='' and post_type = 'post'
group by ID
having score >= 5.00 and bit_or(termtax.term_id in (0)) = 0 order by score desc limit 5) union (SELECT 269 as reference_ID, ID, ROUND(0 + (MATCH (post_content) AGAINST ('trails national com rowe mike day http encourages americans technorati tags 2f269 addthis_title to addthis_pub on ae 2fhiking dirty get')) * 1 + (MATCH (post_title) AGAINST ('on national trails day dirty get rowe encourages americans to mike')) * 1 + count(distinct if( termtax.taxonomy = 'category', refterms.term_taxonomy_id, null )) + count(distinct if( termtax.taxonomy = 'post_tag', refterms.term_taxonomy_id, null )),1) as score
from wp_posts
left join wp_term_relationships as terms on ( terms.object_id = wp_posts.ID )
left join wp_term_taxonomy as termtax on ( terms.term_taxonomy_id = termtax.term_taxonomy_id )
left join wp_term_relationships as refterms on ( terms.term_taxonomy_id = refterms.term_taxonomy_id and refterms.object_id = 269 )
where post_status in ( 'publish', 'static' ) and ID != '269' and post_date <= '2011-05-12 17:23:29' and post_password ='' and post_type = 'page'
group by ID
having score >= 5.00 and bit_or(termtax.term_id in (0)) = 0 order by score desc limit 5) on duplicate key update date = now()
WordPress database error: [Table 'gemini60_9ffbd1.wp_yarpp_related_cache' doesn't exist]
insert into wp_yarpp_related_cache (reference_ID,ID,score) values (269,0,0) on duplicate key update date = now()
American Hiking Society’s 19th annual trails celebration, Saturday, June 4th
http://www.pitchengine.com/pitch/145927/
No related posts.
Wilderness Trekkers