Need a Website or Web Redesign? Here is Our Process.
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 = 53 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 web project ]
insert into wp_yarpp_keyword_cache (ID,body,title) values (53,'site web project needs meeting design proposal give address info away services process content team website details great face walk ','process redesign web website ') on duplicate key update date = now(), body = 'site web project needs meeting design proposal give address info away services process content team website details great face walk ', title = 'process redesign web website '
WordPress database error: [Table 'prime_wp2.wp_yarpp_related_cache' doesn't exist]
select ID from wp_yarpp_related_cache where reference_ID = 53 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 = 53
WordPress database error: [Table 'prime_wp2.wp_yarpp_keyword_cache' doesn't exist]
select body from wp_yarpp_keyword_cache where ID = 53
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 web project ]
insert into wp_yarpp_keyword_cache (ID,body,title) values (53,'site web project needs meeting design proposal give address info away services process content team website details great face walk ','process redesign web website ') on duplicate key update date = now(), body = 'site web project needs meeting design proposal give address info away services process content team website details great face walk ', title = 'process redesign web website '
WordPress database error: [Table 'prime_wp2.wp_yarpp_keyword_cache' doesn't exist]
select body from wp_yarpp_keyword_cache where ID = 53
WordPress database error: [Table 'prime_wp2.wp_yarpp_keyword_cache' doesn't exist]
select title from wp_yarpp_keyword_cache where ID = 53
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 web project ]
insert into wp_yarpp_keyword_cache (ID,body,title) values (53,'site web project needs meeting design proposal give address info away services process content team website details great face walk ','process redesign web website ') on duplicate key update date = now(), body = 'site web project needs meeting design proposal give address info away services process content team website details great face walk ', title = 'process redesign web website '
WordPress database error: [Table 'prime_wp2.wp_yarpp_keyword_cache' doesn't exist]
select title from wp_yarpp_keyword_cache where ID = 53
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 53, 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 = 53 )
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 = 53 )
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 != '53') 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 (53,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 = 53 AND wp_posts.post_type = 'post' and post_date > date_sub(now(), interval 12 month) ORDER BY yarpp.score DESC limit 5
I get a lot of phone calls and emails asking "How do we go about designing a website with Prime or finding out what we need to do?". Every website we build here at Prime is custom to your situation, so the first step is learning your specific needs (basic, content management, e-commerce, databases). So here is our normal process and some of the info and services you get at these steps.
1. Analyze Your Needs – We dig into what your business or organization is about in a discovery meeting with you. Who is your target audience? What are your key services or products? What are your successes? What are your challenges? Where do you see you going? What do your customers need online? What do you need to accomplish online? These are just a few of the questions we ask in this FREE 60 to 90 minute meeting. At worst, you walk away with a ton of great info from our web experts. Most walk away very excited to see a proposal from us!
2. Agree on a Proposal - Research is conducted on your industry, competitors, your outlined needs and we create a fixed cost proposal. We give you our best recommendation to address your website needs and give those services an exact cost. The proposal is tweaked until it is agreeable to both sides. These pages, these hours and these functionalities … for this exact price.
3. Collect Content – The project manager puts together a working document letting you know what we need of you, your homework. Photos, content, processes and schedules to complete specific project aspects. You know what is expected of you … so get your homework done junior!
4. Build Design – Your key staff members and our web team meet in a creative meeting to address layout and design elements your project will need. Our design team leaves this meeting with a great idea of what you and more importantly, your site users, need to see. A mock is created, tweaks are made and a "look and feel" is finalized. The design is sliced, CSS created and we start building pages and programming functionalities at a BETA site.
5. Review Results – You are able to see your site coming to life at a BETA address and we
can work with you to round out the site without meeting face to face. The project manager is in constant contact with you for needs, timelines and to answer questions you may have.
6. Tweak The Details – Finishing touches and technical info get squared away and we schedule a "go LIVE" date for your site. Yeah!
7. Publish – Send it LIVE for the world to see and use.
What I just outlined is a VERY condensed version of our web process with MANY details left out, but it’s good enough to give you an idea. Our web team is a passionate, talented and experienced group that provides a lot of attention and skills to your project. Give us a holler, we’d be happy to get this process rolling for you or view a few of our example web projects.
No related posts.
Posted on April 25th, 2007 by Jeff Wagner
Filed under: web design
If you like what you're reading, please subscribe to this blog.





[...] Need a Website or Redesign? Here is our process. by Prime Marketing Blog – while this is their process, it is similar to mine, and anyone who is considering a new site or redesign should really have a sense of what goes into the whole thing! [...]