SEOClerks

A Seller's Ultimate problem



Write the reason you're deleting this FAQ

A Seller's Ultimate problem

SEOclerks is the best place to sell SEO and SMM services in the entire planet. We, sellers are really blessed to be here. In recent times, some buyers are following a rude way to get things for free. DONT WANT TO MENTION ANY NAMES.

I'm one the most reputed sellers for FB likes, and have lots of regular customers. Couple of days ago, one buyer ordered about 50K likes from me. From the very beginning I have a strange feeling about this order, after giving a few thousands of likes, I stopped and told him, I 'd do the rest tomorrow., I was about to touch the half way mark, so there wouldn't be any chance of cancelling this job.. Gotta a reply from him, he said "I have given this job to 3 sellers in SEOclerks, don't know if the previous likes are given by you. But, no one from my fanpage is seeing my new posts and hit like!! I replied him, that's up to the quality of the posts and the people who liked it, not our concern. Also, Im the only one currently giving likes. He then said, the quality of likes is not good and most of the likes are coming from a specific country. REASON after REASON but different ones... I asked him to pay for what I have done so far. He is sending cancellation requests now.

I contacted the Customer support, they backed me and told me, the buyer looked suspicious!! But, they couldn't ask him to pay for my job so far. I did, he is sending cancellation requests for every 5 minutes A Seller

What's going on? We, sellers have a lot of things to take care of, he isn't really my only problem. Money is not the problem, Truth and Faith is... These kind of buyers are out there, getting stuff from talented sellers and finally threatened to leave a bad feedback for petty issues and thus making the sellers to cancel on their own. FEEDBACK and Appreciation is what we are working for, money comes later. This isn't the first time, I was cheated by this same way. Like I said, its not for money, such SCAMMERS, CHEATERS must be thrown away from this site. How comes a small buyer slamming, and threatening a LEVEL X Seller for petty issues? In the Outside, there are lots of places where FB likes prices are tripled or furthermore, people get it without any complaints, but remember we are the ones who are supplying likes to them as well. If it comes b/w money and feedback, a true seller 'd pick the feedback, it's more precious!!

Im pretty sure, a lot of sellers met with this same problem., I may ask all the affected sellers to give the names of the Suspicious buyers, Scammers immediately to the Customer support and make sure they aren't wandering here anymore...

Regards
SEOfreak

Comments

Please login or sign up to leave a comment

Join
wikicrunch
Yes lot of sellers have problems like these.



Are you sure you want to delete this post?

Bert
I have many of the same issues but only from buyer's of 2 specific countries. Won't mention which!



Are you sure you want to delete this post?

jaymish2
These are some of the disadvantages of working online.You just never know who you are dealing with. They are a lot of scammers out there.You should be careful to clarify terms and conditions before you start. If the job looks like a scam from the get go don’t take it, go with your gut, there is a reason why you have it. Follow your instincts, see from the begging your instincts were warning you about this job.



Are you sure you want to delete this post?

Order Now
Process Time: 0.75174689292908

Possible Duplicate queries found!
MatchCountSQLScript
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='12680'1SELECT 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='12680'

/opt/clerks-staging/docroot/viewfaq.php 496 () ()

SELECT * FROM seoclerks.members WHERE USERID='48593'1SELECT * FROM seoclerks.members WHERE USERID='48593'

/opt/clerks-staging/docroot/include/functions/includes/member.php 445 GetAllUserDetails() ()

SELECT * FROM categories_faq WHERE CATID='42'1SELECT 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=485931SELECT googleplus_profile FROM seoclerks.members WHERE USERID=48593

/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=12680 LIMIT 51SELECT m.username FROM ratings_faq as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=12680 LIMIT 5

/opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() ()

SELECT * FROM answers a, seoclerks.members b WHERE a.quesid='12680' AND a.userid=b.USERID and b.status='1' AND a.status=1 ORDER BY a.combined_votes DESC, a.date_answered asc1SELECT 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='12680' 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=60689 LIMIT 51SELECT m.username FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=60689 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=60690 LIMIT 51SELECT m.username FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=60690 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=178089 LIMIT 51SELECT m.username FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=178089 LIMIT 5

/opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() ()

UPDATE questions SET total_views = total_views + 1 WHERE quesid='12680'1UPDATE questions SET total_views = total_views + 1 WHERE quesid='12680'

/opt/clerks-staging/docroot/include/functions/main.php 1765 update_Faqviewcount() ()

SELECT * FROM questions WHERE quesid!='12680' AND status='1' AND (question like '%A Seller\'s Ultimate problem%' OR question like '%Seller\'s%' OR question like '%Ultimate%' OR question like '%problem%') -- ORDER BY RAND() LIMIT 151SELECT quesid, question, seo, userid FROM questions WHERE quesid!='12680' AND status='1' AND (question like '%A Seller\'s Ultimate problem%' OR question like '%Seller\'s%' OR question like '%Ultimate%' OR question like '%problem%') -- ORDER BY RAND() LIMIT 15

/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() ()

SELECT * FROM seoclerks.members WHERE USERID='1628' limit 11SELECT profilepicture FROM seoclerks.members WHERE USERID='1628' limit 1

/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_get_member_profilepicture()

SELECT * FROM seoclerks.members WHERE USERID='14524' limit 11SELECT profilepicture FROM seoclerks.members WHERE USERID='14524' 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 11SELECT 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='1220' limit 11SELECT profilepicture FROM seoclerks.members WHERE USERID='1220' limit 1

/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_get_member_profilepicture()

SELECT * FROM seoclerks.members WHERE USERID='7247' limit 11SELECT profilepicture FROM seoclerks.members WHERE USERID='7247' 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=12680%' AND added>=UNIX_TIMESTAMP(NOW())-1200 GROUP BY USERID 1SELECT USERID, username FROM members_ledger WHERE script='/opt/clerks-staging/docroot/viewfaq.php' AND querystring LIKE '%id=12680%' AND added>=UNIX_TIMESTAMP(NOW())-1200 GROUP BY USERID

/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() ()

SELECT * FROM categories1SELECT * FROM categories

/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() parseRedundantQueriesCache()

select * from categories_software order by name asc1select * 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 asc1select * 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 asc1select * 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='159895.png'1SELECT profilepicture FROM seoclerks.members WHERE USERID='159895.png'

/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage()

SELECT * FROM seoclerks.members WHERE USERID='337.jpg'1SELECT profilepicture FROM seoclerks.members WHERE USERID='337.jpg'

/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage()

select * from categories_faq order by name asc1select * from categories_faq order by name asc

/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_GetFaqCategories()

Invalid SQL

count(*)sql1error_msg

Expensive SQL

Tuning the following SQL could reduce the server load substantially
LoadCountSQLMaxMin

Suspicious SQL

The following SQL have high average execution times
Avg TimeCountSQLMaxMin
0.0950331SELECT * FROM members WHERE show_freelancer = 1 AND status = 1 AND total_recommendations > 0 AND (skills LIKE '%Musicmarketing%') ORDER BY total_recommendations desc LIMIT 0,400.0950330.095033