Newsletter
WordPress database error: [Table 'intimacy_db1.wp_yarpp_related_cache' doesn't exist]
select min(ID) as min_id from wp_yarpp_related_cache where reference_ID = 820
WordPress database error: [Table 'intimacy_db1.wp_yarpp_related_cache' doesn't exist]
select distinct ID from wp_yarpp_related_cache where reference_ID = 820 and ID != 0
WordPress database error: [Table 'intimacy_db1.wp_yarpp_related_cache' doesn't exist]
delete from wp_yarpp_related_cache where reference_ID = 820
WordPress database error: [Table 'intimacy_db1.wp_yarpp_keyword_cache' doesn't exist]
delete from wp_yarpp_keyword_cache where ID = 820
WordPress database error: [Table 'intimacy_db1.wp_yarpp_keyword_cache' doesn't exist]
select body, title from wp_yarpp_keyword_cache where ID = 820
WordPress database error: [Table 'intimacy_db1.wp_yarpp_keyword_cache' doesn't exist]
insert into wp_yarpp_keyword_cache (ID,body,title) values (820,'islands republic and of united guinea french new island saint states name arab st korea france the democratic british peoples ','newsletter ') on duplicate key update date = now(), body = 'islands republic and of united guinea french new island saint states name arab st korea france the democratic british peoples ', title = 'newsletter '
WordPress database error: [Table 'intimacy_db1.wp_yarpp_related_cache' doesn't exist]
insert into wp_yarpp_related_cache (reference_ID,ID,score) (SELECT 820 as reference_ID, ID, ROUND(0 + (MATCH (post_content) AGAINST ('islands republic and of united guinea french new island saint states name arab st korea france the democratic british peoples')) * 1 + (MATCH (post_title) AGAINST ('newsletter')) * 1 + count(distinct if( termtax.taxonomy = 'post_tag', refterms.term_taxonomy_id, null )) + count(distinct if( termtax.taxonomy = 'category', 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 = 820 )
where post_status in ( 'publish', 'static' ) and ID != '820' and post_date <= '2009-04-03 14:48:31' 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 820 as reference_ID, ID, ROUND(0 + (MATCH (post_content) AGAINST ('islands republic and of united guinea french new island saint states name arab st korea france the democratic british peoples')) * 1 + (MATCH (post_title) AGAINST ('newsletter')) * 1 + count(distinct if( termtax.taxonomy = 'post_tag', refterms.term_taxonomy_id, null )) + count(distinct if( termtax.taxonomy = 'category', 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 = 820 )
where post_status in ( 'publish', 'static' ) and ID != '820' and post_date <= '2009-04-03 14:48:31' 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 'intimacy_db1.wp_yarpp_related_cache' doesn't exist]
select distinct ID from wp_yarpp_related_cache where reference_ID = 820 and ID != 0
WordPress database error: [Table 'intimacy_db1.wp_yarpp_related_cache' doesn't exist]
SELECT SQL_CALC_FOUND_ROWS wp_posts.*, yarpp.score FROM wp_posts join wp_yarpp_related_cache as yarpp on wp_posts.ID = yarpp.ID WHERE 1=1 AND yarpp.score >= 5 and yarpp.reference_ID = 820 AND wp_posts.post_type IN ('post', 'page') ORDER BY yarpp.score DESC limit 5
Popularity: 9% [?]
No related posts.
Related posts brought to you by Yet Another Related Posts Plugin.
