WordPress database error: [Table 'rhythmic_raj.wp_yarpp_related_cache' doesn't exist]
select min(ID) as min_id from wp_yarpp_related_cache where reference_ID = 75
WordPress database error: [Table 'rhythmic_raj.wp_yarpp_related_cache' doesn't exist]
select distinct ID from wp_yarpp_related_cache where reference_ID = 75 and ID != 0
WordPress database error: [Table 'rhythmic_raj.wp_yarpp_related_cache' doesn't exist]
delete from wp_yarpp_related_cache where reference_ID = 75
WordPress database error: [Table 'rhythmic_raj.wp_yarpp_keyword_cache' doesn't exist]
delete from wp_yarpp_keyword_cache where ID = 75
WordPress database error: [Table 'rhythmic_raj.wp_yarpp_keyword_cache' doesn't exist]
select body, title from wp_yarpp_keyword_cache where ID = 75
WordPress database error: [Table 'rhythmic_raj.wp_yarpp_keyword_cache' doesn't exist]
insert into wp_yarpp_keyword_cache (ID,body,title) values (75,'of and was in this for lot the tomorrow things now start period thought clarity blogworthy happened writing during ll ','downs and ups ') on duplicate key update date = now(), body = 'of and was in this for lot the tomorrow things now start period thought clarity blogworthy happened writing during ll ', title = 'downs and ups '
WordPress database error: [Table 'rhythmic_raj.wp_yarpp_related_cache' doesn't exist]
insert into wp_yarpp_related_cache (reference_ID,ID,score) (SELECT 75 as reference_ID, ID, ROUND(0 + (MATCH (post_content) AGAINST ('of and was in this for lot the tomorrow things now start period thought clarity blogworthy happened writing during ll')) * 1 + (MATCH (post_title) AGAINST ('downs and ups')) * 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 = 75 )
where post_status in ( 'publish', 'static' ) and ID != '75' 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 75 as reference_ID, ID, ROUND(0 + (MATCH (post_content) AGAINST ('of and was in this for lot the tomorrow things now start period thought clarity blogworthy happened writing during ll')) * 1 + (MATCH (post_title) AGAINST ('downs and ups')) * 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 = 75 )
where post_status in ( 'publish', 'static' ) and ID != '75' 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 'rhythmic_raj.wp_yarpp_related_cache' doesn't exist]
select distinct ID from wp_yarpp_related_cache where reference_ID = 75 and ID != 0
WordPress database error: [Table 'rhythmic_raj.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 = 75 AND wp_posts.post_type IN ('post', 'page') ORDER BY yarpp.score DESC limit 5
For the first time since I became a regular blogger, I did not post anything for three days. This was because a lot of things were happening in my life and I was very confused. But that phase has passed and I finally have clarity of thought now.
A lot of blogworthy things happened during this period. I’ll start writing about them from tomorrow. Right now, I am in the midst of creating a presentation on ORM/ Hibernate and JDO.
C ya tomorrow ….
I guess we were on the same boat last week.
@Vinaya: Yeah, i think so too.