SEOClerks

Community Discussion Page 101

Showing page: 101 of 511

Are you a freelance writer or author? Are you in the process of either thinking about writing your own book, story, novel or even some kind of eBook story like a Kindle book or something? Well, whether you are or you are...

  • idealmike
    idealmike Level X3
  • 16 9 years ago

    When people think of striking it rich online, they never think about how much money and time they will have to invest into it in order to do so. Working online is never an easy job, but you can do it as long as you bud...

  • TommyCarey
    TommyCarey Level X3
  • 11 9 years ago

    So, you've got a mobile smartphone. And you use it for doing things like, checking social media, checking emails, that kind of thing. Right? But did you know that you can put your mobile to much more use than that and ac...

  • idealmike
    idealmike Level X3
  • 44 9 years ago

    Are you a freelance writer? Do you enjoy doing what you do? Do you like working as a freelance writer for the many different people from all walks of life and areas and places of the world that need a myriad of different...

  • idealmike
    idealmike Level X3
  • 43 9 years ago

    Hello all my content writers! My freelancer writers, authors and bloggers! Do you ever have "writers block"? Well if you do I feel for you! And I used to myself. But that was more in my early days of being a freelance wr...

  • idealmike
    idealmike Level X3
  • 18 9 years ago

    Hello dear entrepreneur! Are you looking for a freelance writer? Want to buy content for your requirements? Want to make a better, smarter, more informed decision on just who you should buy that written content from and ...

  • idealmike
    idealmike Level X3
  • 14 9 years ago

    Who do you assign the task of content optimization, should you use a copywriter or an SEO expert? Building search engine friendly content is messy businesses, you need to have some solid know-how on how a search eng...

  • Cristian
    Cristian Level X3
  • 9 9 years ago

    5 ways a small business can compete with it's giant competitors with SEO When it comes to competition, you may have a pretty big uphill battle. Some of your competitors could be giant companies investing hundreds ...

  • TommyCarey
    TommyCarey Level X3
  • 8 9 years ago

    It is hard to come across an article about internet marketing that does not stress the importance of your email list. Auto responders are being used more and more in the internet marketing game, as webmasters figure out ...

  • TommyCarey
    TommyCarey Level X3
  • 6 9 years ago

    I always think to myself. What advice can I give to any junior SEO expert I may come into contact with. What advice should I give to younger people looking to learn SEO from scratch in 2017 or to anyone interested in SEO...

  • Cristian
    Cristian Level X3
  • 13 9 years ago

    When it comes to generating content for your website, you need to branch out from text and images, think of explainer videos as the new wave of content marketing that you will be riding. I'm sure that you've seen plent...

  • TommyCarey
    TommyCarey Level X3
  • 23 9 years ago

    Freelancing is one of the best ways to be independent but at the same time it can also be a stressful struggle. When you're a freelancer you really don't have many regular clients because there aren't many subscription...

  • TommyCarey
    TommyCarey Level X3
  • 20 9 years ago

    On of the biggest problems, I'm facing as an SEO expert inside an agency is getting stuff my way, the SEO way. When we first start working on a project I always get into some contradictory arguments with the designer ove...

  • Cristian
    Cristian Level X3
  • 6 9 years ago

    For a long time now we know for sure Google has ways of detecting fake link building, especially the paid link building when you will pay a blog or some online publication to write about you in an "ads" type article and ...

  • Cristian
    Cristian Level X3
  • 10 9 years ago

    When it comes to getting into online marketing, you should look to the blogs and forums as your main source of knowledge. When I started off I was a member of plenty of forums and commented on plenty of blogs in order t...

  • TommyCarey
    TommyCarey Level X3
  • 14 9 years ago

    Launching a website needs to be a perfect calculated action, making the job of search engines as easy as possible, we want our new website to be fully indexed at its full potential, ensuring the best possible ranks, this...

  • Cristian
    Cristian Level X3
  • 10 9 years ago

    Setting up a blog is fairly eash nowadays because of all the systems out there to choose from that have one click installs and auto uploading sample text so you get an idea of where everything goes. When I have a clien...

  • TommyCarey
    TommyCarey Level X3
  • 20 9 years ago

    When it comes to running an online business, there are 5 main commandments which aren't actually written on stone tablets, but should still be taken seriously. If you're serious about your business then you will be ser...

  • TommyCarey
    TommyCarey Level X3
  • 11 9 years ago

    An authority guest post can go a long way when it comes to your website and blogging. You need authority guest posts if you're in competition with anyone, and that's almost always the case if you're selling a service o...

  • TommyCarey
    TommyCarey Level X3
  • 12 9 years ago

    Some more social media facts for you! Posted as a listicle again! Some of these are truly mind blowing statistics and should blow you away if you ever wondered or though differently about the popular social media sites o...

  • idealmike
    idealmike Level X3
  • 19 9 years ago

    Your homepage is one of, if not the most important page on your site. Simply because it's the one that is most likely to receive the bulk amount of traffic you get. Whether organic traffic or traffic from some advertisin...

  • idealmike
    idealmike Level X3
  • 9 9 years ago

    how much traffic does your website or blog get promoting it on Google+ compared to other social networks?

  • VickyBurg
    VickyBurg Level 1
  • 40 9 years ago

    When you're beginning affiliate marketing it may be upsetting because it will feel like you're and unappreciated and underpaid intern lol. You'll need to do a decent amount of work before you start seeing a good amount...

  • TommyCarey
    TommyCarey Level X3
  • 13 9 years ago

    When you decide to put up a membership type website, you will need to have content on there that will pitch the perfect content at your visitors in order to close them before you ever get an email from them asking questi...

  • TommyCarey
    TommyCarey Level X3
  • 11 9 years ago

    When it comes to selling some high end information type products or online courses, you should be thinking of Webinars because they close a lot of deals. Webinars are pretty cost affective because you really only have ...

  • TommyCarey
    TommyCarey Level X3
  • 5 9 years ago

    Everyone has a friend on their friends list that can be put into a certain type of category of friend am I right? And since there are quite a lot of different types of Facebook friend, it's likely that you have one of th...

  • idealmike
    idealmike Level X3
  • 36 9 years ago

    When it comes to working online, there are a lot of people that go broke pretty quick and don't cut it in the dog eat dog world of online marketing. When it comes to working online we all know that it's not an easy tas...

  • TommyCarey
    TommyCarey Level X3
  • 9 9 years ago

    Since the last post I made on Some Mad Crazy Internet Facts and Stats about the Internet got a good response, I thought I'd do a few more of these as they're very read moreish and fun to learn as well! And especially w...

  • idealmike
    idealmike Level X3
  • 18 9 years ago

    When it comes to being successful online, there are so many things that you could focus on. You could have a unique idea or product that may sell like hot cakes or you could be selling a consultancy service to help big ...

  • TommyCarey
    TommyCarey Level X3
  • 13 9 years ago

    When I stared out I wish I had a list of online marketing tips that could help me out along the way. I didn't do as much research as I should have and I just pushed forward learning as I went. If I did happen to have...

  • TommyCarey
    TommyCarey Level X3
  • 11 9 years ago

    Using webinars for your business is on the rise when it comes to online marketing. Now there aren't a whole lot of people using webinars for business, but the numbers are increasing year after year because people are sl...

  • TommyCarey
    TommyCarey Level X3
  • 4 9 years ago

    Designing an eCommerce website isn't as easy as you would think it would be. You always need to be cutting edge when it comes to your design so that visitors will want to purchase what you have listed on your website. ...

  • TommyCarey
    TommyCarey Level X3
  • 5 9 years ago

    I'm sure that you've heard the saying "Don't put all of your eggs in one basket" when it comes to running a physical business or online business. When it comes to making money, you won't want to rely on one method to b...

  • TommyCarey
    TommyCarey Level X3
  • 8 9 years ago

    A New Seller Here.... need here please on how to use seoclerks attracts leads to gigs

  • Mobiz
    Mobiz Level 1
  • 4 9 years ago

    Using forums for your marketing methods is nothing new when it comes to generating sales for your website. Finding the right forums within your niche isn't actually that difficult. All you'll really have to do is go to...

  • TommyCarey
    TommyCarey Level X3
  • 16 9 years ago

    When it comes to eCommerce, we tend to just republish the manufacturers plain old set and forget descriptions. Most people don't even think twice about it. They just put the item on their site, copy and paste the des...

  • TommyCarey
    TommyCarey Level X3
  • 11 9 years ago

    I'm frequently amazed by the number of webmasters and programmers out there unable to tell the difference between nofollow and noindex tags as well as robots.txt. Let's start with the nofollow tag. If you reall...

  • Cristian
    Cristian Level X3
  • 3 9 years ago

    Has anyone used "auto Twitter" services and found that they help? Limiting your Twitter contacts to Real Twits, getting retweeted with original live human comments, actually engaging with followers, definitely makes it t...

    33 9 years ago

    A few months ago I got a very sensitive project, something I never been able to achieve before even though I worked on at least one more similar cases over the years. The assignment was simple: Push a certain nega...

  • Cristian
    Cristian Level X3
  • 5 9 years ago

    Hello and welcome to part 5 of my 25+ Fun and Creative Ways to Fundraise Your Startup! I hope you've enjoyed reading about all of the methods and ideas I've posted about so far. And I hope that you find them useful to yo...

  • idealmike
    idealmike Level X3
  • 5 9 years ago
    Order Now
    Process Time: 0.29731392860413

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

    /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 4000, 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 4000, 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='272'1SELECT profilepicture FROM seoclerks.members WHERE USERID='272'

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

    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='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='432584'1SELECT profilepicture FROM seoclerks.members WHERE USERID='432584'

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

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

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

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

    /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.2321443SELECT 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.0788750.076416
    0.1269452SELECT 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 3960, 400.0646570.062288

    Suspicious SQL

    The following SQL have high average execution times
    Avg TimeCountSQLMaxMin
    0.0773813SELECT 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.0788750.076416
    0.0634732SELECT 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 3960, 400.0646570.062288
    0.0597911SELECT 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 4000, 400.0597910.059791