SEOClerks

Questions from user haas

Showing page: 1 of 1

Free boost feature made seoclerks stand out from traditional marketplaces. Even many of us left other markets for their autocratic algorithms & non-friendliness about new sellers. Seoclerks was a perfect place f...

  • haas
    haas Level 3
  • 9 5 years ago

    If I set my account to out of office for 1-2 months, will I be demoted to level 1? As there's a requirement for level 3 "Login very often (once per 7 days)"...

  • haas
    haas Level 3
  • 3 5 years ago

    Once I tried to respond a message at a new conversation, a yellow pop up says: "You have Private Messages disabled. Please enable in order to send this user a message" What does it mean & how to enable that? ...

  • haas
    haas Level 3
  • 4 5 years ago

    We know that a buyer can create custom order from seller's profile page. But is there any way to create custom offer by seller? Some of my client asked me to send them offer. How can I do that, then? Thanks in...

  • haas
    haas Level 3
  • 4 5 years ago

    One of my respected client placed an order by mistake. & sent me a mutual cancellation request. So, if I accept that, will it affect my account/services/visibility to audience anyhow? Thanks

  • haas
    haas Level 3
  • 6 5 years ago

    My client sent me a custom offer And I accepted & completed that. Later he purchased the same offer without my acceptance. Now I want to discard that offer so that he has to send the offer again. & when I'...

  • haas
    haas Level 3
  • 2 5 years ago

    Sometimes we just start working for the requirements. Later the buyer gets a better result than expected. That's the time for showing a popup on order completion to ask the buyer to give seller a tip. It's jus...

  • haas
    haas Level 3
  • 3 5 years ago

    Is there any option for enabling notification sound anyhow? For new alerts. Sometimes It gets too late to reply important messages.

  • haas
    haas Level 3
  • 6 5 years ago

    Hi there, If I withdraw balance from seoclerk to local bank through payoneer, 1. How much will be deducted in the meantime? 2. And how much will be deposted finally in my local bank account? 3. Does pay...

  • haas
    haas Level 3
  • 2 5 years ago
    Order Now
    Process Time: 0.13476395606995

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

    /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
    2.6220461SELECT 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 (21,63) AND gtags like'%Access%' AND type !=99 AND A.feat=0 AND A.catfeatured_upgrade=0 order by A.lastgigedit desc limit 0, 402.6220462.622046