SEOClerks

Questions from user jayawa

Showing page: 1 of 1

Please explain me more details about VPS? I need VPS to run youtube bot software? can any one help me?

  • jayawa
    jayawa Level 3
  • 3 13 years ago

    any body tell me can i get moree sells through buying service by admin regarding? Email Feature? Service for 31 days for $35

  • jayawa
    jayawa Level 3
  • 2 13 years ago

    Can any body answer me What is a high (low) bounce rate and does it matter?

  • jayawa
    jayawa Level 3
  • 2 13 years ago

    How affects order cancelation to ratings on my account? also tell me is there any effects to my ratings if orders are get late delivery?

  • jayawa
    jayawa Level 3
  • 1 13 years ago

    Can any body tell me how long will take to get staff? certify one of my service? is there any possibility to remove staff certify again after certification obtained from staff?? so please tell me what are the possible ...

  • jayawa
    jayawa Level 3
  • 1 13 years ago

    please tell me why reverbnation fans un follow in heavily? can any seller add me 400 quality reverbnation fans for $5, they must not un follow, if you can please PM me to my inbox

  • jayawa
    jayawa Level 3
  • 3 13 years ago

    Any body know how to up reverbnation rank in the country, state, city, genre and other categories. it will help to help you move up the reverbnation rankings and charts please tell me a way apart from delivering more r...

  • jayawa
    jayawa Level 3
  • 0 13 years ago

    My country is srilanka, so Could any one tell me how to get verify my payza account, I currently use paypal, but i would like to use payza also, but i didn't know how to verify my payza account...

  • jayawa
    jayawa Level 3
  • 6 13 years ago

    could anyone explain me what are the possible ways can happen account message panel get spamed? please tell me how can overcome of this situation? thanks

  • jayawa
    jayawa Level 3
  • 2 13 years ago

    please tell me can level 2 sellers create services below $5? please explain me in detail what are the benefits can gain from level 2 seller?

  • jayawa
    jayawa Level 3
  • 13 13 years ago

    I am good quality & fast service provider, but my gigs are relatively less viewed by my buyers, there for i get less orders, although i delivered good quality services,? so please help me to get more sells than curre...

  • jayawa
    jayawa Level 3
  • 5 13 years ago

    I am a level 1 seller. can anybody tell am I received another order/s still a one order in processing queue?

  • jayawa
    jayawa Level 3
  • 7 13 years ago

    I am very fresh to seoclearks. so i want to know If I need additional days to complete my order than normal time period in my gig can i request that from the buyer? are my rating is decreased although i completed that o...

  • jayawa
    jayawa Level 3
  • 5 13 years ago
    Order Now
    Process Time: 0.12763094902039

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

    /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.5567501SELECT A.*, C.username, C.profilepicture, C.userlevel, C.ratingcount, C.rating, C.lastlogin, C.ip, C.lip, C.profile_data from posts A, seoclerks.members C WHERE A.active=1 AND A.USERID=C.USERID AND A.sold_out=0 AND category IN (37) AND gtags like'%sextraffic%' AND type !=99 AND A.feat=0 AND A.catfeatured_upgrade=0 order by A.lastgigedit desc limit 0, 400.5567500.556750
    0.3288211SELECT count(A.PID) as total from posts A , seoclerks.members C WHERE A.active=1 AND A.USERID=C.USERID AND A.sold_out=0 AND A.USERID=C.USERID AND category IN (37) AND gtags like'%Seroranking%' AND type !=99 0.3288210.328821
    0.1209001SELECT A.wantid, A.title, A.p1, A.maxprice, B.name, B.seo FROM wanttobuy A, categories_wanttobuy B WHERE A.wantid != 33375 AND A.category=B.CATID AND A.active=1 AND (A.tags like '%Wordpress Automated Blogs Blog%' ) LIMIT 40.1209000.120900