SEOClerks

Discussions about Tutorials & Guides Page 2

Showing page: 2 of 4

Since i spend so much time here at Seoclerks i would like to introduce you to some facts that you maybe did not know, specially if you are new member here. Ionicware is A diverse community of experts, freelancers and...

  • anwebservices
    anwebservices Level X5
  • 20 10 years ago

    In this tutorial you will learn how to build a browser extension for Google chrome , Mozilla Firefox and Opera, without coding knowledge, using only drag and drop. First Download the “Extension Maker” software...

  • procoder
    procoder Level X3
  • 5 10 years ago

    You may know how to block advertisements with an Adblocker browser extension, or addon. But did you know you can block ads with your system's host file? Before we get into blocking ads with a host file, lets focus on w...

  • Everett
    Everett Level X4
  • 5 10 years ago

    1. Go to : Click Here 2. You will see this window, simply type your website url, then click “Build” 3. This window will appear. 1)Set your website URL 2)Set the name of your APP 3)Don't forget to ty...

  • procoder
    procoder Level X3
  • 3 10 years ago

    Bitdefender TrafficLight is a simple browser extension which will protect your while browsing on the internet. This extension is completely free and available on browsers : Google Chrome, Mozilla Firefox and Safari. C...

  • procoder
    procoder Level X3
  • 9 10 years ago

    Here is where I'll talk about client relations. Now this isn't a direct sales technique or method and it's not a marketing tactic. This just helps keep clients happy and a happy client will usually send referrals ;) I...

  • TommyCarey
    TommyCarey Level X3
  • 5 10 years ago

    This part will cover off page optimization and what you can do in order to achieve higher rankings in the search engines Off page optimization is the act of building content and links on different website and blogs i...

  • TommyCarey
    TommyCarey Level X3
  • 5 10 years ago

    This part will cover on page optimization. A lot of people think you can just build a few links online and then your website will rank for the most difficult keywords in the world. A common thing I hear from clients i...

  • TommyCarey
    TommyCarey Level X3
  • 6 10 years ago

    In this part I will go over paid advertising because I get a lot of questions about how I can put up an ad and be profitable. If you'd like to skip ahead to a section you know you need help with, use these links: Par...

  • TommyCarey
    TommyCarey Level X3
  • 7 10 years ago

    Web design can be a tricky thing if you're starting out. There are so many companies out there promoting their "State of the art" website builders and it's kind of confusing on who you should choose. A simple answer it, ...

  • TommyCarey
    TommyCarey Level X3
  • 5 10 years ago

    This will go over Hosting Companies and what you should look for. If you'd like to skip ahead to a section you know you need help with, use these links: Part 1: Domain Registrars Part 3: Web Design Part 4: Advertis...

  • TommyCarey
    TommyCarey Level X3
  • 5 10 years ago

    I always have people asking me "How can I make money online?" and I can't really answer that because everyones skill sets are different. I typically tell people to start blogging about something they like doing and they'...

  • TommyCarey
    TommyCarey Level X3
  • 5 10 years ago

    OK if you have WordPress blog where you would like to write articles in different languages here is some easy solution for you. No need to use old way of translating whole website in different language. You can simply do...

  • anwebservices
    anwebservices Level X5
  • 4 10 years ago

    You probably know that fast loading of your blog is very important for many reasons. So while WordPress is most used CMS platform, here is how you can speed up loading of your website easy way. No need any programming sk...

  • anwebservices
    anwebservices Level X5
  • 8 10 years ago

    First we need to download software that we’ll use to make usb bootable. Download Rufus here. System Requirements to run Rufus: Windows xp or later , support 32bit and 64bit . After downloading Rufus , open...

  • procoder
    procoder Level X3
  • 4 10 years ago

    Adware or Advertising Supported Software is a software that downloads or display unwanted ads to computer without the user's knowledge. Any computer is vulnerable, and can be easily infected by adware, if it's not protec...

  • procoder
    procoder Level X3
  • 19 10 years ago

    Do you want to test your software in other machines(cloud servers) without causing a mess in your system? Well, you are in the right place... In this tutorial you will learn how to teleport your software or any other sof...

  • procoder
    procoder Level X3
  • 2 10 years ago

    WordPress as CMS platform is constructed very well to embrace search engine's algorithms straight out of the box. It's features attract search engine crawlers to easy access your post and pages all the way in deep diggin...

  • anwebservices
    anwebservices Level X5
  • 3 10 years ago

    The perfect description is creative, clear and you should provide value right from the start. Here are some tips to help you out.. 1.) Description limits and attention Descriptions usually has a limit. Sharpen your d...

  • hitmeasap
    hitmeasap Level X5
  • 5 10 years ago

    NOTE: This tutorial is only suitable for installing Wordpress using cPanel cPanel is a very popular control panel for web hosting servers so I decided to make a guide for installing Wordpress using this control panel....

  • MasterA
    MasterA Level 3
  • 2 10 years ago

    Response time often plays a major role when buyers decides to hire you or not. A seller with less response time is often hired before others having longer response time. It's a fact and it's quite logical. Here you will ...

  • hitmeasap
    hitmeasap Level X5
  • 9 10 years ago

    Smart phone and mobile apps aren't going anywhere soon. You should begin to optimize not rather than later. They're not like a brick phone, the smart phones are here to stay and will only evolve for the better (hopefu...

  • TommyCarey
    TommyCarey Level X3
  • 3 10 years ago

    I get this question a lot with my new clients. When I hear this, I know the person who is signing up with me may be unhappy in 30 days when they're not ranking #1 for their difficult keywords. Now then, with 8% of sea...

  • TommyCarey
    TommyCarey Level X3
  • 8 10 years ago

    Over the years, SEO has changed and evolved. What used to work last year, might not work this year or the next. What mattered last year, might not matter anymore. So as SEO is a constantly shifting thing, from one thi...

  • idealmike
    idealmike Level X3
  • 4 10 years ago

    Since i was watching this video, which makes sense to me, i learned one fast way to rank high in Google. Video also explain which pages on our websites need more attention to improve SEO. Since in other cases it t...

  • anwebservices
    anwebservices Level X5
  • 3 10 years ago

    White hat backlinks are links placed by you (shhhh don't tell anyone) or a third party (other people) that are not spam type links. High quality links placed by you or other people in order to add quality information to ...

  • TommyCarey
    TommyCarey Level X3
  • 4 10 years ago

    Are you looking to build backlinks yourself or outsource to a freelancer here on SeoClerks? Here are some things you should read prior to doing your linking. Higher Search Engine Rankings The main reason for buil...

  • TommyCarey
    TommyCarey Level X3
  • 9 10 years ago

    Read this over and let me know what you think. Do you use private blog networks? Do you like private blog networks? Did you see a benefit using private blog networks? Did you get banned into oblivion because you...

  • TommyCarey
    TommyCarey Level X3
  • 6 10 years ago

    Hi Before working for any job, my suggestions are below to make safe your work from fraud buyer and some detector points may help you as seller for safe work: 1. First response to buyer after ordering 2. Go to buyer pro...

  • ajlancer
    ajlancer Level X3
  • 23 10 years ago

    I am guessing you are seller on Seoclerks marketplace curious how to earn more money then by only selling your services. Yes it's possible and many of us doing it, so why not you For begginers here is the guide how to ...

  • anwebservices
    anwebservices Level X5
  • 17 10 years ago

    Instead of writing long text to explain everything, i found one very good video made by @BarryinSiam (Trusted Power Seller) which explain how to setup you seoclerks account and how to list your services for sale. Please ...

  • anwebservices
    anwebservices Level X5
  • 9 10 years ago

    So the question “how should I promote my gigs online” has been asked many times and has been answered many times. New sellers usually have a lot of trouble getting their sales up. But sometimes seasoned sellers also ...

  • seocsl
    seocsl Level 1
  • 4 10 years ago

    Hello! There's tons of questions regarding the "bump your service" feature and if you actually benefit from this feature. I'm here to shed some light on this topic. If you are serious about using your bumps you should p...

  • hitmeasap
    hitmeasap Level X5
  • 87 10 years ago

    As you start reading this, i bet you are interested to make more money and boost sales of your SEOClerks services. Here i will share my experience and thoughts so you can use and hopefully increase sales. First thi...

  • anwebservices
    anwebservices Level X5
  • 9 11 years ago

    Today I was going over this forum regarding tips and tricks so I thought to share my little experience as well regarding happy and regular buyers. I think it depends upon how you treat your buyer . I got many returning ...

  • farahkhan
    farahkhan Level X3
  • 47 11 years ago

    The native text editor here on the CodeClerks Forum is both graceful and powerful as a means of getting your point across publishing-wise, but I'm always struck dumb when I read posts here and in the Marketplace. It see...

  • Promodrone
    Promodrone Level 1
  • 7 11 years ago

    If you haven't realized it already, you're going to have to have a dedicated web development environment if you hope to grow into a top-flight coding freelancer. A mandatory practice is to employ a local machine web se...

  • Promodrone
    Promodrone Level 1
  • 4 11 years ago

    Hello I need help how can I monitor that my youtube video keyword is ranking or not. Like I have a video Of Computer Trick That is "How To Make Pendrive Bootable" So I have added Keyword-- How To Make Pendrive Bootable...

  • ssam
    ssam Level 1
  • 4 11 years ago

    Now you can Enjoy SEO Clerks / Code Clerks / Listing Dock Services on the Go on your Smart Phone. Just Download this UnOfficial App. I have Created this App for my Affiliate Website using some Third Party Android Develo...

    2 11 years ago

    Here is the Static Banner, Simple Animated Banner and Advance Animated Banner in Two Different Sizes 300 x 300 and 300 x 250. Static Banner 300 x 300 Static Banner 300 x 250 Simpe Animated Banner 300 x 300 Simp...

    14 11 years ago
    Order Now
    Process Time: 0.49342489242554

    Possible Duplicate queries found!
    MatchCountSQLScript
    SELECT * FROM categories_faq WHERE seo=?1SELECT CATID, seo, name, metatitle, h2header, metakeywords, metadescription, metaheader, parentid, image_name FROM categories_faq WHERE seo=?

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

    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 B.seo='tutorials-guides' 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 B.seo='tutorials-guides' 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 B.seo='tutorials-guides' ORDER BY A.sticky DESC, A.date_asked DESC LIMIT 40, 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 B.seo='tutorials-guides' ORDER BY A.sticky DESC, A.date_asked DESC LIMIT 40, 40

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

    SELECT * from questions as A where A.status='1' AND CATID=461SELECT count(A.quesid) as total from questions as A where A.status='1' AND CATID=46

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

    SELECT * FROM answers as A, questions as Q where A.status='1' AND A.quesid=Q.quesid AND Q.CATID=461SELECT count(A.ansid) as total FROM answers as A, questions as Q where A.status='1' AND A.quesid=Q.quesid AND Q.CATID=46

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

    /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.2843511SELECT count(A.ansid) as total FROM answers as A, questions as Q where A.status='1' AND A.quesid=Q.quesid AND Q.CATID=460.2843510.284351
    0.2155131SELECT 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 '%professi%' OR A.skills LIKE '%professi%') ORDER BY A.lastgigedit desc LIMIT 0,400.2155130.215513
    0.1711751SELECT 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 '%exchange%' OR A.skills LIKE '%exchange%') ORDER BY A.lastgigedit desc LIMIT 0,400.1711750.171175
    0.1490241SELECT COUNT(A.wantid) AS total FROM wanttobuy as 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 '%exchange%' OR A.skills LIKE '%exchange%')0.1490240.149024
    0.1180491SELECT * FROM members WHERE show_freelancer = 1 AND status = 1 AND total_recommendations > 0 AND (skills LIKE '%Soundcoud%') ORDER BY total_recommendations desc LIMIT 0,400.1180490.118049
    0.1136211SELECT * FROM members WHERE show_freelancer = 1 AND status = 1 AND total_recommendations > 0 AND (skills LIKE '%increaseda%') ORDER BY total_recommendations desc LIMIT 0,400.1136210.113621
    0.0819241SELECT count(USERID) AS total FROM members WHERE show_freelancer = 1 AND status = 1 AND total_recommendations > 0 AND (skills LIKE '%Soundcoud%') 0.0819240.081924
    0.0756911SELECT 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=203458 LIMIT 10.0756910.075691
    0.0705081SELECT 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 B.seo='tutorials-guides' ORDER BY A.sticky DESC, A.date_asked DESC LIMIT 40, 400.0705080.070508