Hello! At first, please ignore the price tag that I have put into this WTB. This gig is not a one time gig and the person who will get selected will get to work with my company for a long time. Anyway, we have started a local online service and we need to rank the website on the top of the google. We are not looking for guess work and we need a legit SEO specialist who can get us to the first page result in Google. The keywords we wants rank is low competition. Besides doing SEO, it'd be great if you can advice us on how to optimize our site(SEO wise) and all. We can work like partners and this relationship will be a good investment for both company and you. Please drop me a message if you think you're the one who qualified and if you have enough confidence about your SEO skills.
SEO Specialist.
Fluent in English.
Guaranteed results.
Responsiveness.
seo specialist.
fluent in english.
guaranteed results.
responsiveness.
our 100 % quality work speaks about our major / key services
we will implement white hat seo
hi there,
i found your job posting and i think i'd be a great fit.
we have 5+ years of experience in the field of seo, smo, smm, ppc, orm.
we have a dedicated team of highly qualified and experienced professionals for each project.
my rate is usually fix but i can be flexible based on your needs.
i'd lo
hi,
we are an seo expert and we have 10+ year experience in seo, link building, keyword research, article writing, email marketing, black-hat & white-hat & gray-hat methods link building, and social media marketing "facebook, google plus and twitter,etc..". we have done both on page and off page seo.
we have also experienced i
| Match | Count | SQL | Script |
| SELECT * FROM wanttobuy A, categories_wanttobuy B, seoclerks.members C WHERE A.wantid='36286' AND A.category=B.CATID AND A.USERID=C.USERID | 1 | SELECT 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='36286'
AND A.category=B.CATID AND A.USERID=C.USERID | /opt/clerks-staging/docroot/viewwant.php 163 () () |
| SELECT * FROM ratings_buyer WHERE USERID=142819 | 1 | SELECT sum(good) as thumbup, sum(bad) as thumbdown
FROM ratings_buyer WHERE USERID=142819 | /opt/clerks-staging/docroot/include/functions/main.php 19523 GetRatingsAsBuyerTotal() () |
| SELECT * FROM wanttobuy A, categories_wanttobuy B WHERE A.wantid != 36286 AND A.category=B.CATID AND A.active=1 AND (A.tags like '%Googlewebmaste Youtubeseoskil Searchenginesu%' ) LIMIT 4 | 1 | SELECT A.wantid, A.title, A.p1, A.maxprice, B.name, B.seo
FROM wanttobuy A,
categories_wanttobuy B
WHERE A.wantid != 36286
AND A.category=B.CATID
AND A.active=1
AND (A.tags like '%Googlewebmaste Youtubeseoskil Searchenginesu%' ) LIMIT 4 | /opt/clerks-staging/docroot/viewwant.php 551 () () |
| SELECT * FROM wanttobuy A, categories_wanttobuy B WHERE A.wantid != 36286 AND A.category=B.CATID AND A.active=1 AND A.USERID=142819 LIMIT 4 | 1 | SELECT A.wantid, A.title, A.p1, A.maxprice, B.name, B.seo
FROM wanttobuy A, categories_wanttobuy B
WHERE A.wantid != 36286
AND A.category=B.CATID
AND A.active=1
AND A.USERID=142819
LIMIT 4 | /opt/clerks-staging/docroot/viewwant.php 568 () () |
| SELECT * FROM wantcomments a, seoclerks.members b WHERE a.PID='36286' AND a.USERID=b.USERID and b.status='1' AND a.status=1 order by a.CID asc | 1 | SELECT 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='36286' 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='36286' | 1 | UPDATE wanttobuy SET viewcount = viewcount + 1 WHERE wantid='36286' | /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='36286' ORDER BY w.bidid ASC | 1 | SELECT 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='36286'
ORDER BY w.bidid ASC
| /opt/clerks-staging/docroot/viewwant.php 1192 () () |
| SELECT * FROM seoclerks.members as m WHERE m.USERID=409340 | 1 | SELECT m.username, m.skills, m.userlevel, m.ip, m.total_recommendations
FROM seoclerks.members as m
WHERE m.USERID=409340 | /opt/clerks-staging/docroot/viewwant.php 1258 () () |
| SELECT * FROM seoclerks.members as m WHERE m.USERID=312025 | 1 | SELECT m.username, m.skills, m.userlevel, m.ip, m.total_recommendations
FROM seoclerks.members as m
WHERE m.USERID=312025 | /opt/clerks-staging/docroot/viewwant.php 1258 () () |
| SELECT * FROM seoclerks.members as m WHERE m.USERID=267575 | 1 | SELECT m.username, m.skills, m.userlevel, m.ip, m.total_recommendations
FROM seoclerks.members as m
WHERE m.USERID=267575 | /opt/clerks-staging/docroot/viewwant.php 1258 () () |
| SELECT * FROM seoclerks.members as m WHERE m.USERID=359353 | 1 | SELECT m.username, m.skills, m.userlevel, m.ip, m.total_recommendations
FROM seoclerks.members as m
WHERE m.USERID=359353 | /opt/clerks-staging/docroot/viewwant.php 1258 () () |
| SELECT * FROM seoclerks.members as m WHERE m.USERID=350520 | 1 | SELECT m.username, m.skills, m.userlevel, m.ip, m.total_recommendations
FROM seoclerks.members as m
WHERE m.USERID=350520 | /opt/clerks-staging/docroot/viewwant.php 1258 () () |
| SELECT * FROM seoclerks.members as m WHERE m.USERID=83371 | 1 | SELECT m.username, m.skills, m.userlevel, m.ip, m.total_recommendations
FROM seoclerks.members as m
WHERE m.USERID=83371 | /opt/clerks-staging/docroot/viewwant.php 1258 () () |
| SELECT * FROM categories_wanttobuy | 1 | SELECT * FROM categories_wanttobuy | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() parseRedundantQueriesCache() |
| SELECT * FROM posts WHERE USERID=142819 | 1 | SELECT sum(positive_ratings) as thumbup,
sum(negative_ratings) as thumbdown
FROM posts
WHERE USERID=142819 | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() GetBuyerRatingsTotal() |
| SELECT * FROM categories | 1 | SELECT * FROM categories | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() parseRedundantQueriesCache() |
| select * from categories_software order by name asc | 1 | select * 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 asc | 1 | select * 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 asc | 1 | select * 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='409340' | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='409340' | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage() |
| SELECT * FROM seoclerks.members WHERE USERID='312025' | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='312025' | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage() |
| SELECT * FROM seoclerks.members WHERE USERID='267575' | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='267575' | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage() |
| SELECT * FROM seoclerks.members WHERE USERID='359353' | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='359353' | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage() |
| SELECT * FROM seoclerks.members WHERE USERID='350520' | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='350520' | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage() |
| SELECT * FROM seoclerks.members WHERE USERID='83371' | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='83371' | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage() |
| SELECT * FROM seoclerks.members WHERE USERID='142819' | 1 | SELECT profile_data FROM seoclerks.members WHERE USERID='142819' | /opt/clerks-staging/docroot/include/functions/main.php 1927 getUserBackground() include() |
| count(*) | sql1 | error_msg |
|---|
| Load | Count | SQL | Max | Min |
