hasibbpi1988
Level 1
Write the reason you're deleting this FAQ
Hello Friends,
I am very new at this marketplace. I am an affiliate marketer work on different network before now.
I have good knowledge of how to do SEO and able to work on the project. I really want to work on this network.
Can anyone give me some useful tips that I will get some good amount work on this network, If anyone give me some good tips then i will very happy.
Are you sure you want to delete this post?
Are you sure you want to delete this post?
Being active on the forum here and regularly taking part in discussions, being helpful and sharing your skills and knowledge on here is one way to make a good name for yourself as a respected authority figure in your niche! The forum here has a lot of bonuses and benefits to it for that reason alone. It doesn't mean you have to be active every day. Just try to get on here and check for new discussions and leave some replies and let people get to know you and that you're helpful and that. 

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='21485' | 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='21485' | /opt/clerks-staging/docroot/viewfaq.php 496 () () |
| SELECT * FROM seoclerks.members WHERE USERID='309351' | 1 | SELECT * FROM seoclerks.members WHERE USERID='309351' | /opt/clerks-staging/docroot/include/functions/includes/member.php 445 GetAllUserDetails() () |
| SELECT * FROM seoclerks.members WHERE USERID=309351 | 1 | SELECT googleplus_profile FROM seoclerks.members WHERE USERID=309351 | /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=21485 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=21485
LIMIT 5 | /opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() () |
| SELECT * FROM answers a, seoclerks.members b WHERE a.quesid='21485' 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='21485' 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=114733 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=114733
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=114734 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=114734
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=114817 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=114817
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=114752 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=114752
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=114848 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=114848
LIMIT 5 | /opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() () |
| UPDATE questions SET total_views = total_views + 1 WHERE quesid='21485' | 1 | UPDATE questions SET total_views = total_views + 1 WHERE quesid='21485' | /opt/clerks-staging/docroot/include/functions/main.php 1765 update_Faqviewcount() () |
| SELECT * FROM questions WHERE quesid!='21485' AND status='1' AND (question like '%How I start successful journey SEOClerks?%' OR question like '%start%' OR question like '%successful%' OR question like '%journey%' OR question like '%SEOClerks?%') -- ORDER BY RAND() LIMIT 15 | 1 | SELECT quesid, question, seo, userid
FROM questions
WHERE quesid!='21485' AND status='1'
AND (question like '%How I start successful journey SEOClerks?%' OR question like '%start%' OR question like '%successful%' OR question like '%journey%' 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='3160' limit 1 | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='3160' 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='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='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='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 members_ledger WHERE script='/opt/clerks-staging/docroot/viewfaq.php' AND querystring LIKE '%id=21485%' 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=21485%'
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='147.jpg' | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='147.jpg' | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage() |
| SELECT * FROM seoclerks.members WHERE USERID='309351.jpg' | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='309351.jpg' | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage() |
| SELECT * FROM seoclerks.members WHERE USERID='511523.jpg' | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='511523.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 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 |
Beverly
There are many other services and sellers here already and you're competing against them. You seem to have fairly unique services, which is in your favor. There are not many offering forum posting services. It will be useful to include some writing samples (screenshots, if you have them) on the service description of possibly link to a live writing sample on another forum or blog. At least, that's what I used to do when I was offering the forum posting and writing services. The buyers love to see writing samples!
As for promotion, don't rely on buyers to find your services via search. You will want to bump your services daily so they appear at the top of the category and also promote outside SEOClerks. If you have friends from other networks or sites, you will want to invite them here via your affiliate link. When those people become your buyers and purchase your services, you will earn even more.
You can find your affiliate link here: https://www.seoclerks.com/balance/affiliate
You can also link to specific services, in addition to the home page or your profile.
One of the ways that worked for me in terms of promotion was to be active on the SEOClerks forum (now called Community Discussion) as well as a few other business related forums where forum owners were active. Then I could include a simple signature line on those forums such as "Hire me" with a link back to my profile or best service here on SEOClerks.
The advantage of posting here is that every post you create (reply or discussion) links back to your own seller profile. There is a good chance that buyers will click through to see what you have to offer.
Also, creating new discussions here daily will earn free bumps for your services.
It's a win-win situation for you as a seller! You've made a really good start by creating your first services. However, you might want to embellish your descriptions some to include more details, for instance if you have a specific specialty or niche. There are many other services and sellers here already and you're competing against them. You seem to have fairly unique services, which is in your favor. There are not many offering forum posting services. It will be useful to include some writing samples (screenshots, if you have them) on the service description of possibly link to a live writing sample on another forum or blog. At least, that's what I used to do when I was offering the forum posting and writing services. The buyers love to see writing samples! As for promotion, don't rely on buyers to find your services via search. You will want to bump your services daily so they appear at the top of the category and also promote outside SEOClerks. If you have friends from other networks or sites, you will want to invite them here via your affiliate link. When those people become your buyers and purchase your services, you will earn even more. You can find your affiliate link here: https://www.seoclerks.com/balance/affiliate You can also link to specific services, in addition to the home page or your profile. One of the ways that worked for me in terms of promotion was to be active on the SEOClerks forum (now called Community Discussion) as well as a few other business related forums where forum owners were active. Then I could include a simple signature line on those forums such as "Hire me" with a link back to my profile or best service here on SEOClerks. The advantage of posting here is that every post you create (reply or discussion) links back to your own seller profile. There is a good chance that buyers will click through to see what you have to offer. Also, creating new discussions here daily will earn free bumps for your services. It's a win-win situation for you as a seller!
Are you sure you want to delete this post?