EXPERTSEO1
Level 1
Write the reason you're deleting this FAQ
Freelancing an SEO related service can be difficult, especially if you are new to freelance or don't have the built in customer connections you might otherwise have as an employee of a large SEO firm.
What can a new SEO freelancer do to locate and secure new clients for his business?
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='20823' | 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='20823' | /opt/clerks-staging/docroot/viewfaq.php 496 () () |
| SELECT * FROM seoclerks.members WHERE USERID='538431' | 1 | SELECT * FROM seoclerks.members WHERE USERID='538431' | /opt/clerks-staging/docroot/include/functions/includes/member.php 445 GetAllUserDetails() () |
| SELECT * FROM seoclerks.members WHERE USERID=538431 | 1 | SELECT googleplus_profile FROM seoclerks.members WHERE USERID=538431 | /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=20823 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=20823
LIMIT 5 | /opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() () |
| SELECT * FROM answers a, seoclerks.members b WHERE a.quesid='20823' 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='20823' 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=113261 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=113261
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=113258 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=113258
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=113551 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=113551
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=169329 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=169329
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=169343 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=169343
LIMIT 5 | /opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() () |
| UPDATE questions SET total_views = total_views + 1 WHERE quesid='20823' | 1 | UPDATE questions SET total_views = total_views + 1 WHERE quesid='20823' | /opt/clerks-staging/docroot/include/functions/main.php 1765 update_Faqviewcount() () |
| SELECT * FROM questions WHERE quesid!='20823' AND status='1' AND (question like '%What\'s technique finding SEO buyers?%' OR question like '%What\'s%' OR question like '%technique%' OR question like '%finding%' OR question like '%buyers?%') -- ORDER BY RAND() LIMIT 15 | 1 | SELECT quesid, question, seo, userid
FROM questions
WHERE quesid!='20823' AND status='1'
AND (question like '%What\'s technique finding SEO buyers?%' OR question like '%What\'s%' OR question like '%technique%' OR question like '%finding%' OR question like '%buyers?%')
-- ORDER BY RAND()
LIMIT 15 | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() () |
| SELECT * FROM seoclerks.members WHERE USERID='3764' limit 1 | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='3764' limit 1 | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_get_member_profilepicture() |
| 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='1129' limit 1 | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='1129' 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=20823%' 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=20823%'
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='6160.png' | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='6160.png' | /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='134.png' | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='134.png' | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage() |
| SELECT * FROM seoclerks.members WHERE USERID='600657.jpg' | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='600657.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 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 |
hitmeasap
Let me answer you by doing this:
This is from another reply I made yesterday. This is obviously an answer related to how you'll get your first sale on SEOClerks.. But, the answers within these topics are awesome and valuable so you'll benefit from them no matter where you end up doing business.
That being said, no matter where you do business, or how, you'll always struggle with the first sale. - The first sale is the hardest one to get, but when you've got that first sale, the snowball effect will begin. - As long as you continue to work hard and as long as you put in the necessary effort it requires.
Best Regards,
hitmeasap Hello! Let me answer you by doing this: [quote] [b]Here's a few topics (from the [url=https://www.seoclerks.com/faq]Community Discussion[/url]) I recommend:[/b] [url=https://www.seoclerks.com/faq/19798/8-tips-to-help-you-speed-up-your-success-on-SeoClerks]8 tips to help you speed up your success on SeoClerks[/url] - [url=https://www.seoclerks.com/user/Razzy]By [/url][url=https://www.seoclerks.com/user/Razzy]Razzy[/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] - [url=https://www.seoclerks.com/user/hitmeasap]By hitmeasap[/url] (that's me). [url=https://www.seoclerks.com/faq/9997/The-5-Most-Common-Mistakes-Freelancers-Make]The 5 Most Common Mistakes Freelancers Make [/url]- By hitmeasap [url=https://www.seoclerks.com/faq/9979/How-To-Setup-The-Perfect-Descriptions]How To Setup The Perfect Descriptions[/url] - By hitmeasap [url=https://www.seoclerks.com/faq/9977/Repeat-Customers-And-How-To-Get-Them]Repeat Customers And How To Get Them[/url] - By hitmeasap [url=https://www.seoclerks.com/faq/9941/How-To-Use-The-Bump-Feature]How To Use The Bump Feature?[/url] - By hitmeasap [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]- idealmike There's many more outstanding tips and topics in the [b]Community Discussion[/b], so I truly recommend that you give it a go and search for even more inspiration, information and real valuable methods and "[i]secrets[/i]". [/quote] This is from another reply I made yesterday. This is obviously an answer related to [b]how you'll get your first sale on SEOClerks[/b].. But, the answers within these topics are awesome and valuable so you'll benefit from them no matter where you end up doing business. That being said, no matter where you do business, or how, you'll always struggle with the first sale. - The first sale is the hardest one to get, but when you've got that first sale, the snowball effect will begin. - As long as you continue to work hard and as long as you put in the necessary effort it requires. Best Regards, hitmeasap
Are you sure you want to delete this post?