SEOClerks

Questions from user OptimismSEO

Showing page: 1 of 1

Hello to my SEOclerks family, It has been a while since my last post in May, I’ve been busy with MBA classes and work. Hope you guys are doing well. I am not doing very well in SEOclerks, with the sudden increase...

  • OptimismSEO
    OptimismSEO Level 1
  • 10 9 years ago

    In the world of freelance being busy is great and having multiple projects to manage is much more of a blessing than a curse, but that doesn’t make it any easier when there are deadlines, client expectations and budget...

  • OptimismSEO
    OptimismSEO Level 1
  • 7 9 years ago

    When we go to a market to get certain things we tend to browse the market and buy from the seller that offers the lower price than other sellers or offer perks. Same with me, when I tend to buy something expensive, like ...

  • OptimismSEO
    OptimismSEO Level 1
  • 5 9 years ago

    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

    If you guys have read my previous post on “The struggles of balancing your freelance work life with real life concerns” then probably some of you guys already know my struggle. Just recently working with both my p...

  • OptimismSEO
    OptimismSEO Level 1
  • 5 9 years ago

    Remember how I cracked my first deal on fiverr? afterbeing removed and banned from fiverr, I managed to re-enter and create a service with very honesty possible by any humankind. Through constantly monitoring, I have se...

  • OptimismSEO
    OptimismSEO Level 1
  • 6 9 years ago

    Last month, I got a message from a buyer saying that he has a list of forums and I just need to register on each of these forums. His rate was 1$ for 10 forum registrations. At first, I didn’t agree because it seems li...

  • OptimismSEO
    OptimismSEO Level 1
  • 3 9 years ago

    I had a hard time landing a job during the first few months, but as time went on, I got accepted for various projects depending on the skill required. The hardest part would have to find a buyer to choose you even if you...

  • OptimismSEO
    OptimismSEO Level 1
  • 10 9 years ago

    FULL SPECS OF MY RIG: - INTEL i7 6700K - ASUS Z170 Maximus VIII Hero - G SKILL Ripjaws X 8GB (2X4GB) DDR4 - WESTERN DIGITAL 1 TB SATA III HDD - MSI GTX 980 Ti Gaming - THERMALTAKE Core V51 750W - CORSAIR H80i GT...

  • OptimismSEO
    OptimismSEO Level 1
  • 3 9 years ago

    AT the very beginning of the year, after being removed and banned from fiverr, I managed to re-enter and create a gig with very honesty possible by any human kind. Through constantly monitoring, I have seen that the gig ...

  • OptimismSEO
    OptimismSEO Level 1
  • 8 9 years ago

    I have seen my father when he used to come home from his office, he would bring his work along with him and continue to work until late night eventually passing out on his desk, rather than spending time with his family ...

  • OptimismSEO
    OptimismSEO Level 1
  • 7 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

    It's been a rock solid operating system and perfectly usable within its limits. The moment when you feel secure with your Windows XP and it does what you want it to do, but one day something bad happens, it locks up and ...

  • OptimismSEO
    OptimismSEO Level 1
  • 8 9 years ago

    There are days, When I have more on my plate than I can ask for, too many orders in a single day and I am all alone to complete with the top quality service is a challenge. To be honest, I am very very happy when I get p...

  • OptimismSEO
    OptimismSEO Level 1
  • 11 9 years ago

    Last month, I got an order of 100+ comments for Youtube. It was a very easy job and for 100 comments it usually takes less than a day to complete. But it took me over 2 weeks, That’s right! In the beginning, it was...

  • OptimismSEO
    OptimismSEO Level 1
  • 4 9 years ago

    Just recently I have finished an order related to YouTube from a buyer whose language I am not familiar with. Usually, I give my buyers a lot of perks with the service purchased, but in this case, I asked the buyer if he...

  • OptimismSEO
    OptimismSEO Level 1
  • 3 9 years ago

    There is a saying in management, that the greatest tool to motivate the employees is money. But now things have changed over time, money isn’t the only thing. For example, Google allows their employees superior freedom...

  • OptimismSEO
    OptimismSEO Level 1
  • 17 9 years ago

    Blogging is fully based on text. There are many kinds of blogs, travel blogs, cooking blogs,tech blogs etc. Let me put it this way, you plan to go somewhere, for a holiday destination, you want to know about that plac...

  • OptimismSEO
    OptimismSEO Level 1
  • 4 9 years ago

    Have you guys felt to highlight a customer in a bigger picture, in some other platform because I’m not sure you cannot do anything out here, especially if your target of concerned is the customer itself, who pays you f...

  • OptimismSEO
    OptimismSEO Level 1
  • 2 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

    Hello, If you’re a newbie and have zero or low ratings for your service gig based on YouTube then this is for you, it’s been a while since I’m here and based on my experience SEOclerk is a very promising platfor...

  • OptimismSEO
    OptimismSEO Level 1
  • 2 9 years ago

    Hello, Last month, I had an order for YouTube user engagement on a particular video and it annoyed me the whole time as I was begging to finish with this order as early as possible. It was a video of some Indian du...

  • OptimismSEO
    OptimismSEO Level 1
  • 2 9 years ago

    What do you guys think of SEOclerks Help desk? I think these guys are simply awesome. I even remember a few of their names because I ask for their support almost every day. Sometimes It is difficult understand them, I ...

  • OptimismSEO
    OptimismSEO Level 1
  • 16 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
    Order Now
    Process Time: 0.14202499389648

    Possible Duplicate queries found!
    MatchCountSQLScript
    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 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=541270 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=541270 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=541270 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=541270 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 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.1601741SELECT 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 '%Companypage%' OR A.skills LIKE '%Companypage%') ORDER BY A.lastgigedit desc LIMIT 0,400.1601740.160174