SEOClerks

Answers from user OptimismSEO

Showing page: 1 of 1

After struggling a lot in various platforms finally, I have finally tasted my first income out of SEOclerk. Tried on Fiverr, couldn’t make my mark, mostly because of their nature of work and support team, worst in t...

  • OptimismSEO
    OptimismSEO Level 1
  • 9 9 years ago

    1. Lively music. Diverse sorts of music effectsly affect us, however you can realize which are best for you by experimentation. When you discover the music that awakens you, keep it prepared. Keep a cd in your car, and a...

  • keen2write
    keen2write Level 1
  • 9 9 years ago

    I create new service. But after few hours my services automatic drop in seoclerks. why ? Why ? Why ? please help me.

  • WRITINGMAFIA
    WRITINGMAFIA Level 1
  • 3 9 years ago

    I want to post a Youtube service for my buyers but they keep removing it. How can I post a Youtube service they won't remove? I'm desperate.

  • seytumi
    seytumi Level 1
  • 5 9 years ago

    As part of our on-going effort to keep the SEOClerks Marketplace cleaned up and free of spam, we are deleting services from inactive sellers. After all, these services are another form of spam if you think about it, c...

  • Beverly
    Beverly Level X3
  • 113 9 years ago

    Last week, when I was cleaning up my old hard disc, I found a doc file that contains data linked to a website. It was the website that I had created long ago for some shitty Facebook page, even then I used to post a l...

  • OptimismSEO
    OptimismSEO Level 1
  • 4 9 years ago

    I had said it before in past forums, this is a great platform with lots of opportunity for all of us. Also have mentioned, this market is highly dominated by the SEO experts. What I have seen and discussed, minimum nu...

  • OptimismSEO
    OptimismSEO Level 1
  • 3 9 years ago

    How to get my first sell on seo clerks. help me expert worker in seoclerks and admin please

  • XsNiloy
    XsNiloy Level 1
  • 6 9 years ago

    I am put in a position to purchase items. I do it for 2 reasons: 1. lack of time and 2. I think that someone who writes every day has more experience and can do better than me. Sometimes I take text paragraphs of the a...

  • Livache90
    Livache90 Level 1
  • 1 9 years ago

    Recently I had been using the firefox as had few cool extensions but changed to chrome as it handled my other activities much better and great tools and extensions. Specially Seo tools, From time to time I do use the int...

  • keen2write
    keen2write Level 1
  • 32 9 years ago

    Today how market goes changed. SEO is for a business name for creating path in industry on keywords. But ORM is that give now image for any Name or Company to get better Work. How this got changed when SEO and ORM sim...

  • Babbar86
    Babbar86 Level 1
  • 5 9 years ago

    I am slight disappointed, It’s been 3 months since I’m working on this site, and have understood that this market place is dominated by level 3 and above user, I understand they have worked extremely hard to get t...

  • OptimismSEO
    OptimismSEO Level 1
  • 3 9 years ago

    Hello Everyone, How can I boost sale of my service on SEO Clerks? I am also offering affiliates 25% commission. Promotion of SEO service on Facebook is not allowed on Facebook so I cannot do that. What more can I...

  • bloggersjoy
    bloggersjoy Level 1
  • 2 9 years ago

    Hi, A friend of mine, web designer, says that most customers do not understand what SEO's, and they want result immediately. There are specialized courses in SEO? Offering a title that sounds good (SEO Engineer or som...

  • Livache90
    Livache90 Level 1
  • 5 9 years ago

    Right well to start off by saying I have started promoting seoclerks even more now I just made a animated video about seoclerks . Soon as its uploaded to YouTube going to work on promoting the video . We should all work ...

  • keen2write
    keen2write Level 1
  • 14 9 years ago

    There are so many ways nowadays to get the word out about your business from advertising on similar websites to your niche to adding the link to your website in directories. One other way to get the word out there is off...

  • Shortie861
    Shortie861 Level 1
  • 5 9 years ago
    Order Now
    Process Time: 0.059129953384399

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

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

    SELECT * FROM answers WHERE userid=5412701SELECT distinct quesid FROM answers WHERE userid=541270

    /opt/clerks-staging/docroot/faq.php 258 () ()

    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.quesid IN (21719,21740,21723,21722,21711,21699,21674,21704,21794,21801,22166,22218,22167,22270,22317,22381) 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.quesid IN (21719,21740,21723,21722,21711,21699,21674,21704,21794,21801,22166,22218,22167,22270,22317,22381) 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.quesid IN (21719,21740,21723,21722,21711,21699,21674,21704,21794,21801,22166,22218,22167,22270,22317,22381) 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.quesid IN (21719,21740,21723,21722,21711,21699,21674,21704,21794,21801,22166,22218,22167,22270,22317,22381) 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='541270'1SELECT profilepicture FROM seoclerks.members WHERE USERID='541270'

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

    SELECT * FROM seoclerks.members WHERE USERID='322073'1SELECT profilepicture FROM seoclerks.members WHERE USERID='322073'

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

    SELECT * FROM seoclerks.members WHERE USERID='472424'1SELECT profilepicture FROM seoclerks.members WHERE USERID='472424'

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

    SELECT * FROM seoclerks.members WHERE USERID='409255'1SELECT profilepicture FROM seoclerks.members WHERE USERID='409255'

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

    SELECT * FROM seoclerks.members WHERE USERID='147'1SELECT profilepicture FROM seoclerks.members WHERE USERID='147'

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

    SELECT * FROM seoclerks.members WHERE USERID='505802'1SELECT profilepicture FROM seoclerks.members WHERE USERID='505802'

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

    SELECT * FROM seoclerks.members WHERE USERID='216494'1SELECT profilepicture FROM seoclerks.members WHERE USERID='216494'

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

    SELECT * FROM seoclerks.members WHERE USERID='509977'1SELECT profilepicture FROM seoclerks.members WHERE USERID='509977'

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

    SELECT * FROM seoclerks.members WHERE USERID='39501'1SELECT profilepicture FROM seoclerks.members WHERE USERID='39501'

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

    SELECT * FROM seoclerks.members WHERE USERID='4225'1SELECT profilepicture FROM seoclerks.members WHERE USERID='4225'

    /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.1116881SELECT A.wantid, A.title, A.p1, A.maxprice, B.name, B.seo FROM wanttobuy A, categories_wanttobuy B WHERE A.wantid != 7205 AND A.category=B.CATID AND A.active=1 AND (A.tags like '%Flash Action Script photoshop jquery%' ) LIMIT 40.1116880.111688