Write the reason you're deleting this FAQ
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 
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
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='12680' | 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='12680' | /opt/clerks-staging/docroot/viewfaq.php 496 () () |
| SELECT * FROM seoclerks.members WHERE USERID='48593' | 1 | SELECT * FROM seoclerks.members WHERE USERID='48593' | /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=48593 | 1 | SELECT 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 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=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 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='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 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=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 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=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 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=178089
LIMIT 5 | /opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() () |
| UPDATE questions SET total_views = total_views + 1 WHERE quesid='12680' | 1 | UPDATE 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 15 | 1 | SELECT 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 1 | 1 | SELECT 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 1 | 1 | SELECT 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 1 | 1 | SELECT 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 1 | 1 | SELECT 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 1 | 1 | SELECT 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 | 1 | SELECT 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 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='159895.png' | 1 | SELECT 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' | 1 | SELECT 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 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 |
| 0.095033 | 1 | SELECT * FROM members WHERE show_freelancer = 1 AND status = 1 AND total_recommendations > 0 AND (skills LIKE '%Musicmarketing%') ORDER BY total_recommendations desc LIMIT 0,40 | 0.095033 | 0.095033 |
wikicrunch
Are you sure you want to delete this post?