MENU

  • 13wham.com
  • bjztb.com
  • byggfakta.se
  • skifrance-international.com
  • exoticpetmedicalcenter.com.mx
  • xyyandex.net
  • 17job.com
  • hzzwgy.com
  • displaydynamics.ca
  • santofile.org
  • eldoradofurniture.com
  • 0w4.zba.co
  • t4f.com.br
  • diakonhjemmeths.no
  • eelamenews.com
  • horizonfitnessstore.ca
  • s7aybfr7.com
  • sharewareupdate.com
  • uch.edu.ar
  • siemon.com

    • last data update: 2011/10/17, 14:30

    Website loading time

    during the test: 0.42 s

    cable connection (average): 0.89 s

    DSL connection (average): 1.37 s

    modem (average): 26.37 s

    HTTP headers

    HTTP/1.1 301 Moved Permanently

    Date: Mon, 17 Oct 2011 21:30:08 GMT

    Server: Apache/2.2.19 (Unix) mod_ssl/2.2.19 OpenSSL/0.9.8e-fips-rhel5 mod_auth_passthrough/2.1 mod_bwlimited/1.4 FrontPage/5.0.2.2635

    X-Powered-By: PHP/5.3.6

    Vary: Cookie

    X-Pingback: http://www.mysqldiary.com/xmlrpc.php

    Location: http://www.mysqldiary.com/

    Content-Length: 0

    Connection: close

    Content-Type: text/html; charset=UTF-8

    HTTP/1.1 200 OK

    Date: Mon, 17 Oct 2011 21:30:08 GMT

    Server: Apache/2.2.19 (Unix) mod_ssl/2.2.19 OpenSSL/0.9.8e-fips-rhel5 mod_auth_passthrough/2.1 mod_bwlimited/1.4 FrontPage/5.0.2.2635

    Last-Modified: Thu, 18 Aug 2011 21:20:16 GMT

    ETag: "39800b8-2d6ba-4aace2dd8a400"

    Accept-Ranges: bytes

    Content-Length: 186042

    Cache-Control: max-age=3, must-revalidate

    Expires: Mon, 17 Oct 2011 21:30:11 GMT

    Vary: Accept-Encoding,Cookie

    Connection: close

    Content-Type: text/html; charset=UTF-8

    Information about DNS servers

    grimaldi-ferries.comMX10inbound1.grapesnet.netIN600
    grimaldi-ferries.comMX20inbound2.grapesnet.netIN600
    grimaldi-ferries.comSOAmnt1.eutelia.ithostmaster.eutelia.it201107250086400 7200 604800 86400 IN 43200
    grimaldi-ferries.comNSmnt2.eutelia.itIN43200
    grimaldi-ferries.comNSmnt1.eutelia.itIN43200
    mp3juices.comA76.73.40.154IN14400
    mp3juices.comSOAns1.mp3juices.comrethgif.24.hotmail.com201107300086400 7200 3600000 86400 IN 43200
    mp3juices.comMX0mp3juices.comIN14400
    mp3juices.comNSns1.mp3juices.comIN43200
    mp3juices.comNSns2.mp3juices.comIN43200
    mysqldiary.comA70.38.31.112IN14400
    mysqldiary.comSOAns1.servibest.comilan.ilje.gmail.com201107040286400 7200 3600000 86400 IN 43200
    mysqldiary.comMX0mysqldiary.comIN14400
    mysqldiary.comNSns1.servibest.comIN43200
    mysqldiary.comNSns2.servibest.comIN43200

    Received from the first DNS server

    Request to the server "mysqldiary.com"
    You used the following DNS server:
    DNS Name: mnt2.eutelia.it
    DNS Server Address: 62.94.0.52#53
    DNS server aliases:

    HEADER opcode: REQUEST, status: NOERROR, id: 12404
    flag: qr rd ra REQUEST: 1, ANSWER: 5, AUTHORITY: 2, ADDITIONAL: 0

    REQUEST SECTION:
    mysqldiary.com. IN ANY

    ANSWER SECTION:
    mysqldiary.com. 14400 IN A 70.38.31.112
    mysqldiary.com. 86400 IN SOA ns1.servibest.com. ilan.ilje.gmail.com. 2011070402 86400 7200 3600000 86400
    mysqldiary.com. 14400 IN MX 0 mysqldiary.com.
    mysqldiary.com. 86400 IN NS ns2.servibest.com.
    mysqldiary.com. 86400 IN NS ns1.servibest.com.

    AUTHORITY SECTION:
    mysqldiary.com. 86400 IN NS ns1.servibest.com.
    mysqldiary.com. 86400 IN NS ns2.servibest.com.

    Received 190 bytes from address 62.94.0.52#53 in 248 ms

    Received from the second DNS server

    Request to the server "mysqldiary.com"
    You used the following DNS server:
    DNS Name: mnt1.eutelia.it
    DNS Server Address: 62.94.0.51#53
    DNS server aliases:

    HEADER opcode: REQUEST, status: NOERROR, id: 49929
    flag: qr rd ra REQUEST: 1, ANSWER: 5, AUTHORITY: 2, ADDITIONAL: 0

    REQUEST SECTION:
    mysqldiary.com. IN ANY

    ANSWER SECTION:
    mysqldiary.com. 14400 IN A 70.38.31.112
    mysqldiary.com. 86400 IN SOA ns1.servibest.com. ilan.ilje.gmail.com. 2011070402 86400 7200 3600000 86400
    mysqldiary.com. 14400 IN MX 0 mysqldiary.com.
    mysqldiary.com. 86400 IN NS ns1.servibest.com.
    mysqldiary.com. 86400 IN NS ns2.servibest.com.

    AUTHORITY SECTION:
    mysqldiary.com. 86400 IN NS ns2.servibest.com.
    mysqldiary.com. 86400 IN NS ns1.servibest.com.

    Received 190 bytes from address 62.94.0.51#53 in 510 ms

    Subdomains (the first 50)

    Typos (misspells)

    nysqldiary.com
    kysqldiary.com
    jysqldiary.com
    mtsqldiary.com
    mgsqldiary.com
    mhsqldiary.com
    musqldiary.com
    m7sqldiary.com
    m6sqldiary.com
    myaqldiary.com
    myzqldiary.com
    myxqldiary.com
    mydqldiary.com
    myeqldiary.com
    mywqldiary.com
    mys1ldiary.com
    mys2ldiary.com
    myswldiary.com
    mysaldiary.com
    mysqkdiary.com
    mysqpdiary.com
    mysqodiary.com
    mysqlsiary.com
    mysqlxiary.com
    mysqlciary.com
    mysqlfiary.com
    mysqlriary.com    		mysqleiary.com
    mysqlduary.com
    mysqldjary.com
    mysqldkary.com
    mysqldoary.com
    mysqld9ary.com
    mysqld8ary.com
    mysqldizry.com
    mysqldisry.com
    mysqldiwry.com
    mysqldiqry.com
    mysqldiaey.com
    mysqldiady.com
    mysqldiafy.com
    mysqldiaty.com
    mysqldia5y.com
    mysqldia4y.com
    mysqldiart.com
    mysqldiarg.com
    mysqldiarh.com
    mysqldiaru.com
    mysqldiar7.com
    mysqldiar6.com
    ysqldiary.com
    msqldiary.com
    myqldiary.com
    mysldiary.com    		mysqdiary.com
    mysqliary.com
    mysqldary.com
    mysqldiry.com
    mysqldiay.com
    mysqldiar.com
    ymsqldiary.com
    msyqldiary.com
    myqsldiary.com
    myslqdiary.com
    mysqdliary.com
    mysqlidary.com
    mysqldairy.com
    mysqldiray.com
    mysqldiayr.com
    mmysqldiary.com
    myysqldiary.com
    myssqldiary.com
    mysqqldiary.com
    mysqlldiary.com
    mysqlddiary.com
    mysqldiiary.com
    mysqldiaary.com
    mysqldiarry.com
    mysqldiaryy.com

    Location

    IP: 70.38.31.112

    continent: NA, country: Canada (CAN), city: Montreal

    Website value

    rank in the traffic statistics:

    There is not enough data to estimate website value.

    Basic information

    website build using CSS

    code weight: 181.68 KB

    text per all code ratio: 18 %

    title: MySQL Diary

    description: Exploring, Sharing and Discussing MySQL practice

    keywords:

    encoding:

    language: en

    Website code analysis

    one word phrases repeated minimum three times

    PhraseQuantity
    the8
    LEFT4
    in4
    ON4
    to4
    MySQL4
    is4
    will3
    you3
    condition3
    JOIN3

    two word phrases repeated minimum three times

    PhraseQuantity
    LEFT JOIN3

    three word phrases repeated minimum three times

    B tags

    ON

    Lets see a LEFT JOIN example:

    A question:

    WHERE …. IS NULL

    WHERE … IS NULL

    !(A and B) == !A OR !B

    IS NULL

    don’t

    PLUS

    do have

    Does these queries really the same?

    General Note:

    U tags

    I tags

    images

    headers

    H1

    H2

    H3

    H4

    H5

    H6

    internal links

    addressanchor text
    http://www.mysqldiary.com/MySQL Diary
    http://www.mysqldiary.comHome
    http://www.mysqldiary.com/about/About
    http://www.mysqldiary.com/question/Ask A Question
    http://www.mysqldiary.com/do-you-need-my-help/Do You Need My Help?
    http://www.mysqldiary.com/questions-and-answers/Questions And Answers
    http://www.mysqldiary.com/feed/Subscribe to Feed
    http://www.mysqldiary.com/mysql-left-join/MySQL Left Join
    http://www.mysqldiary.com/category/cool-mysql-queries/Cool MySQL Queries
    http://www.mysqldiary.com/tag/is-null/is null
    http://www.mysqldiary.com/tag/left-join/left join
    http://www.mysqldiary.com/tag/on/on
    http://www.mysqldiary.com/mysql-left-join/#comments4 Comments
    http://www.mysqldiary.com/as-restoring-a-dump-table-into-the-mysql-master-you-better-get-some-sleep/As restoring a dump table into the MySQL master – you better get some sleep
    http://www.mysqldiary.com/category/cool-mysql-queries/Cool MySQL Queries
    http://www.mysqldiary.com/category/mysql-script/MySQL Script

    external links