Wilderness TrekkersEARTH DAY 2009 – GO GREEN HIKING
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 = 52
WordPress database error: [Table 'gemini60_9ffbd1.wp_yarpp_related_cache' doesn't exist]
select distinct ID from wp_yarpp_related_cache where reference_ID = 52 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 = 52
WordPress database error: [Table 'gemini60_9ffbd1.wp_yarpp_keyword_cache' doesn't exist]
delete from wp_yarpp_keyword_cache where ID = 52
WordPress database error: [Table 'gemini60_9ffbd1.wp_yarpp_keyword_cache' doesn't exist]
select body, title from wp_yarpp_keyword_cache where ID = 52
WordPress database error: [Table 'gemini60_9ffbd1.wp_yarpp_keyword_cache' doesn't exist]
insert into wp_yarpp_keyword_cache (ID,body,title) values (52,'hiking day green earth go 2009 26 2f addthis_title 238211 3b tags technorati addthis_pub http 2fwww outdoors great 2fthe 2fearth ','green hiking go 2009 day earth ') on duplicate key update date = now(), body = 'hiking day green earth go 2009 26 2f addthis_title 238211 3b tags technorati addthis_pub http 2fwww outdoors great 2fthe 2fearth ', title = 'green hiking go 2009 day earth '
WordPress database error: [Table 'gemini60_9ffbd1.wp_yarpp_related_cache' doesn't exist]
insert into wp_yarpp_related_cache (reference_ID,ID,score) (SELECT 52 as reference_ID, ID, ROUND(0 + (MATCH (post_content) AGAINST ('hiking day green earth go 2009 26 2f addthis_title 238211 3b tags technorati addthis_pub http 2fwww outdoors great 2fthe 2fearth')) * 1 + (MATCH (post_title) AGAINST ('green hiking go 2009 day earth')) * 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 = 52 )
where post_status in ( 'publish', 'static' ) and ID != '52' and post_date <= '2009-04-22 23:16:59' 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 52 as reference_ID, ID, ROUND(0 + (MATCH (post_content) AGAINST ('hiking day green earth go 2009 26 2f addthis_title 238211 3b tags technorati addthis_pub http 2fwww outdoors great 2fthe 2fearth')) * 1 + (MATCH (post_title) AGAINST ('green hiking go 2009 day earth')) * 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 = 52 )
where post_status in ( 'publish', 'static' ) and ID != '52' and post_date <= '2009-04-22 23:16:59' 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 (52,0,0) on duplicate key update date = now()
No related posts.