SEOClerks

Questions from user vinothmech

Showing page: 1 of 1

Hi, Started my journey 3 years ago in SEOClerks. Seen lot of good and bad things in life But this site completely turned my life. Million thanks to @jordan All the gadgets and things I am using are from SEOClerks ear...

  • vinothmech
    vinothmech Level X3
  • 8 11 years ago

    Happy to announce that I have reached a milestone of 3000 Positive Feedback. I started Freelancing 579 days ago in SEOClerks. Satisfied now that I achieved something really good. http://prntscr.com/46eue7 In this happy...

  • vinothmech
    vinothmech Level X3
  • 43 12 years ago

    Hello everyone, Real Bad news for all Youtube views suppliers. Youtube doing a major update, millions of videos are deleted in past 7 days. All sellers over the world have no clue with this update. Scripts, ...

  • vinothmech
    vinothmech Level X3
  • 6 12 years ago

    Hi, I am very much interested to suggest Live Portfolio feature in Seoclerks. Live portfolio feature provides the buyer clear idea of what he is going to get and seller recent work. For example if I am doing Facebook ...

  • vinothmech
    vinothmech Level X3
  • 10 12 years ago

    Hi, I am @vinothmech . I am very happy to announce that I reached 2000 Positive feedbacks in a little time without a negative review. Seoclerks changed my life and I am very happy that I am part of it. I thank all sell...

  • vinothmech
    vinothmech Level X3
  • 31 12 years ago

    Hi, I have heard that Seoclerks started removing Soundcloud services from here. Soundcloud made announcement that won't purchase plays, followers, likes from Seoclerks in their forum. Today my client cancelled 3 orders...

  • vinothmech
    vinothmech Level X3
  • 3 12 years ago

    Hi, Beware Youtube started hunting videos again. Entire algorithm to views counter changes. 301 is not the checking point now. They started checking each and every views source. If you use any black hat method previous...

  • vinothmech
    vinothmech Level X3
  • 5 12 years ago

    Hi, One most the most wanted and waiting feature everyone needed is Live now. https://www.seoclerks.com/buygiftcard You can Gift you money to any one of your Wish. Amount The amount will be the value of the gift ca...

  • vinothmech
    vinothmech Level X3
  • 1 12 years ago

    Hi, I have Joined SEOclerks in December 23, 2012. Positive Feedback - 961 Negative Feedback - 0 Thanks to all sellers and Buyers Who have made me achieve this level in Short time. Recently Jordon Promoted me to LEV...

  • vinothmech
    vinothmech Level X3
  • 8 12 years ago

    Hi, Youtube Updated 2 days ago. Any one Experiencing problem in providing youtube views? Views not updating properly for me. Even retention views not working. Seems like youtube changes their algorithm!!

  • vinothmech
    vinothmech Level X3
  • 5 12 years ago

    Hi, I have send nearly 15 message to different persons within an hour. I am trying to provide price list to TOP reputed buyers here. This is the message """Hi, I am one of the Best supplier of Social media service in ...

  • vinothmech
    vinothmech Level X3
  • 15 12 years ago

    I am planning to add Affiliates with the coupon code. I know "How to create coupon for providing Discount in the Seoclerks service" But I want that code to be used by the new members and add that to their Seoclerks Balan...

  • vinothmech
    vinothmech Level X3
  • 1 13 years ago

    What is the minimum amount of withdrawal for level1? Please help me soon???

  • vinothmech
    vinothmech Level X3
  • 10 13 years ago

    Hi, I want 20$ transferred from my paypal to SEOCLERKS account. Can I do this? Is credit cards required for that? How much amount deduce if I transfer? Please clarify

  • vinothmech
    vinothmech Level X3
  • 10 13 years ago

    Is ay tool available to get you tube views. Many freelancers giving 40000 views. How is this possible???

  • vinothmech
    vinothmech Level X3
  • 6 13 years ago
    Order Now
    Process Time: 0.12534785270691

    Possible Duplicate queries found!
    MatchCountSQLScript
    SELECT * FROM seoclerks.members WHERE username='vinothmech' AND status='1'1SELECT USERID FROM seoclerks.members WHERE username='vinothmech' 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=23280 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=23280 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=23280 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=23280 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='23280'1SELECT profilepicture FROM seoclerks.members WHERE USERID='23280'

    /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.1450451SELECT time FROM inbox2 WHERE MSGFROM = ? AND action = 'delivery' ORDER BY time DESC LIMIT 10.1450450.145045
    0.1252661SELECT 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 AND (A.tags LIKE '%Makeaccounttwi%' OR A.skills LIKE '%Makeaccounttwi%')0.1252660.125266
    0.0943661SELECT * FROM members WHERE show_freelancer = 1 AND status = 1 AND total_recommendations > 0 AND (skills LIKE '%Nondrops%') ORDER BY total_recommendations desc LIMIT 0,400.0943660.094366
    0.0936631SELECT * FROM members WHERE show_freelancer = 1 AND status = 1 AND total_recommendations > 0 AND (skills LIKE '%webresearch%') ORDER BY total_recommendations desc LIMIT 0,400.0936630.093663
    0.0724281SELECT SUM(price*quantity) as total FROM seoclerks.orders WHERE seller_USERID = ?0.0724280.072428