SEOClerks

A Great SEO Trouble - Is there a way out?



Write the reason you're deleting this FAQ

A Great SEO Trouble - Is there a way out?

There is this guy who sells PBN service on SEOClerks. I bought a service from him for my one site in the early May of this year and along with that I also bought a couple other services which were just transparent and never did any harm to any of my websites before.

On the 15th May, my website which was ranking on the page 1 for six popular keywords reached on page 7 for all those keywords and since then I haven't been able to got it back to even page 5. I didn't suspect this seller's service after that all.

Today, my other site also reached page 8 for all the keywords that were ranking page 1 before. It happened right after a couple of days of availing that service again.

These 2 sites were the major sources of my income. I am very scared yet happy that I have found what has been doing so much harm to my hard work and bank balance.

Please tell me how do I get back to page 1.

Thanks

Comments

Please login or sign up to leave a comment

Join
Cristian
I suggest you go here: http://pixelgroove.com/serp/sandbox_checker/ - and check your current status for both websites. Maybe you are being Deindexed, Penalized or Sandboxed. Either way, that's too big of a drop to be something like Google Dance.



Are you sure you want to delete this post?

WinnersPBN
Thanks very much for the reply Cristian but my websites haven't been deindexed, penalized or sandboxed at all. He didn't provide me the report about which sites he made my backlinks with but he sent me a couple screenshots of the posts themselves. I tried for about 15-20 minutes and located which sites he made my backlinks with. They are total spammy sites with the stolen content and he didn't even care to spin the content.

He just gave me the money back for my 3rd order but not replying to my requests to delete the posts he made for the other 2 websites.



Are you sure you want to delete this post?

EliteWriter
That is so infuriating. I am very sorry this happened eljefseo. I suggest you publicly mention who this seller is because I feel he is abusing of buyers as well as stealing their money. In your case he also affected your ranking which is something I am sure you worked hard for and it will affect your business. I would certainly let support staff know of this matter so that they will take proper action against this user since he will be affecting the reputation of the site too. As Everett said, when it comes to hiring SEO experts, you need to choose very, very wisely and carefully.



Are you sure you want to delete this post?

WinnersPBN
Yes, Elite, it is indeed very infuriating. I don't think SEOClerks would allow me mention him publicly but I have given him a big red and I don't think anybody would buy his service again after seeing that. I certainly worked hard for the rankings and I spent thousands of dollars for it too. Yes, I will choose very wisely and carefully from now on.

Thanks for the comment.



Are you sure you want to delete this post?

Lynne
Sorry to hear that, it sounds very upsetting. It must be a penalty or something like Cristian said. I woud follow his advice and check on those things.



Are you sure you want to delete this post?

WinnersPBN
I just checked that. There's no penalty or any such thing. Only those backlinks caused it. I have sent him 15 messages and he hasn't replied to a single of those yet.



Are you sure you want to delete this post?

Cristian
If those backlinks are spammy and with a low level of authority you can remove them via Search Console - Links to Your Site. Download the list with your current backlinks and upload a list with the ones you want to disavow.

More info on how to remove harmful backlinks here: https://support.google.com/webmasters/answer/2648487?hl=en



Are you sure you want to delete this post?

idealmike
Fair note. Doing that doesn't actually "remove" the links, it only tells Google not to count them as part of your backlinks. You will still have to actually remove those links. You can try to contact the webmaster of those sites where the links are and politely ask them to remove them for you. Chances are they are more responsive than the seller is. I think it's disgusting when sellers ignore you after you have purchased their service and I think anyone that ignores anyone on here should not be allowed to sell on here. There's no excuse for it and burying their head in the sand is not a good thing to do. I would contact support about this @eljefeseo and make a complaint about the seller ignoring you because as said, there should be no place for that on a professional marketplace and I've had it happen to me before and it's just infuriating. Good luck!



Are you sure you want to delete this post?

WinnersPBN
I am in touch with the seller and certainly update everyone about what happened. Thanks for a great advice @idealmike



Are you sure you want to delete this post?

WinnersPBN
A Little Update

I just kept messaging that seller and turned out he is selling paid cheap backlinks that you get for 10 cent each and which Google bans on sight for 45$. I kept requesting him to delete it and he confessed in the end that he has no control over it and he just buys it for 10 cent each.

Man, SEOClerks must ban these frauds.



Are you sure you want to delete this post?

Everett
That is one thing you have to look out for. All these "SEO Gurus" claiming they have expertise, etc when in fact they have no knowledge of SEO at all. I'm hoping you can recover your rankings back. You should contact support and inform them of the seller as the service may be harmful.



Are you sure you want to delete this post?

WinnersPBN
I think I will do that. I am trying my best to recover the rankings back. These 2 sites are the main source of my income.



Are you sure you want to delete this post?

Corzhens
That’s very expensive lesson to pay for your adventure. At least we now know that buying a service is not exactly the reason and that we should be aware of the potential harm that it can bring our site. I cannot imagine the pain you felt when you realized that your ranking from page 1 went down to the lower pages of the search list. To go back to the former ranking perhaps you can upload new contents more often and tag it with the proper keywords.



Are you sure you want to delete this post?

Order Now
Process Time: 0.11131906509399

Possible Duplicate queries found!
MatchCountSQLScript
SELECT * FROM members_ledger WHERE ip = ? AND added>=unix_timestamp(NOW())-864001SELECT querystring, added FROM members_ledger WHERE ip = ? AND added>=unix_timestamp(NOW())-86400

/opt/clerks-staging/docroot/include/functions/includes/security.php 398 fetchMemberLedger() include_once()

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='18283'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='18283'

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

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

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

SELECT * FROM seoclerks.members WHERE USERID=2619181SELECT googleplus_profile FROM seoclerks.members WHERE USERID=261918

/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=18283 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=18283 LIMIT 5

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

SELECT * FROM answers a, seoclerks.members b WHERE a.quesid='18283' 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='18283' 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=100614 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=100614 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=100619 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=100619 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=100756 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=100756 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=100854 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=100854 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=100636 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=100636 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=100638 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=100638 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=100643 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=100643 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=100647 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=100647 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=100679 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=100679 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=100699 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=100699 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=100705 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=100705 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=100853 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=100853 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=167170 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=167170 LIMIT 5

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

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

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

SELECT * FROM questions WHERE quesid!='18283' AND status='1' AND (question like '%A Great SEO Trouble - out?%' OR question like '%Great%' OR question like '%Trouble%' OR question like '%out?%') -- ORDER BY RAND() LIMIT 151SELECT quesid, question, seo, userid FROM questions WHERE quesid!='18283' AND status='1' AND (question like '%A Great SEO Trouble - out?%' OR question like '%Great%' OR question like '%Trouble%' OR question like '%out?%') -- ORDER BY RAND() LIMIT 15

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

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

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

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

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

SELECT * FROM seoclerks.members WHERE USERID='2637' limit 11SELECT profilepicture FROM seoclerks.members WHERE USERID='2637' 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=18283%' 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=18283%' 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='134.png'1SELECT profilepicture FROM seoclerks.members WHERE USERID='134.png'

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

SELECT * FROM seoclerks.members WHERE USERID='261918.png'1SELECT profilepicture FROM seoclerks.members WHERE USERID='261918.png'

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

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

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

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

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

SELECT * FROM seoclerks.members WHERE USERID='272.jpg'1SELECT 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='2951.jpg'1SELECT profilepicture FROM seoclerks.members WHERE USERID='2951.jpg'

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

SELECT * FROM seoclerks.members WHERE USERID='600657.jpg'1SELECT profilepicture FROM seoclerks.members WHERE USERID='600657.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.1755881SELECT COUNT(A.wantid) AS total FROM wanttobuy as A, categories_wanttobuy B, seoclerks.members C WHERE A.active = 1 AND A.category = B.CATID AND A.USERID = C.USERID 0.1755880.175588