SEOClerks

Community Discussion Page 79

Showing page: 79 of 511

We all know that content is king, but we also know that it's not the easiest thing to do, for multiple reasons. You could have too much on your plate already and not have time to write up your own content, you might no...

  • TommyCarey
    TommyCarey Level X3
  • 7 8 years ago

    Hello to everyone I just started checking out Seoclerks and was impressed by the incredibly low cost of the services offered.Can anybody tell me or had any experience with any of them?how can a writer charge only $5 fo...

  • garcell06
    garcell06 Level 1
  • 25 8 years ago

    Most writers have heard about blog writing. Many writers have their own blogs. They want the world to know them, in a personal way. Blog writing helps both the writer and the readers stay connected. Readers will soon wan...

  • JennyHeart5
    JennyHeart5 Level 1
  • 37 8 years ago

    How I can pay through Payoneer for SEO Clerks Services? Please tell I am from pakistan and Paypal Service not Available here.

  • umair444
    umair444 Level 1
  • 6 8 years ago

    People all over the world are put in front of content when they go online. It doesn't matter where you go, content is thrown at you and sometimes it feels like people are just saying "READ ME!!!". If you want to be r...

  • TommyCarey
    TommyCarey Level X3
  • 72 8 years ago

    The internet is a vast openness of information for anyone to read and learn, but another thing it is great for is to build your own personal brand. You can reach a much bigger audience than if you were to just go to an...

  • TommyCarey
    TommyCarey Level X3
  • 29 8 years ago

    Expectations can actually hurt your business because nothing ever goes as planned. You may think that a client is going to sign up with you, but then they give you the cold shoulder and never respond to any of your pho...

  • TommyCarey
    TommyCarey Level X3
  • 21 8 years ago

    A lot of people think you need to spend hundreds of dollars to acquire a regular client, but that's not true at all. In fact, I've actually acquired a client for less than $0.10 and they've been with me for close to 10...

  • TommyCarey
    TommyCarey Level X3
  • 11 8 years ago

    There are great tools out there to create unique and original domain names. This is one aspect of website creation that stumps me the most. What do I call my website? I spend usually a week or two before I pick out the n...

  • Everett
    Everett Level X4
  • 16 8 years ago

    It doesn't matter if you're in business for yourself or you're working for a company, getting a journalist to respond to your pitch is a difficult thing to do if you're new at pitching. You'll need to refine your pitch...

  • TommyCarey
    TommyCarey Level X3
  • 24 8 years ago

    It's no mystery that over 90% of businesses out there are working on their own social media as part of their marketing campaign. It's also no mystery that every entrepreneur is getting into social media as well. But ...

  • TommyCarey
    TommyCarey Level X3
  • 15 8 years ago

    We all want to get online but sometimes we don't know the first steps to take in order to do it. The good thing is that you found this discussion where the process from purchasing a domain to getting your initial sale a...

  • TommyCarey
    TommyCarey Level X3
  • 28 8 years ago

    Networking isn't as easy as going to a conference and shaking some hands then partnering up with large corporations. You will actually have to do a lot of work after meeting the person you're networking with in order t...

  • TommyCarey
    TommyCarey Level X3
  • 18 8 years ago

    Today, I logged in after a long time away from SEOClerks and found dozens of notifications waiting, for jobs like Youtube and social media and stuff that I'm not really qualified or interested in doing. I don't remembe...

  • America
    America Level 1
  • 16 8 years ago

    Getting traffic to your website is just the first hurdle you need to get over in order to be successful. The real battle begins when they get to your website and want to make a purchasing decision or leave your website...

  • TommyCarey
    TommyCarey Level X3
  • 40 8 years ago

    Running a website can be a difficult thing to do if you're performing all the tasks, big and small, by yourself. You can go crazy working 12+ hour days managing everything from building a few backlinks to answering ema...

  • TommyCarey
    TommyCarey Level X3
  • 16 8 years ago

    A lot of people who are in the marketing field have good taste, and this could actually be hurting their blogs. Having good taste will help out when you're trying to build a website or writing up taglines for marketing...

  • TommyCarey
    TommyCarey Level X3
  • 32 8 years ago

    An angel investor wants to know their investment is worth it, so they don't take many chances on startups unless they are already showing promise. Showing promise early on could be anything from getting interviewed on ...

  • TommyCarey
    TommyCarey Level X3
  • 19 8 years ago

    Everyone that starts a business wants it to be a multi-million dollar empire, but they aren't sure exactly how to get the ball rolling and keep it going. It's no secret that starting a business and managing it until yo...

  • TommyCarey
    TommyCarey Level X3
  • 37 8 years ago

    sold hourly for $138 only to receive $108 so what exactly is the fee amount? does it vary or is it fixed Thanks.

  • TheRealRio
    TheRealRio Level 3
  • 13 8 years ago

    It's the season of celebration and I wish everyone celebrating a joyful merriment. I'm writing to know some of the useful tips you guys have been using to keep your clients in check and how you connected with clients, fo...

  • Barida
    Barida Level 3
  • 38 8 years ago

    When you're publishing content on your blog, you're essentially creating a potential to make a sale. Not all of your posts will result in a flood of leads, but after you accumulate enough of them, you should see a stea...

  • TommyCarey
    TommyCarey Level X3
  • 18 8 years ago

    Recently I got an email from Paypal stating that my IPN will no longer function because the website doesn't have a SSL certificate. This is a very big move for Paypal because they are basically stating "we are increasing...

  • Everett
    Everett Level X4
  • 8 8 years ago

    Whenever we get into building our own businesses, we always think about our designs that will help convert all of our traffic into sales, but we don't go over how much money it will take to push ourselves into the spotli...

  • TommyCarey
    TommyCarey Level X3
  • 20 8 years ago

    We all know that content is king and helps us rank well within the SERPs, but did you know that you can have your own voice within your content that will help you convert more people into customers? It's true, and it w...

  • TommyCarey
    TommyCarey Level X3
  • 17 8 years ago

    No one will argue with you if you decided to say that social media has completely changed how we live our everyday lives, because it has. Social media is more than just a place for you to post a new status for your fri...

  • TommyCarey
    TommyCarey Level X3
  • 38 8 years ago

    Everyone wants their content to go viral because that's the best way to make money in a very short amount of time. Think about it, how often do you hear that something went viral and now the person in the video is now ...

  • TommyCarey
    TommyCarey Level X3
  • 28 8 years ago

    Elgg is an open source content management system in social networking niche. The CMS gives you a site like facebook, twitter and tumblr combined. Has anyone used this CMS? How easy is it to manage the site without any pr...

  • vinaya
    vinaya Level 1
  • 16 8 years ago

    Big update coming from Google this week! Remeber how for years now the absolute limit of meta description was 160 characters with a few occasional test where Google allowed bigger snippets but quickly reverted back to no...

  • Cristian
    Cristian Level X3
  • 7 8 years ago

    hello, i know seoclerks don't accept btc but i found announcement in 2015 that it was accept it for withdrawal not btc only but Litecoin (LTC) and Dogecoin (XDG). https://www.seoclerks.com/faq/10336/Litecoin-LTC-and-...

  • SEObonds
    SEObonds Level 1
  • 30 8 years ago

    When it comes to keeping your clients happy, one of the best ways to do this is by giving them something they weren't expecting. This could mean that you did some free design work for them if you're a graphic designer ...

  • TommyCarey
    TommyCarey Level X3
  • 21 8 years ago

    I have tried Thrivetheme for my first website that was hosted in hostagor. It is easy to use in designing a page in wordpress. It also comes with optin form that redirects to a customized thank you page after the reader ...

  • vhinz
    vhinz Level 1
  • 17 8 years ago

    We've all been on Facebook and have seen plenty of advertisements on our news feed whether it been in actual feed or off to the side. If you haven't seen any of these, you probably have a great ad blocker and should be...

  • TommyCarey
    TommyCarey Level X3
  • 57 8 years ago

    I know that a lot of people use Snapchat for video content, and Youtube as well. I was wondering what the forum community here thought about using live facebook posts in order to self-promote or "shout out" about our con...

  • JoeMilford
    JoeMilford Level 1
  • 28 8 years ago

    One of the biggest things that has a lot of people stepping back and taking another look at how to run a website is the amount of content that needs to be created in order to be competitive within their industry. If yo...

  • TommyCarey
    TommyCarey Level X3
  • 19 8 years ago

    In a move that would seem contradictory to most, since they have stated they don't use the description for ranking purposes. Google has expanded the meta description tag from 160 characters to 320 characters. This wil...

  • idealmike
    idealmike Level X3
  • 10 8 years ago

    I have a question.. If i send traffic to a URL starting http:// will it be shown on stats for a website starting https:// ? I ask because i sent traffic to a client website, then he says his stats show no increase in ...

  • TheRealRio
    TheRealRio Level 3
  • 22 8 years ago

    We all want to be extremely successful online, and that's why we constantly push ourselves. Everyone sees success stories of how someone turned $500 into $5,000,000 but they never really see the entire story which incl...

  • TommyCarey
    TommyCarey Level X3
  • 24 8 years ago

    Whenever we're doing some marketing, we are hoping that with every link we place we're going to get one of two things. We either want to get some direct traffic from the link we placed or we want to get some higher ran...

  • TommyCarey
    TommyCarey Level X3
  • 29 8 years ago

    When it comes to business marketing, you are probably used to the typical AdWords or Facebook ads to get your business in front of the decision makers who will hopefully call you and sign up for your services. Spending...

  • TommyCarey
    TommyCarey Level X3
  • 44 8 years ago
    Order Now
    Process Time: 0.23788380622864

    Possible Duplicate queries found!
    MatchCountSQLScript
    SELECT * FROM seoclerks.banned_bot_ip WHERE ip='216.73.216.173'1SELECT count(id) as total FROM seoclerks.banned_bot_ip WHERE ip='216.73.216.173'

    /opt/clerks-staging/docroot/include/functions/includes/security.php 1090 IsIPBannedBot() include_once()

    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 questions A, categories_faq B, seoclerks.members C where A.status='1' AND A.catid=B.CATID AND A.userid=C.USERID 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 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 ORDER BY A.sticky DESC, A.date_asked DESC LIMIT 3120, 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 ORDER BY A.sticky DESC, A.date_asked DESC LIMIT 3120, 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='19821'1SELECT profilepicture FROM seoclerks.members WHERE USERID='19821'

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

    /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
    0.1645752SELECT 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 LIMIT 10.0859740.078601
    0.1189782SELECT 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 ORDER BY A.sticky DESC, A.date_asked DESC LIMIT 3200, 400.0668370.052141
    0.1125532SELECT 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 ORDER BY A.sticky DESC, A.date_asked DESC LIMIT 3120, 400.0624230.050130

    Suspicious SQL

    The following SQL have high average execution times
    Avg TimeCountSQLMaxMin
    0.0822882SELECT 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 LIMIT 10.0859740.078601
    0.0594892SELECT 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 ORDER BY A.sticky DESC, A.date_asked DESC LIMIT 3200, 400.0668370.052141
    0.0562772SELECT 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 ORDER BY A.sticky DESC, A.date_asked DESC LIMIT 3120, 400.0624230.050130