bwwind
Level 1
Write the reason you're deleting this FAQ
Hi, I'm a new member here, got some questions as following:
1.Most of the package prices, for web ranking, social media, backlinks,youtube views,etc., are obviously cheaper than other SEO servivers provided. Are these services all black or grey hat style? If not, why cheaper?
2.The buyers here, are their websites all home business, not enterprise business? If the second, why they choose the services here, just only because the cheaper prices? Now I'm running the second one, can I buy the services here? Change a word, do these services fit for me?
3.There're lots of seller who said guarantee the 1st page of Google, however, how long can this ranking be maintained?
| 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='11501' | 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='11501' | /opt/clerks-staging/docroot/viewfaq.php 496 () () |
| SELECT * FROM seoclerks.members WHERE USERID='238625' | 1 | SELECT * FROM seoclerks.members WHERE USERID='238625' | /opt/clerks-staging/docroot/include/functions/includes/member.php 445 GetAllUserDetails() () |
| SELECT * FROM seoclerks.members WHERE USERID=238625 | 1 | SELECT googleplus_profile FROM seoclerks.members WHERE USERID=238625 | /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=11501 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=11501
LIMIT 5 | /opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() () |
| SELECT * FROM answers a, seoclerks.members b WHERE a.quesid='11501' 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='11501' 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=52050 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=52050
LIMIT 5 | /opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() () |
| UPDATE questions SET total_views = total_views + 1 WHERE quesid='11501' | 1 | UPDATE questions SET total_views = total_views + 1 WHERE quesid='11501' | /opt/clerks-staging/docroot/include/functions/main.php 1765 update_Faqviewcount() () |
| SELECT * FROM questions WHERE quesid!='11501' AND status='1' AND (question like '%Some hard questions I join forum.%' OR question like '%Some%' OR question like '%hard%' OR question like '%questions%' OR question like '%join%' OR question like '%forum.%') -- ORDER BY RAND() LIMIT 15 | 1 | SELECT quesid, question, seo, userid
FROM questions
WHERE quesid!='11501' AND status='1'
AND (question like '%Some hard questions I join forum.%' OR question like '%Some%' OR question like '%hard%' OR question like '%questions%' OR question like '%join%' OR question like '%forum.%')
-- ORDER BY RAND()
LIMIT 15 | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() () |
| SELECT * FROM seoclerks.members WHERE USERID='3160' limit 1 | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='3160' limit 1 | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_get_member_profilepicture() |
| SELECT * FROM seoclerks.members WHERE USERID='3489' limit 1 | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='3489' 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='3738' limit 1 | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='3738' 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=11501%' 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=11501%'
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='147.jpg' | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='147.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 |
Beverly
To answer some of your questions, the buyers of SEOClerks services are all varieties, both home business and enterprise level (such as locally owned businesses).
Not every buyer chooses a service on SEOClerks based on cheap price.
And, actually I would never recommend buying a service based solely on price.
You will be best served to choose an SEO services provider who has an excellent rating; many positive recommendations and reviews and a solid history of good job performance.
As for which package you should buy and whether or not that service will work for you will depend on the seller you choose along with a number of other factors.
Although I have not used his services personally, I have heard amazing things about @BarryinSiam with his SEO related services. He has over 1000 positive ratings on one of his services. There are many other excellent sellers here and I'm looking forward to others talking about the successful sellers that have delivered results for them. These are some excellent questions. And, I look forward to answers by those who actually provide SEO (blackhat/grayhat/whitehat) services on SEOClerks. To answer some of your questions, the buyers of SEOClerks services are all varieties, both home business and enterprise level (such as locally owned businesses). Not every buyer chooses a service on SEOClerks based on cheap price. And, actually I would never recommend buying a service based solely on price. You will be best served to choose an SEO services provider who has an excellent rating; many positive recommendations and reviews and a solid history of good job performance. As for which package you should buy and whether or not that service will work for you will depend on the seller you choose along with a number of other factors. Although I have not used his services personally, I have heard amazing things about @[USER=205]BarryinSiam[/USER] with his SEO related services. He has over 1000 positive ratings on one of his services. There are many other excellent sellers here and I'm looking forward to others talking about the successful sellers that have delivered results for them.
Are you sure you want to delete this post?