idealmike
Level X3
Write the reason you're deleting this FAQ
If you're a freelancer and can do a service of some kind and want to find some work, the SEOClerks WTB and WTT section is where you can find people who want to hire you!
But how to know who's hiring?
This is where your skills come into play! If you put your skills as keywords in your profile, when people use those keywords in their WTB's and WTT's, you will get a notification about it. So if you have SEO, SMO, SMM skills or have skills blogging, writing, translating, or with WordPress or Windows, VPS, etc etc, put those words as your skills in your profile.
Then when people put those keywords in their WTB in the skills field, you are going to get a notification about that telling you that some member has just started a WTB which you may have the skills to complete.
Then all you have to do is visit that WTB and place your bid on it! Obviously doing that doesn't guarantee the buyer will order from your bid. But there are some things you can do though to increase the chances of that...
A Lesson in Bidding on People's WTB's
It's a little annoying when people bid on your WTB's for things you don't want, need or ask for. It's a waste of time for the WTB starter, it dilutes and devalues the WTB and turns it into a free for all smorgasbord for anyone to bid anything. That's not what they're for! I understand that people want to make money. I get that! But there's a place for everything and everything in a place! And I know some things are related and might be what the WTB starter might be interested in too such as if I was to start a WTB asking for YouTube subs, someone might place a bid for YouTube views or likes too. That's not too bad but still annoying. But it's when people bid things not even remotely related such as if I start a WTB asking for YouTube subs and someone places a bid for SoundCloud views or something, it's like what!? For starters, I'm specifically asking for oranges not pears or bananas. Not only is it a waste of time for me as the WTB starter but you're also wasting your own time by bidding something I'm not looking for and anyone looking for what I was originally looking for by browsing the WTB section isn't likely going to want that either. All it ends up doing is making a mess of the WTB itself and WTB section and making you look like a wally at the same time!
Where's Wally? He's in your WTB that asks for blog comments placing a bid for SoundCloud views! Because you know, they're sooo relevant...
Rant over. This is all logical. For the above stated reasons. Don't place a bid on someone's WTB unless it's specifically what the WTB starter is asking for!
How to increase the chances of someone hiring you from your placed bid?
What's been said so far are some good things to think about, but nothing says it better than bullet points so let's shoot!
Thanks Aj! Yes the WTB and WTT sections of SEOClerks can be very very useful for people to find a freelancer that can do whatever it is they need. By simply listing out what it is you need, someone with those skills can bid on that which helps you to find a freelancer for your requirements much faster. This is a very unique thing about SEOClerks that no other freelance site has in any other way like this. And I hear what you're saying, the good news is that this area will be more policed and moderated in the future and good changes are happening so that the WTB section in particular will be much better both for the WTB starter and for people who bid on them. :)
Are you sure you want to delete this post?
Are you sure you want to delete this post?
Thanks Elitewriter! Yes, I was aware that not many people actually know about the skills thing being so connected to WTB in that by simply having those skills in your skills field in your profile you can get notifications about WTB's that you might have the skills to complete. This means you can make much more money as a freelancer by getting more work by just having those skills listed in your profile. :)
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?
Are you sure you want to delete this post?
Are you sure you want to delete this post?
You're welcome! Yes you can get really creative with the title and think outside the box and use titles that contain call to actions in them which prove to be more effective I find and works in a subconscious way when you're telling someone you can do it and to do something to get it. It makes it much more likely they'll hire you for the job. Which I hope you'll go on to find yourse and get much work from the WTB's people make that you can do! :)
Are you sure you want to delete this post?
| Match | Count | SQL | Script |
| 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='10152' | 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='10152' | /opt/clerks-staging/docroot/viewfaq.php 496 () () |
| SELECT * FROM seoclerks.members WHERE USERID='272' | 1 | SELECT * FROM seoclerks.members WHERE USERID='272' | /opt/clerks-staging/docroot/include/functions/includes/member.php 445 GetAllUserDetails() () |
| SELECT * FROM seoclerks.members WHERE USERID=272 | 1 | SELECT googleplus_profile FROM seoclerks.members WHERE USERID=272 | /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=10152 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=10152
LIMIT 5 | /opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() () |
| SELECT * FROM answers a, seoclerks.members b WHERE a.quesid='10152' 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='10152' 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=39672 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=39672
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=39687 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=39687
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=39682 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=39682
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=39688 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=39688
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=39664 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=39664
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=39668 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=39668
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=39673 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=39673
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=39683 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=39683
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=98137 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=98137
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=98140 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=98140
LIMIT 5 | /opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() () |
| UPDATE questions SET total_views = total_views + 1 WHERE quesid='10152' | 1 | UPDATE questions SET total_views = total_views + 1 WHERE quesid='10152' | /opt/clerks-staging/docroot/include/functions/main.php 1765 update_Faqviewcount() () |
| SELECT * FROM questions WHERE quesid!='10152' AND status='1' AND (question like '%How Bid People\'s WTB\'s WTT\'s Hired Work Freelancer%' OR question like '%People\'s%' OR question like '%WTB\'s%' OR question like '%WTT\'s%' OR question like '%Hired%' OR question like '%Work%' OR question like '%Freelancer%') -- ORDER BY RAND() LIMIT 15 | 1 | SELECT quesid, question, seo, userid
FROM questions
WHERE quesid!='10152' AND status='1'
AND (question like '%How Bid People\'s WTB\'s WTT\'s Hired Work Freelancer%' OR question like '%People\'s%' OR question like '%WTB\'s%' OR question like '%WTT\'s%' OR question like '%Hired%' OR question like '%Work%' OR question like '%Freelancer%')
-- ORDER BY RAND()
LIMIT 15 | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() () |
| SELECT * FROM seoclerks.members WHERE USERID='4245' limit 1 | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='4245' 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 seoclerks.members WHERE USERID='5262' limit 1 | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='5262' limit 1 | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_get_member_profilepicture() |
| SELECT * FROM seoclerks.members WHERE USERID='1490' limit 1 | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='1490' limit 1 | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_get_member_profilepicture() |
| SELECT * FROM seoclerks.members WHERE USERID='8619' limit 1 | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='8619' 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=10152%' 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=10152%'
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='4987.jpg' | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='4987.jpg' | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage() |
| 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='212316.jpg' | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='212316.jpg' | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage() |
| SELECT * FROM seoclerks.members WHERE USERID='471288.jpg' | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='471288.jpg' | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage() |
| SELECT * FROM seoclerks.members WHERE USERID='398619.jpg' | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='398619.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 |
ajlancer
Thanks by Ajlancer Hi idealmike thanks for your very good tutorial. I'm sure this tutorial should be helpful to new buyers and sellers. Especially those who do not know how to create a want to buy (WTB) according to his own requirements and want to trade another good section on SEOClerks who want to exchange service with each other. Both section are very unique on SEOClerks. But nowadays lots of spammers make spam in WTB section and doing fraud. And they offer to seller to join his own website for same service. I think SEOClerks has to do more regarding this section. I also reported previously. Thanks by Ajlancer
Are you sure you want to delete this post?