Prime Wins a COTY Award at 2007 NARI Event
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 = 141 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 = 'coty remodeling m]
insert into wp_yarpp_keyword_cache (ID,body,title) values (141,'coty remodeling mark award year event holtan jody clients nari great paramount awards industry design murray received people mcnamara center ','nari event 2007 award wins coty prime ') on duplicate key update date = now(), body = 'coty remodeling mark award year event holtan jody clients nari great paramount awards industry design murray received people mcnamara center ', title = 'nari event 2007 award wins coty prime '
WordPress database error: [Table 'prime_wp2.wp_yarpp_related_cache' doesn't exist]
select ID from wp_yarpp_related_cache where reference_ID = 141 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 = 141
WordPress database error: [Table 'prime_wp2.wp_yarpp_keyword_cache' doesn't exist]
select body from wp_yarpp_keyword_cache where ID = 141
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 = 'coty remodeling m]
insert into wp_yarpp_keyword_cache (ID,body,title) values (141,'coty remodeling mark award year event holtan jody clients nari great paramount awards industry design murray received people mcnamara center ','nari event 2007 award wins coty prime ') on duplicate key update date = now(), body = 'coty remodeling mark award year event holtan jody clients nari great paramount awards industry design murray received people mcnamara center ', title = 'nari event 2007 award wins coty prime '
WordPress database error: [Table 'prime_wp2.wp_yarpp_keyword_cache' doesn't exist]
select body from wp_yarpp_keyword_cache where ID = 141
WordPress database error: [Table 'prime_wp2.wp_yarpp_keyword_cache' doesn't exist]
select title from wp_yarpp_keyword_cache where ID = 141
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 = 'coty remodeling m]
insert into wp_yarpp_keyword_cache (ID,body,title) values (141,'coty remodeling mark award year event holtan jody clients nari great paramount awards industry design murray received people mcnamara center ','nari event 2007 award wins coty prime ') on duplicate key update date = now(), body = 'coty remodeling mark award year event holtan jody clients nari great paramount awards industry design murray received people mcnamara center ', title = 'nari event 2007 award wins coty prime '
WordPress database error: [Table 'prime_wp2.wp_yarpp_keyword_cache' doesn't exist]
select title from wp_yarpp_keyword_cache where ID = 141
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 141, 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 = 141 )
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 = 141 )
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 != '141') 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 (141,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 = 141 AND wp_posts.post_type = 'post' and post_date > date_sub(now(), interval 12 month) ORDER BY yarpp.score DESC limit 5
We were honored Wednesday night to be the recipient of the 2007 Professional Service Provider of the Year COTY Award from the Minnesota chapter of the National Association of the Remodeling Industry. Prime has multiple clients in the remodeling industry including NARI members Vision Remodeling, Advanced Home Improvement, Select Integrated Systems and Paramount Granite. The COTY awards are the Contractor Of The Year awards in various categories of remodeling projects and associated services. The event is held at the McNamara Alumni Center at the University of Minnesota and had over 500 people in attendance.
Our company President and owner Mark Murray received the award on stage as WCCO News anchor Frank Vascellaro emceed the event again this year. As you can see from the photo above myself and Jody Niskanen were also present. Jody has been very involved with NARI for the past year and even donated her time to the COTY event planning and execution this year. No doubt that her interaction and dedication aided in our recognition.
We had the pleasure of sitting with Keith Holtan of Holtan Kitchens and Remodeling and his two staff members. It was fun getting to know another talented and award winning remodeler as Holtan received the COTY Honorable Mention Award in the category for Bathroom Remodeling Project over $60,000. Wow!
You can view the entire list of COTY winners and some more photos of us at Paramount Granite’s Blog, Barb does a great job of small business blogging as well!
It’s great to be recognized for the hard work and dedication we give our clients. For many construction industry clients we provide web design and hosting services, logo design, print and brochure design, video testimonials, blogs and more. The synergy of managing so many of their marketing tools together allows us to work closely with them on growing their business.
Here are the rest of the photos I managed to snap from the night. As you can see, it’s a large event with great people and a ton of fun.
A packed McNamara Center for the NARI COTY awards
WCCO TV News anchor Frank Vascellaro & Prime’s CEO Mark Murray
Mark hits the stage to accept our 2007 COTY award
Jeff Warner, President of Warners’ Stellian with Mark
The ladies of Paramount Granite Company – Angie, Anita & Barb
The Vision Remodeling Crew with Jody and Mark
No related posts.
Posted on November 8th, 2007 by Jeff Wagner
Filed under: office, prime clients, prime news, teamwork
If you like what you're reading, please subscribe to this blog.
Great job Prime Advertising!
Thanks Barb – You’re a driving reason behind our participation, succcess and we have a blast hanging out with you at the annual event as well!
Congratulations on your continued success!
Thanks Jason. How about that CUhire project? That will be something to post about!
Absolutely! We cannot wait – your team has done an amazing job.