susolapitoto
Level 3
Write the reason you're deleting this FAQ
Hello here,
please i need a person to guide me on How can i register as a freelancer here on SEO PLATFORM
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?
| 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='18498' | 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='18498' | /opt/clerks-staging/docroot/viewfaq.php 496 () () |
| SELECT * FROM seoclerks.members WHERE USERID='313424' | 1 | SELECT * FROM seoclerks.members WHERE USERID='313424' | /opt/clerks-staging/docroot/include/functions/includes/member.php 445 GetAllUserDetails() () |
| SELECT * FROM seoclerks.members WHERE USERID=313424 | 1 | SELECT googleplus_profile FROM seoclerks.members WHERE USERID=313424 | /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=18498 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=18498
LIMIT 5 | /opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() () |
| SELECT * FROM answers a, seoclerks.members b WHERE a.quesid='18498' 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='18498' 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=102467 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=102467
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=138677 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=138677
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=102461 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=102461
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=102462 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=102462
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=102464 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=102464
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=103046 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=103046
LIMIT 5 | /opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() () |
| UPDATE questions SET total_views = total_views + 1 WHERE quesid='18498' | 1 | UPDATE questions SET total_views = total_views + 1 WHERE quesid='18498' | /opt/clerks-staging/docroot/include/functions/main.php 1765 update_Faqviewcount() () |
| SELECT * FROM questions WHERE quesid!='18498' AND status='1' AND (question like '%How i register freelancer SEO PLATFORM %' OR question like '%register%' OR question like '%freelancer%' OR question like '%PLATFORM%') -- ORDER BY RAND() LIMIT 15 | 1 | SELECT quesid, question, seo, userid
FROM questions
WHERE quesid!='18498' AND status='1'
AND (question like '%How i register freelancer SEO PLATFORM %' OR question like '%register%' OR question like '%freelancer%' OR question like '%PLATFORM%')
-- ORDER BY RAND()
LIMIT 15 | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() () |
| SELECT * FROM seoclerks.members WHERE USERID='43' limit 1 | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='43' limit 1 | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_get_member_profilepicture() |
| SELECT * FROM seoclerks.members WHERE USERID='4136' limit 1 | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='4136' limit 1 | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_get_member_profilepicture() |
| SELECT * FROM seoclerks.members WHERE USERID='13175' limit 1 | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='13175' limit 1 | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_get_member_profilepicture() |
| SELECT * FROM seoclerks.members WHERE USERID='16132' limit 1 | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='16132' 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=18498%' 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=18498%'
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='617077.jpg' | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='617077.jpg' | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage() |
| SELECT * FROM seoclerks.members WHERE USERID='306632.jpg' | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='306632.jpg' | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage() |
| SELECT * FROM seoclerks.members WHERE USERID='254580.jpg' | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='254580.jpg' | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage() |
| SELECT * FROM seoclerks.members WHERE USERID='2951.jpg' | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='2951.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 |
| Avg Time | Count | SQL | Max | Min |
idealmike
You'll also show up on the list of Freelancers page. However, you only have 3 recommendations so you'll be listed wayyy at the back of the list! In order to show up higher up on that list (like on the 1st page), you'll need to get a lot of recommendations. The top 50 freelancers have up to 45k recommendations. The bottom 10 (40-50) have 3-5000 recommendations. Where as the freelancers that show on page 2 (51-100) have between 1-3000 recommendations. So if you want to be listed on the 1st or 2nd page or nearer to it, you need to have as many recommendations as these people (freelancers) do.
However, it's not all just about how many recommendations you have. You also need to have the skills that people are looking for if you want to have any chance of getting hired too. If you look at the skills the top freelancers have they have many different skills listed on their profile as well for the things they can do that they have skills in.
Check out some of these guides in the CD that you will find useful if you're looking for work as a freelancer.
How to Bid on People's WTB's and WTT's Be Hired and Get Work as a Freelancer.
How To Become a Successful Power Seller on SEOClerks.
How To Sell On Seoclerks - Explained By Power Seller!
How To Build Reputation, Credibility And Gain Sales With Community Discussions. [quote][color=#800080][b]please i need a person to guide me on How can i register as a freelancer here on SEO PLATFORM.[/b][/color][/quote]You're already registered here so you're already automatically registered as a freelancer! :) You'll also show up on the [url=https://www.seoclerks.com/freelancers]list of Freelancers page[/url]. However, you only have [b]3 recommendations[/b] so you'll be listed wayyy at the back of the list! In order to show up higher up on that list (like on the 1st page), you'll need to get a lot of recommendations. The top 50 freelancers have up to [b]45k recommendations[/b]. The bottom 10 (40-50) have [b]3-5000 recommendations[/b]. Where as the freelancers that show on page 2 (51-100) have between [b]1-3000 recommendations[/b]. So if you want to be listed on the 1st or 2nd page or nearer to it, you need to have as many recommendations as these people (freelancers) do. However, it's not all just about [b]how many recommendations[/b] you have. You also need to have the [b]skills[/b] that people are looking for if you want to have any chance of getting hired too. If you look at the skills the top freelancers have they have many different skills listed on their profile as well for the things they can do that they have skills in. Check out some of these guides in the CD that you will find useful if you're looking for work as a freelancer. [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]. [url=https://www.seoclerks.com/faq/9928/How-To-Become-a-Successful-Power-Seller-on-SEOClerks]How To Become a Successful Power Seller on SEOClerks[/url]. [url=https://www.seoclerks.com/faq/12114/How-To-Sell-On-Seoclerks-Explained-By-Power-Seller]How To Sell On Seoclerks - Explained By Power Seller[/url]! [url=https://www.seoclerks.com/faq/10200/How-To-Build-Reputation-Credibility-And-Gain-Sales-With-Community-Discussions]How To Build Reputation, Credibility And Gain Sales With Community Discussions[/url].
Are you sure you want to delete this post?