SEOClerks

Questions from user ppscslv

Showing page: 1 of 1

Hi, I'm using Payoneer because it's a very fast way to withdraw your money. Unfortuantely on Seoclerks, from a few weeks (i think...) a bottleneck is created by the too long processing withdrawal request. I understand...

  • ppscslv
    ppscslv Level X5
  • 24 8 years ago

    After several years as a freelancer, I noticed that the most buyers who create problems (usualy trying to steal my work or to get get refund under the bad review pressure), are from a few countries in the world. I can't ...

  • ppscslv
    ppscslv Level X5
  • 15 9 years ago

    What's the best working YouTube bot to get YT views (or even likes, comments, etc)? I don't want anything that can get me banned.

  • ppscslv
    ppscslv Level X5
  • 7 10 years ago

    What SEO software is used to get thousands of backlinks? I see some sellers are selling 50K backlinks or 100k live backlinks for $5. One of them should be Scrapebox, usually to get blog comments, but other SEO softwar...

  • ppscslv
    ppscslv Level X5
  • 12 10 years ago

    Here, on Seoclerks, some niches rocked in the music industry: cheap prices (starting from $1) and lots of plays. Usually who offer most plays at cheapest price ($1) he get the most customers - it's called competition in ...

  • ppscslv
    ppscslv Level X5
  • 12 10 years ago

    I wish to every seller and buyer a happy new year!!!

  • ppscslv
    ppscslv Level X5
  • 17 10 years ago

    Hi, When I try to access a Seoclerks service via an affiliate link I get an error: invalid certificate. This error will keep many new customers out of seoclerks (or at least very suspicious) if it will not be fixed. A...

  • ppscslv
    ppscslv Level X5
  • 5 10 years ago

    In the last month I encountered many problems with Seoclerks: it banned legal bookmarking services (manual bookmarking on twitter, facebook, etc), it banned legal music services (like sharing music on twitter, facebook, ...

  • ppscslv
    ppscslv Level X5
  • 17 11 years ago

    Hi, Last evening I tried to Free Bump one SoundCloud service (I had 5 free bumps available), but I couldn't and a message notified me that bumping the service in not allowed. I tried to free bump other SoundCloud servi...

  • ppscslv
    ppscslv Level X5
  • 9 11 years ago

    Hi, I started this Samsung Galaxy (S4,S5,Note2,Note3) G+ page https://plus.google.com/106540732086836623615/posts 1 year and half ago, and now I have more than 32,000 real followers (most of them are from USA). The pro...

  • ppscslv
    ppscslv Level X5
  • 4 12 years ago

    Hi, Recently I saw that many sellers from here have affiliate stores that sell Seoclerks services. It's a great idea and I would like to create that kind of store, but I don't know what script to use or what to do. I ma...

  • ppscslv
    ppscslv Level X5
  • 17 12 years ago
    Order Now
    Process Time: 0.12795805931091

    Possible Duplicate queries found!
    MatchCountSQLScript
    SELECT * FROM seoclerks.members WHERE username='ppscslv' AND status='1'1SELECT USERID FROM seoclerks.members WHERE username='ppscslv' AND status='1'

    /opt/clerks-staging/docroot/include/functions/includes/member.php 627 GetUseridFromUsername() ()

    SELECT * FROM questions A, categories_faq B, seoclerks.members C where A.status='1' AND A.catid=B.CATID AND A.userid=C.USERID AND A.userid=6995 LIMIT 11SELECT count(A.quesid) as total FROM questions A, categories_faq B, seoclerks.members C where A.status='1' AND A.catid=B.CATID AND A.userid=C.USERID AND A.userid=6995 LIMIT 1

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

    SELECT * FROM questions A, categories_faq B, seoclerks.members C where A.status='1' AND A.catid=B.CATID AND A.userid=C.USERID AND A.userid=6995 ORDER BY A.sticky DESC, A.date_asked DESC LIMIT 0, 401SELECT A.*, C.username, C.userlevel FROM questions A, categories_faq B, seoclerks.members C where A.status='1' AND A.catid=B.CATID AND A.userid=C.USERID AND A.userid=6995 ORDER BY A.sticky DESC, A.date_asked DESC LIMIT 0, 40

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

    SELECT * from questions as A where A.status='1' 1SELECT count(A.quesid) as total from questions as A where A.status='1'

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

    SELECT * FROM answers as A where A.status='1' 1SELECT count(A.ansid) as total FROM answers as A where A.status='1'

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

    SELECT * FROM members_ledger WHERE (script='/opt/clerks-staging/docroot/faq.php' OR script='/opt/clerks-staging/docroot/viewfaq.php') AND added>=UNIX_TIMESTAMP(NOW())-1200 GROUP BY USERID 1SELECT USERID, username FROM members_ledger WHERE (script='/opt/clerks-staging/docroot/faq.php' OR script='/opt/clerks-staging/docroot/viewfaq.php') 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='6995'1SELECT profilepicture FROM seoclerks.members WHERE USERID='6995'

    /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.1037361SELECT * FROM members WHERE show_freelancer = 1 AND status = 1 AND total_recommendations > 0 AND (skills LIKE '%Seolerks%') ORDER BY total_recommendations desc LIMIT 0,400.1037360.103736
    0.1011891SELECT * FROM members WHERE show_freelancer = 1 AND status = 1 AND total_recommendations > 0 AND (skills LIKE '%Seo-%') ORDER BY total_recommendations desc LIMIT 0,400.1011890.101189
    0.0711921SELECT count(USERID) AS total FROM members WHERE show_freelancer = 1 AND status = 1 AND total_recommendations > 0 AND (skills LIKE '%Seolerks%') 0.0711920.071192