centurion
Level X4
Write the reason you're deleting this FAQ
Hello Everyone
Have a wonderful day.
SEO Clerk is a three tier marketplace where you can buy services or you can sell services or you can hire people or peoples bid. For the first time your account will show a new status: after registration: level 1. On level 1 you can enlist 5 services for sell. Now think yourself on the SEO section what is your specialty. Like tier 1 to tier 9 linkwheel for any website. So for getting huge works you will create 5 exceptional services for sell from sell to sell a swrvice option. On the another way from home want to buy section you can do unlimited application for getting works on your profile. When some one hire you for any work you will get notification to start immediate work. Finally you can hire any one by uploading dollar if you have huge work on your hand and if you want to give works to marketplace. After creating every service you can share those on social media to collect clients.
Fourthly there have an option of affiliate earning. Like if any one join Seoclerk from your affiliate link and if any one buy a service from seo clerk you will get 10% profit. Your affiliate link will be like as : http://a.seoclerks.com/linkin/USERID. You can bring traffic to your affiliate link to join with SEOClerk.
Finally there have another option that is called want to trade. Here you can exchange your work or you can get hired by your profile services or by any work or you can hire anyone for any work or any one service after discussion. Work exchange means I will give you 1000 retweet and you will provide me 1000 youtube subscribers- like this.
So there are minimum 5 ways to earn randomly from seoclerk. Hope every newbie will be happy.
Thanks
Centurion
Are you sure you want to delete this post?
Are you sure you want to delete this post?
Are you sure you want to delete this post?
Are you sure you want to delete this post?
| Match | Count | SQL | Script |
| SELECT * FROM members_ledger WHERE ip = ? AND added>=unix_timestamp(NOW())-86400 | 1 | SELECT querystring, added
FROM members_ledger
WHERE
ip = ? AND added>=unix_timestamp(NOW())-86400 | /opt/clerks-staging/docroot/include/functions/includes/security.php 398 fetchMemberLedger() include_once() |
| SELECT * FROM `questions` as q JOIN categories_faq as c ON q.catid=c.CATID WHERE (q.status=1 OR (q.status=2 AND userid='') ) AND q.quesid='21893' | 1 | SELECT q.*, c.seo as CatSEO, c.name as CatName, c.parentid
FROM `questions` as q
JOIN categories_faq as c ON q.catid=c.CATID
WHERE (q.status=1 OR
(q.status=2 AND userid='')
)
AND q.quesid='21893' | /opt/clerks-staging/docroot/viewfaq.php 496 () () |
| SELECT * FROM seoclerks.members WHERE USERID='301993' | 1 | SELECT * FROM seoclerks.members WHERE USERID='301993' | /opt/clerks-staging/docroot/include/functions/includes/member.php 445 GetAllUserDetails() () |
| SELECT * FROM seoclerks.members WHERE USERID=301993 | 1 | SELECT googleplus_profile FROM seoclerks.members WHERE USERID=301993 | /opt/clerks-staging/docroot/include/functions/main.php 16914 GetGooglePlusProfileFromId() () |
| SELECT * FROM ratings_faq as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=21893 LIMIT 5 | 1 | SELECT m.username FROM
ratings_faq as r,
seoclerks.members as m
WHERE r.USERID=m.USERID
AND r.upvote=1
AND r.PID=21893
LIMIT 5 | /opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() () |
| SELECT * FROM answers a, seoclerks.members b WHERE a.quesid='21893' AND a.userid=b.USERID and b.status='1' AND a.status=1 ORDER BY a.combined_votes DESC, a.date_answered asc | 1 | SELECT a.answer, a.USERID, a.upvotes, a.downvotes, a.ansid, a.parentid, a.combined_votes, a.date_answered,
b.username, b.userlevel, b.profilepicture FROM answers a, seoclerks.members b
WHERE a.quesid='21893' AND a.userid=b.USERID and b.status='1' AND a.status=1
ORDER BY a.combined_votes DESC, a.date_answered asc | /opt/clerks-staging/docroot/viewfaq.php 1245 () () |
| SELECT * FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=115494 LIMIT 5 | 1 | SELECT m.username FROM
ratings_faqanswers as r,
seoclerks.members as m
WHERE r.USERID=m.USERID
AND r.upvote=1
AND r.PID=115494
LIMIT 5 | /opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() () |
| SELECT * FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=115541 LIMIT 5 | 1 | SELECT m.username FROM
ratings_faqanswers as r,
seoclerks.members as m
WHERE r.USERID=m.USERID
AND r.upvote=1
AND r.PID=115541
LIMIT 5 | /opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() () |
| SELECT * FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=115579 LIMIT 5 | 1 | SELECT m.username FROM
ratings_faqanswers as r,
seoclerks.members as m
WHERE r.USERID=m.USERID
AND r.upvote=1
AND r.PID=115579
LIMIT 5 | /opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() () |
| SELECT * FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=115511 LIMIT 5 | 1 | SELECT m.username FROM
ratings_faqanswers as r,
seoclerks.members as m
WHERE r.USERID=m.USERID
AND r.upvote=1
AND r.PID=115511
LIMIT 5 | /opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() () |
| SELECT * FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=115543 LIMIT 5 | 1 | SELECT m.username FROM
ratings_faqanswers as r,
seoclerks.members as m
WHERE r.USERID=m.USERID
AND r.upvote=1
AND r.PID=115543
LIMIT 5 | /opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() () |
| UPDATE questions SET total_views = total_views + 1 WHERE quesid='21893' | 1 | UPDATE questions SET total_views = total_views + 1 WHERE quesid='21893' | /opt/clerks-staging/docroot/include/functions/main.php 1765 update_Faqviewcount() () |
| SELECT * FROM questions WHERE quesid!='21893' AND status='1' AND (question like '%Get works SEOCLERK%' OR question like '%works%' OR question like '%SEOCLERK%') -- ORDER BY RAND() LIMIT 15 | 1 | SELECT quesid, question, seo, userid
FROM questions
WHERE quesid!='21893' AND status='1'
AND (question like '%Get works SEOCLERK%' OR question like '%works%' OR question like '%SEOCLERK%')
-- ORDER BY RAND()
LIMIT 15 | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() () |
| SELECT * FROM seoclerks.members WHERE USERID='957' limit 1 | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='957' limit 1 | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_get_member_profilepicture() |
| SELECT * FROM seoclerks.members WHERE USERID='498' limit 1 | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='498' limit 1 | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_get_member_profilepicture() |
| SELECT * FROM seoclerks.members WHERE USERID='750' limit 1 | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='750' limit 1 | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_get_member_profilepicture() |
| SELECT * FROM seoclerks.members WHERE USERID='1159' limit 1 | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='1159' limit 1 | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_get_member_profilepicture() |
| SELECT * FROM seoclerks.members WHERE USERID='318' limit 1 | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='318' limit 1 | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_get_member_profilepicture() |
| SELECT * FROM members_ledger WHERE script='/opt/clerks-staging/docroot/viewfaq.php' AND querystring LIKE '%id=21893%' AND added>=UNIX_TIMESTAMP(NOW())-1200 GROUP BY USERID | 1 | SELECT USERID, username FROM members_ledger
WHERE script='/opt/clerks-staging/docroot/viewfaq.php'
AND querystring LIKE '%id=21893%'
AND added>=UNIX_TIMESTAMP(NOW())-1200
GROUP BY USERID
| /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() () |
| 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='272.jpg' | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='272.jpg' | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage() |
| SELECT * FROM seoclerks.members WHERE USERID='301993.jpg' | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='301993.jpg' | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage() |
| SELECT * FROM seoclerks.members WHERE USERID='112100.jpg' | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='112100.jpg' | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage() |
| select * from categories_faq order by name asc | 1 | select * from categories_faq order by name asc | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_GetFaqCategories() |
| count(*) | sql1 | error_msg |
|---|
| Load | Count | SQL | Max | Min |
idealmike
I wrote a guide on how to use WTB section of the site properly a while back which you, and others may find useful and helpful to them if they are new to this part of SEOClerks. You can read it here: How to Bid on People's WTB's and WTT's Be Hired and Get Work as a Freelancer. ?
Anyway thanks for your post and to your success!
Mike. Great stuff! SEOClerks is all of that and so much more! And you mentioned WTT (Want To Trade) section but not the WTB (Want To Buy) section! This is a very awesome part of the SEOClerks site for getting virtually anything you want! All you need to do is create a new WTB, list out what it is you're looking for, whether it's something built or something done for you, then put your terms and the amount you're willing to pay, along with some skills that people need as tags in the skills section, then people who have those skills listed in their profile will get a notification about your WTB and can then bid on it for you. The great thing is, there is no limit to the amount of people that can bid on your WTB (or WTT). And what usually happens is the first people that bid, do so at a higher price, then eventually, other people see that and then bid at a price that is a little lower until it gets lower and lower. That way, if you're patient and hold out, you can often get what it is you need at a very low price. Although that doesn't always guarantee you'll get the work done to a high degree. But you can just message the bidder first and ask them about it, get a feel for them before buying which is what I do. :) I wrote a guide on how to use WTB section of the site properly a while back which you, and others may find useful and helpful to them if they are new to this part of SEOClerks. You can read it here: [url=https://www.seoclerks.com/faq/10152/How-to-Bid-on-People-s-WTB-s-and-WTT-s-Be-Hired-and-Get-Work-as-a]How to Bid on People's WTB's and WTT's Be Hired and Get Work as a Freelancer[/url]. ? Anyway thanks for your post and to your success! Mike.
Are you sure you want to delete this post?