TopSEO4you
Level 3
Write the reason you're deleting this FAQ
How can I promote my services on Seoclerks?
I am using bumps , please suggest more methods to promote my services
as messaging bulk lay to infraction
Posting on WTB &WTT also lay to infraction??
Please Suggest
Thanks
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='18704' | 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='18704' | /opt/clerks-staging/docroot/viewfaq.php 496 () () |
| SELECT * FROM seoclerks.members WHERE USERID='479127' | 1 | SELECT * FROM seoclerks.members WHERE USERID='479127' | /opt/clerks-staging/docroot/include/functions/includes/member.php 445 GetAllUserDetails() () |
| SELECT * FROM categories_faq WHERE CATID='42' | 1 | SELECT CATID, seo, name, metatitle, h2header, metakeywords, metadescription, metaheader, parentid, image_name FROM categories_faq WHERE CATID='42' | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() GetCategorySeoFromType() |
| SELECT * FROM seoclerks.members WHERE USERID=479127 | 1 | SELECT googleplus_profile FROM seoclerks.members WHERE USERID=479127 | /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=18704 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=18704
LIMIT 5 | /opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() () |
| SELECT * FROM answers a, seoclerks.members b WHERE a.quesid='18704' 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='18704' 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=103476 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=103476
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=103468 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=103468
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=103473 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=103473
LIMIT 5 | /opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() () |
| UPDATE questions SET total_views = total_views + 1 WHERE quesid='18704' | 1 | UPDATE questions SET total_views = total_views + 1 WHERE quesid='18704' | /opt/clerks-staging/docroot/include/functions/main.php 1765 update_Faqviewcount() () |
| SELECT * FROM questions WHERE quesid!='18704' AND status='1' AND (question like '%How I promote services Seoclerks?%' OR question like '%promote%' OR question like '%services%' OR question like '%Seoclerks?%') -- ORDER BY RAND() LIMIT 15 | 1 | SELECT quesid, question, seo, userid
FROM questions
WHERE quesid!='18704' AND status='1'
AND (question like '%How I promote services Seoclerks?%' OR question like '%promote%' OR question like '%services%' OR question like '%Seoclerks?%')
-- ORDER BY RAND()
LIMIT 15 | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() () |
| SELECT * FROM seoclerks.members WHERE USERID='1323' limit 1 | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='1323' limit 1 | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_get_member_profilepicture() |
| SELECT * FROM seoclerks.members WHERE USERID='632' limit 1 | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='632' 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='30' limit 1 | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='30' limit 1 | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_get_member_profilepicture() |
| SELECT * FROM seoclerks.members WHERE USERID='2077' limit 1 | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='2077' 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=18704%' 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=18704%'
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='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='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 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
Hi TopSEO4you, there are many ways to promote your services on SEOClerks. And there has been many ways written and posted about doing that in the Community Discussions here as well. I'll try to dig up some of guides that have been posted recently but the first thing you should do is browse through the SEOClerks category. In there you will find many people who have asked the same question before and many answers have been given to them that you will find useful to do that. Also, the same can be said for the Tips and Tricks category too. Take some time to just browse through that category as you will find many tips and tricks on promoting your SEOClerks services and getting more sales and also tips and tricks on getting repeat sales as well. Basically, there are enough tips there to make you a better seller!
But you can also search the very discussions here for promotion and there you will find many guides and tutorials and things written to help you promote your services here. I'm not talking about just skimming the posts though. If possible try not to skim stuff as you wont learn as well that way even though it's really tempting just to skim over things.
You can also check out How To Become a Successful Power Seller on SEOClerks. Which is a must read if you do want to become a bigger, better seller on here as it will put you in the right direction and there's some good tips in there too.
These are ways you can promote your services without paying for the promotion too. And of course, nobody is expecting you to become a power seller over night and to learn all of these over night. But just take your time, read the guides and things and slowly by slowly, but surely by surely, you'll start picking up on things and putting the pieces of the jigsaw together and be well on your way.
One other way to be a good successful seller, is to offer unique services that nobody else is offering. That way, you don't have any competition. Something I learned a while back so that I'm not jostling with other sellers selling the same thing.
Anyway, hope this helps for now and good luck and to your success!
Mike. [size=140]How can I promote my services on Seoclerks?[/size] Hi TopSEO4you, there are many ways to promote your services on SEOClerks. And there has been many ways written and posted about doing that in the [url=https://www.seoclerks.com/faq/]Community Discussions[/url] here as well. I'll try to dig up some of guides that have been posted recently but the first thing you should do is browse through the [url=https://www.seoclerks.com/faq/cat/SEOClerks]SEOClerks category[/url]. In there you will find many people who have asked the same question before and many answers have been given to them that you will find useful to do that. Also, the same can be said for the [url=https://www.seoclerks.com/faq/cat/tips-tricks]Tips and Tricks category[/url] too. Take some time to just browse through that category as you will find many tips and tricks on promoting your SEOClerks services and getting more sales and also tips and tricks on getting repeat sales as well. Basically, there are enough tips there to make you a better seller! :) But you can also search the very discussions here for [url=https://www.seoclerks.com/faq/q/promotion]promotion[/url] and there you will find many guides and tutorials and things written to help you promote your services here. I'm not talking about just skimming the posts though. If possible try not to skim stuff as you wont learn as well that way even though it's really tempting just to skim over things. You can also check out [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]. Which is a must read if you do want to become a bigger, better seller on here as it will put you in the right direction and there's some good tips in there too. These are ways you can promote your services without paying for the promotion too. And of course, nobody is expecting you to become a power seller over night and to learn all of these over night. But just take your time, read the guides and things and slowly by slowly, but surely by surely, you'll start picking up on things and putting the pieces of the jigsaw together and be well on your way. One other way to be a good successful seller, is to offer unique services that nobody else is offering. That way, you don't have any competition. Something I learned a while back so that I'm not jostling with other sellers selling the same thing. :) Anyway, hope this helps for now and good luck and to your success! Mike.
Are you sure you want to delete this post?