Recent Website Redesign & Remodels!!
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 = 166 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 = 'site remodeling b]
insert into wp_yarpp_keyword_cache (ID,body,title) values (166,'site remodeling before important irish below specials allow smc client week photos updating events transformation pub visual work usability update ','remodels redesign website recent ') on duplicate key update date = now(), body = 'site remodeling before important irish below specials allow smc client week photos updating events transformation pub visual work usability update ', title = 'remodels redesign website recent '
WordPress database error: [Table 'prime_wp2.wp_yarpp_related_cache' doesn't exist]
select ID from wp_yarpp_related_cache where reference_ID = 166 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 = 166
WordPress database error: [Table 'prime_wp2.wp_yarpp_keyword_cache' doesn't exist]
select body from wp_yarpp_keyword_cache where ID = 166
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 = 'site remodeling b]
insert into wp_yarpp_keyword_cache (ID,body,title) values (166,'site remodeling before important irish below specials allow smc client week photos updating events transformation pub visual work usability update ','remodels redesign website recent ') on duplicate key update date = now(), body = 'site remodeling before important irish below specials allow smc client week photos updating events transformation pub visual work usability update ', title = 'remodels redesign website recent '
WordPress database error: [Table 'prime_wp2.wp_yarpp_keyword_cache' doesn't exist]
select body from wp_yarpp_keyword_cache where ID = 166
WordPress database error: [Table 'prime_wp2.wp_yarpp_keyword_cache' doesn't exist]
select title from wp_yarpp_keyword_cache where ID = 166
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 = 'site remodeling b]
insert into wp_yarpp_keyword_cache (ID,body,title) values (166,'site remodeling before important irish below specials allow smc client week photos updating events transformation pub visual work usability update ','remodels redesign website recent ') on duplicate key update date = now(), body = 'site remodeling before important irish below specials allow smc client week photos updating events transformation pub visual work usability update ', title = 'remodels redesign website recent '
WordPress database error: [Table 'prime_wp2.wp_yarpp_keyword_cache' doesn't exist]
select title from wp_yarpp_keyword_cache where ID = 166
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 166, 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 = 166 )
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 = 166 )
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 != '166') 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 (166,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 = 166 AND wp_posts.post_type = 'post' and post_date > date_sub(now(), interval 12 month) ORDER BY yarpp.score DESC limit 5
Over the past few weeks, the web team has been back in our little corner of Prime, completing some website redesigns & remodels! Below I have featured two of our most recent remodels!!
Vision Remodeling
Vision Remodeling is a Twin Cities area home remodeling company providing exceptional craftsmanship in their work. In our "remodel" of their website, we did a complete redesign. We took their site to a wider design, providing more space to showcase larger photos of their remodeling projects. Additional, we moved the client to the SMC which would allow for more ease in updating their site regularly. Vision Remodeling participates in many remodeling events throughout MN & is in the media quite often for their work, so it was very important that there site be very easy to update!! You can check out the visual transformation with the before & after below:
Before:
After:
Kieran’s Irish Pub
Kieran’s Irish Pub, is a traditional Irish Pub located downtown Minneapolis. They came to us to improve the visual appeal of the site, but to also increase the functionality & usability of their site. The Site Management Console (SMC) was one of the most important pieces to the client. The ability to update their site with food specials, music events & happy hour each day was crucial to them. We built in a function to allow them to enter their specials in at the beginning of each week, and as a day would pass, the old specials would leave & the new ones appear.
The other very important piece for Kieran’s was updating their photo gallery frequently. As you can see, being just a week later, they already have the St. Patrick’s Day photos up for everyone to enjoy & look back fondly on!! You can check out the transformation of this site below in the before & afters!
Before:
After:
If you are looking for a change to the look, feel & usability of your site, give Prime a call!
No related posts.
Posted on March 25th, 2008 by Janna
Filed under: design, prime clients, web design
If you like what you're reading, please subscribe to this blog.
The Ability to Update!
“The Site Management Console (SMC) was one of the most important pieces to the client.” SMC functionality is were corporate sites have to go to remain relevant and focused on strategy. We have upgraded with http://www.bitrix.com and plan to advance with their 7.0 in May. The nibleness you describe is critical to making our website a news site and not just ancient history.