rnett
Level 1
Write the reason you're deleting this FAQ
I started with seoclerks this week. I bought $5 links from 4 sellers. 2 of the sellers made spun pages, one had sex words on the pages and the other had only a hyper link on each page. 10 of the 50 pages semrhsh ranked as a zero for Trust Score. Did buy black hat hurt my competitor links for myself? How do I ask or convey what want for next orders. I think I would ask for non spun content, no sexual words on pages, no zero Trust Score pages. I will have to disavow 50% to 75% of these pages. How do I get quality work without being overcharged. Rich
| Match | Count | SQL | Script |
| SELECT * FROM members_ledger WHERE ip = ? AND added>=unix_timestamp(NOW())-86400 | 1 | SELECT 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='29489' | 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='29489' | /opt/clerks-staging/docroot/viewfaq.php 496 () () |
| SELECT * FROM seoclerks.members WHERE USERID='867481' | 1 | SELECT * FROM seoclerks.members WHERE USERID='867481' | /opt/clerks-staging/docroot/include/functions/includes/member.php 445 GetAllUserDetails() () |
| SELECT * FROM seoclerks.members WHERE USERID=867481 | 1 | SELECT googleplus_profile FROM seoclerks.members WHERE USERID=867481 | /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=29489 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=29489
LIMIT 5 | /opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() () |
| SELECT * FROM answers a, seoclerks.members b WHERE a.quesid='29489' 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='29489' 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=188981 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=188981
LIMIT 5 | /opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() () |
| UPDATE questions SET total_views = total_views + 1 WHERE quesid='29489' | 1 | UPDATE questions SET total_views = total_views + 1 WHERE quesid='29489' | /opt/clerks-staging/docroot/include/functions/main.php 1765 update_Faqviewcount() () |
| SELECT * FROM questions WHERE quesid!='29489' AND status='1' AND (question like '%New seoclerks, Mistakes%' OR question like '%seoclerks,%' OR question like '%Mistakes%') -- ORDER BY RAND() LIMIT 15 | 1 | SELECT quesid, question, seo, userid
FROM questions
WHERE quesid!='29489' AND status='1'
AND (question like '%New seoclerks, Mistakes%' OR question like '%seoclerks,%' OR question like '%Mistakes%')
-- ORDER BY RAND()
LIMIT 15 | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() () |
| SELECT * FROM seoclerks.members WHERE USERID='39006' limit 1 | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='39006' limit 1 | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_get_member_profilepicture() |
| SELECT * FROM seoclerks.members WHERE USERID='22718' limit 1 | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='22718' limit 1 | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_get_member_profilepicture() |
| SELECT * FROM seoclerks.members WHERE USERID='632' limit 1 | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='632' limit 1 | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_get_member_profilepicture() |
| SELECT * FROM seoclerks.members WHERE USERID='2044' limit 1 | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='2044' limit 1 | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_get_member_profilepicture() |
| SELECT * FROM seoclerks.members WHERE USERID='212316' limit 1 | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='212316' 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=29489%' 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=29489%'
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 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 |
TommyCarey
The problem with this is that...
You always get what you paid for and that's is very true when it comes to backlinks and SEO. I couldn't tell you how many times I've quoted a potential client $1,500+ a month for SEO services and they say "I can outsource this for $10 and get the same thing" and then they're coming back and paying me more than I quoted because the $10 service they purchased hurt their site and rankings.
I'm not saying that cheap services are bad, I'm saying you need to learn to filter them a bit more, and you will find some really nice people selling services at a discounted rate that will boost your rankings exponentially
What I like to do is contact the seller prior to purchasing and see how long it takes them to respond. If they take a few days to respond, and they only respond with a few words, I'll usually avoid them because a good seller will respond and answer all of my questions as well as answer additional questions that may pop up in the future. If you contact the seller prior to purchase you can get all your questions asked, get a better understanding of what the service will look like when finished, and have a better case on your hands if they don't deliver what was promised.
The services you purchased sound like they were done using software to spin articles and place them wherever they could. This will never help your SEO and you may have a loss on your hands. I would disavow all of the links because the work was shotty from the start. You might even be able to reject the order completely, get your money back, and purchase something that will help you out better in the long run. Take your refunds and purchase something more expensive even if it has fewer links, just be sure the links getting placed are better than what you previously purchased so you get the biggest benefit within the SERPs.
Thanks,
Tommy Hey Rich, The problem with this is that... [quote][i]How do I get quality work without being overcharged?[/i][/quote]You always get what you paid for and that's is very true when it comes to backlinks and SEO. I couldn't tell you how many times I've quoted a potential client $1,500+ a month for SEO services and they say "I can outsource this for $10 and get the same thing" and then they're coming back and paying me more than I quoted because the $10 service they purchased hurt their site and rankings. I'm not saying that cheap services are bad, I'm saying you need to learn to filter them a bit more, and you will find some really nice people selling services at a discounted rate that will boost your rankings exponentially :) I always tell new sellers to offer their services for cheap so they can get a flood of traffic and sales, which turn into reviews, then they can boost their overall sales while increasing their prices gradually. Finding these types of sellers is a difficult thing to do, but it can be done, you just have to be picky about who you buy from. What I like to do is contact the seller prior to purchasing and see how long it takes them to respond. If they take a few days to respond, and they only respond with a few words, I'll usually avoid them because a good seller will respond and answer all of my questions as well as answer additional questions that may pop up in the future. If you contact the seller prior to purchase you can get all your questions asked, get a better understanding of what the service will look like when finished, and have a better case on your hands if they don't deliver what was promised. The services you purchased sound like they were done using software to spin articles and place them wherever they could. This will never help your SEO and you may have a loss on your hands. I would disavow all of the links because the work was shotty from the start. You might even be able to reject the order completely, get your money back, and purchase something that will help you out better in the long run. Take your refunds and purchase something more expensive even if it has fewer links, just be sure the links getting placed are better than what you previously purchased so you get the biggest benefit within the SERPs. Thanks, Tommy
Are you sure you want to delete this post?