Trashing The Boss on a Friday
WordPress database error: [Table 'prime_wp2.wp_yarpp_related_cache' doesn't exist]
select count(*) as count from wp_yarpp_related_cache where reference_ID = 68 and date > date_sub(now(),interval 600 minute)
WordPress database error: [You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'on duplicate key update date = now(), body = 'office house clea]
insert into wp_yarpp_keyword_cache (ID,body,title) values (68,'office house cleaning friday normal garbages item gathered instead photos great smell nice stacked taking dumpster team prospect stories cant ','friday boss trashing ') on duplicate key update date = now(), body = 'office house cleaning friday normal garbages item gathered instead photos great smell nice stacked taking dumpster team prospect stories cant ', title = 'friday boss trashing '
WordPress database error: [Table 'prime_wp2.wp_yarpp_related_cache' doesn't exist]
select ID from wp_yarpp_related_cache where reference_ID = 68 and ID != 0
WordPress database error: [Table 'prime_wp2.wp_yarpp_related_cache' doesn't exist]
delete from wp_yarpp_related_cache where reference_ID = 68
WordPress database error: [Table 'prime_wp2.wp_yarpp_keyword_cache' doesn't exist]
select body from wp_yarpp_keyword_cache where ID = 68
WordPress database error: [You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'on duplicate key update date = now(), body = 'office house clea]
insert into wp_yarpp_keyword_cache (ID,body,title) values (68,'office house cleaning friday normal garbages item gathered instead photos great smell nice stacked taking dumpster team prospect stories cant ','friday boss trashing ') on duplicate key update date = now(), body = 'office house cleaning friday normal garbages item gathered instead photos great smell nice stacked taking dumpster team prospect stories cant ', title = 'friday boss trashing '
WordPress database error: [Table 'prime_wp2.wp_yarpp_keyword_cache' doesn't exist]
select body from wp_yarpp_keyword_cache where ID = 68
WordPress database error: [Table 'prime_wp2.wp_yarpp_keyword_cache' doesn't exist]
select title from wp_yarpp_keyword_cache where ID = 68
WordPress database error: [You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'on duplicate key update date = now(), body = 'office house clea]
insert into wp_yarpp_keyword_cache (ID,body,title) values (68,'office house cleaning friday normal garbages item gathered instead photos great smell nice stacked taking dumpster team prospect stories cant ','friday boss trashing ') on duplicate key update date = now(), body = 'office house cleaning friday normal garbages item gathered instead photos great smell nice stacked taking dumpster team prospect stories cant ', title = 'friday boss trashing '
WordPress database error: [Table 'prime_wp2.wp_yarpp_keyword_cache' doesn't exist]
select title from wp_yarpp_keyword_cache where ID = 68
WordPress database error: [You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'on duplicate key update date = now()' at line 15]
insert into wp_yarpp_related_cache (reference_ID,ID,score) SELECT 68, ID, (0+ 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 = 68 )
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 = 68 )
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 != '68') and post_date <= NOW() and post_password ='' and post_date > date_sub(now(), interval 12 month) and post_type IN ('post', 'page')
group by id
having score >= 2.5 order by score desc limit 5 on duplicate key update date = now()
WordPress database error: [Table 'prime_wp2.wp_yarpp_related_cache' doesn't exist]
insert into wp_yarpp_related_cache (reference_ID,ID,score) values (68,0,0)
WordPress database error: [You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'using (ID) WHERE 1=1 AND yarpp.score > 5 and yarpp.reference_I]
SELECT SQL_CALC_FOUND_ROWS wp_posts.*, yarpp.score FROM wp_posts join wp_yarpp_related_cache as yarpp using (ID) WHERE 1=1 AND yarpp.score > 5 and yarpp.reference_ID = 68 AND wp_posts.post_type = 'post' and post_date > date_sub(now(), interval 12 month) ORDER BY yarpp.score DESC limit 5
I like to pull a few pranks and have some fun at other peoples expense, most of those stories can’t be told on this blog. Sometimes the tables turn on you when you partake in these kinds of activities. While I was out meeting with a prospect, my team gathered all the garbages in our office … which is a normal Friday house cleaning item … but instead of taking them to the dumpster, they stacked them in my office. They were even nice enough to take photos.
What a great smell my office has now.
No related posts.
Posted on May 18th, 2007 by Jeff Wagner
Filed under: office
If you like what you're reading, please subscribe to this blog.
I don’t think he’ll be scheduling any meetings at 3pm on Friday’s anymore.
Hey – that’s why I got out of the corporate world to work virtually from my home office for myself!
Caroline
[...] brand. On the Prime Advertising & Design blog, Aaron does a great job of mixing up posts about their office, with posts about their involvement with the community, announcements of new projects, and articles [...]