daragramsmedia
Level 3
Write the reason you're deleting this FAQ
1. What are the best ways to resell a service from seoclerks?
2. What other ways can one get paid apart from paypal?
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='29349' | 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='29349' | /opt/clerks-staging/docroot/viewfaq.php 496 () () |
| SELECT * FROM seoclerks.members WHERE USERID='428753' | 1 | SELECT * FROM seoclerks.members WHERE USERID='428753' | /opt/clerks-staging/docroot/include/functions/includes/member.php 445 GetAllUserDetails() () |
| SELECT * FROM seoclerks.members WHERE USERID=428753 | 1 | SELECT googleplus_profile FROM seoclerks.members WHERE USERID=428753 | /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=29349 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=29349
LIMIT 5 | /opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() () |
| SELECT * FROM answers a, seoclerks.members b WHERE a.quesid='29349' 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='29349' 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=188740 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=188740
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=188750 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=188750
LIMIT 5 | /opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() () |
| UPDATE questions SET total_views = total_views + 1 WHERE quesid='29349' | 1 | UPDATE questions SET total_views = total_views + 1 WHERE quesid='29349' | /opt/clerks-staging/docroot/include/functions/main.php 1765 update_Faqviewcount() () |
| SELECT * FROM questions WHERE quesid!='29349' AND status='1' AND (question like '%How resell%' OR question like '%resell%') -- ORDER BY RAND() LIMIT 15 | 1 | SELECT quesid, question, seo, userid
FROM questions
WHERE quesid!='29349' AND status='1'
AND (question like '%How resell%' OR question like '%resell%')
-- ORDER BY RAND()
LIMIT 15 | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() () |
| SELECT * FROM seoclerks.members WHERE USERID='328958' limit 1 | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='328958' limit 1 | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_get_member_profilepicture() |
| SELECT * FROM seoclerks.members WHERE USERID='147' limit 1 | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='147' limit 1 | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_get_member_profilepicture() |
| SELECT * FROM seoclerks.members WHERE USERID='306632' limit 1 | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='306632' limit 1 | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_get_member_profilepicture() |
| SELECT * FROM seoclerks.members WHERE USERID='197137' limit 1 | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='197137' limit 1 | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_get_member_profilepicture() |
| SELECT * FROM seoclerks.members WHERE USERID='311920' limit 1 | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='311920' 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=29349%' 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=29349%'
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='428753.jpg' | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='428753.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 |
TommyCarey
Reselling is pretty simple and I do it almost every single day to customers all over the world
1. What are the best ways to resell a service from seoclerks?
The best way to resell a service from here is to start your own SEO website and sell packages on it. You can cherry-pick the services from here, I like picking Level 3+ members and reselling their services, then you will write up custom pages related to the service you're reselling.
If you're reselling a bulk backlink package then in the description of your own service you'll need to talk about the backlinks, where they will be placed, what type of authority they will have, and how well they will work on new sites as well as aged sites that have done plenty of SEO. If you can keep people reading about the services you're reselling, they will likely pay you for it, and that means you could make 200% profit or more after you come here and purchase the service with your clients' information submitted.
After you have 10+ services listed on your website, all with varying prices, you'll want to start an Adwords campaign. You'll want to make sure your website doesn't mention anything about a guarantee to increase rankings or give the user any sort of hope when it comes to top rankings because your ad campaign for this service will likely get denied.
If you do everything right, split test your ads, and make sure your campaign is as optimized as it possibly can be then you'll get results like this...
This is over the last 2 weeks and I think I've spent around $200 on clicks. I'm averaging around $0.04 per click right now and making much more than I'm investing
It's not tough to do, you just need to run it like a legitimate business and not a side gig because your customers will get annoyed if it takes you 2 weeks to respond to them and they can get a response within an hour from your competitors
2. What other ways can one get paid apart from PayPal?
There are a bunch of ways you can get paid other than PayPal. You can set up an account with Authorize.net, Skrill, Payoneer, etc. I only accept PayPal on my site because I get less fraudulent purchases than when I would accept payments through something like Authorize.net
I do like using 2checkout.com (2co) for my credit card processing because they seem to have a pretty good handle on fraudulent purchases and they tend to not go through when trying to purchase from me. That means I don't have to worry as much when I get a credit card purchase because 2co is monitoring the transactions and flags suspicious payments based on my settings. If the payment seems to come from an account that might be fraudulent, I won't submit the order right away, and I'll tell the buyer there is a 5-day hold on all credit card purchases. This is where you can tell if it's fraudulent or not because the legitimate buyers will usually understand and the fraudulent ones will complain because they know the owner of the card will likely file a chargeback before the work is completed on my end if I do a 5 day hold lol Hey Daragramsmedia, Reselling is pretty simple and I do it almost every single day to customers all over the world :D [b]1. What are the best ways to resell a service from seoclerks?[/b] The best way to resell a service from here is to start your own SEO website and sell packages on it. You can cherry-pick the services from here, I like picking Level 3+ members and reselling their services, then you will write up custom pages related to the service you're reselling. If you're reselling a bulk backlink package then in the description of your own service you'll need to talk about the backlinks, where they will be placed, what type of authority they will have, and how well they will work on new sites as well as aged sites that have done plenty of SEO. If you can keep people reading about the services you're reselling, they will likely pay you for it, and that means you could make 200% profit or more after you come here and purchase the service with your clients' information submitted. After you have 10+ services listed on your website, all with varying prices, you'll want to start an Adwords campaign. You'll want to make sure your website doesn't mention anything about a guarantee to increase rankings or give the user any sort of hope when it comes to top rankings because your ad campaign for this service will likely get denied. If you do everything right, split test your ads, and make sure your campaign is as optimized as it possibly can be then you'll get results like this... [url=https://www.seoclerks.com/files/user/community/000/019/821/adwords blm.1572399501.jpg][url=https://www.seoclerks.com/files/user/community/000/019/821/adwords blm.1572399501.jpg][img]https://www.seoclerks.com/files/user/community/000/019/821/adwords blm.1572399501.jpg[/img][/url][/url] This is over the last 2 weeks and I think I've spent around $200 on clicks. I'm averaging around $0.04 per click right now and making much more than I'm investing :) I do have to pay the freelancers to do the work, but I'm still very profitable for something I don't have to do any work for lol :D It's not tough to do, you just need to run it like a legitimate business and not a side gig because your customers will get annoyed if it takes you 2 weeks to respond to them and they can get a response within an hour from your competitors :) [b]2. What other ways can one get paid apart from PayPal?[/b] There are a bunch of ways you can get paid other than PayPal. You can set up an account with Authorize.net, Skrill, Payoneer, etc. I only accept PayPal on my site because I get less fraudulent purchases than when I would accept payments through something like Authorize.net I do like using 2checkout.com (2co) for my credit card processing because they seem to have a pretty good handle on fraudulent purchases and they tend to not go through when trying to purchase from me. That means I don't have to worry as much when I get a credit card purchase because 2co is monitoring the transactions and flags suspicious payments based on my settings. If the payment seems to come from an account that might be fraudulent, I won't submit the order right away, and I'll tell the buyer there is a 5-day hold on all credit card purchases. This is where you can tell if it's fraudulent or not because the legitimate buyers will usually understand and the fraudulent ones will complain because they know the owner of the card will likely file a chargeback before the work is completed on my end if I do a 5 day hold lol
Are you sure you want to delete this post?