Wilderness TrekkersTENTS & SLEEPING BAGS
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 = 108
WordPress database error: [Table 'gemini60_9ffbd1.wp_yarpp_related_cache' doesn't exist]
select distinct ID from wp_yarpp_related_cache where reference_ID = 108 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 = 108
WordPress database error: [Table 'gemini60_9ffbd1.wp_yarpp_keyword_cache' doesn't exist]
delete from wp_yarpp_keyword_cache where ID = 108
WordPress database error: [Table 'gemini60_9ffbd1.wp_yarpp_keyword_cache' doesn't exist]
select body, title from wp_yarpp_keyword_cache where ID = 108
WordPress database error: [Table 'gemini60_9ffbd1.wp_yarpp_keyword_cache' doesn't exist]
insert into wp_yarpp_keyword_cache (ID,body,title) values (108,'tents bags sleeping camping gear hiking technorati addthis_pub tent marmot backpacking 3b backpacker tags addthis_title 2fwww 2f 3a http wildernesstrekkers ','bags sleeping tents ') on duplicate key update date = now(), body = 'tents bags sleeping camping gear hiking technorati addthis_pub tent marmot backpacking 3b backpacker tags addthis_title 2fwww 2f 3a http wildernesstrekkers ', title = 'bags sleeping tents '
WordPress database error: [Table 'gemini60_9ffbd1.wp_yarpp_related_cache' doesn't exist]
insert into wp_yarpp_related_cache (reference_ID,ID,score) (SELECT 108 as reference_ID, ID, ROUND(0 + (MATCH (post_content) AGAINST ('tents bags sleeping camping gear hiking technorati addthis_pub tent marmot backpacking 3b backpacker tags addthis_title 2fwww 2f 3a http wildernesstrekkers')) * 1 + (MATCH (post_title) AGAINST ('bags sleeping tents')) * 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 = 108 )
where post_status in ( 'publish', 'static' ) and ID != '108' and post_date <= '2009-05-10 22:56: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 108 as reference_ID, ID, ROUND(0 + (MATCH (post_content) AGAINST ('tents bags sleeping camping gear hiking technorati addthis_pub tent marmot backpacking 3b backpacker tags addthis_title 2fwww 2f 3a http wildernesstrekkers')) * 1 + (MATCH (post_title) AGAINST ('bags sleeping tents')) * 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 = 108 )
where post_status in ( 'publish', 'static' ) and ID != '108' and post_date <= '2009-05-10 22:56: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 (108,0,0) on duplicate key update date = now()
No related posts.
[...] View [...]