SEOClerks

Clear
Sign In Join

SEOCLERKS, digging it's own grave

  • pacospain Level 3
    • 4

    Write the reason you're deleting this FAQ

    SEOCLERKS, digging it's own grave

    Seoclerks is digging it's own grave with bad sellers, that state anything they want and nothing is done about it

    I.E.
    24 hour service --> they never or deliver 5 days later
    telling you every lie to get an order and again -->> they do not deliver or 1 week to late
    90% of the sellers on this platform are not taking at all responsibility of their work, quality is bad, most of them do not speak English at all, most of them don't give a damn about anything

    ordered on 5 different people that state 24 hour service or 2 days service, got a message i start on your order and they never do anything, it's incredible annoying, I am happy I am not like that i always deliver quality and on time!

    I bet on it most of these sellers have 3 or 4 accounts on the platform

    i rather pay a bit more knowing they do the job GOOD and that they really DOING IT.

    bad sellers here bad platform, i reported a few that their headings of service is misleading SEOCLERK did not do anything about it...why?

    digging your own grave it's only getting more worse if nothing is done against it

    just my opinion and view on it

    # Freelance
    Share post:

    Comments

    Please login or sign up to leave a comment

    Join
    khorshed088

    khorshed088

    good to opinion.
    10 years ago

    Are you sure you want to delete this post?

    vin99

    vin99

    Seoclerks is digging it's own grave with bad sellers, that state anything they want and nothing is done about it

    I.E.
    24 hour service --> they never or deliver 5 days later
    telling you every lie to get an order and again -->> they do not deliver or 1 week to late
    90% of the sellers on this platform are not taking at all responsibility of their work, quality is bad, most of them do not speak English at all, most of them don't give a damn about anything

    ordered on 5 different people that state 24 hour service or 2 days service, got a message i start on your order and they never do anything, it's incredible annoying, I am happy I am not like that i always deliver quality and on time!

    I bet on it most of these sellers have 3 or 4 accounts on the platform

    i rather pay a bit more knowing they do the job GOOD and that they really DOING IT.

    bad sellers here bad platform, i reported a few that their headings of service is misleading SEOCLERK did not do anything about it...why?

    digging your own grave it's only getting more worse if nothing is done against it

    just my opinion and view on it


    I guess you ordered twitter followers...
    I had the same issue when I ordered twitter followers.. they say mix quality and all turned out to be eggs SEOCLERKS, digging it
    10 years ago

    Are you sure you want to delete this post?

    Asmodeus

    Asmodeus

    I get the most laughs from the WTB section. Buyers will post exactly what they want and yet I always see sellers posting their irrelevant services on the page saying "Hire me now", but they can't even read and understand what is required of them.
    10 years ago

    Are you sure you want to delete this post?

    Barida

    Barida

    The terms and conditions in place make it possible for a buyer to cancel an order as long as the seller does not follow the terms of contracts agreed before such works are set in motion. So, I don't think it is SEOClerks admins faults, but that of those sellers that select a service that they can't be able to offer.
    9 years ago

    Are you sure you want to delete this post?

    Order Now
    Process Time: 0.26704597473145

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

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

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

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

    SELECT * FROM seoclerks.members WHERE USERID=4234001SELECT googleplus_profile FROM seoclerks.members WHERE USERID=423400

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

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

    SELECT * FROM answers a, seoclerks.members b WHERE a.quesid='13424' 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='13424' 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=68517 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=68517 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=68518 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=68518 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=68519 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=68519 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=136200 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=136200 LIMIT 5

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

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

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

    SELECT * FROM questions WHERE quesid!='13424' AND status='1' AND (question like '%SEOCLERKS, digging grave%' OR question like '%SEOCLERKS,%' OR question like '%digging%' OR question like '%grave%') -- ORDER BY RAND() LIMIT 151SELECT quesid, question, seo, userid FROM questions WHERE quesid!='13424' AND status='1' AND (question like '%SEOCLERKS, digging grave%' OR question like '%SEOCLERKS,%' OR question like '%digging%' OR question like '%grave%') -- ORDER BY RAND() LIMIT 15

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

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

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

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

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

    SELECT * FROM seoclerks.members WHERE USERID='42124' limit 11SELECT profilepicture FROM seoclerks.members WHERE USERID='42124' 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 11SELECT 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 members_ledger WHERE script='/opt/clerks-staging/docroot/viewfaq.php' AND querystring LIKE '%id=13424%' 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=13424%' 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='167023.jpg'1SELECT profilepicture FROM seoclerks.members WHERE USERID='167023.jpg'

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

    SELECT * FROM seoclerks.members WHERE USERID='617077.jpg'1SELECT profilepicture FROM seoclerks.members WHERE USERID='617077.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.1746491SELECT 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.1746490.174649
    0.1142351SELECT A.wantid, A.title, A.p1, A.maxprice, B.name, B.seo FROM wanttobuy A, categories_wanttobuy B WHERE A.wantid != 51013 AND A.category=B.CATID AND A.active=1 AND (A.tags like '%Level3 Level4 Level5%' ) LIMIT 40.1142350.114235