SEOClerks

Questions from user LordLoki

Showing page: 1 of 1

I wanted to put a service on sale but I am getting the message a service can only go on sale once per 31 days I have checked my records and it seems that the last time it was on sale was way more than 40 days back I...

  • LordLoki
    LordLoki Level 3
  • 3 5 years ago

    I am a relatively new seller and have around 70 -80 reviews within 2 months. I saw that the homepage featured costs $1800. So my question is ... is it worth it? My biggest fear is that even if I buy it, then I woul...

  • LordLoki
    LordLoki Level 3
  • 4 6 years ago

    Hello I joined SEO Clerk 2 months back as a seller and enjoying it thoroughly I am curious how can I get more affiliates to promote my offers? I know increasing the affiliate commission will make it more attractive ...

  • LordLoki
    LordLoki Level 3
  • 4 6 years ago

    Hello I have recently started my journey as a seller here and I look forward to learning (and improving) from the more experienced members. >>> This is the link to my second listing on SEOClerk However...

  • LordLoki
    LordLoki Level 3
  • 4 6 years ago

    I have already raised this issue with support and the matter is being investigated for sometime now with not much resolution. So I wanted to ask in the community if anyone else faced this issue. I purchased a 20 pa...

  • LordLoki
    LordLoki Level 3
  • 5 6 years ago

    Can anyone please guide me on how to ask for tips after delivering a service? I have seen there is an automated option for buyers to tip a seller - how do I enable that for my service?

  • LordLoki
    LordLoki Level 3
  • 10 6 years ago

    Is there anyway we can integrate Getresponse with seoclerk so that whenever a customer buys our service, his email address is added to my list?

  • LordLoki
    LordLoki Level 3
  • 1 6 years ago
    Order Now
    Process Time: 0.11976599693298

    Possible Duplicate queries found!
    MatchCountSQLScript
    SELECT * FROM members_ledger WHERE ip = ? AND added>=unix_timestamp(NOW())-864001SELECT querystring, added FROM members_ledger WHERE ip = ? AND added>=unix_timestamp(NOW())-86400

    /opt/clerks-staging/docroot/include/functions/includes/security.php 398 fetchMemberLedger() include_once()

    SELECT * FROM seoclerks.members WHERE username='LordLoki' AND status='1'1SELECT USERID FROM seoclerks.members WHERE username='LordLoki' 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=508287 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=508287 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=508287 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=508287 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='508287'1SELECT profilepicture FROM seoclerks.members WHERE USERID='508287'

    /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.1562791SELECT A.*, B.seo, B.name as categoryname, C.username, C.userlevel, C.lastlogin, C.ip, C.profilepicture FROM wanttobuy 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 '%Facebookfansel%' OR A.skills LIKE '%Facebookfansel%') ORDER BY A.lastgigedit desc LIMIT 0,400.1562790.156279
    0.1251321SELECT A.wantid, A.title, A.p1, A.maxprice, B.name, B.seo FROM wanttobuy A, categories_wanttobuy B WHERE A.wantid != 48523 AND A.category=B.CATID AND A.active=1 AND (A.tags like '%English Blogger Blogging Article%' ) LIMIT 40.1251320.125132
    0.1123781SELECT * FROM members WHERE show_freelancer = 1 AND status = 1 AND total_recommendations > 0 AND (skills LIKE '%blogcommenting%') ORDER BY total_recommendations desc LIMIT 0,400.1123780.112378