WordPress database error: [Table 'd60557633.wp_yarpp_related_cache' doesn't exist]
select count(*) as count from wp_yarpp_related_cache where reference_ID = 450
WordPress database error: [Table 'd60557633.wp_yarpp_keyword_cache' doesn't exist]
insert into wp_yarpp_keyword_cache (ID,body,title) values (450,'everything once settles expect thanks posts busy ive post havent lately spring started quarter sorry ','quarter spring ') on duplicate key update date = now(), body = 'everything once settles expect thanks posts busy ive post havent lately spring started quarter sorry ', title = 'quarter spring '
WordPress database error: [Table 'd60557633.wp_yarpp_related_cache' doesn't exist]
delete from wp_yarpp_related_cache where reference_ID in (450)
WordPress database error: [Table 'd60557633.wp_yarpp_keyword_cache' doesn't exist]
select body from wp_yarpp_keyword_cache where ID = 450
WordPress database error: [Table 'd60557633.wp_yarpp_keyword_cache' doesn't exist]
insert into wp_yarpp_keyword_cache (ID,body,title) values (450,'everything once settles expect thanks posts busy ive post havent lately spring started quarter sorry ','quarter spring ') on duplicate key update date = now(), body = 'everything once settles expect thanks posts busy ive post havent lately spring started quarter sorry ', title = 'quarter spring '
WordPress database error: [Table 'd60557633.wp_yarpp_keyword_cache' doesn't exist]
select body from wp_yarpp_keyword_cache where ID = 450
WordPress database error: [Table 'd60557633.wp_yarpp_keyword_cache' doesn't exist]
select title from wp_yarpp_keyword_cache where ID = 450
WordPress database error: [Table 'd60557633.wp_yarpp_keyword_cache' doesn't exist]
insert into wp_yarpp_keyword_cache (ID,body,title) values (450,'everything once settles expect thanks posts busy ive post havent lately spring started quarter sorry ','quarter spring ') on duplicate key update date = now(), body = 'everything once settles expect thanks posts busy ive post havent lately spring started quarter sorry ', title = 'quarter spring '
WordPress database error: [Table 'd60557633.wp_yarpp_keyword_cache' doesn't exist]
select title from wp_yarpp_keyword_cache where ID = 450
WordPress database error: [Table 'd60557633.wp_yarpp_related_cache' doesn't exist]
insert into wp_yarpp_related_cache (reference_ID,ID,score) (SELECT 450, ID, (0+ (MATCH (post_content) AGAINST ('')) * 3+ (MATCH (post_title) AGAINST ('')) * 3+ COUNT( DISTINCT tagtax.term_taxonomy_id ) * 1+ COUNT( DISTINCT cattax.term_taxonomy_id ) * 1) as score
from wp_posts
left JOIN wp_term_relationships AS thistag ON (thistag.object_id = 450 )
left JOIN wp_term_relationships AS tagrel on (tagrel.term_taxonomy_id = thistag.term_taxonomy_id
AND tagrel.object_id = wp_posts.ID)
left JOIN wp_term_taxonomy AS tagtax ON ( tagrel.term_taxonomy_id = tagtax.term_taxonomy_id
AND tagtax.taxonomy = 'post_tag')
left JOIN wp_term_relationships AS thiscat ON (thiscat.object_id = 450 )
left JOIN wp_term_relationships AS catrel on (catrel.term_taxonomy_id = thiscat.term_taxonomy_id
AND catrel.object_id = wp_posts.ID)
left JOIN wp_term_taxonomy AS cattax ON ( catrel.term_taxonomy_id = cattax.term_taxonomy_id
AND cattax.taxonomy = 'category')
where (post_status IN ( 'publish', 'static' ) and ID != '450') and post_password ='' and post_type = 'post'
group by id
having score >= 5.00 order by score desc limit 5) union (SELECT 450, ID, (0+ (MATCH (post_content) AGAINST ('')) * 3+ (MATCH (post_title) AGAINST ('')) * 3+ COUNT( DISTINCT tagtax.term_taxonomy_id ) * 1+ COUNT( DISTINCT cattax.term_taxonomy_id ) * 1) as score
from wp_posts
left JOIN wp_term_relationships AS thistag ON (thistag.object_id = 450 )
left JOIN wp_term_relationships AS tagrel on (tagrel.term_taxonomy_id = thistag.term_taxonomy_id
AND tagrel.object_id = wp_posts.ID)
left JOIN wp_term_taxonomy AS tagtax ON ( tagrel.term_taxonomy_id = tagtax.term_taxonomy_id
AND tagtax.taxonomy = 'post_tag')
left JOIN wp_term_relationships AS thiscat ON (thiscat.object_id = 450 )
left JOIN wp_term_relationships AS catrel on (catrel.term_taxonomy_id = thiscat.term_taxonomy_id
AND catrel.object_id = wp_posts.ID)
left JOIN wp_term_taxonomy AS cattax ON ( catrel.term_taxonomy_id = cattax.term_taxonomy_id
AND cattax.taxonomy = 'category')
where (post_status IN ( 'publish', 'static' ) and ID != '450') and post_password ='' and post_type = 'page'
group by id
having score >= 5.00 order by score desc limit 5) on duplicate key update date = now()
WordPress database error: [Table 'd60557633.wp_yarpp_related_cache' doesn't exist]
insert into wp_yarpp_related_cache (reference_ID,ID,score) values (450,0,0) on duplicate key update date = now()
WordPress database error: [Table 'd60557633.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 = 450 AND wp_posts.post_type IN ('post', 'page') ORDER BY yarpp.score DESC limit 5
Sorry I haven’t had time to post lately since my spring quarter just started and I’ve been pretty busy. But once everything settles down expect a lot more posts.
Thanks =]
No related posts.
Discussion
No comments for “Spring Quarter”
Post a comment