WordPress database error: [Table 'd60557633.wp_yarpp_related_cache' doesn't exist]
select count(*) as count from wp_yarpp_related_cache where reference_ID = 63
WordPress database error: [Table 'd60557633.wp_yarpp_keyword_cache' doesn't exist]
insert into wp_yarpp_keyword_cache (ID,body,title) values (63,'freshies advice experience college ','advice ') on duplicate key update date = now(), body = 'freshies advice experience college ', title = 'advice '
WordPress database error: [Table 'd60557633.wp_yarpp_related_cache' doesn't exist]
delete from wp_yarpp_related_cache where reference_ID in (63)
WordPress database error: [Table 'd60557633.wp_yarpp_keyword_cache' doesn't exist]
select body from wp_yarpp_keyword_cache where ID = 63
WordPress database error: [Table 'd60557633.wp_yarpp_keyword_cache' doesn't exist]
insert into wp_yarpp_keyword_cache (ID,body,title) values (63,'freshies advice experience college ','advice ') on duplicate key update date = now(), body = 'freshies advice experience college ', title = 'advice '
WordPress database error: [Table 'd60557633.wp_yarpp_keyword_cache' doesn't exist]
select body from wp_yarpp_keyword_cache where ID = 63
WordPress database error: [Table 'd60557633.wp_yarpp_keyword_cache' doesn't exist]
select title from wp_yarpp_keyword_cache where ID = 63
WordPress database error: [Table 'd60557633.wp_yarpp_keyword_cache' doesn't exist]
insert into wp_yarpp_keyword_cache (ID,body,title) values (63,'freshies advice experience college ','advice ') on duplicate key update date = now(), body = 'freshies advice experience college ', title = 'advice '
WordPress database error: [Table 'd60557633.wp_yarpp_keyword_cache' doesn't exist]
select title from wp_yarpp_keyword_cache where ID = 63
WordPress database error: [Table 'd60557633.wp_yarpp_related_cache' doesn't exist]
insert into wp_yarpp_related_cache (reference_ID,ID,score) (SELECT 63, 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 = 63 )
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 = 63 )
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 != '63') and post_password ='' and post_type = 'post'
group by id
having score >= 5.00 order by score desc limit 5) union (SELECT 63, 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 = 63 )
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 = 63 )
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 != '63') 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 (63,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 = 63 AND wp_posts.post_type IN ('post', 'page') ORDER BY yarpp.score DESC limit 5
Some more good advice for freshies. Here
No related posts.
Discussion
No comments for “More advice…”
Post a comment