SEOClerks

website improvements

website improvements

We are interested in what you might have to offer.

Our website is: www.nwm-usa.com . We need the following to be done for our website, Adwords, Analytics and WordPress accounts:
We need keyword search, SEO meta data and site optimization done for the above website.
We need our new website hooked up to our Google Analytics account.
We need our company summary attached to the initial Google search of the company name (instead of random wording).
We need to fix our WordPress account so that the blogs are being entered into the right tab on the website.
We need to fix the language glitch on our website (switching between German and English)
We need to fix some small structure problems (deleting/removing some wording and images) & changing wordings.
Start up our Google Adwords to set up campaigns
Come up with good SEO strategies
We need to optimize page titles, body text, anchor/bold text, H1 headings and more…
Can you please send a quote for the following. I look forward to your response.

Best Regards,


Requirements

web design


Skills Required

Web Design

Bids

just provide me website i will seo optimized and do google analysis for your website and fix tweaks and also advertise with 16 million usa emails list.(if needed).

regards

i can help you to improve your website. you always contact and discuss with me through skype. also i have a own website: http://www.bdtipsntricks.com/

you can check my site and see that all i have designed fixed by myself. all the improvements will be done within a week.

hi, i have a lot of experience with wordpress, i can make the changes.
my current wordpress sites-
www.bitdoz.com
www.photo-roll.com
www.sachinverma.net

hello friend,
i carefully studied your requirement. as i am good in php, wordpress and smarty, i am placing bid here. your job is more close to php and wordpress. i have done various major project in wordpress and php. so you have most welcome to order. as your rate is ok, i am ready to do this project.
to check my skill , go through

hire me and i will do all that you need

Bid On Listing Created 12 years ago in Design

Other jobs by xficinox

Order Now
Process Time: 0.081006050109863

Possible Duplicate queries found!
MatchCountSQLScript
SELECT * FROM wanttobuy A, categories_wanttobuy B, seoclerks.members C WHERE A.wantid='9770' AND A.category=B.CATID AND A.USERID=C.USERID1SELECT A.*, B.name, B.seo, C.username, C.userlevel, C.footer_code, C.rating, C.ratingcount, C.googleplus_profile, C.total_recommendations, C.USERID, C.profilepicture, C.average_response_time, C.lastlogin, C.addtime FROM wanttobuy A, categories_wanttobuy B, seoclerks.members C WHERE A.wantid='9770' AND A.category=B.CATID AND A.USERID=C.USERID

/opt/clerks-staging/docroot/viewwant.php 163 () ()

SELECT * FROM seoclerks.members_recommendations WHERE USERID=16566 AND status=1 ORDER BY MRID DESC limit 11SELECT recommendation_text, FROMID, time_added FROM seoclerks.members_recommendations WHERE USERID=16566 AND status=1 ORDER BY MRID DESC limit 1

/opt/clerks-staging/docroot/include/functions/main.php 21955 getLastRecommendation() ()

SELECT * FROM seoclerks.members WHERE USERID='200392'1SELECT username FROM seoclerks.members WHERE USERID='200392'

/opt/clerks-staging/docroot/include/functions/main.php 1577 insert_get_username_from_userid() ()

SELECT * FROM ratings_buyer WHERE USERID=165661SELECT sum(good) as thumbup, sum(bad) as thumbdown FROM ratings_buyer WHERE USERID=16566

/opt/clerks-staging/docroot/include/functions/main.php 19523 GetRatingsAsBuyerTotal() ()

SELECT * FROM wanttobuy A, categories_wanttobuy B WHERE A.wantid != 9770 AND A.category=B.CATID AND A.active=1 AND (A.tags like '%Web Design%' ) LIMIT 41SELECT A.wantid, A.title, A.p1, A.maxprice, B.name, B.seo FROM wanttobuy A, categories_wanttobuy B WHERE A.wantid != 9770 AND A.category=B.CATID AND A.active=1 AND (A.tags like '%Web Design%' ) LIMIT 4

/opt/clerks-staging/docroot/viewwant.php 551 () ()

SELECT * FROM wanttobuy A, categories_wanttobuy B WHERE A.wantid != 9770 AND A.category=B.CATID AND A.active=1 AND A.USERID=16566 LIMIT 41SELECT A.wantid, A.title, A.p1, A.maxprice, B.name, B.seo FROM wanttobuy A, categories_wanttobuy B WHERE A.wantid != 9770 AND A.category=B.CATID AND A.active=1 AND A.USERID=16566 LIMIT 4

/opt/clerks-staging/docroot/viewwant.php 568 () ()

SELECT * FROM wantcomments a, seoclerks.members b WHERE a.PID='9770' AND a.USERID=b.USERID and b.status='1' AND a.status=1 order by a.CID asc1SELECT a.comment, a.USERID, a.CID, a.time_added, a.istranslated, a.parentid, b.username, b.profilepicture FROM wantcomments a, seoclerks.members b WHERE a.PID='9770' AND a.USERID=b.USERID and b.status='1' AND a.status=1 order by a.CID asc

/opt/clerks-staging/docroot/viewwant.php 835 () ()

UPDATE wanttobuy SET viewcount = viewcount + 1 WHERE wantid='9770'1UPDATE wanttobuy SET viewcount = viewcount + 1 WHERE wantid='9770'

/opt/clerks-staging/docroot/include/functions/main.php 1729 update_wantviewcount() ()

SELECT * FROM wantbids as w, seoclerks.members AS m WHERE w.active=1 AND m.USERID=w.USERID AND m.status=1 AND w.USERID>0 AND w.wantid='9770' ORDER BY w.bidid ASC 1SELECT w.bidid, w.PID, w.comment, w.title, w.pricepublic, w.USERID, w.adjustedprice, w.ip, m.profilepicture FROM wantbids as w, seoclerks.members AS m WHERE w.active=1 AND m.USERID=w.USERID AND m.status=1 AND w.USERID>0 AND w.wantid='9770' ORDER BY w.bidid ASC

/opt/clerks-staging/docroot/viewwant.php 1192 () ()

SELECT * FROM seoclerks.members as m WHERE m.USERID=866131SELECT m.username, m.skills, m.userlevel, m.ip, m.total_recommendations FROM seoclerks.members as m WHERE m.USERID=86613

/opt/clerks-staging/docroot/viewwant.php 1258 () ()

SELECT * FROM seoclerks.members as m WHERE m.USERID=680511SELECT m.username, m.skills, m.userlevel, m.ip, m.total_recommendations FROM seoclerks.members as m WHERE m.USERID=68051

/opt/clerks-staging/docroot/viewwant.php 1258 () ()

SELECT * FROM seoclerks.members as m WHERE m.USERID=70271SELECT m.username, m.skills, m.userlevel, m.ip, m.total_recommendations FROM seoclerks.members as m WHERE m.USERID=7027

/opt/clerks-staging/docroot/viewwant.php 1258 () ()

SELECT * FROM seoclerks.members as m WHERE m.USERID=669321SELECT m.username, m.skills, m.userlevel, m.ip, m.total_recommendations FROM seoclerks.members as m WHERE m.USERID=66932

/opt/clerks-staging/docroot/viewwant.php 1258 () ()

SELECT * FROM seoclerks.members as m WHERE m.USERID=1026941SELECT m.username, m.skills, m.userlevel, m.ip, m.total_recommendations FROM seoclerks.members as m WHERE m.USERID=102694

/opt/clerks-staging/docroot/viewwant.php 1258 () ()

SELECT * FROM categories_wanttobuy1SELECT * FROM categories_wanttobuy

/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() parseRedundantQueriesCache()

SELECT * FROM posts WHERE USERID=165661SELECT sum(positive_ratings) as thumbup, sum(negative_ratings) as thumbdown FROM posts WHERE USERID=16566

/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() GetBuyerRatingsTotal()

SELECT * FROM categories1SELECT * FROM categories

/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() parseRedundantQueriesCache()

select * from categories_software order by name asc1select * from categories_software order by name asc

/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_GetSoftwareCategories()

select * from categories_wanttobuy order by name asc1select * from categories_wanttobuy order by name asc

/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_get_wantcategories()

select * from categories_wanttotrade order by name asc1select * from categories_wanttotrade order by name asc

/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_get_tradecategories()

SELECT * FROM seoclerks.members WHERE USERID='86613'1SELECT profilepicture FROM seoclerks.members WHERE USERID='86613'

/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage()

SELECT * FROM seoclerks.members WHERE USERID='68051'1SELECT profilepicture FROM seoclerks.members WHERE USERID='68051'

/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage()

SELECT * FROM seoclerks.members WHERE USERID='7027'1SELECT profilepicture FROM seoclerks.members WHERE USERID='7027'

/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage()

SELECT * FROM seoclerks.members WHERE USERID='66932'1SELECT profilepicture FROM seoclerks.members WHERE USERID='66932'

/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage()

SELECT * FROM seoclerks.members WHERE USERID='102694'1SELECT profilepicture FROM seoclerks.members WHERE USERID='102694'

/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage()

SELECT * FROM seoclerks.members WHERE USERID='16566'1SELECT profile_data FROM seoclerks.members WHERE USERID='16566'

/opt/clerks-staging/docroot/include/functions/main.php 1927 getUserBackground() include()

Invalid SQL

count(*)sql1error_msg

Expensive SQL

Tuning the following SQL could reduce the server load substantially
LoadCountSQLMaxMin

Suspicious SQL

The following SQL have high average execution times
Avg TimeCountSQLMaxMin