arifurashik
Level 1
Write the reason you're deleting this FAQ
How can i sell my service ? i want give someone who want website manager and his website all kind of management i ensure buyer for wonderful service . if buyer want me hour base work i am agree but i don't know SEOclerks has hour base working opportunity or not. some body help me who experience in this marketplace
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='29315' | 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='29315' | /opt/clerks-staging/docroot/viewfaq.php 496 () () |
| SELECT * FROM seoclerks.members WHERE USERID='748650' | 1 | SELECT * FROM seoclerks.members WHERE USERID='748650' | /opt/clerks-staging/docroot/include/functions/includes/member.php 445 GetAllUserDetails() () |
| SELECT * FROM seoclerks.members WHERE USERID=748650 | 1 | SELECT googleplus_profile FROM seoclerks.members WHERE USERID=748650 | /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=29315 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=29315
LIMIT 5 | /opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() () |
| SELECT * FROM answers a, seoclerks.members b WHERE a.quesid='29315' 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='29315' 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=188722 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=188722
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=189072 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=189072
LIMIT 5 | /opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() () |
| UPDATE questions SET total_views = total_views + 1 WHERE quesid='29315' | 1 | UPDATE questions SET total_views = total_views + 1 WHERE quesid='29315' | /opt/clerks-staging/docroot/include/functions/main.php 1765 update_Faqviewcount() () |
| SELECT * FROM questions WHERE quesid!='29315' AND status='1' AND (question like '%Sell Service hour base body %' OR question like '%Sell%' OR question like '%Service%' OR question like '%hour%' OR question like '%base%' OR question like '%body%') -- ORDER BY RAND() LIMIT 15 | 1 | SELECT quesid, question, seo, userid
FROM questions
WHERE quesid!='29315' AND status='1'
AND (question like '%Sell Service hour base body %' OR question like '%Sell%' OR question like '%Service%' OR question like '%hour%' OR question like '%base%' OR question like '%body%')
-- ORDER BY RAND()
LIMIT 15 | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() () |
| 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='9' limit 1 | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='9' limit 1 | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_get_member_profilepicture() |
| SELECT * FROM seoclerks.members WHERE USERID='3290' limit 1 | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='3290' limit 1 | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_get_member_profilepicture() |
| SELECT * FROM seoclerks.members WHERE USERID='3644' limit 1 | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='3644' limit 1 | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_get_member_profilepicture() |
| SELECT * FROM seoclerks.members WHERE USERID='3250' limit 1 | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='3250' 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=29315%' 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=29315%'
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='19821.png' | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='19821.png' | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage() |
| SELECT * FROM seoclerks.members WHERE USERID='868856.png' | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='868856.png' | /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 |
TommyCarey
There is no option to do an hourly job for a client here on SEOclerks but you can set up a service that will provide your service for 1, 5, 10, 20, 30, 40+ hours each week and they will pay you every Friday or the day you agree upon with the buyer of the service.
What you can do is sell a service for 1 hour of work to be completed. It looks like you want to do website management, so it would be 1 hour of website management for $X.
What you can then do is add on some services for a pre-set amount of hours and let people purchase from you. They can buy your main service for one hour and select the 20-hour add-on to get your management services for 21 hours in total for the week. This will also allow them to purchase 40+ hours of your time, so you'll need to be careful because some people may purchase all of your add ons and that would mean you'd need to do website management for 106 hours a week. That would mean you'd be working 21.2 hours a day if you worked Monday through Friday lol
Be sure to add in a clause that says you can work a maximum of 40 hours per week for a client and a maximum of 50-60 hours a week in total. This will mean you get paid a decent amount of money to manage 1-2 websites per week. You will need to suspend your services once you get a few people subscribing to your services so you can genuinely work for these people and not accept 100 customers totaling 400 hours a week (which isn't possible).
You could them add your services to the website management category or set up a service that sells your time as a virtual assistant and bring in more sales that way. Hey arifuarshik, There is no option to do an hourly job for a client here on SEOclerks but you can set up a service that will provide your service for 1, 5, 10, 20, 30, 40+ hours each week and they will pay you every Friday or the day you agree upon with the buyer of the service. What you can do is sell a service for 1 hour of work to be completed. It looks like you want to do website management, so it would be 1 hour of website management for $X. What you can then do is add on some services for a pre-set amount of hours and let people purchase from you. They can buy your main service for one hour and select the 20-hour add-on to get your management services for 21 hours in total for the week. This will also allow them to purchase 40+ hours of your time, so you'll need to be careful because some people may purchase all of your add ons and that would mean you'd need to do website management for 106 hours a week. That would mean you'd be working 21.2 hours a day if you worked Monday through Friday lol :D Be sure to add in a clause that says you can work a maximum of 40 hours per week for a client and a maximum of 50-60 hours a week in total. This will mean you get paid a decent amount of money to manage 1-2 websites per week. You will need to suspend your services once you get a few people subscribing to your services so you can genuinely work for these people and not accept 100 customers totaling 400 hours a week (which isn't possible). You could them add your services to the website management category or set up a service that sells your time as a virtual assistant and bring in more sales that way.
Are you sure you want to delete this post?