SEOClerks

Need server guru to promote tutorials on blogs and forums

Need server guru to promote tutorials on blogs and forums

I have created an online server management guide and I need someone to promote my tutorials on relevant pages/threads on forums like SitePoint, Yahoo Answers, ServerFault, etc. (You can also post links in the comment sections of relevant blog articles.)

If someone on the web asks a question related to server management...I want a link to the relevant page on my site. (I don't care about pagerank or Alexa rankings...just post links to my site wherever it's appropriate.)

I need someone proactive and resourceful who understands server management. Also, if you find questions that my site does not answer, let me know so I can create the necessary content.


Requirements

- This is a long-term gig. I will pay per link/posting (up to a maximum of $50 per week).

- There's no fixed link total, but I need dozens of links posted per week.

- I will send outstanding payments every Friday.

- Even though this seems like a simple data entry gig, I need someone who understands server management. You don't need to be an expert, but you need to be at least computer literate.

- Try to spread out links across many sites.

- Try not to post a reply consisting of only a link. (Every now and then is fine.) Instead, post relevant tutorial excerpts and/or some kind of introductory text like "Here's a link that might answer your question..."

- I will require a list/log of all of the pages you have posted my links in order to pay you for your work.

- If you are hired I will pay for a trial run of 10 (ten) links/postings before making any additional commitments.

Bidding:
Your bids should be based on 10 links/postings.

Also, SeoClerks doesn't seem to allow listings of long-term projects and I'm new to this site...so let me know if there are any payment/billing issues I need to know about.

If you have any comments or questions please let me know. (Seriously, don't hesitate to share your thoughts with me.)


Skills Required

Linux Ssh Server Writing

Bids

hi,i am an expert in computer networking,i understand the concepts of working on this project,i will post a link to your page on meaningful comments,i will make the audience really curious and you will get their clicks

Bid On Listing Created 12 years ago in Forum Posts

Other jobs by parker1979

Order Now
Process Time: 0.17768383026123

Possible Duplicate queries found!
MatchCountSQLScript
SELECT * FROM wanttobuy A, categories_wanttobuy B, seoclerks.members C WHERE A.wantid='19909' 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='19909' AND A.category=B.CATID AND A.USERID=C.USERID

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

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

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

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

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

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

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

SELECT * FROM wantcomments a, seoclerks.members b WHERE a.PID='19909' 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='19909' 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='19909'1UPDATE wanttobuy SET viewcount = viewcount + 1 WHERE wantid='19909'

/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='19909' 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='19909' ORDER BY w.bidid ASC

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

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

/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=2558341SELECT sum(positive_ratings) as thumbup, sum(negative_ratings) as thumbdown FROM posts WHERE USERID=255834

/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='69214'1SELECT profilepicture FROM seoclerks.members WHERE USERID='69214'

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

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

/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
0.2966261SELECT A.*, B.seo, B.name as categoryname, C.username, C.userlevel, C.lastlogin, C.ip, C.profilepicture FROM wanttobuy A, categories_wanttobuy B, seoclerks.members C WHERE A.active = 1 AND A.category = B.CATID AND A.USERID = C.USERID ORDER BY A.bdays desc LIMIT 0,400.2966260.296626
0.1042621SELECT A.wantid, A.title, A.p1, A.maxprice, B.name, B.seo FROM wanttobuy A, categories_wanttobuy B WHERE A.wantid != 19909 AND A.category=B.CATID AND A.active=1 AND (A.tags like '%Linux Ssh Server Writing%' ) LIMIT 40.1042620.104262