Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-12580

Wrong query result in join when using an index (Version > "10.2.3")

Details

    Description

      Two Tables:

      CREATE TABLE `tage` (
      		 
        `datum` date NOT NULL,
      		 
        KEY `i_datum` (`datum`)
      		 
      ) ENGINE=InnoDB DEFAULT CHARSET=utf8
      		 
       
      		 
      CREATE TABLE `mitarbeiter` (
      		 
        `pk` int(11) NOT NULL DEFAULT 0,
      		 
        `in_aw_liste` int(1) DEFAULT 1,
      		 
        `deaktiviert` int(1) NOT NULL DEFAULT 0
      		 
      ) ENGINE=InnoDB DEFAULT CHARSET=utf8

      Query:

      select  distinct mar.deaktiviert, in_aw_liste from mitarbeiter mar  join  tage t where  t.datum >= '2017-04-01' and  mar.deaktiviert = 0 and in_aw_liste=1;

      Result in Version 10.2.5:

      +-------------+-------------+
      		 
      | deaktiviert | in_aw_liste |
      		 
      +-------------+-------------+
      		 
      |           0 |           1 |
      		 
      |           1 |           1 |
      		 
      |           0 |           0 |
      		 
      |           1 |           0 |
      		 
      +-------------+-------------+

      but should be (as in Version 10.2.3 or/and without the index i_datum):

      +-------------+-------------+
      		 
      | deaktiviert | in_aw_liste |
      		 
      +-------------+-------------+
      		 
      |           0 |           1 |
      		 
      +-------------+-------------+

      The result of

      explain extended  select distinct mar.deaktiviert, in_aw_liste from mitarbeiter mar join tage t where t.datum >= '2017-04-01' and mar.deaktiviert = 0 and in_aw_liste=1;

      with index i_datum

      +------+-------------+-------+-------+---------------+---------+---------+------+------+----------+-------------------------------------------+
      		 
      | id   | select_type | table | type  | possible_keys | key     | key_len | ref  | rows | filtered | Extra                                     |
      		 
      +------+-------------+-------+-------+---------------+---------+---------+------+------+----------+-------------------------------------------+
      		 
      |    1 | SIMPLE      | t     | range | i_datum       | i_datum | 3       | NULL |  275 |   100.00 | Using where; Using index; Using temporary |
      		 
      |    1 | SIMPLE      | mar   | ALL   | NULL          | NULL    | NULL    | NULL |  575 |   100.00 | Using where                               |
      		 
      +------+-------------+-------+-------+---------------+---------+---------+------+------+----------+-------------------------------------------+


      show warnings;


      +-------+------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
      		 
      | Level | Code | Message                                                                                                                                                                                                                                                                |
      		 
      +-------+------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
      		 
      | Note  | 1003 | select distinct `tmp`.`mar`.`deaktiviert` AS `deaktiviert`,`tmp`.`mar`.`in_aw_liste` AS `in_aw_liste` from `tmp`.`mitarbeiter` `mar` join `tmp`.`tage` `t` where `tmp`.`mar`.`deaktiviert` = 0 and `tmp`.`mar`.`in_aw_liste` = 1 and `tmp`.`t`.`datum` >= '2017-04-01' |
      		 
      +-------+------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+

      The same without index on tage (datum):

      +------+-------------+-------+------+---------------+------+---------+------+------+----------+------------------------------+
      		 
      | id   | select_type | table | type | possible_keys | key  | key_len | ref  | rows | filtered | Extra                        |
      		 
      +------+-------------+-------+------+---------------+------+---------+------+------+----------+------------------------------+
      		 
      |    1 | SIMPLE      | mar   | ALL  | NULL          | NULL | NULL    | NULL |  575 |   100.00 | Using where; Using temporary |
      		 
      |    1 | SIMPLE      | t     | ALL  | NULL          | NULL | NULL    | NULL | 4018 |   100.00 | Using where                  |
      		 
      +------+-------------+-------+------+---------------+------+---------+------+------+----------+------------------------------+

      Warning:

      +-------+------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
      		 
      | Level | Code | Message                                                                                                                                                                                                                                                                |
      		 
      +-------+------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
      		 
      | Note  | 1003 | select distinct `tmp`.`mar`.`deaktiviert` AS `deaktiviert`,`tmp`.`mar`.`in_aw_liste` AS `in_aw_liste` from `tmp`.`mitarbeiter` `mar` join `tmp`.`tage` `t` where `tmp`.`mar`.`deaktiviert` = 0 and `tmp`.`mar`.`in_aw_liste` = 1 and `tmp`.`t`.`datum` >= '2017-04-01' |
      		 
      +-------+------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+

      Attachments

        1. variables-10.2.3
          17 kB
        2. variables-10.2.5
          17 kB
        3. mitarbeiter.sql
          9 kB
        4. tage.sql
          61 kB

        Issue Links

          is caused by

          Bug - A problem which impairs or prevents the functions of the product. MDEV-11640 gcol.gcol_select_myisam fails in buildbot on Power

          • Major - Major loss of function.
          • Closed

          Activity

            Ascending order - Click to sort in descending order
            wandazorro Helmut Zeilinger created issue -
            elenst Elena Stepanova made changes -
            Field Original Value New Value
            Description Two Tables:

            CREATE TABLE `tage` (
              `datum` date NOT NULL,
              KEY `i_datum` (`datum`)
            ) ENGINE=InnoDB DEFAULT CHARSET=utf8

            CREATE TABLE `mitarbeiter` (
              `pk` int(11) NOT NULL DEFAULT 0,
              `in_aw_liste` int(1) DEFAULT 1,
              `deaktiviert` int(1) NOT NULL DEFAULT 0
            ) ENGINE=InnoDB DEFAULT CHARSET=utf8

            Query:

            select distinct mar.deaktiviert, in_aw_liste from mitarbeiter mar join tage t where t.datum >= '2017-04-01' and mar.deaktiviert = 0 and in_aw_liste=1;

            Result in Version 10.2.5:

            +-------------+-------------+
            | deaktiviert | in_aw_liste |
            +-------------+-------------+
            | 0 | 1 |
            | 1 | 1 |
            | 0 | 0 |
            | 1 | 0 |
            +-------------+-------------+

            but should be (as in Version 10.2.3 or/and without the index i_datum):

            +-------------+-------------+
            | deaktiviert | in_aw_liste |
            +-------------+-------------+
            | 0 | 1 |
            +-------------+-------------+

            		Two Tables:

            {code:sql}
            CREATE TABLE `tage` (
              `datum` date NOT NULL,
              KEY `i_datum` (`datum`)
            ) ENGINE=InnoDB DEFAULT CHARSET=utf8

            CREATE TABLE `mitarbeiter` (
              `pk` int(11) NOT NULL DEFAULT 0,
              `in_aw_liste` int(1) DEFAULT 1,
              `deaktiviert` int(1) NOT NULL DEFAULT 0
            ) ENGINE=InnoDB DEFAULT CHARSET=utf8
            {code}

            Query:

            {code:sql}
            select distinct mar.deaktiviert, in_aw_liste from mitarbeiter mar join tage t where t.datum >= '2017-04-01' and mar.deaktiviert = 0 and in_aw_liste=1;
            {code}

            Result in Version 10.2.5:

            {noformat}
            +-------------+-------------+
            | deaktiviert | in_aw_liste |
            +-------------+-------------+
            | 0 | 1 |
            | 1 | 1 |
            | 0 | 0 |
            | 1 | 0 |
            +-------------+-------------+
            {noformat}

            but should be (as in Version 10.2.3 or/and without the index i_datum):

            {noformat}
            +-------------+-------------+
            | deaktiviert | in_aw_liste |
            +-------------+-------------+
            | 0 | 1 |
            +-------------+-------------+
            {noformat}
            serg Sergei Golubchik made changes -
            Labels INDEX JOIN, index join
            elenst Elena Stepanova added a comment - - edited

            Thanks for the report and the data.

            The problem was introduced in 10.2 tree with this commit:

            commit 8d99166c697516ad9b4084c2bc10ba4acf8b9744
            		 
            Author: Sergei Golubchik
            		 
            Date:   Mon Feb 6 23:52:47 2017 +0100
            		 
             
            		 
                MDEV-11640 gcol.gcol_select_myisam fails in buildbot on Power

            Test case (Expected 1 row, actual result 4 rows)

            		 
            SET join_buffer_size = 268435456;
            		 
             
            		 
            DROP TABLE IF EXISTS `tage`;
            		 
            CREATE TABLE `tage` (
            		 
              `datum` date NOT NULL,
            		 
              KEY `i_datum` (`datum`)
            		 
            ) DEFAULT CHARSET=utf8;
            		 
             
            		 
            INSERT INTO `tage` VALUES ('2007-01-01'),('2007-01-02'),('2007-01-03'),('2007-01-04'),('2007-01-05'),('2007-01-06'),('2007-01-07'),('2007-01-08'),('2007-01-09'),('2007-01-10'),('2007-01-11'),('2007-01-12'),('2007-01-13'),('2007-01-14'),('2007-01-15'),('2007-01-16'),('2007-01-17'),('2007-01-18'),('2007-01-19'),('2007-01-20'),('2007-01-21'),('2007-01-22'),('2007-01-23'),('2007-01-24'),('2007-01-25'),('2007-01-26'),('2007-01-27'),('2007-01-28'),('2007-01-29'),('2007-01-30'),('2007-01-31'),('2007-02-01'),('2007-02-02'),('2007-02-03'),('2007-02-04'),('2007-02-05'),('2007-02-06'),('2007-02-07'),('2007-02-08'),('2007-02-09'),('2007-02-10'),('2007-02-11'),('2007-02-12'),('2007-02-13'),('2007-02-14'),('2007-02-15'),('2007-02-16'),('2007-02-17'),('2007-02-18'),('2007-02-19'),('2007-02-20'),('2007-02-21'),('2007-02-22'),('2007-02-23'),('2007-02-24'),('2007-02-25'),('2007-02-26'),('2007-02-27'),('2007-02-28'),('2007-03-01'),('2007-03-02'),('2007-03-03'),('2007-03-04'),('2007-03-05'),('2007-03-06'),('2007-03-07'),('2007-03-08'),('2007-03-09'),('2007-03-10'),('2007-03-11'),('2007-03-12'),('2007-03-13'),('2007-03-14'),('2007-03-15'),('2007-03-16'),('2007-03-17'),('2007-03-18'),('2007-03-19'),('2007-03-20'),('2007-03-21'),('2007-03-22'),('2007-03-23'),('2007-03-24'),('2007-03-25'),('2007-03-26'),('2007-03-27'),('2007-03-28'),('2007-03-29'),('2007-03-30'),('2007-03-31'),('2007-04-01'),('2007-04-02'),('2007-04-03'),('2007-04-04'),('2007-04-05'),('2007-04-06'),('2007-04-07'),('2007-04-08'),('2007-04-09'),('2007-04-10'),('2007-04-11'),('2007-04-12'),('2007-04-13'),('2007-04-14'),('2007-04-15'),('2007-04-16'),('2007-04-17'),('2007-04-18'),('2007-04-19'),('2007-04-20'),('2007-04-21'),('2007-04-22'),('2007-04-23'),('2007-04-24'),('2007-04-25'),('2007-04-26'),('2007-04-27'),('2007-04-28'),('2007-04-29'),('2007-04-30'),('2007-05-01'),('2007-05-02'),('2007-05-03'),('2007-05-04'),('2007-05-05'),('2007-05-06'),('2007-05-07'),('2007-05-08'),('2007-05-09'),('2007-05-10'),('2007-05-11'),('2007-05-12'),('2007-05-13'),('2007-05-14'),('2007-05-15'),('2007-05-16'),('2007-05-17'),('2007-05-18'),('2007-05-19'),('2007-05-20'),('2007-05-21'),('2007-05-22'),('2007-05-23'),('2007-05-24'),('2007-05-25'),('2007-05-26'),('2007-05-27'),('2007-05-28'),('2007-05-29'),('2007-05-30'),('2007-05-31'),('2007-06-01'),('2007-06-02'),('2007-06-03'),('2007-06-04'),('2007-06-05'),('2007-06-06'),('2007-06-07'),('2007-06-08'),('2007-06-09'),('2007-06-10'),('2007-06-11'),('2007-06-12'),('2007-06-13'),('2007-06-14'),('2007-06-15'),('2007-06-16'),('2007-06-17'),('2007-06-18'),('2007-06-19'),('2007-06-20'),('2007-06-21'),('2007-06-22'),('2007-06-23'),('2007-06-24'),('2007-06-25'),('2007-06-26'),('2007-06-27'),('2007-06-28'),('2007-06-29'),('2007-06-30'),('2007-07-01'),('2007-07-02'),('2007-07-03'),('2007-07-04'),('2007-07-05'),('2007-07-06'),('2007-07-07'),('2007-07-08'),('2007-07-09'),('2007-07-10'),('2007-07-11'),('2007-07-12'),('2007-07-13'),('2007-07-14'),('2007-07-15'),('2007-07-16'),('2007-07-17'),('2007-07-18'),('2007-07-19'),('2007-07-20'),('2007-07-21'),('2007-07-22'),('2007-07-23'),('2007-07-24'),('2007-07-25'),('2007-07-26'),('2007-07-27'),('2007-07-28'),('2007-07-29'),('2007-07-30'),('2007-07-31'),('2007-08-01'),('2007-08-02'),('2007-08-03'),('2007-08-04'),('2007-08-05'),('2007-08-06'),('2007-08-07'),('2007-08-08'),('2007-08-09'),('2007-08-10'),('2007-08-11'),('2007-08-12'),('2007-08-13'),('2007-08-14'),('2007-08-15'),('2007-08-16'),('2007-08-17'),('2007-08-18'),('2007-08-19'),('2007-08-20'),('2007-08-21'),('2007-08-22'),('2007-08-23'),('2007-08-24'),('2007-08-25'),('2007-08-26'),('2007-08-27'),('2007-08-28'),('2007-08-29'),('2007-08-30'),('2007-08-31'),('2007-09-01'),('2007-09-02'),('2007-09-03'),('2007-09-04'),('2007-09-05'),('2007-09-06'),('2007-09-07'),('2007-09-08'),('2007-09-09'),('2007-09-10'),('2007-09-11'),('2007-09-12'),('2007-09-13'),('2007-09-14'),('2007-09-15'),('2007-09-16'),('2007-09-17'),('2007-09-18'),('2007-09-19'),('2007-09-20'),('2007-09-21'),('2007-09-22'),('2007-09-23'),('2007-09-24'),('2007-09-25'),('2007-09-26'),('2007-09-27'),('2007-09-28'),('2007-09-29'),('2007-09-30'),('2007-10-01'),('2007-10-02'),('2007-10-03'),('2007-10-04'),('2007-10-05'),('2007-10-06'),('2007-10-07'),('2007-10-08'),('2007-10-09'),('2007-10-10'),('2007-10-11'),('2007-10-12'),('2007-10-13'),('2007-10-14'),('2007-10-15'),('2007-10-16'),('2007-10-17'),('2007-10-18'),('2007-10-19'),('2007-10-20'),('2007-10-21'),('2007-10-22'),('2007-10-23'),('2007-10-24'),('2007-10-25'),('2007-10-26'),('2007-10-27'),('2007-10-28'),('2007-10-29'),('2007-10-30'),('2007-10-31'),('2007-11-01'),('2007-11-02'),('2007-11-03'),('2007-11-04'),('2007-11-05'),('2007-11-06'),('2007-11-07'),('2007-11-08'),('2007-11-09'),('2007-11-10'),('2007-11-11'),('2007-11-12'),('2007-11-13'),('2007-11-14'),('2007-11-15'),('2007-11-16'),('2007-11-17'),('2007-11-18'),('2007-11-19'),('2007-11-20'),('2007-11-21'),('2007-11-22'),('2007-11-23'),('2007-11-24'),('2007-11-25'),('2007-11-26'),('2007-11-27'),('2007-11-28'),('2007-11-29'),('2007-11-30'),('2007-12-01'),('2007-12-02'),('2007-12-03'),('2007-12-04'),('2007-12-05'),('2007-12-06'),('2007-12-07'),('2007-12-08'),('2007-12-09'),('2007-12-10'),('2007-12-11'),('2007-12-12'),('2007-12-13'),('2007-12-14'),('2007-12-15'),('2007-12-16'),('2007-12-17'),('2007-12-18'),('2007-12-19'),('2007-12-20'),('2007-12-21'),('2007-12-22'),('2007-12-23'),('2007-12-24'),('2007-12-25'),('2007-12-26'),('2007-12-27'),('2007-12-28'),('2007-12-29'),('2007-12-30'),('2007-12-31'),('2008-01-01'),('2008-01-02'),('2008-01-03'),('2008-01-04'),('2008-01-05'),('2008-01-06'),('2008-01-07'),('2008-01-08'),('2008-01-09'),('2008-01-10'),('2008-01-11'),('2008-01-12'),('2008-01-13'),('2008-01-14'),('2008-01-15'),('2008-01-16'),('2008-01-17'),('2008-01-18'),('2008-01-19'),('2008-01-20'),('2008-01-21'),('2008-01-22'),('2008-01-23'),('2008-01-24'),('2008-01-25'),('2008-01-26'),('2008-01-27'),('2008-01-28'),('2008-01-29'),('2008-01-30'),('2008-01-31'),('2008-02-01'),('2008-02-02'),('2008-02-03'),('2008-02-04'),('2008-02-05'),('2008-02-06'),('2008-02-07'),('2008-02-08'),('2008-02-09'),('2008-02-10'),('2008-02-11'),('2008-02-12'),('2008-02-13'),('2008-02-14'),('2008-02-15'),('2008-02-16'),('2008-02-17'),('2008-02-18'),('2008-02-19'),('2008-02-20'),('2008-02-21'),('2008-02-22'),('2008-02-23'),('2008-02-24'),('2008-02-25'),('2008-02-26'),('2008-02-27'),('2008-02-28'),('2008-02-29'),('2008-03-01'),('2008-03-02'),('2008-03-03'),('2008-03-04'),('2008-03-05'),('2008-03-06'),('2008-03-07'),('2008-03-08'),('2008-03-09'),('2008-03-10'),('2008-03-11'),('2008-03-12'),('2008-03-13'),('2008-03-14'),('2008-03-15'),('2008-03-16'),('2008-03-17'),('2008-03-18'),('2008-03-19'),('2008-03-20'),('2008-03-21'),('2008-03-22'),('2008-03-23'),('2008-03-24'),('2008-03-25'),('2008-03-26'),('2008-03-27'),('2008-03-28'),('2008-03-29'),('2008-03-30'),('2008-03-31'),('2008-04-01'),('2008-04-02'),('2008-04-03'),('2008-04-04'),('2008-04-05'),('2008-04-06'),('2008-04-07'),('2008-04-08'),('2008-04-09'),('2008-04-10'),('2008-04-11'),('2008-04-12'),('2008-04-13'),('2008-04-14'),('2008-04-15'),('2008-04-16'),('2008-04-17'),('2008-04-18'),('2008-04-19'),('2008-04-20'),('2008-04-21'),('2008-04-22'),('2008-04-23'),('2008-04-24'),('2008-04-25'),('2008-04-26'),('2008-04-27'),('2008-04-28'),('2008-04-29'),('2008-04-30'),('2008-05-01'),('2008-05-02'),('2008-05-03'),('2008-05-04'),('2008-05-05'),('2008-05-06'),('2008-05-07'),('2008-05-08'),('2008-05-09'),('2008-05-10'),('2008-05-11'),('2008-05-12'),('2008-05-13'),('2008-05-14'),('2008-05-15'),('2008-05-16'),('2008-05-17'),('2008-05-18'),('2008-05-19'),('2008-05-20'),('2008-05-21'),('2008-05-22'),('2008-05-23'),('2008-05-24'),('2008-05-25'),('2008-05-26'),('2008-05-27'),('2008-05-28'),('2008-05-29'),('2008-05-30'),('2008-05-31'),('2008-06-01'),('2008-06-02'),('2008-06-03'),('2008-06-04'),('2008-06-05'),('2008-06-06'),('2008-06-07'),('2008-06-08'),('2008-06-09'),('2008-06-10'),('2008-06-11'),('2008-06-12'),('2008-06-13'),('2008-06-14'),('2008-06-15'),('2008-06-16'),('2008-06-17'),('2008-06-18'),('2008-06-19'),('2008-06-20'),('2008-06-21'),('2008-06-22'),('2008-06-23'),('2008-06-24'),('2008-06-25'),('2008-06-26'),('2008-06-27'),('2008-06-28'),('2008-06-29'),('2008-06-30'),('2008-07-01'),('2008-07-02'),('2008-07-03'),('2008-07-04'),('2008-07-05'),('2008-07-06'),('2008-07-07'),('2008-07-08'),('2008-07-09'),('2008-07-10'),('2008-07-11'),('2008-07-12'),('2008-07-13'),('2008-07-14'),('2008-07-15'),('2008-07-16'),('2008-07-17'),('2008-07-18'),('2008-07-19'),('2008-07-20'),('2008-07-21'),('2008-07-22'),('2008-07-23'),('2008-07-24'),('2008-07-25'),('2008-07-26'),('2008-07-27'),('2008-07-28'),('2008-07-29'),('2008-07-30'),('2008-07-31'),('2008-08-01'),('2008-08-02'),('2008-08-03'),('2008-08-04'),('2008-08-05'),('2008-08-06'),('2008-08-07'),('2008-08-08'),('2008-08-09'),('2008-08-10'),('2008-08-11'),('2008-08-12'),('2008-08-13'),('2008-08-14'),('2008-08-15'),('2008-08-16'),('2008-08-17'),('2008-08-18'),('2008-08-19'),('2008-08-20'),('2008-08-21'),('2008-08-22'),('2008-08-23'),('2008-08-24'),('2008-08-25'),('2008-08-26'),('2008-08-27'),('2008-08-28'),('2008-08-29'),('2008-08-30'),('2008-08-31'),('2008-09-01'),('2008-09-02'),('2008-09-03'),('2008-09-04'),('2008-09-05'),('2008-09-06'),('2008-09-07'),('2008-09-08'),('2008-09-09'),('2008-09-10'),('2008-09-11'),('2008-09-12'),('2008-09-13'),('2008-09-14'),('2008-09-15'),('2008-09-16'),('2008-09-17'),('2008-09-18'),('2008-09-19'),('2008-09-20'),('2008-09-21'),('2008-09-22'),('2008-09-23'),('2008-09-24'),('2008-09-25'),('2008-09-26'),('2008-09-27'),('2008-09-28'),('2008-09-29'),('2008-09-30'),('2008-10-01'),('2008-10-02'),('2008-10-03'),('2008-10-04'),('2008-10-05'),('2008-10-06'),('2008-10-07'),('2008-10-08'),('2008-10-09'),('2008-10-10'),('2008-10-11'),('2008-10-12'),('2008-10-13'),('2008-10-14'),('2008-10-15'),('2008-10-16'),('2008-10-17'),('2008-10-18'),('2008-10-19'),('2008-10-20'),('2008-10-21'),('2008-10-22'),('2008-10-23'),('2008-10-24'),('2008-10-25'),('2008-10-26'),('2008-10-27'),('2008-10-28'),('2008-10-29'),('2008-10-30'),('2008-10-31'),('2008-11-01'),('2008-11-02'),('2008-11-03'),('2008-11-04'),('2008-11-05'),('2008-11-06'),('2008-11-07'),('2008-11-08'),('2008-11-09'),('2008-11-10'),('2008-11-11'),('2008-11-12'),('2008-11-13'),('2008-11-14'),('2008-11-15'),('2008-11-16'),('2008-11-17'),('2008-11-18'),('2008-11-19'),('2008-11-20'),('2008-11-21'),('2008-11-22'),('2008-11-23'),('2008-11-24'),('2008-11-25'),('2008-11-26'),('2008-11-27'),('2008-11-28'),('2008-11-29'),('2008-11-30'),('2008-12-01'),('2008-12-02'),('2008-12-03'),('2008-12-04'),('2008-12-05'),('2008-12-06'),('2008-12-07'),('2008-12-08'),('2008-12-09'),('2008-12-10'),('2008-12-11'),('2008-12-12'),('2008-12-13'),('2008-12-14'),('2008-12-15'),('2008-12-16'),('2008-12-17'),('2008-12-18'),('2008-12-19'),('2008-12-20'),('2008-12-21'),('2008-12-22'),('2008-12-23'),('2008-12-24'),('2008-12-25'),('2008-12-26'),('2008-12-27'),('2008-12-28'),('2008-12-29'),('2008-12-30'),('2008-12-31'),('2009-01-01'),('2009-01-02'),('2009-01-03'),('2009-01-04'),('2009-01-05'),('2009-01-06'),('2009-01-07'),('2009-01-08'),('2009-01-09'),('2009-01-10'),('2009-01-11'),('2009-01-12'),('2009-01-13'),('2009-01-14'),('2009-01-15'),('2009-01-16'),('2009-01-17'),('2009-01-18'),('2009-01-19'),('2009-01-20'),('2009-01-21'),('2009-01-22'),('2009-01-23'),('2009-01-24'),('2009-01-25'),('2009-01-26'),('2009-01-27'),('2009-01-28'),('2009-01-29'),('2009-01-30'),('2009-01-31'),('2009-02-01'),('2009-02-02'),('2009-02-03'),('2009-02-04'),('2009-02-05'),('2009-02-06'),('2009-02-07'),('2009-02-08'),('2009-02-09'),('2009-02-10'),('2009-02-11'),('2009-02-12'),('2009-02-13'),('2009-02-14'),('2009-02-15'),('2009-02-16'),('2009-02-17'),('2009-02-18'),('2009-02-19'),('2009-02-20'),('2009-02-21'),('2009-02-22'),('2009-02-23'),('2009-02-24'),('2009-02-25'),('2009-02-26'),('2009-02-27'),('2009-02-28'),('2009-03-01'),('2009-03-02'),('2009-03-03'),('2009-03-04'),('2009-03-05'),('2009-03-06'),('2009-03-07'),('2009-03-08'),('2009-03-09'),('2009-03-10'),('2009-03-11'),('2009-03-12'),('2009-03-13'),('2009-03-14'),('2009-03-15'),('2009-03-16'),('2009-03-17'),('2009-03-18'),('2009-03-19'),('2009-03-20'),('2009-03-21'),('2009-03-22'),('2009-03-23'),('2009-03-24'),('2009-03-25'),('2009-03-26'),('2009-03-27'),('2009-03-28'),('2009-03-29'),('2009-03-30'),('2009-03-31'),('2009-04-01'),('2009-04-02'),('2009-04-03'),('2009-04-04'),('2009-04-05'),('2009-04-06'),('2009-04-07'),('2009-04-08'),('2009-04-09'),('2009-04-10'),('2009-04-11'),('2009-04-12'),('2009-04-13'),('2009-04-14'),('2009-04-15'),('2009-04-16'),('2009-04-17'),('2009-04-18'),('2009-04-19'),('2009-04-20'),('2009-04-21'),('2009-04-22'),('2009-04-23'),('2009-04-24'),('2009-04-25'),('2009-04-26'),('2009-04-27'),('2009-04-28'),('2009-04-29'),('2009-04-30'),('2009-05-01'),('2009-05-02'),('2009-05-03'),('2009-05-04'),('2009-05-05'),('2009-05-06'),('2009-05-07'),('2009-05-08'),('2009-05-09'),('2009-05-10'),('2009-05-11'),('2009-05-12'),('2009-05-13'),('2009-05-14'),('2009-05-15'),('2009-05-16'),('2009-05-17'),('2009-05-18'),('2009-05-19'),('2009-05-20'),('2009-05-21'),('2009-05-22'),('2009-05-23'),('2009-05-24'),('2009-05-25'),('2009-05-26'),('2009-05-27'),('2009-05-28'),('2009-05-29'),('2009-05-30'),('2009-05-31'),('2009-06-01'),('2009-06-02'),('2009-06-03'),('2009-06-04'),('2009-06-05'),('2009-06-06'),('2009-06-07'),('2009-06-08'),('2009-06-09'),('2009-06-10'),('2009-06-11'),('2009-06-12'),('2009-06-13'),('2009-06-14'),('2009-06-15'),('2009-06-16'),('2009-06-17'),('2009-06-18'),('2009-06-19'),('2009-06-20'),('2009-06-21'),('2009-06-22'),('2009-06-23'),('2009-06-24'),('2009-06-25'),('2009-06-26'),('2009-06-27'),('2009-06-28'),('2009-06-29'),('2009-06-30'),('2009-07-01'),('2009-07-02'),('2009-07-03'),('2009-07-04'),('2009-07-05'),('2009-07-06'),('2009-07-07'),('2009-07-08'),('2009-07-09'),('2009-07-10'),('2009-07-11'),('2009-07-12'),('2009-07-13'),('2009-07-14'),('2009-07-15'),('2009-07-16'),('2009-07-17'),('2009-07-18'),('2009-07-19'),('2009-07-20'),('2009-07-21'),('2009-07-22'),('2009-07-23'),('2009-07-24'),('2009-07-25'),('2009-07-26'),('2009-07-27'),('2009-07-28'),('2009-07-29'),('2009-07-30'),('2009-07-31'),('2009-08-01'),('2009-08-02'),('2009-08-03'),('2009-08-04'),('2009-08-05'),('2009-08-06'),('2009-08-07'),('2009-08-08'),('2009-08-09'),('2009-08-10'),('2009-08-11'),('2009-08-12'),('2009-08-13'),('2009-08-14'),('2009-08-15'),('2009-08-16'),('2009-08-17'),('2009-08-18'),('2009-08-19'),('2009-08-20'),('2009-08-21'),('2009-08-22'),('2009-08-23'),('2009-08-24'),('2009-08-25'),('2009-08-26'),('2009-08-27'),('2009-08-28'),('2009-08-29'),('2009-08-30'),('2009-08-31'),('2009-09-01'),('2009-09-02'),('2009-09-03'),('2009-09-04'),('2009-09-05'),('2009-09-06'),('2009-09-07'),('2009-09-08'),('2009-09-09'),('2009-09-10'),('2009-09-11'),('2009-09-12'),('2009-09-13'),('2009-09-14'),('2009-09-15'),('2009-09-16'),('2009-09-17'),('2009-09-18'),('2009-09-19'),('2009-09-20'),('2009-09-21'),('2009-09-22'),('2009-09-23'),('2009-09-24'),('2009-09-25'),('2009-09-26'),('2009-09-27'),('2009-09-28'),('2009-09-29'),('2009-09-30'),('2009-10-01'),('2009-10-02'),('2009-10-03'),('2009-10-04'),('2009-10-05'),('2009-10-06'),('2009-10-07'),('2009-10-08'),('2009-10-09'),('2009-10-10'),('2009-10-11'),('2009-10-12'),('2009-10-13'),('2009-10-14'),('2009-10-15'),('2009-10-16'),('2009-10-17'),('2009-10-18'),('2009-10-19'),('2009-10-20'),('2009-10-21'),('2009-10-22'),('2009-10-23'),('2009-10-24'),('2009-10-25'),('2009-10-26'),('2009-10-27'),('2009-10-28'),('2009-10-29'),('2009-10-30'),('2009-10-31'),('2009-11-01'),('2009-11-02'),('2009-11-03'),('2009-11-04'),('2009-11-05'),('2009-11-06'),('2009-11-07'),('2009-11-08'),('2009-11-09'),('2009-11-10'),('2009-11-11'),('2009-11-12'),('2009-11-13'),('2009-11-14'),('2009-11-15'),('2009-11-16'),('2009-11-17'),('2009-11-18'),('2009-11-19'),('2009-11-20'),('2009-11-21'),('2009-11-22'),('2009-11-23'),('2009-11-24'),('2009-11-25'),('2009-11-26'),('2009-11-27'),('2009-11-28'),('2009-11-29'),('2009-11-30'),('2009-12-01'),('2009-12-02'),('2009-12-03'),('2009-12-04'),('2009-12-05'),('2009-12-06'),('2009-12-07'),('2009-12-08'),('2009-12-09'),('2009-12-10'),('2009-12-11'),('2009-12-12'),('2009-12-13'),('2009-12-14'),('2009-12-15'),('2009-12-16'),('2009-12-17'),('2009-12-18'),('2009-12-19'),('2009-12-20'),('2009-12-21'),('2009-12-22'),('2009-12-23'),('2009-12-24'),('2009-12-25'),('2009-12-26'),('2009-12-27'),('2009-12-28'),('2009-12-29'),('2009-12-30'),('2009-12-31'),('2010-01-01'),('2010-01-02'),('2010-01-03'),('2010-01-04'),('2010-01-05'),('2010-01-06'),('2010-01-07'),('2010-01-08'),('2010-01-09'),('2010-01-10'),('2010-01-11'),('2010-01-12'),('2010-01-13'),('2010-01-14'),('2010-01-15'),('2010-01-16'),('2010-01-17'),('2010-01-18'),('2010-01-19'),('2010-01-20'),('2010-01-21'),('2010-01-22'),('2010-01-23'),('2010-01-24'),('2010-01-25'),('2010-01-26'),('2010-01-27'),('2010-01-28'),('2010-01-29'),('2010-01-30'),('2010-01-31'),('2010-02-01'),('2010-02-02'),('2010-02-03'),('2010-02-04'),('2010-02-05'),('2010-02-06'),('2010-02-07'),('2010-02-08'),('2010-02-09'),('2010-02-10'),('2010-02-11'),('2010-02-12'),('2010-02-13'),('2010-02-14'),('2010-02-15'),('2010-02-16'),('2010-02-17'),('2010-02-18'),('2010-02-19'),('2010-02-20'),('2010-02-21'),('2010-02-22'),('2010-02-23'),('2010-02-24'),('2010-02-25'),('2010-02-26'),('2010-02-27'),('2010-02-28'),('2010-03-01'),('2010-03-02'),('2010-03-03'),('2010-03-04'),('2010-03-05'),('2010-03-06'),('2010-03-07'),('2010-03-08'),('2010-03-09'),('2010-03-10'),('2010-03-11'),('2010-03-12'),('2010-03-13'),('2010-03-14'),('2010-03-15'),('2010-03-16'),('2010-03-17'),('2010-03-18'),('2010-03-19'),('2010-03-20'),('2010-03-21'),('2010-03-22'),('2010-03-23'),('2010-03-24'),('2010-03-25'),('2010-03-26'),('2010-03-27'),('2010-03-28'),('2010-03-29'),('2010-03-30'),('2010-03-31'),('2010-04-01'),('2010-04-02'),('2010-04-03'),('2010-04-04'),('2010-04-05'),('2010-04-06'),('2010-04-07'),('2010-04-08'),('2010-04-09'),('2010-04-10'),('2010-04-11'),('2010-04-12'),('2010-04-13'),('2010-04-14'),('2010-04-15'),('2010-04-16'),('2010-04-17'),('2010-04-18'),('2010-04-19'),('2010-04-20'),('2010-04-21'),('2010-04-22'),('2010-04-23'),('2010-04-24'),('2010-04-25'),('2010-04-26'),('2010-04-27'),('2010-04-28'),('2010-04-29'),('2010-04-30'),('2010-05-01'),('2010-05-02'),('2010-05-03'),('2010-05-04'),('2010-05-05'),('2010-05-06'),('2010-05-07'),('2010-05-08'),('2010-05-09'),('2010-05-10'),('2010-05-11'),('2010-05-12'),('2010-05-13'),('2010-05-14'),('2010-05-15'),('2010-05-16'),('2010-05-17'),('2010-05-18'),('2010-05-19'),('2010-05-20'),('2010-05-21'),('2010-05-22'),('2010-05-23'),('2010-05-24'),('2010-05-25'),('2010-05-26'),('2010-05-27'),('2010-05-28'),('2010-05-29'),('2010-05-30'),('2010-05-31'),('2010-06-01'),('2010-06-02'),('2010-06-03'),('2010-06-04'),('2010-06-05'),('2010-06-06'),('2010-06-07'),('2010-06-08'),('2010-06-09'),('2010-06-10'),('2010-06-11'),('2010-06-12'),('2010-06-13'),('2010-06-14'),('2010-06-15'),('2010-06-16'),('2010-06-17'),('2010-06-18'),('2010-06-19'),('2010-06-20'),('2010-06-21'),('2010-06-22'),('2010-06-23'),('2010-06-24'),('2010-06-25'),('2010-06-26'),('2010-06-27'),('2010-06-28'),('2010-06-29'),('2010-06-30'),('2010-07-01'),('2010-07-02'),('2010-07-03'),('2010-07-04'),('2010-07-05'),('2010-07-06'),('2010-07-07'),('2010-07-08'),('2010-07-09'),('2010-07-10'),('2010-07-11'),('2010-07-12'),('2010-07-13'),('2010-07-14'),('2010-07-15'),('2010-07-16'),('2010-07-17'),('2010-07-18'),('2010-07-19'),('2010-07-20'),('2010-07-21'),('2010-07-22'),('2010-07-23'),('2010-07-24'),('2010-07-25'),('2010-07-26'),('2010-07-27'),('2010-07-28'),('2010-07-29'),('2010-07-30'),('2010-07-31'),('2010-08-01'),('2010-08-02'),('2010-08-03'),('2010-08-04'),('2010-08-05'),('2010-08-06'),('2010-08-07'),('2010-08-08'),('2010-08-09'),('2010-08-10'),('2010-08-11'),('2010-08-12'),('2010-08-13'),('2010-08-14'),('2010-08-15'),('2010-08-16'),('2010-08-17'),('2010-08-18'),('2010-08-19'),('2010-08-20'),('2010-08-21'),('2010-08-22'),('2010-08-23'),('2010-08-24'),('2010-08-25'),('2010-08-26'),('2010-08-27'),('2010-08-28'),('2010-08-29'),('2010-08-30'),('2010-08-31'),('2010-09-01'),('2010-09-02'),('2010-09-03'),('2010-09-04'),('2010-09-05'),('2010-09-06'),('2010-09-07'),('2010-09-08'),('2010-09-09'),('2010-09-10'),('2010-09-11'),('2010-09-12'),('2010-09-13'),('2010-09-14'),('2010-09-15'),('2010-09-16'),('2010-09-17'),('2010-09-18'),('2010-09-19'),('2010-09-20'),('2010-09-21'),('2010-09-22'),('2010-09-23'),('2010-09-24'),('2010-09-25'),('2010-09-26'),('2010-09-27'),('2010-09-28'),('2010-09-29'),('2010-09-30'),('2010-10-01'),('2010-10-02'),('2010-10-03'),('2010-10-04'),('2010-10-05'),('2010-10-06'),('2010-10-07'),('2010-10-08'),('2010-10-09'),('2010-10-10'),('2010-10-11'),('2010-10-12'),('2010-10-13'),('2010-10-14'),('2010-10-15'),('2010-10-16'),('2010-10-17'),('2010-10-18'),('2010-10-19'),('2010-10-20'),('2010-10-21'),('2010-10-22'),('2010-10-23'),('2010-10-24'),('2010-10-25'),('2010-10-26'),('2010-10-27'),('2010-10-28'),('2010-10-29'),('2010-10-30'),('2010-10-31'),('2010-11-01'),('2010-11-02'),('2010-11-03'),('2010-11-04'),('2010-11-05'),('2010-11-06'),('2010-11-07'),('2010-11-08'),('2010-11-09'),('2010-11-10'),('2010-11-11'),('2010-11-12'),('2010-11-13'),('2010-11-14'),('2010-11-15'),('2010-11-16'),('2010-11-17'),('2010-11-18'),('2010-11-19'),('2010-11-20'),('2010-11-21'),('2010-11-22'),('2010-11-23'),('2010-11-24'),('2010-11-25'),('2010-11-26'),('2010-11-27'),('2010-11-28'),('2010-11-29'),('2010-11-30'),('2010-12-01'),('2010-12-02'),('2010-12-03'),('2010-12-04'),('2010-12-05'),('2010-12-06'),('2010-12-07'),('2010-12-08'),('2010-12-09'),('2010-12-10'),('2010-12-11'),('2010-12-12'),('2010-12-13'),('2010-12-14'),('2010-12-15'),('2010-12-16'),('2010-12-17'),('2010-12-18'),('2010-12-19'),('2010-12-20'),('2010-12-21'),('2010-12-22'),('2010-12-23'),('2010-12-24'),('2010-12-25'),('2010-12-26'),('2010-12-27'),('2010-12-28'),('2010-12-29'),('2010-12-30'),('2010-12-31'),('2011-01-01'),('2011-01-02'),('2011-01-03'),('2011-01-04'),('2011-01-05'),('2011-01-06'),('2011-01-07'),('2011-01-08'),('2011-01-09'),('2011-01-10'),('2011-01-11'),('2011-01-12'),('2011-01-13'),('2011-01-14'),('2011-01-15'),('2011-01-16'),('2011-01-17'),('2011-01-18'),('2011-01-19'),('2011-01-20'),('2011-01-21'),('2011-01-22'),('2011-01-23'),('2011-01-24'),('2011-01-25'),('2011-01-26'),('2011-01-27'),('2011-01-28'),('2011-01-29'),('2011-01-30'),('2011-01-31'),('2011-02-01'),('2011-02-02'),('2011-02-03'),('2011-02-04'),('2011-02-05'),('2011-02-06'),('2011-02-07'),('2011-02-08'),('2011-02-09'),('2011-02-10'),('2011-02-11'),('2011-02-12'),('2011-02-13'),('2011-02-14'),('2011-02-15'),('2011-02-16'),('2011-02-17'),('2011-02-18'),('2011-02-19'),('2011-02-20'),('2011-02-21'),('2011-02-22'),('2011-02-23'),('2011-02-24'),('2011-02-25'),('2011-02-26'),('2011-02-27'),('2011-02-28'),('2011-03-01'),('2011-03-02'),('2011-03-03'),('2011-03-04'),('2011-03-05'),('2011-03-06'),('2011-03-07'),('2011-03-08'),('2011-03-09'),('2011-03-10'),('2011-03-11'),('2011-03-12'),('2011-03-13'),('2011-03-14'),('2011-03-15'),('2011-03-16'),('2011-03-17'),('2011-03-18'),('2011-03-19'),('2011-03-20'),('2011-03-21'),('2011-03-22'),('2011-03-23'),('2011-03-24'),('2011-03-25'),('2011-03-26'),('2011-03-27'),('2011-03-28'),('2011-03-29'),('2011-03-30'),('2011-03-31'),('2011-04-01'),('2011-04-02'),('2011-04-03'),('2011-04-04'),('2011-04-05'),('2011-04-06'),('2011-04-07'),('2011-04-08'),('2011-04-09'),('2011-04-10'),('2011-04-11'),('2011-04-12'),('2011-04-13'),('2011-04-14'),('2011-04-15'),('2011-04-16'),('2011-04-17'),('2011-04-18'),('2011-04-19'),('2011-04-20'),('2011-04-21'),('2011-04-22'),('2011-04-23'),('2011-04-24'),('2011-04-25'),('2011-04-26'),('2011-04-27'),('2011-04-28'),('2011-04-29'),('2011-04-30'),('2011-05-01'),('2011-05-02'),('2011-05-03'),('2011-05-04'),('2011-05-05'),('2011-05-06'),('2011-05-07'),('2011-05-08'),('2011-05-09'),('2011-05-10'),('2011-05-11'),('2011-05-12'),('2011-05-13'),('2011-05-14'),('2011-05-15'),('2011-05-16'),('2011-05-17'),('2011-05-18'),('2011-05-19'),('2011-05-20'),('2011-05-21'),('2011-05-22'),('2011-05-23'),('2011-05-24'),('2011-05-25'),('2011-05-26'),('2011-05-27'),('2011-05-28'),('2011-05-29'),('2011-05-30'),('2011-05-31'),('2011-06-01'),('2011-06-02'),('2011-06-03'),('2011-06-04'),('2011-06-05'),('2011-06-06'),('2011-06-07'),('2011-06-08'),('2011-06-09'),('2011-06-10'),('2011-06-11'),('2011-06-12'),('2011-06-13'),('2011-06-14'),('2011-06-15'),('2011-06-16'),('2011-06-17'),('2011-06-18'),('2011-06-19'),('2011-06-20'),('2011-06-21'),('2011-06-22'),('2011-06-23'),('2011-06-24'),('2011-06-25'),('2011-06-26'),('2011-06-27'),('2011-06-28'),('2011-06-29'),('2011-06-30'),('2011-07-01'),('2011-07-02'),('2011-07-03'),('2011-07-04'),('2011-07-05'),('2011-07-06'),('2011-07-07'),('2011-07-08'),('2011-07-09'),('2011-07-10'),('2011-07-11'),('2011-07-12'),('2011-07-13'),('2011-07-14'),('2011-07-15'),('2011-07-16'),('2011-07-17'),('2011-07-18'),('2011-07-19'),('2011-07-20'),('2011-07-21'),('2011-07-22'),('2011-07-23'),('2011-07-24'),('2011-07-25'),('2011-07-26'),('2011-07-27'),('2011-07-28'),('2011-07-29'),('2011-07-30'),('2011-07-31'),('2011-08-01'),('2011-08-02'),('2011-08-03'),('2011-08-04'),('2011-08-05'),('2011-08-06'),('2011-08-07'),('2011-08-08'),('2011-08-09'),('2011-08-10'),('2011-08-11'),('2011-08-12'),('2011-08-13'),('2011-08-14'),('2011-08-15'),('2011-08-16'),('2011-08-17'),('2011-08-18'),('2011-08-19'),('2011-08-20'),('2011-08-21'),('2011-08-22'),('2011-08-23'),('2011-08-24'),('2011-08-25'),('2011-08-26'),('2011-08-27'),('2011-08-28'),('2011-08-29'),('2011-08-30'),('2011-08-31'),('2011-09-01'),('2011-09-02'),('2011-09-03'),('2011-09-04'),('2011-09-05'),('2011-09-06'),('2011-09-07'),('2011-09-08'),('2011-09-09'),('2011-09-10'),('2011-09-11'),('2011-09-12'),('2011-09-13'),('2011-09-14'),('2011-09-15'),('2011-09-16'),('2011-09-17'),('2011-09-18'),('2011-09-19'),('2011-09-20'),('2011-09-21'),('2011-09-22'),('2011-09-23'),('2011-09-24'),('2011-09-25'),('2011-09-26'),('2011-09-27'),('2011-09-28'),('2011-09-29'),('2011-09-30'),('2011-10-01'),('2011-10-02'),('2011-10-03'),('2011-10-04'),('2011-10-05'),('2011-10-06'),('2011-10-07'),('2011-10-08'),('2011-10-09'),('2011-10-10'),('2011-10-11'),('2011-10-12'),('2011-10-13'),('2011-10-14'),('2011-10-15'),('2011-10-16'),('2011-10-17'),('2011-10-18'),('2011-10-19'),('2011-10-20'),('2011-10-21'),('2011-10-22'),('2011-10-23'),('2011-10-24'),('2011-10-25'),('2011-10-26'),('2011-10-27'),('2011-10-28'),('2011-10-29'),('2011-10-30'),('2011-10-31'),('2011-11-01'),('2011-11-02'),('2011-11-03'),('2011-11-04'),('2011-11-05'),('2011-11-06'),('2011-11-07'),('2011-11-08'),('2011-11-09'),('2011-11-10'),('2011-11-11'),('2011-11-12'),('2011-11-13'),('2011-11-14'),('2011-11-15'),('2011-11-16'),('2011-11-17'),('2011-11-18'),('2011-11-19'),('2011-11-20'),('2011-11-21'),('2011-11-22'),('2011-11-23'),('2011-11-24'),('2011-11-25'),('2011-11-26'),('2011-11-27'),('2011-11-28'),('2011-11-29'),('2011-11-30'),('2011-12-01'),('2011-12-02'),('2011-12-03'),('2011-12-04'),('2011-12-05'),('2011-12-06'),('2011-12-07'),('2011-12-08'),('2011-12-09'),('2011-12-10'),('2011-12-11'),('2011-12-12'),('2011-12-13'),('2011-12-14'),('2011-12-15'),('2011-12-16'),('2011-12-17'),('2011-12-18'),('2011-12-19'),('2011-12-20'),('2011-12-21'),('2011-12-22'),('2011-12-23'),('2011-12-24'),('2011-12-25'),('2011-12-26'),('2011-12-27'),('2011-12-28'),('2011-12-29'),('2011-12-30'),('2011-12-31'),('2012-01-01'),('2012-01-02'),('2012-01-03'),('2012-01-04'),('2012-01-05'),('2012-01-06'),('2012-01-07'),('2012-01-08'),('2012-01-09'),('2012-01-10'),('2012-01-11'),('2012-01-12'),('2012-01-13'),('2012-01-14'),('2012-01-15'),('2012-01-16'),('2012-01-17'),('2012-01-18'),('2012-01-19'),('2012-01-20'),('2012-01-21'),('2012-01-22'),('2012-01-23'),('2012-01-24'),('2012-01-25'),('2012-01-26'),('2012-01-27'),('2012-01-28'),('2012-01-29'),('2012-01-30'),('2012-01-31'),('2012-02-01'),('2012-02-02'),('2012-02-03'),('2012-02-04'),('2012-02-05'),('2012-02-06'),('2012-02-07'),('2012-02-08'),('2012-02-09'),('2012-02-10'),('2012-02-11'),('2012-02-12'),('2012-02-13'),('2012-02-14'),('2012-02-15'),('2012-02-16'),('2012-02-17'),('2012-02-18'),('2012-02-19'),('2012-02-20'),('2012-02-21'),('2012-02-22'),('2012-02-23'),('2012-02-24'),('2012-02-25'),('2012-02-26'),('2012-02-27'),('2012-02-28'),('2012-02-29'),('2012-03-01'),('2012-03-02'),('2012-03-03'),('2012-03-04'),('2012-03-05'),('2012-03-06'),('2012-03-07'),('2012-03-08'),('2012-03-09'),('2012-03-10'),('2012-03-11'),('2012-03-12'),('2012-03-13'),('2012-03-14'),('2012-03-15'),('2012-03-16'),('2012-03-17'),('2012-03-18'),('2012-03-19'),('2012-03-20'),('2012-03-21'),('2012-03-22'),('2012-03-23'),('2012-03-24'),('2012-03-25'),('2012-03-26'),('2012-03-27'),('2012-03-28'),('2012-03-29'),('2012-03-30'),('2012-03-31'),('2012-04-01'),('2012-04-02'),('2012-04-03'),('2012-04-04'),('2012-04-05'),('2012-04-06'),('2012-04-07'),('2012-04-08'),('2012-04-09'),('2012-04-10'),('2012-04-11'),('2012-04-12'),('2012-04-13'),('2012-04-14'),('2012-04-15'),('2012-04-16'),('2012-04-17'),('2012-04-18'),('2012-04-19'),('2012-04-20'),('2012-04-21'),('2012-04-22'),('2012-04-23'),('2012-04-24'),('2012-04-25'),('2012-04-26'),('2012-04-27'),('2012-04-28'),('2012-04-29'),('2012-04-30'),('2012-05-01'),('2012-05-02'),('2012-05-03'),('2012-05-04'),('2012-05-05'),('2012-05-06'),('2012-05-07'),('2012-05-08'),('2012-05-09'),('2012-05-10'),('2012-05-11'),('2012-05-12'),('2012-05-13'),('2012-05-14'),('2012-05-15'),('2012-05-16'),('2012-05-17'),('2012-05-18'),('2012-05-19'),('2012-05-20'),('2012-05-21'),('2012-05-22'),('2012-05-23'),('2012-05-24'),('2012-05-25'),('2012-05-26'),('2012-05-27'),('2012-05-28'),('2012-05-29'),('2012-05-30'),('2012-05-31'),('2012-06-01'),('2012-06-02'),('2012-06-03'),('2012-06-04'),('2012-06-05'),('2012-06-06'),('2012-06-07'),('2012-06-08'),('2012-06-09'),('2012-06-10'),('2012-06-11'),('2012-06-12'),('2012-06-13'),('2012-06-14'),('2012-06-15'),('2012-06-16'),('2012-06-17'),('2012-06-18'),('2012-06-19'),('2012-06-20'),('2012-06-21'),('2012-06-22'),('2012-06-23'),('2012-06-24'),('2012-06-25'),('2012-06-26'),('2012-06-27'),('2012-06-28'),('2012-06-29'),('2012-06-30'),('2012-07-01'),('2012-07-02'),('2012-07-03'),('2012-07-04'),('2012-07-05'),('2012-07-06'),('2012-07-07'),('2012-07-08'),('2012-07-09'),('2012-07-10'),('2012-07-11'),('2012-07-12'),('2012-07-13'),('2012-07-14'),('2012-07-15'),('2012-07-16'),('2012-07-17'),('2012-07-18'),('2012-07-19'),('2012-07-20'),('2012-07-21'),('2012-07-22'),('2012-07-23'),('2012-07-24'),('2012-07-25'),('2012-07-26'),('2012-07-27'),('2012-07-28'),('2012-07-29'),('2012-07-30'),('2012-07-31'),('2012-08-01'),('2012-08-02'),('2012-08-03'),('2012-08-04'),('2012-08-05'),('2012-08-06'),('2012-08-07'),('2012-08-08'),('2012-08-09'),('2012-08-10'),('2012-08-11'),('2012-08-12'),('2012-08-13'),('2012-08-14'),('2012-08-15'),('2012-08-16'),('2012-08-17'),('2012-08-18'),('2012-08-19'),('2012-08-20'),('2012-08-21'),('2012-08-22'),('2012-08-23'),('2012-08-24'),('2012-08-25'),('2012-08-26'),('2012-08-27'),('2012-08-28'),('2012-08-29'),('2012-08-30'),('2012-08-31'),('2012-09-01'),('2012-09-02'),('2012-09-03'),('2012-09-04'),('2012-09-05'),('2012-09-06'),('2012-09-07'),('2012-09-08'),('2012-09-09'),('2012-09-10'),('2012-09-11'),('2012-09-12'),('2012-09-13'),('2012-09-14'),('2012-09-15'),('2012-09-16'),('2012-09-17'),('2012-09-18'),('2012-09-19'),('2012-09-20'),('2012-09-21'),('2012-09-22'),('2012-09-23'),('2012-09-24'),('2012-09-25'),('2012-09-26'),('2012-09-27'),('2012-09-28'),('2012-09-29'),('2012-09-30'),('2012-10-01'),('2012-10-02'),('2012-10-03'),('2012-10-04'),('2012-10-05'),('2012-10-06'),('2012-10-07'),('2012-10-08'),('2012-10-09'),('2012-10-10'),('2012-10-11'),('2012-10-12'),('2012-10-13'),('2012-10-14'),('2012-10-15'),('2012-10-16'),('2012-10-17'),('2012-10-18'),('2012-10-19'),('2012-10-20'),('2012-10-21'),('2012-10-22'),('2012-10-23'),('2012-10-24'),('2012-10-25'),('2012-10-26'),('2012-10-27'),('2012-10-28'),('2012-10-29'),('2012-10-30'),('2012-10-31'),('2012-11-01'),('2012-11-02'),('2012-11-03'),('2012-11-04'),('2012-11-05'),('2012-11-06'),('2012-11-07'),('2012-11-08'),('2012-11-09'),('2012-11-10'),('2012-11-11'),('2012-11-12'),('2012-11-13'),('2012-11-14'),('2012-11-15'),('2012-11-16'),('2012-11-17'),('2012-11-18'),('2012-11-19'),('2012-11-20'),('2012-11-21'),('2012-11-22'),('2012-11-23'),('2012-11-24'),('2012-11-25'),('2012-11-26'),('2012-11-27'),('2012-11-28'),('2012-11-29'),('2012-11-30'),('2012-12-01'),('2012-12-02'),('2012-12-03'),('2012-12-04'),('2012-12-05'),('2012-12-06'),('2012-12-07'),('2012-12-08'),('2012-12-09'),('2012-12-10'),('2012-12-11'),('2012-12-12'),('2012-12-13'),('2012-12-14'),('2012-12-15'),('2012-12-16'),('2012-12-17'),('2012-12-18'),('2012-12-19'),('2012-12-20'),('2012-12-21'),('2012-12-22'),('2012-12-23'),('2012-12-24'),('2012-12-25'),('2012-12-26'),('2012-12-27'),('2012-12-28'),('2012-12-29'),('2012-12-30'),('2012-12-31'),('2013-01-01'),('2013-01-02'),('2013-01-03'),('2013-01-04'),('2013-01-05'),('2013-01-06'),('2013-01-07'),('2013-01-08'),('2013-01-09'),('2013-01-10'),('2013-01-11'),('2013-01-12'),('2013-01-13'),('2013-01-14'),('2013-01-15'),('2013-01-16'),('2013-01-17'),('2013-01-18'),('2013-01-19'),('2013-01-20'),('2013-01-21'),('2013-01-22'),('2013-01-23'),('2013-01-24'),('2013-01-25'),('2013-01-26'),('2013-01-27'),('2013-01-28'),('2013-01-29'),('2013-01-30'),('2013-01-31'),('2013-02-01'),('2013-02-02'),('2013-02-03'),('2013-02-04'),('2013-02-05'),('2013-02-06'),('2013-02-07'),('2013-02-08'),('2013-02-09'),('2013-02-10'),('2013-02-11'),('2013-02-12'),('2013-02-13'),('2013-02-14'),('2013-02-15'),('2013-02-16'),('2013-02-17'),('2013-02-18'),('2013-02-19'),('2013-02-20'),('2013-02-21'),('2013-02-22'),('2013-02-23'),('2013-02-24'),('2013-02-25'),('2013-02-26'),('2013-02-27'),('2013-02-28'),('2013-03-01'),('2013-03-02'),('2013-03-03'),('2013-03-04'),('2013-03-05'),('2013-03-06'),('2013-03-07'),('2013-03-08'),('2013-03-09'),('2013-03-10'),('2013-03-11'),('2013-03-12'),('2013-03-13'),('2013-03-14'),('2013-03-15'),('2013-03-16'),('2013-03-17'),('2013-03-18'),('2013-03-19'),('2013-03-20'),('2013-03-21'),('2013-03-22'),('2013-03-23'),('2013-03-24'),('2013-03-25'),('2013-03-26'),('2013-03-27'),('2013-03-28'),('2013-03-29'),('2013-03-30'),('2013-03-31'),('2013-04-01'),('2013-04-02'),('2013-04-03'),('2013-04-04'),('2013-04-05'),('2013-04-06'),('2013-04-07'),('2013-04-08'),('2013-04-09'),('2013-04-10'),('2013-04-11'),('2013-04-12'),('2013-04-13'),('2013-04-14'),('2013-04-15'),('2013-04-16'),('2013-04-17'),('2013-04-18'),('2013-04-19'),('2013-04-20'),('2013-04-21'),('2013-04-22'),('2013-04-23'),('2013-04-24'),('2013-04-25'),('2013-04-26'),('2013-04-27'),('2013-04-28'),('2013-04-29'),('2013-04-30'),('2013-05-01'),('2013-05-02'),('2013-05-03'),('2013-05-04'),('2013-05-05'),('2013-05-06'),('2013-05-07'),('2013-05-08'),('2013-05-09'),('2013-05-10'),('2013-05-11'),('2013-05-12'),('2013-05-13'),('2013-05-14'),('2013-05-15'),('2013-05-16'),('2013-05-17'),('2013-05-18'),('2013-05-19'),('2013-05-20'),('2013-05-21'),('2013-05-22'),('2013-05-23'),('2013-05-24'),('2013-05-25'),('2013-05-26'),('2013-05-27'),('2013-05-28'),('2013-05-29'),('2013-05-30'),('2013-05-31'),('2013-06-01'),('2013-06-02'),('2013-06-03'),('2013-06-04'),('2013-06-05'),('2013-06-06'),('2013-06-07'),('2013-06-08'),('2013-06-09'),('2013-06-10'),('2013-06-11'),('2013-06-12'),('2013-06-13'),('2013-06-14'),('2013-06-15'),('2013-06-16'),('2013-06-17'),('2013-06-18'),('2013-06-19'),('2013-06-20'),('2013-06-21'),('2013-06-22'),('2013-06-23'),('2013-06-24'),('2013-06-25'),('2013-06-26'),('2013-06-27'),('2013-06-28'),('2013-06-29'),('2013-06-30'),('2013-07-01'),('2013-07-02'),('2013-07-03'),('2013-07-04'),('2013-07-05'),('2013-07-06'),('2013-07-07'),('2013-07-08'),('2013-07-09'),('2013-07-10'),('2013-07-11'),('2013-07-12'),('2013-07-13'),('2013-07-14'),('2013-07-15'),('2013-07-16'),('2013-07-17'),('2013-07-18'),('2013-07-19'),('2013-07-20'),('2013-07-21'),('2013-07-22'),('2013-07-23'),('2013-07-24'),('2013-07-25'),('2013-07-26'),('2013-07-27'),('2013-07-28'),('2013-07-29'),('2013-07-30'),('2013-07-31'),('2013-08-01'),('2013-08-02'),('2013-08-03'),('2013-08-04'),('2013-08-05'),('2013-08-06'),('2013-08-07'),('2013-08-08'),('2013-08-09'),('2013-08-10'),('2013-08-11'),('2013-08-12'),('2013-08-13'),('2013-08-14'),('2013-08-15'),('2013-08-16'),('2013-08-17'),('2013-08-18'),('2013-08-19'),('2013-08-20'),('2013-08-21'),('2013-08-22'),('2013-08-23'),('2013-08-24'),('2013-08-25'),('2013-08-26'),('2013-08-27'),('2013-08-28'),('2013-08-29'),('2013-08-30'),('2013-08-31'),('2013-09-01'),('2013-09-02'),('2013-09-03'),('2013-09-04'),('2013-09-05'),('2013-09-06'),('2013-09-07'),('2013-09-08'),('2013-09-09'),('2013-09-10'),('2013-09-11'),('2013-09-12'),('2013-09-13'),('2013-09-14'),('2013-09-15'),('2013-09-16'),('2013-09-17'),('2013-09-18'),('2013-09-19'),('2013-09-20'),('2013-09-21'),('2013-09-22'),('2013-09-23'),('2013-09-24'),('2013-09-25'),('2013-09-26'),('2013-09-27'),('2013-09-28'),('2013-09-29'),('2013-09-30'),('2013-10-01'),('2013-10-02'),('2013-10-03'),('2013-10-04'),('2013-10-05'),('2013-10-06'),('2013-10-07'),('2013-10-08'),('2013-10-09'),('2013-10-10'),('2013-10-11'),('2013-10-12'),('2013-10-13'),('2013-10-14'),('2013-10-15'),('2013-10-16'),('2013-10-17'),('2013-10-18'),('2013-10-19'),('2013-10-20'),('2013-10-21'),('2013-10-22'),('2013-10-23'),('2013-10-24'),('2013-10-25'),('2013-10-26'),('2013-10-27'),('2013-10-28'),('2013-10-29'),('2013-10-30'),('2013-10-31'),('2013-11-01'),('2013-11-02'),('2013-11-03'),('2013-11-04'),('2013-11-05'),('2013-11-06'),('2013-11-07'),('2013-11-08'),('2013-11-09'),('2013-11-10'),('2013-11-11'),('2013-11-12'),('2013-11-13'),('2013-11-14'),('2013-11-15'),('2013-11-16'),('2013-11-17'),('2013-11-18'),('2013-11-19'),('2013-11-20'),('2013-11-21'),('2013-11-22'),('2013-11-23'),('2013-11-24'),('2013-11-25'),('2013-11-26'),('2013-11-27'),('2013-11-28'),('2013-11-29'),('2013-11-30'),('2013-12-01'),('2013-12-02'),('2013-12-03'),('2013-12-04'),('2013-12-05'),('2013-12-06'),('2013-12-07'),('2013-12-08'),('2013-12-09'),('2013-12-10'),('2013-12-11'),('2013-12-12'),('2013-12-13'),('2013-12-14'),('2013-12-15'),('2013-12-16'),('2013-12-17'),('2013-12-18'),('2013-12-19'),('2013-12-20'),('2013-12-21'),('2013-12-22'),('2013-12-23'),('2013-12-24'),('2013-12-25'),('2013-12-26'),('2013-12-27'),('2013-12-28'),('2013-12-29'),('2013-12-30'),('2013-12-31'),('2014-01-01'),('2014-01-02'),('2014-01-03'),('2014-01-04'),('2014-01-05'),('2014-01-06'),('2014-01-07'),('2014-01-08'),('2014-01-09'),('2014-01-10'),('2014-01-11'),('2014-01-12'),('2014-01-13'),('2014-01-14'),('2014-01-15'),('2014-01-16'),('2014-01-17'),('2014-01-18'),('2014-01-19'),('2014-01-20'),('2014-01-21'),('2014-01-22'),('2014-01-23'),('2014-01-24'),('2014-01-25'),('2014-01-26'),('2014-01-27'),('2014-01-28'),('2014-01-29'),('2014-01-30'),('2014-01-31'),('2014-02-01'),('2014-02-02'),('2014-02-03'),('2014-02-04'),('2014-02-05'),('2014-02-06'),('2014-02-07'),('2014-02-08'),('2014-02-09'),('2014-02-10'),('2014-02-11'),('2014-02-12'),('2014-02-13'),('2014-02-14'),('2014-02-15'),('2014-02-16'),('2014-02-17'),('2014-02-18'),('2014-02-19'),('2014-02-20'),('2014-02-21'),('2014-02-22'),('2014-02-23'),('2014-02-24'),('2014-02-25'),('2014-02-26'),('2014-02-27'),('2014-02-28'),('2014-03-01'),('2014-03-02'),('2014-03-03'),('2014-03-04'),('2014-03-05'),('2014-03-06'),('2014-03-07'),('2014-03-08'),('2014-03-09'),('2014-03-10'),('2014-03-11'),('2014-03-12'),('2014-03-13'),('2014-03-14'),('2014-03-15'),('2014-03-16'),('2014-03-17'),('2014-03-18'),('2014-03-19'),('2014-03-20'),('2014-03-21'),('2014-03-22'),('2014-03-23'),('2014-03-24'),('2014-03-25'),('2014-03-26'),('2014-03-27'),('2014-03-28'),('2014-03-29'),('2014-03-30'),('2014-03-31'),('2014-04-01'),('2014-04-02'),('2014-04-03'),('2014-04-04'),('2014-04-05'),('2014-04-06'),('2014-04-07'),('2014-04-08'),('2014-04-09'),('2014-04-10'),('2014-04-11'),('2014-04-12'),('2014-04-13'),('2014-04-14'),('2014-04-15'),('2014-04-16'),('2014-04-17'),('2014-04-18'),('2014-04-19'),('2014-04-20'),('2014-04-21'),('2014-04-22'),('2014-04-23'),('2014-04-24'),('2014-04-25'),('2014-04-26'),('2014-04-27'),('2014-04-28'),('2014-04-29'),('2014-04-30'),('2014-05-01'),('2014-05-02'),('2014-05-03'),('2014-05-04'),('2014-05-05'),('2014-05-06'),('2014-05-07'),('2014-05-08'),('2014-05-09'),('2014-05-10'),('2014-05-11'),('2014-05-12'),('2014-05-13'),('2014-05-14'),('2014-05-15'),('2014-05-16'),('2014-05-17'),('2014-05-18'),('2014-05-19'),('2014-05-20'),('2014-05-21'),('2014-05-22'),('2014-05-23'),('2014-05-24'),('2014-05-25'),('2014-05-26'),('2014-05-27'),('2014-05-28'),('2014-05-29'),('2014-05-30'),('2014-05-31'),('2014-06-01'),('2014-06-02'),('2014-06-03'),('2014-06-04'),('2014-06-05'),('2014-06-06'),('2014-06-07'),('2014-06-08'),('2014-06-09'),('2014-06-10'),('2014-06-11'),('2014-06-12'),('2014-06-13'),('2014-06-14'),('2014-06-15'),('2014-06-16'),('2014-06-17'),('2014-06-18'),('2014-06-19'),('2014-06-20'),('2014-06-21'),('2014-06-22'),('2014-06-23'),('2014-06-24'),('2014-06-25'),('2014-06-26'),('2014-06-27'),('2014-06-28'),('2014-06-29'),('2014-06-30'),('2014-07-01'),('2014-07-02'),('2014-07-03'),('2014-07-04'),('2014-07-05'),('2014-07-06'),('2014-07-07'),('2014-07-08'),('2014-07-09'),('2014-07-10'),('2014-07-11'),('2014-07-12'),('2014-07-13'),('2014-07-14'),('2014-07-15'),('2014-07-16'),('2014-07-17'),('2014-07-18'),('2014-07-19'),('2014-07-20'),('2014-07-21'),('2014-07-22'),('2014-07-23'),('2014-07-24'),('2014-07-25'),('2014-07-26'),('2014-07-27'),('2014-07-28'),('2014-07-29'),('2014-07-30'),('2014-07-31'),('2014-08-01'),('2014-08-02'),('2014-08-03'),('2014-08-04'),('2014-08-05'),('2014-08-06'),('2014-08-07'),('2014-08-08'),('2014-08-09'),('2014-08-10'),('2014-08-11'),('2014-08-12'),('2014-08-13'),('2014-08-14'),('2014-08-15'),('2014-08-16'),('2014-08-17'),('2014-08-18'),('2014-08-19'),('2014-08-20'),('2014-08-21'),('2014-08-22'),('2014-08-23'),('2014-08-24'),('2014-08-25'),('2014-08-26'),('2014-08-27'),('2014-08-28'),('2014-08-29'),('2014-08-30'),('2014-08-31'),('2014-09-01'),('2014-09-02'),('2014-09-03'),('2014-09-04'),('2014-09-05'),('2014-09-06'),('2014-09-07'),('2014-09-08'),('2014-09-09'),('2014-09-10'),('2014-09-11'),('2014-09-12'),('2014-09-13'),('2014-09-14'),('2014-09-15'),('2014-09-16'),('2014-09-17'),('2014-09-18'),('2014-09-19'),('2014-09-20'),('2014-09-21'),('2014-09-22'),('2014-09-23'),('2014-09-24'),('2014-09-25'),('2014-09-26'),('2014-09-27'),('2014-09-28'),('2014-09-29'),('2014-09-30'),('2014-10-01'),('2014-10-02'),('2014-10-03'),('2014-10-04'),('2014-10-05'),('2014-10-06'),('2014-10-07'),('2014-10-08'),('2014-10-09'),('2014-10-10'),('2014-10-11'),('2014-10-12'),('2014-10-13'),('2014-10-14'),('2014-10-15'),('2014-10-16'),('2014-10-17'),('2014-10-18'),('2014-10-19'),('2014-10-20'),('2014-10-21'),('2014-10-22'),('2014-10-23'),('2014-10-24'),('2014-10-25'),('2014-10-26'),('2014-10-27'),('2014-10-28'),('2014-10-29'),('2014-10-30'),('2014-10-31'),('2014-11-01'),('2014-11-02'),('2014-11-03'),('2014-11-04'),('2014-11-05'),('2014-11-06'),('2014-11-07'),('2014-11-08'),('2014-11-09'),('2014-11-10'),('2014-11-11'),('2014-11-12'),('2014-11-13'),('2014-11-14'),('2014-11-15'),('2014-11-16'),('2014-11-17'),('2014-11-18'),('2014-11-19'),('2014-11-20'),('2014-11-21'),('2014-11-22'),('2014-11-23'),('2014-11-24'),('2014-11-25'),('2014-11-26'),('2014-11-27'),('2014-11-28'),('2014-11-29'),('2014-11-30'),('2014-12-01'),('2014-12-02'),('2014-12-03'),('2014-12-04'),('2014-12-05'),('2014-12-06'),('2014-12-07'),('2014-12-08'),('2014-12-09'),('2014-12-10'),('2014-12-11'),('2014-12-12'),('2014-12-13'),('2014-12-14'),('2014-12-15'),('2014-12-16'),('2014-12-17'),('2014-12-18'),('2014-12-19'),('2014-12-20'),('2014-12-21'),('2014-12-22'),('2014-12-23'),('2014-12-24'),('2014-12-25'),('2014-12-26'),('2014-12-27'),('2014-12-28'),('2014-12-29'),('2014-12-30'),('2014-12-31'),('2015-01-01'),('2015-01-02'),('2015-01-03'),('2015-01-04'),('2015-01-05'),('2015-01-06'),('2015-01-07'),('2015-01-08'),('2015-01-09'),('2015-01-10'),('2015-01-11'),('2015-01-12'),('2015-01-13'),('2015-01-14'),('2015-01-15'),('2015-01-16'),('2015-01-17'),('2015-01-18'),('2015-01-19'),('2015-01-20'),('2015-01-21'),('2015-01-22'),('2015-01-23'),('2015-01-24'),('2015-01-25'),('2015-01-26'),('2015-01-27'),('2015-01-28'),('2015-01-29'),('2015-01-30'),('2015-01-31'),('2015-02-01'),('2015-02-02'),('2015-02-03'),('2015-02-04'),('2015-02-05'),('2015-02-06'),('2015-02-07'),('2015-02-08'),('2015-02-09'),('2015-02-10'),('2015-02-11'),('2015-02-12'),('2015-02-13'),('2015-02-14'),('2015-02-15'),('2015-02-16'),('2015-02-17'),('2015-02-18'),('2015-02-19'),('2015-02-20'),('2015-02-21'),('2015-02-22'),('2015-02-23'),('2015-02-24'),('2015-02-25'),('2015-02-26'),('2015-02-27'),('2015-02-28'),('2015-03-01'),('2015-03-02'),('2015-03-03'),('2015-03-04'),('2015-03-05'),('2015-03-06'),('2015-03-07'),('2015-03-08'),('2015-03-09'),('2015-03-10'),('2015-03-11'),('2015-03-12'),('2015-03-13'),('2015-03-14'),('2015-03-15'),('2015-03-16'),('2015-03-17'),('2015-03-18'),('2015-03-19'),('2015-03-20'),('2015-03-21'),('2015-03-22'),('2015-03-23'),('2015-03-24'),('2015-03-25'),('2015-03-26'),('2015-03-27'),('2015-03-28'),('2015-03-29'),('2015-03-30'),('2015-03-31'),('2015-04-01'),('2015-04-02'),('2015-04-03'),('2015-04-04'),('2015-04-05'),('2015-04-06'),('2015-04-07'),('2015-04-08'),('2015-04-09'),('2015-04-10'),('2015-04-11'),('2015-04-12'),('2015-04-13'),('2015-04-14'),('2015-04-15'),('2015-04-16'),('2015-04-17'),('2015-04-18'),('2015-04-19'),('2015-04-20'),('2015-04-21'),('2015-04-22'),('2015-04-23'),('2015-04-24'),('2015-04-25'),('2015-04-26'),('2015-04-27'),('2015-04-28'),('2015-04-29'),('2015-04-30'),('2015-05-01'),('2015-05-02'),('2015-05-03'),('2015-05-04'),('2015-05-05'),('2015-05-06'),('2015-05-07'),('2015-05-08'),('2015-05-09'),('2015-05-10'),('2015-05-11'),('2015-05-12'),('2015-05-13'),('2015-05-14'),('2015-05-15'),('2015-05-16'),('2015-05-17'),('2015-05-18'),('2015-05-19'),('2015-05-20'),('2015-05-21'),('2015-05-22'),('2015-05-23'),('2015-05-24'),('2015-05-25'),('2015-05-26'),('2015-05-27'),('2015-05-28'),('2015-05-29'),('2015-05-30'),('2015-05-31'),('2015-06-01'),('2015-06-02'),('2015-06-03'),('2015-06-04'),('2015-06-05'),('2015-06-06'),('2015-06-07'),('2015-06-08'),('2015-06-09'),('2015-06-10'),('2015-06-11'),('2015-06-12'),('2015-06-13'),('2015-06-14'),('2015-06-15'),('2015-06-16'),('2015-06-17'),('2015-06-18'),('2015-06-19'),('2015-06-20'),('2015-06-21'),('2015-06-22'),('2015-06-23'),('2015-06-24'),('2015-06-25'),('2015-06-26'),('2015-06-27'),('2015-06-28'),('2015-06-29'),('2015-06-30'),('2015-07-01'),('2015-07-02'),('2015-07-03'),('2015-07-04'),('2015-07-05'),('2015-07-06'),('2015-07-07'),('2015-07-08'),('2015-07-09'),('2015-07-10'),('2015-07-11'),('2015-07-12'),('2015-07-13'),('2015-07-14'),('2015-07-15'),('2015-07-16'),('2015-07-17'),('2015-07-18'),('2015-07-19'),('2015-07-20'),('2015-07-21'),('2015-07-22'),('2015-07-23'),('2015-07-24'),('2015-07-25'),('2015-07-26'),('2015-07-27'),('2015-07-28'),('2015-07-29'),('2015-07-30'),('2015-07-31'),('2015-08-01'),('2015-08-02'),('2015-08-03'),('2015-08-04'),('2015-08-05'),('2015-08-06'),('2015-08-07'),('2015-08-08'),('2015-08-09'),('2015-08-10'),('2015-08-11'),('2015-08-12'),('2015-08-13'),('2015-08-14'),('2015-08-15'),('2015-08-16'),('2015-08-17'),('2015-08-18'),('2015-08-19'),('2015-08-20'),('2015-08-21'),('2015-08-22'),('2015-08-23'),('2015-08-24'),('2015-08-25'),('2015-08-26'),('2015-08-27'),('2015-08-28'),('2015-08-29'),('2015-08-30'),('2015-08-31'),('2015-09-01'),('2015-09-02'),('2015-09-03'),('2015-09-04'),('2015-09-05'),('2015-09-06'),('2015-09-07'),('2015-09-08'),('2015-09-09'),('2015-09-10'),('2015-09-11'),('2015-09-12'),('2015-09-13'),('2015-09-14'),('2015-09-15'),('2015-09-16'),('2015-09-17'),('2015-09-18'),('2015-09-19'),('2015-09-20'),('2015-09-21'),('2015-09-22'),('2015-09-23'),('2015-09-24'),('2015-09-25'),('2015-09-26'),('2015-09-27'),('2015-09-28'),('2015-09-29'),('2015-09-30'),('2015-10-01'),('2015-10-02'),('2015-10-03'),('2015-10-04'),('2015-10-05'),('2015-10-06'),('2015-10-07'),('2015-10-08'),('2015-10-09'),('2015-10-10'),('2015-10-11'),('2015-10-12'),('2015-10-13'),('2015-10-14'),('2015-10-15'),('2015-10-16'),('2015-10-17'),('2015-10-18'),('2015-10-19'),('2015-10-20'),('2015-10-21'),('2015-10-22'),('2015-10-23'),('2015-10-24'),('2015-10-25'),('2015-10-26'),('2015-10-27'),('2015-10-28'),('2015-10-29'),('2015-10-30'),('2015-10-31'),('2015-11-01'),('2015-11-02'),('2015-11-03'),('2015-11-04'),('2015-11-05'),('2015-11-06'),('2015-11-07'),('2015-11-08'),('2015-11-09'),('2015-11-10'),('2015-11-11'),('2015-11-12'),('2015-11-13'),('2015-11-14'),('2015-11-15'),('2015-11-16'),('2015-11-17'),('2015-11-18'),('2015-11-19'),('2015-11-20'),('2015-11-21'),('2015-11-22'),('2015-11-23'),('2015-11-24'),('2015-11-25'),('2015-11-26'),('2015-11-27'),('2015-11-28'),('2015-11-29'),('2015-11-30'),('2015-12-01'),('2015-12-02'),('2015-12-03'),('2015-12-04'),('2015-12-05'),('2015-12-06'),('2015-12-07'),('2015-12-08'),('2015-12-09'),('2015-12-10'),('2015-12-11'),('2015-12-12'),('2015-12-13'),('2015-12-14'),('2015-12-15'),('2015-12-16'),('2015-12-17'),('2015-12-18'),('2015-12-19'),('2015-12-20'),('2015-12-21'),('2015-12-22'),('2015-12-23'),('2015-12-24'),('2015-12-25'),('2015-12-26'),('2015-12-27'),('2015-12-28'),('2015-12-29'),('2015-12-30'),('2015-12-31'),('2016-01-01'),('2016-01-02'),('2016-01-03'),('2016-01-04'),('2016-01-05'),('2016-01-06'),('2016-01-07'),('2016-01-08'),('2016-01-09'),('2016-01-10'),('2016-01-11'),('2016-01-12'),('2016-01-13'),('2016-01-14'),('2016-01-15'),('2016-01-16'),('2016-01-17'),('2016-01-18'),('2016-01-19'),('2016-01-20'),('2016-01-21'),('2016-01-22'),('2016-01-23'),('2016-01-24'),('2016-01-25'),('2016-01-26'),('2016-01-27'),('2016-01-28'),('2016-01-29'),('2016-01-30'),('2016-01-31'),('2016-02-01'),('2016-02-02'),('2016-02-03'),('2016-02-04'),('2016-02-05'),('2016-02-06'),('2016-02-07'),('2016-02-08'),('2016-02-09'),('2016-02-10'),('2016-02-11'),('2016-02-12'),('2016-02-13'),('2016-02-14'),('2016-02-15'),('2016-02-16'),('2016-02-17'),('2016-02-18'),('2016-02-19'),('2016-02-20'),('2016-02-21'),('2016-02-22'),('2016-02-23'),('2016-02-24'),('2016-02-25'),('2016-02-26'),('2016-02-27'),('2016-02-28'),('2016-02-29'),('2016-03-01'),('2016-03-02'),('2016-03-03'),('2016-03-04'),('2016-03-05'),('2016-03-06'),('2016-03-07'),('2016-03-08'),('2016-03-09'),('2016-03-10'),('2016-03-11'),('2016-03-12'),('2016-03-13'),('2016-03-14'),('2016-03-15'),('2016-03-16'),('2016-03-17'),('2016-03-18'),('2016-03-19'),('2016-03-20'),('2016-03-21'),('2016-03-22'),('2016-03-23'),('2016-03-24'),('2016-03-25'),('2016-03-26'),('2016-03-27'),('2016-03-28'),('2016-03-29'),('2016-03-30'),('2016-03-31'),('2016-04-01'),('2016-04-02'),('2016-04-03'),('2016-04-04'),('2016-04-05'),('2016-04-06'),('2016-04-07'),('2016-04-08'),('2016-04-09'),('2016-04-10'),('2016-04-11'),('2016-04-12'),('2016-04-13'),('2016-04-14'),('2016-04-15'),('2016-04-16'),('2016-04-17'),('2016-04-18'),('2016-04-19'),('2016-04-20'),('2016-04-21'),('2016-04-22'),('2016-04-23'),('2016-04-24'),('2016-04-25'),('2016-04-26'),('2016-04-27'),('2016-04-28'),('2016-04-29'),('2016-04-30'),('2016-05-01'),('2016-05-02'),('2016-05-03'),('2016-05-04'),('2016-05-05'),('2016-05-06'),('2016-05-07'),('2016-05-08'),('2016-05-09'),('2016-05-10'),('2016-05-11'),('2016-05-12'),('2016-05-13'),('2016-05-14'),('2016-05-15'),('2016-05-16'),('2016-05-17'),('2016-05-18'),('2016-05-19'),('2016-05-20'),('2016-05-21'),('2016-05-22'),('2016-05-23'),('2016-05-24'),('2016-05-25'),('2016-05-26'),('2016-05-27'),('2016-05-28'),('2016-05-29'),('2016-05-30'),('2016-05-31'),('2016-06-01'),('2016-06-02'),('2016-06-03'),('2016-06-04'),('2016-06-05'),('2016-06-06'),('2016-06-07'),('2016-06-08'),('2016-06-09'),('2016-06-10'),('2016-06-11'),('2016-06-12'),('2016-06-13'),('2016-06-14'),('2016-06-15'),('2016-06-16'),('2016-06-17'),('2016-06-18'),('2016-06-19'),('2016-06-20'),('2016-06-21'),('2016-06-22'),('2016-06-23'),('2016-06-24'),('2016-06-25'),('2016-06-26'),('2016-06-27'),('2016-06-28'),('2016-06-29'),('2016-06-30'),('2016-07-01'),('2016-07-02'),('2016-07-03'),('2016-07-04'),('2016-07-05'),('2016-07-06'),('2016-07-07'),('2016-07-08'),('2016-07-09'),('2016-07-10'),('2016-07-11'),('2016-07-12'),('2016-07-13'),('2016-07-14'),('2016-07-15'),('2016-07-16'),('2016-07-17'),('2016-07-18'),('2016-07-19'),('2016-07-20'),('2016-07-21'),('2016-07-22'),('2016-07-23'),('2016-07-24'),('2016-07-25'),('2016-07-26'),('2016-07-27'),('2016-07-28'),('2016-07-29'),('2016-07-30'),('2016-07-31'),('2016-08-01'),('2016-08-02'),('2016-08-03'),('2016-08-04'),('2016-08-05'),('2016-08-06'),('2016-08-07'),('2016-08-08'),('2016-08-09'),('2016-08-10'),('2016-08-11'),('2016-08-12'),('2016-08-13'),('2016-08-14'),('2016-08-15'),('2016-08-16'),('2016-08-17'),('2016-08-18'),('2016-08-19'),('2016-08-20'),('2016-08-21'),('2016-08-22'),('2016-08-23'),('2016-08-24'),('2016-08-25'),('2016-08-26'),('2016-08-27'),('2016-08-28'),('2016-08-29'),('2016-08-30'),('2016-08-31'),('2016-09-01'),('2016-09-02'),('2016-09-03'),('2016-09-04'),('2016-09-05'),('2016-09-06'),('2016-09-07'),('2016-09-08'),('2016-09-09'),('2016-09-10'),('2016-09-11'),('2016-09-12'),('2016-09-13'),('2016-09-14'),('2016-09-15'),('2016-09-16'),('2016-09-17'),('2016-09-18'),('2016-09-19'),('2016-09-20'),('2016-09-21'),('2016-09-22'),('2016-09-23'),('2016-09-24'),('2016-09-25'),('2016-09-26'),('2016-09-27'),('2016-09-28'),('2016-09-29'),('2016-09-30'),('2016-10-01'),('2016-10-02'),('2016-10-03'),('2016-10-04'),('2016-10-05'),('2016-10-06'),('2016-10-07'),('2016-10-08'),('2016-10-09'),('2016-10-10'),('2016-10-11'),('2016-10-12'),('2016-10-13'),('2016-10-14'),('2016-10-15'),('2016-10-16'),('2016-10-17'),('2016-10-18'),('2016-10-19'),('2016-10-20'),('2016-10-21'),('2016-10-22'),('2016-10-23'),('2016-10-24'),('2016-10-25'),('2016-10-26'),('2016-10-27'),('2016-10-28'),('2016-10-29'),('2016-10-30'),('2016-10-31'),('2016-11-01'),('2016-11-02'),('2016-11-03'),('2016-11-04'),('2016-11-05'),('2016-11-06'),('2016-11-07'),('2016-11-08'),('2016-11-09'),('2016-11-10'),('2016-11-11'),('2016-11-12'),('2016-11-13'),('2016-11-14'),('2016-11-15'),('2016-11-16'),('2016-11-17'),('2016-11-18'),('2016-11-19'),('2016-11-20'),('2016-11-21'),('2016-11-22'),('2016-11-23'),('2016-11-24'),('2016-11-25'),('2016-11-26'),('2016-11-27'),('2016-11-28'),('2016-11-29'),('2016-11-30'),('2016-12-01'),('2016-12-02'),('2016-12-03'),('2016-12-04'),('2016-12-05'),('2016-12-06'),('2016-12-07'),('2016-12-08'),('2016-12-09'),('2016-12-10'),('2016-12-11'),('2016-12-12'),('2016-12-13'),('2016-12-14'),('2016-12-15'),('2016-12-16'),('2016-12-17'),('2016-12-18'),('2016-12-19'),('2016-12-20'),('2016-12-21'),('2016-12-22'),('2016-12-23'),('2016-12-24'),('2016-12-25'),('2016-12-26'),('2016-12-27'),('2016-12-28'),('2016-12-29'),('2016-12-30'),('2016-12-31'),('2017-01-01'),('2017-01-02'),('2017-01-03'),('2017-01-04'),('2017-01-05'),('2017-01-06'),('2017-01-07'),('2017-01-08'),('2017-01-09'),('2017-01-10'),('2017-01-11'),('2017-01-12'),('2017-01-13'),('2017-01-14'),('2017-01-15'),('2017-01-16'),('2017-01-17'),('2017-01-18'),('2017-01-19'),('2017-01-20'),('2017-01-21'),('2017-01-22'),('2017-01-23'),('2017-01-24'),('2017-01-25'),('2017-01-26'),('2017-01-27'),('2017-01-28'),('2017-01-29'),('2017-01-30'),('2017-01-31'),('2017-02-01'),('2017-02-02'),('2017-02-03'),('2017-02-04'),('2017-02-05'),('2017-02-06'),('2017-02-07'),('2017-02-08'),('2017-02-09'),('2017-02-10'),('2017-02-11'),('2017-02-12'),('2017-02-13'),('2017-02-14'),('2017-02-15'),('2017-02-16'),('2017-02-17'),('2017-02-18'),('2017-02-19'),('2017-02-20'),('2017-02-21'),('2017-02-22'),('2017-02-23'),('2017-02-24'),('2017-02-25'),('2017-02-26'),('2017-02-27'),('2017-02-28'),('2017-03-01'),('2017-03-02'),('2017-03-03'),('2017-03-04'),('2017-03-05'),('2017-03-06'),('2017-03-07'),('2017-03-08'),('2017-03-09'),('2017-03-10'),('2017-03-11'),('2017-03-12'),('2017-03-13'),('2017-03-14'),('2017-03-15'),('2017-03-16'),('2017-03-17'),('2017-03-18'),('2017-03-19'),('2017-03-20'),('2017-03-21'),('2017-03-22'),('2017-03-23'),('2017-03-24'),('2017-03-25'),('2017-03-26'),('2017-03-27'),('2017-03-28'),('2017-03-29'),('2017-03-30'),('2017-03-31'),('2017-04-01'),('2017-04-02'),('2017-04-03'),('2017-04-04'),('2017-04-05'),('2017-04-06'),('2017-04-07'),('2017-04-08'),('2017-04-09'),('2017-04-10'),('2017-04-11'),('2017-04-12'),('2017-04-13'),('2017-04-14'),('2017-04-15'),('2017-04-16'),('2017-04-17'),('2017-04-18'),('2017-04-19'),('2017-04-20'),('2017-04-21'),('2017-04-22'),('2017-04-23'),('2017-04-24'),('2017-04-25'),('2017-04-26'),('2017-04-27'),('2017-04-28'),('2017-04-29'),('2017-04-30'),('2017-05-01'),('2017-05-02'),('2017-05-03'),('2017-05-04'),('2017-05-05'),('2017-05-06'),('2017-05-07'),('2017-05-08'),('2017-05-09'),('2017-05-10'),('2017-05-11'),('2017-05-12'),('2017-05-13'),('2017-05-14'),('2017-05-15'),('2017-05-16'),('2017-05-17'),('2017-05-18'),('2017-05-19'),('2017-05-20'),('2017-05-21'),('2017-05-22'),('2017-05-23'),('2017-05-24'),('2017-05-25'),('2017-05-26'),('2017-05-27'),('2017-05-28'),('2017-05-29'),('2017-05-30'),('2017-05-31'),('2017-06-01'),('2017-06-02'),('2017-06-03'),('2017-06-04'),('2017-06-05'),('2017-06-06'),('2017-06-07'),('2017-06-08'),('2017-06-09'),('2017-06-10'),('2017-06-11'),('2017-06-12'),('2017-06-13'),('2017-06-14'),('2017-06-15'),('2017-06-16'),('2017-06-17'),('2017-06-18'),('2017-06-19'),('2017-06-20'),('2017-06-21'),('2017-06-22'),('2017-06-23'),('2017-06-24'),('2017-06-25'),('2017-06-26'),('2017-06-27'),('2017-06-28'),('2017-06-29'),('2017-06-30'),('2017-07-01'),('2017-07-02'),('2017-07-03'),('2017-07-04'),('2017-07-05'),('2017-07-06'),('2017-07-07'),('2017-07-08'),('2017-07-09'),('2017-07-10'),('2017-07-11'),('2017-07-12'),('2017-07-13'),('2017-07-14'),('2017-07-15'),('2017-07-16'),('2017-07-17'),('2017-07-18'),('2017-07-19'),('2017-07-20'),('2017-07-21'),('2017-07-22'),('2017-07-23'),('2017-07-24'),('2017-07-25'),('2017-07-26'),('2017-07-27'),('2017-07-28'),('2017-07-29'),('2017-07-30'),('2017-07-31'),('2017-08-01'),('2017-08-02'),('2017-08-03'),('2017-08-04'),('2017-08-05'),('2017-08-06'),('2017-08-07'),('2017-08-08'),('2017-08-09'),('2017-08-10'),('2017-08-11'),('2017-08-12'),('2017-08-13'),('2017-08-14'),('2017-08-15'),('2017-08-16'),('2017-08-17'),('2017-08-18'),('2017-08-19'),('2017-08-20'),('2017-08-21'),('2017-08-22'),('2017-08-23'),('2017-08-24'),('2017-08-25'),('2017-08-26'),('2017-08-27'),('2017-08-28'),('2017-08-29'),('2017-08-30'),('2017-08-31'),('2017-09-01'),('2017-09-02'),('2017-09-03'),('2017-09-04'),('2017-09-05'),('2017-09-06'),('2017-09-07'),('2017-09-08'),('2017-09-09'),('2017-09-10'),('2017-09-11'),('2017-09-12'),('2017-09-13'),('2017-09-14'),('2017-09-15'),('2017-09-16'),('2017-09-17'),('2017-09-18'),('2017-09-19'),('2017-09-20'),('2017-09-21'),('2017-09-22'),('2017-09-23'),('2017-09-24'),('2017-09-25'),('2017-09-26'),('2017-09-27'),('2017-09-28'),('2017-09-29'),('2017-09-30'),('2017-10-01'),('2017-10-02'),('2017-10-03'),('2017-10-04'),('2017-10-05'),('2017-10-06'),('2017-10-07'),('2017-10-08'),('2017-10-09'),('2017-10-10'),('2017-10-11'),('2017-10-12'),('2017-10-13'),('2017-10-14'),('2017-10-15'),('2017-10-16'),('2017-10-17'),('2017-10-18'),('2017-10-19'),('2017-10-20'),('2017-10-21'),('2017-10-22'),('2017-10-23'),('2017-10-24'),('2017-10-25'),('2017-10-26'),('2017-10-27'),('2017-10-28'),('2017-10-29'),('2017-10-30'),('2017-10-31'),('2017-11-01'),('2017-11-02'),('2017-11-03'),('2017-11-04'),('2017-11-05'),('2017-11-06'),('2017-11-07'),('2017-11-08'),('2017-11-09'),('2017-11-10'),('2017-11-11'),('2017-11-12'),('2017-11-13'),('2017-11-14'),('2017-11-15'),('2017-11-16'),('2017-11-17'),('2017-11-18'),('2017-11-19'),('2017-11-20'),('2017-11-21'),('2017-11-22'),('2017-11-23'),('2017-11-24'),('2017-11-25'),('2017-11-26'),('2017-11-27'),('2017-11-28'),('2017-11-29'),('2017-11-30'),('2017-12-01'),('2017-12-02'),('2017-12-03'),('2017-12-04'),('2017-12-05'),('2017-12-06'),('2017-12-07'),('2017-12-08'),('2017-12-09'),('2017-12-10'),('2017-12-11'),('2017-12-12'),('2017-12-13'),('2017-12-14'),('2017-12-15'),('2017-12-16'),('2017-12-17'),('2017-12-18'),('2017-12-19'),('2017-12-20'),('2017-12-21'),('2017-12-22'),('2017-12-23'),('2017-12-24'),('2017-12-25'),('2017-12-26'),('2017-12-27'),('2017-12-28'),('2017-12-29'),('2017-12-30'),('2017-12-31');
            		 
             
            		 
            DROP TABLE IF EXISTS `mitarbeiter`;
            		 
            CREATE TABLE `mitarbeiter` (
            		 
              `pk` int(11) NOT NULL DEFAULT 0,
            		 
              `in_aw_liste` int(1) DEFAULT 1,
            		 
              `deaktiviert` int(1) NOT NULL DEFAULT 0
            		 
            ) DEFAULT CHARSET=utf8;
            		 
             
            		 
            INSERT INTO `mitarbeiter` VALUES (1,1,0),(2,1,0),(3,1,0),(4,1,1),(5,1,0),(6,1,1),(7,1,0),(10,0,0),(11,0,0),(12,1,0),(13,0,1),(14,0,1),(16,1,0),(17,0,1),(19,1,1),(20,0,1),(21,1,1),(22,1,0),(23,0,0),(26,1,0),(27,1,1),(28,1,0),(29,1,0),(30,1,1),(31,1,0),(32,0,1),(33,1,0),(34,1,0),(36,1,1),(37,1,0),(38,1,1),(39,1,1),(41,1,0),(43,1,0),(44,1,0),(45,1,0),(46,1,0),(47,1,0),(49,1,0),(50,1,0),(51,1,0),(52,1,0),(53,1,0),(54,0,1),(55,0,1),(56,1,1),(57,1,0),(58,1,1),(59,1,1),(60,1,1),(61,1,0),(63,0,0),(65,1,1),(66,1,1),(68,1,0),(72,1,1),(73,1,0),(74,1,0),(76,1,1),(77,1,1),(78,1,1),(79,1,1),(80,1,0),(81,1,1),(82,1,1),(83,1,0),(84,1,0),(85,0,1),(87,1,0),(88,1,1),(89,1,1),(90,1,1),(91,1,0),(92,1,0),(93,1,1),(94,1,0),(95,1,0),(96,1,0),(98,1,1),(99,1,0),(101,1,0),(102,1,1),(103,1,0),(104,1,1),(105,0,1),(106,1,1),(107,0,1),(108,1,0),(109,1,0),(110,1,0),(111,1,0),(112,1,1),(113,1,0),(114,1,1),(115,1,0),(116,1,0),(117,1,1),(118,1,0),(119,1,0),(120,1,0),(122,1,0),(123,1,1),(200,1,1),(5003,1,1),(5005,1,1),(5008,1,1),(5010,1,1),(5011,1,1),(5012,0,1),(5014,1,1),(5015,1,1),(5017,1,1),(5018,1,1),(5019,1,1),(5020,1,1),(5021,1,1),(5022,1,1),(5023,1,1),(5024,1,1),(5026,1,1),(5027,1,1),(5028,1,1),(5029,1,1),(5030,1,1),(5031,1,1),(5032,1,1),(5033,1,1),(5034,1,1),(5036,1,1),(100001,0,1),(100002,0,0),(100003,1,1),(100004,1,1),(100005,1,0),(100006,1,1),(100007,0,1),(100008,1,1),(100009,1,1),(100010,1,1),(100011,1,1),(100012,1,1),(100013,1,0),(100014,1,1),(100015,0,0),(100016,1,1),(100017,1,1),(100018,1,1),(100019,1,1),(100020,1,1),(100021,1,1),(100022,1,0),(100023,1,1),(100024,1,1),(100025,1,1),(100026,1,0),(100027,1,1),(100028,1,0),(100029,0,1),(100030,1,1),(100031,1,1),(100032,1,1),(100033,1,1),(100035,1,1),(100036,1,1),(100037,1,1),(100038,1,1),(100039,1,1),(100040,0,1),(100041,1,1),(100042,1,1),(100049,1,1),(100050,1,1),(100051,1,1),(100052,1,0),(100053,1,1),(100054,1,0),(100055,1,1),(100056,1,0),(100057,1,1),(100058,1,1),(100059,1,1),(100060,1,1),(100061,1,1),(100062,1,1),(100063,1,0),(100064,1,1),(100065,1,0),(100066,1,1),(100067,1,1),(100068,1,0),(100069,1,1),(100070,1,1),(100071,1,1),(100072,1,1),(100073,1,1),(100074,1,1),(100075,1,1),(100076,1,1),(100077,1,0),(100078,1,1),(100079,1,1),(100080,1,1),(100081,1,1),(100082,1,1),(100083,1,0),(100084,1,0),(100085,0,1),(100086,1,1),(100087,1,1),(100088,1,1),(100089,1,0),(100090,1,1),(100091,1,1),(100092,1,1),(100093,1,1),(100094,1,0),(100095,0,1),(100096,0,1),(100097,0,1),(100098,0,1),(100099,0,1),(100100,0,1),(100101,1,1),(100102,1,0),(100103,1,1),(100104,1,1),(100105,0,1),(100106,0,1),(100107,0,1),(100108,0,1),(100109,0,1),(100110,0,1),(100111,0,1),(100112,0,1),(100113,0,1),(100114,0,1),(100115,0,1),(100116,0,1),(100117,0,1),(100118,0,1),(100119,0,1),(100120,0,1),(100121,1,1),(100122,1,1),(100123,1,1),(100124,1,0),(100125,1,0),(100126,1,1),(100127,0,1),(100128,0,1),(100129,0,1),(100131,1,1),(100132,1,0),(100133,1,0),(100134,1,1),(100135,1,1),(100136,0,0),(100137,0,1),(100138,0,1),(100139,0,1),(100140,0,1),(100141,0,1),(100142,0,1),(100143,0,1),(100144,0,1),(100145,1,1),(100146,1,0),(100147,1,0),(100148,0,1),(100149,0,1),(100150,1,1),(100151,0,1),(100152,0,1),(100153,1,1),(100154,0,1),(100155,0,1),(100156,0,1),(100157,0,1),(100158,0,1),(100159,1,0),(100160,1,0),(100161,1,0),(100162,1,1),(100163,1,1),(100164,1,0),(100165,0,0),(100166,1,1),(100167,0,1),(100168,1,1),(100169,1,1),(100170,1,1),(100171,1,1),(100172,1,1),(100173,0,0),(100174,1,1),(100175,0,1),(100176,1,1),(100177,0,1),(100178,0,1),(100179,1,1),(100180,0,0),(100181,1,1),(100182,1,1),(100183,1,0),(100184,0,1),(100185,0,1),(100186,1,1),(100187,1,1),(100188,1,1),(100189,1,1),(100190,1,0),(100191,1,1),(100192,1,1),(100193,1,1),(100194,1,0),(100195,1,0),(100196,1,1),(100197,1,1),(100198,1,0),(100199,1,0),(100200,1,1),(100201,1,1),(100202,1,1),(100203,1,1),(100204,1,1),(100205,1,0),(100206,1,1),(100207,1,1),(100208,1,0),(100209,1,1),(100210,0,1),(100211,1,1),(100212,1,1),(100213,0,1),(100214,1,1),(100215,1,1),(100216,1,0),(100217,1,1),(100218,1,0),(100219,0,1),(100220,1,0),(100221,1,1),(100222,1,1),(100223,1,1),(100224,1,1),(100225,1,1),(100226,1,0),(100227,1,1),(100228,1,1),(100229,1,1),(100230,1,1),(100231,1,1),(100232,1,1),(100233,1,1),(100234,1,1),(100235,1,1),(100236,1,1),(100237,1,1),(100238,1,1),(100239,1,1),(100240,1,1),(100241,1,1),(100242,1,1),(100243,1,1),(100244,1,0),(100245,1,1),(100246,1,0),(100247,1,0),(100248,1,0),(100249,1,0),(100250,1,0),(100251,1,1),(100252,1,1),(100253,1,1),(100254,1,1),(100255,1,0),(100256,1,1),(100257,1,1),(100258,1,0),(100259,1,1),(100260,1,0),(100261,1,1),(100262,1,1),(100263,1,1),(100264,1,1),(100265,1,0),(100266,1,1),(100267,1,1),(100268,1,0),(100269,1,0),(100270,1,0),(100271,1,0),(100272,1,0),(100273,1,0),(100274,1,0),(100275,1,0),(100276,1,0),(100277,1,1),(100278,1,1),(100279,1,0),(100280,1,0),(100281,0,1),(100282,1,0),(100283,1,1),(100284,1,1),(100285,1,1),(100286,1,0),(100287,1,1),(100288,1,0),(100289,1,0),(100290,1,1),(100291,1,0),(100292,1,1),(100293,1,1),(100294,1,0),(100295,1,0),(100296,1,0),(100297,1,1),(100298,1,1),(100299,1,1),(100300,1,1),(100301,1,0),(100302,1,1),(100303,1,1),(100304,1,0),(100305,1,0),(100306,1,0),(100307,1,1),(100308,1,0),(100309,1,0),(100310,1,0),(100311,1,0),(100312,1,0),(100313,1,0),(100314,1,1),(100315,1,0),(100316,1,1),(100317,1,0),(100318,1,0),(100319,1,0),(100320,1,1),(100321,1,0),(100322,1,0),(100323,1,1),(100324,1,0),(100325,1,0),(100326,1,1),(100327,1,0),(100328,1,1),(100329,1,1),(100330,1,1),(100331,1,0),(100332,1,0),(100333,1,0),(100334,1,0),(100335,1,0),(100336,1,0),(100337,1,0),(100338,1,0),(100339,1,0),(100340,1,0),(100341,1,1),(100342,1,1),(100344,1,1),(100347,1,1),(100350,1,0),(100355,1,0),(100358,1,0),(100361,1,0),(100364,1,1),(100367,1,1),(100370,1,1),(100373,1,1),(100376,1,1),(100379,1,1),(100382,1,0),(100385,1,1),(100388,1,1),(100391,1,1),(100394,1,0),(100397,1,0),(100400,1,1),(100401,1,1),(100404,1,0),(100407,1,0),(100410,1,0),(100413,1,0),(100416,1,0),(100419,1,0),(100422,1,0),(100425,1,0),(100428,1,1),(100431,1,1),(100434,1,1),(100437,1,0),(100440,1,0),(100443,1,0),(100446,1,0),(100449,1,0),(100452,1,0),(100455,1,1),(100458,1,0),(100461,1,0),(100464,1,1),(100465,1,0),(100466,1,0),(100469,1,1),(100472,1,1),(100475,1,0),(100478,1,0),(100481,1,0),(100484,1,1),(100487,1,0),(100490,1,1),(100493,1,0),(100496,1,0),(100499,1,0),(100502,1,0),(100505,1,1),(100508,1,1),(100512,1,0),(100513,1,1),(100517,0,1),(100520,0,1),(100521,1,0),(100524,1,0),(100527,1,0),(100530,1,0),(100534,1,0),(100540,1,1),(100547,1,1),(100552,1,1),(100560,1,0),(100568,1,0),(100576,0,1),(100584,0,1),(100591,0,0),(100599,0,1),(100603,0,1),(100607,0,1),(100615,1,0),(100623,1,0),(100627,1,0),(100635,1,1),(100643,1,1),(100651,1,0),(100659,1,0),(100667,1,0),(100671,1,0),(100679,1,0),(100687,1,1),(100695,1,0),(100699,1,1),(100707,1,0),(100715,0,0),(100719,0,1),(100727,0,1),(100735,0,1),(100739,0,0),(100743,1,0),(100751,1,0),(100759,1,0),(100764,0,0),(100770,1,0),(100775,1,0),(100783,0,0),(100791,1,0),(100799,1,0),(100803,1,0),(100811,1,0),(100815,1,0),(100823,1,0),(100831,1,0),(100839,1,0),(100841,1,0);
            		 
             
            		 
            select  distinct mar.deaktiviert, in_aw_liste from mitarbeiter mar  join  tage t where  t.datum >= '2017-04-01' and  mar.deaktiviert = 0 and in_aw_liste=1;
            		 
             
            		 
            DROP TABLE mitarbeiter, tage;

            elenst Elena Stepanova added a comment - - edited Thanks for the report and the data. The problem was introduced in 10.2 tree with this commit: commit 8d99166c697516ad9b4084c2bc10ba4acf8b9744 Author: Sergei Golubchik Date: Mon Feb 6 23:52:47 2017 +0100   MDEV-11640 gcol.gcol_select_myisam fails in buildbot on Power Test case (Expected 1 row, actual result 4 rows) SET join_buffer_size = 268435456;   DROP TABLE IF EXISTS `tage`; CREATE TABLE `tage` ( `datum` date NOT NULL , KEY `i_datum` (`datum`) ) DEFAULT CHARSET=utf8;   INSERT INTO `tage` VALUES ( '2007-01-01' ),( '2007-01-02' ),( '2007-01-03' ),( '2007-01-04' ),( '2007-01-05' ),( '2007-01-06' ),( '2007-01-07' ),( '2007-01-08' ),( '2007-01-09' ),( '2007-01-10' ),( '2007-01-11' ),( '2007-01-12' ),( '2007-01-13' ),( '2007-01-14' ),( '2007-01-15' ),( '2007-01-16' ),( '2007-01-17' ),( '2007-01-18' ),( '2007-01-19' ),( '2007-01-20' ),( '2007-01-21' ),( '2007-01-22' ),( '2007-01-23' ),( '2007-01-24' ),( '2007-01-25' ),( '2007-01-26' ),( '2007-01-27' ),( '2007-01-28' ),( '2007-01-29' ),( '2007-01-30' ),( '2007-01-31' ),( '2007-02-01' ),( '2007-02-02' ),( '2007-02-03' ),( '2007-02-04' ),( '2007-02-05' ),( '2007-02-06' ),( '2007-02-07' ),( '2007-02-08' ),( '2007-02-09' ),( '2007-02-10' ),( '2007-02-11' ),( '2007-02-12' ),( '2007-02-13' ),( '2007-02-14' ),( '2007-02-15' ),( '2007-02-16' ),( '2007-02-17' ),( '2007-02-18' ),( '2007-02-19' ),( '2007-02-20' ),( '2007-02-21' ),( '2007-02-22' ),( '2007-02-23' ),( '2007-02-24' ),( '2007-02-25' ),( '2007-02-26' ),( '2007-02-27' ),( '2007-02-28' ),( '2007-03-01' ),( '2007-03-02' ),( '2007-03-03' ),( '2007-03-04' ),( '2007-03-05' ),( '2007-03-06' ),( '2007-03-07' ),( '2007-03-08' ),( '2007-03-09' ),( '2007-03-10' ),( '2007-03-11' ),( '2007-03-12' ),( '2007-03-13' ),( '2007-03-14' ),( '2007-03-15' ),( '2007-03-16' ),( '2007-03-17' ),( '2007-03-18' ),( '2007-03-19' ),( '2007-03-20' ),( '2007-03-21' ),( '2007-03-22' ),( '2007-03-23' ),( '2007-03-24' ),( '2007-03-25' ),( '2007-03-26' ),( '2007-03-27' ),( '2007-03-28' ),( '2007-03-29' ),( '2007-03-30' ),( '2007-03-31' ),( '2007-04-01' ),( '2007-04-02' ),( '2007-04-03' ),( '2007-04-04' ),( '2007-04-05' ),( '2007-04-06' ),( '2007-04-07' ),( '2007-04-08' ),( '2007-04-09' ),( '2007-04-10' ),( '2007-04-11' ),( '2007-04-12' ),( '2007-04-13' ),( '2007-04-14' ),( '2007-04-15' ),( '2007-04-16' ),( '2007-04-17' ),( '2007-04-18' ),( '2007-04-19' ),( '2007-04-20' ),( '2007-04-21' ),( '2007-04-22' ),( '2007-04-23' ),( '2007-04-24' ),( '2007-04-25' ),( '2007-04-26' ),( '2007-04-27' ),( '2007-04-28' ),( '2007-04-29' ),( '2007-04-30' ),( '2007-05-01' ),( '2007-05-02' ),( '2007-05-03' ),( '2007-05-04' ),( '2007-05-05' ),( '2007-05-06' ),( '2007-05-07' ),( '2007-05-08' ),( '2007-05-09' ),( '2007-05-10' ),( '2007-05-11' ),( '2007-05-12' ),( '2007-05-13' ),( '2007-05-14' ),( '2007-05-15' ),( '2007-05-16' ),( '2007-05-17' ),( '2007-05-18' ),( '2007-05-19' ),( '2007-05-20' ),( '2007-05-21' ),( '2007-05-22' ),( '2007-05-23' ),( '2007-05-24' ),( '2007-05-25' ),( '2007-05-26' ),( '2007-05-27' ),( '2007-05-28' ),( '2007-05-29' ),( '2007-05-30' ),( '2007-05-31' ),( '2007-06-01' ),( '2007-06-02' ),( '2007-06-03' ),( '2007-06-04' ),( '2007-06-05' ),( '2007-06-06' ),( '2007-06-07' ),( '2007-06-08' ),( '2007-06-09' ),( '2007-06-10' ),( '2007-06-11' ),( '2007-06-12' ),( '2007-06-13' ),( '2007-06-14' ),( '2007-06-15' ),( '2007-06-16' ),( '2007-06-17' ),( '2007-06-18' ),( '2007-06-19' ),( '2007-06-20' ),( '2007-06-21' ),( '2007-06-22' ),( '2007-06-23' ),( '2007-06-24' ),( '2007-06-25' ),( '2007-06-26' ),( '2007-06-27' ),( '2007-06-28' ),( '2007-06-29' ),( '2007-06-30' ),( '2007-07-01' ),( '2007-07-02' ),( '2007-07-03' ),( '2007-07-04' ),( '2007-07-05' ),( '2007-07-06' ),( '2007-07-07' ),( '2007-07-08' ),( '2007-07-09' ),( '2007-07-10' ),( '2007-07-11' ),( '2007-07-12' ),( '2007-07-13' ),( '2007-07-14' ),( '2007-07-15' ),( '2007-07-16' ),( '2007-07-17' ),( '2007-07-18' ),( '2007-07-19' ),( '2007-07-20' ),( '2007-07-21' ),( '2007-07-22' ),( '2007-07-23' ),( '2007-07-24' ),( '2007-07-25' ),( '2007-07-26' ),( '2007-07-27' ),( '2007-07-28' ),( '2007-07-29' ),( '2007-07-30' ),( '2007-07-31' ),( '2007-08-01' ),( '2007-08-02' ),( '2007-08-03' ),( '2007-08-04' ),( '2007-08-05' ),( '2007-08-06' ),( '2007-08-07' ),( '2007-08-08' ),( '2007-08-09' ),( '2007-08-10' ),( '2007-08-11' ),( '2007-08-12' ),( '2007-08-13' ),( '2007-08-14' ),( '2007-08-15' ),( '2007-08-16' ),( '2007-08-17' ),( '2007-08-18' ),( '2007-08-19' ),( '2007-08-20' ),( '2007-08-21' ),( '2007-08-22' ),( '2007-08-23' ),( '2007-08-24' ),( '2007-08-25' ),( '2007-08-26' ),( '2007-08-27' ),( '2007-08-28' ),( '2007-08-29' ),( '2007-08-30' ),( '2007-08-31' ),( '2007-09-01' ),( '2007-09-02' ),( '2007-09-03' ),( '2007-09-04' ),( '2007-09-05' ),( '2007-09-06' ),( '2007-09-07' ),( '2007-09-08' ),( '2007-09-09' ),( '2007-09-10' ),( '2007-09-11' ),( '2007-09-12' ),( '2007-09-13' ),( '2007-09-14' ),( '2007-09-15' ),( '2007-09-16' ),( '2007-09-17' ),( '2007-09-18' ),( '2007-09-19' ),( '2007-09-20' ),( '2007-09-21' ),( '2007-09-22' ),( '2007-09-23' ),( '2007-09-24' ),( '2007-09-25' ),( '2007-09-26' ),( '2007-09-27' ),( '2007-09-28' ),( '2007-09-29' ),( '2007-09-30' ),( '2007-10-01' ),( '2007-10-02' ),( '2007-10-03' ),( '2007-10-04' ),( '2007-10-05' ),( '2007-10-06' ),( '2007-10-07' ),( '2007-10-08' ),( '2007-10-09' ),( '2007-10-10' ),( '2007-10-11' ),( '2007-10-12' ),( '2007-10-13' ),( '2007-10-14' ),( '2007-10-15' ),( '2007-10-16' ),( '2007-10-17' ),( '2007-10-18' ),( '2007-10-19' ),( '2007-10-20' ),( '2007-10-21' ),( '2007-10-22' ),( '2007-10-23' ),( '2007-10-24' ),( '2007-10-25' ),( '2007-10-26' ),( '2007-10-27' ),( '2007-10-28' ),( '2007-10-29' ),( '2007-10-30' ),( '2007-10-31' ),( '2007-11-01' ),( '2007-11-02' ),( '2007-11-03' ),( '2007-11-04' ),( '2007-11-05' ),( '2007-11-06' ),( '2007-11-07' ),( '2007-11-08' ),( '2007-11-09' ),( '2007-11-10' ),( '2007-11-11' ),( '2007-11-12' ),( '2007-11-13' ),( '2007-11-14' ),( '2007-11-15' ),( '2007-11-16' ),( '2007-11-17' ),( '2007-11-18' ),( '2007-11-19' ),( '2007-11-20' ),( '2007-11-21' ),( '2007-11-22' ),( '2007-11-23' ),( '2007-11-24' ),( '2007-11-25' ),( '2007-11-26' ),( '2007-11-27' ),( '2007-11-28' ),( '2007-11-29' ),( '2007-11-30' ),( '2007-12-01' ),( '2007-12-02' ),( '2007-12-03' ),( '2007-12-04' ),( '2007-12-05' ),( '2007-12-06' ),( '2007-12-07' ),( '2007-12-08' ),( '2007-12-09' ),( '2007-12-10' ),( '2007-12-11' ),( '2007-12-12' ),( '2007-12-13' ),( '2007-12-14' ),( '2007-12-15' ),( '2007-12-16' ),( '2007-12-17' ),( '2007-12-18' ),( '2007-12-19' ),( '2007-12-20' ),( '2007-12-21' ),( '2007-12-22' ),( '2007-12-23' ),( '2007-12-24' ),( '2007-12-25' ),( '2007-12-26' ),( '2007-12-27' ),( '2007-12-28' ),( '2007-12-29' ),( '2007-12-30' ),( '2007-12-31' ),( '2008-01-01' ),( '2008-01-02' ),( '2008-01-03' ),( '2008-01-04' ),( '2008-01-05' ),( '2008-01-06' ),( '2008-01-07' ),( '2008-01-08' ),( '2008-01-09' ),( '2008-01-10' ),( '2008-01-11' ),( '2008-01-12' ),( '2008-01-13' ),( '2008-01-14' ),( '2008-01-15' ),( '2008-01-16' ),( '2008-01-17' ),( '2008-01-18' ),( '2008-01-19' ),( '2008-01-20' ),( '2008-01-21' ),( '2008-01-22' ),( '2008-01-23' ),( '2008-01-24' ),( '2008-01-25' ),( '2008-01-26' ),( '2008-01-27' ),( '2008-01-28' ),( '2008-01-29' ),( '2008-01-30' ),( '2008-01-31' ),( '2008-02-01' ),( '2008-02-02' ),( '2008-02-03' ),( '2008-02-04' ),( '2008-02-05' ),( '2008-02-06' ),( '2008-02-07' ),( '2008-02-08' ),( '2008-02-09' ),( '2008-02-10' ),( '2008-02-11' ),( '2008-02-12' ),( '2008-02-13' ),( '2008-02-14' ),( '2008-02-15' ),( '2008-02-16' ),( '2008-02-17' ),( '2008-02-18' ),( '2008-02-19' ),( '2008-02-20' ),( '2008-02-21' ),( '2008-02-22' ),( '2008-02-23' ),( '2008-02-24' ),( '2008-02-25' ),( '2008-02-26' ),( '2008-02-27' ),( '2008-02-28' ),( '2008-02-29' ),( '2008-03-01' ),( '2008-03-02' ),( '2008-03-03' ),( '2008-03-04' ),( '2008-03-05' ),( '2008-03-06' ),( '2008-03-07' ),( '2008-03-08' ),( '2008-03-09' ),( '2008-03-10' ),( '2008-03-11' ),( '2008-03-12' ),( '2008-03-13' ),( '2008-03-14' ),( '2008-03-15' ),( '2008-03-16' ),( '2008-03-17' ),( '2008-03-18' ),( '2008-03-19' ),( '2008-03-20' ),( '2008-03-21' ),( '2008-03-22' ),( '2008-03-23' ),( '2008-03-24' ),( '2008-03-25' ),( '2008-03-26' ),( '2008-03-27' ),( '2008-03-28' ),( '2008-03-29' ),( '2008-03-30' ),( '2008-03-31' ),( '2008-04-01' ),( '2008-04-02' ),( '2008-04-03' ),( '2008-04-04' ),( '2008-04-05' ),( '2008-04-06' ),( '2008-04-07' ),( '2008-04-08' ),( '2008-04-09' ),( '2008-04-10' ),( '2008-04-11' ),( '2008-04-12' ),( '2008-04-13' ),( '2008-04-14' ),( '2008-04-15' ),( '2008-04-16' ),( '2008-04-17' ),( '2008-04-18' ),( '2008-04-19' ),( '2008-04-20' ),( '2008-04-21' ),( '2008-04-22' ),( '2008-04-23' ),( '2008-04-24' ),( '2008-04-25' ),( '2008-04-26' ),( '2008-04-27' ),( '2008-04-28' ),( '2008-04-29' ),( '2008-04-30' ),( '2008-05-01' ),( '2008-05-02' ),( '2008-05-03' ),( '2008-05-04' ),( '2008-05-05' ),( '2008-05-06' ),( '2008-05-07' ),( '2008-05-08' ),( '2008-05-09' ),( '2008-05-10' ),( '2008-05-11' ),( '2008-05-12' ),( '2008-05-13' ),( '2008-05-14' ),( '2008-05-15' ),( '2008-05-16' ),( '2008-05-17' ),( '2008-05-18' ),( '2008-05-19' ),( '2008-05-20' ),( '2008-05-21' ),( '2008-05-22' ),( '2008-05-23' ),( '2008-05-24' ),( '2008-05-25' ),( '2008-05-26' ),( '2008-05-27' ),( '2008-05-28' ),( '2008-05-29' ),( '2008-05-30' ),( '2008-05-31' ),( '2008-06-01' ),( '2008-06-02' ),( '2008-06-03' ),( '2008-06-04' ),( '2008-06-05' ),( '2008-06-06' ),( '2008-06-07' ),( '2008-06-08' ),( '2008-06-09' ),( '2008-06-10' ),( '2008-06-11' ),( '2008-06-12' ),( '2008-06-13' ),( '2008-06-14' ),( '2008-06-15' ),( '2008-06-16' ),( '2008-06-17' ),( '2008-06-18' ),( '2008-06-19' ),( '2008-06-20' ),( '2008-06-21' ),( '2008-06-22' ),( '2008-06-23' ),( '2008-06-24' ),( '2008-06-25' ),( '2008-06-26' ),( '2008-06-27' ),( '2008-06-28' ),( '2008-06-29' ),( '2008-06-30' ),( '2008-07-01' ),( '2008-07-02' ),( '2008-07-03' ),( '2008-07-04' ),( '2008-07-05' ),( '2008-07-06' ),( '2008-07-07' ),( '2008-07-08' ),( '2008-07-09' ),( '2008-07-10' ),( '2008-07-11' ),( '2008-07-12' ),( '2008-07-13' ),( '2008-07-14' ),( '2008-07-15' ),( '2008-07-16' ),( '2008-07-17' ),( '2008-07-18' ),( '2008-07-19' ),( '2008-07-20' ),( '2008-07-21' ),( '2008-07-22' ),( '2008-07-23' ),( '2008-07-24' ),( '2008-07-25' ),( '2008-07-26' ),( '2008-07-27' ),( '2008-07-28' ),( '2008-07-29' ),( '2008-07-30' ),( '2008-07-31' ),( '2008-08-01' ),( '2008-08-02' ),( '2008-08-03' ),( '2008-08-04' ),( '2008-08-05' ),( '2008-08-06' ),( '2008-08-07' ),( '2008-08-08' ),( '2008-08-09' ),( '2008-08-10' ),( '2008-08-11' ),( '2008-08-12' ),( '2008-08-13' ),( '2008-08-14' ),( '2008-08-15' ),( '2008-08-16' ),( '2008-08-17' ),( '2008-08-18' ),( '2008-08-19' ),( '2008-08-20' ),( '2008-08-21' ),( '2008-08-22' ),( '2008-08-23' ),( '2008-08-24' ),( '2008-08-25' ),( '2008-08-26' ),( '2008-08-27' ),( '2008-08-28' ),( '2008-08-29' ),( '2008-08-30' ),( '2008-08-31' ),( '2008-09-01' ),( '2008-09-02' ),( '2008-09-03' ),( '2008-09-04' ),( '2008-09-05' ),( '2008-09-06' ),( '2008-09-07' ),( '2008-09-08' ),( '2008-09-09' ),( '2008-09-10' ),( '2008-09-11' ),( '2008-09-12' ),( '2008-09-13' ),( '2008-09-14' ),( '2008-09-15' ),( '2008-09-16' ),( '2008-09-17' ),( '2008-09-18' ),( '2008-09-19' ),( '2008-09-20' ),( '2008-09-21' ),( '2008-09-22' ),( '2008-09-23' ),( '2008-09-24' ),( '2008-09-25' ),( '2008-09-26' ),( '2008-09-27' ),( '2008-09-28' ),( '2008-09-29' ),( '2008-09-30' ),( '2008-10-01' ),( '2008-10-02' ),( '2008-10-03' ),( '2008-10-04' ),( '2008-10-05' ),( '2008-10-06' ),( '2008-10-07' ),( '2008-10-08' ),( '2008-10-09' ),( '2008-10-10' ),( '2008-10-11' ),( '2008-10-12' ),( '2008-10-13' ),( '2008-10-14' ),( '2008-10-15' ),( '2008-10-16' ),( '2008-10-17' ),( '2008-10-18' ),( '2008-10-19' ),( '2008-10-20' ),( '2008-10-21' ),( '2008-10-22' ),( '2008-10-23' ),( '2008-10-24' ),( '2008-10-25' ),( '2008-10-26' ),( '2008-10-27' ),( '2008-10-28' ),( '2008-10-29' ),( '2008-10-30' ),( '2008-10-31' ),( '2008-11-01' ),( '2008-11-02' ),( '2008-11-03' ),( '2008-11-04' ),( '2008-11-05' ),( '2008-11-06' ),( '2008-11-07' ),( '2008-11-08' ),( '2008-11-09' ),( '2008-11-10' ),( '2008-11-11' ),( '2008-11-12' ),( '2008-11-13' ),( '2008-11-14' ),( '2008-11-15' ),( '2008-11-16' ),( '2008-11-17' ),( '2008-11-18' ),( '2008-11-19' ),( '2008-11-20' ),( '2008-11-21' ),( '2008-11-22' ),( '2008-11-23' ),( '2008-11-24' ),( '2008-11-25' ),( '2008-11-26' ),( '2008-11-27' ),( '2008-11-28' ),( '2008-11-29' ),( '2008-11-30' ),( '2008-12-01' ),( '2008-12-02' ),( '2008-12-03' ),( '2008-12-04' ),( '2008-12-05' ),( '2008-12-06' ),( '2008-12-07' ),( '2008-12-08' ),( '2008-12-09' ),( '2008-12-10' ),( '2008-12-11' ),( '2008-12-12' ),( '2008-12-13' ),( '2008-12-14' ),( '2008-12-15' ),( '2008-12-16' ),( '2008-12-17' ),( '2008-12-18' ),( '2008-12-19' ),( '2008-12-20' ),( '2008-12-21' ),( '2008-12-22' ),( '2008-12-23' ),( '2008-12-24' ),( '2008-12-25' ),( '2008-12-26' ),( '2008-12-27' ),( '2008-12-28' ),( '2008-12-29' ),( '2008-12-30' ),( '2008-12-31' ),( '2009-01-01' ),( '2009-01-02' ),( '2009-01-03' ),( '2009-01-04' ),( '2009-01-05' ),( '2009-01-06' ),( '2009-01-07' ),( '2009-01-08' ),( '2009-01-09' ),( '2009-01-10' ),( '2009-01-11' ),( '2009-01-12' ),( '2009-01-13' ),( '2009-01-14' ),( '2009-01-15' ),( '2009-01-16' ),( '2009-01-17' ),( '2009-01-18' ),( '2009-01-19' ),( '2009-01-20' ),( '2009-01-21' ),( '2009-01-22' ),( '2009-01-23' ),( '2009-01-24' ),( '2009-01-25' ),( '2009-01-26' ),( '2009-01-27' ),( '2009-01-28' ),( '2009-01-29' ),( '2009-01-30' ),( '2009-01-31' ),( '2009-02-01' ),( '2009-02-02' ),( '2009-02-03' ),( '2009-02-04' ),( '2009-02-05' ),( '2009-02-06' ),( '2009-02-07' ),( '2009-02-08' ),( '2009-02-09' ),( '2009-02-10' ),( '2009-02-11' ),( '2009-02-12' ),( '2009-02-13' ),( '2009-02-14' ),( '2009-02-15' ),( '2009-02-16' ),( '2009-02-17' ),( '2009-02-18' ),( '2009-02-19' ),( '2009-02-20' ),( '2009-02-21' ),( '2009-02-22' ),( '2009-02-23' ),( '2009-02-24' ),( '2009-02-25' ),( '2009-02-26' ),( '2009-02-27' ),( '2009-02-28' ),( '2009-03-01' ),( '2009-03-02' ),( '2009-03-03' ),( '2009-03-04' ),( '2009-03-05' ),( '2009-03-06' ),( '2009-03-07' ),( '2009-03-08' ),( '2009-03-09' ),( '2009-03-10' ),( '2009-03-11' ),( '2009-03-12' ),( '2009-03-13' ),( '2009-03-14' ),( '2009-03-15' ),( '2009-03-16' ),( '2009-03-17' ),( '2009-03-18' ),( '2009-03-19' ),( '2009-03-20' ),( '2009-03-21' ),( '2009-03-22' ),( '2009-03-23' ),( '2009-03-24' ),( '2009-03-25' ),( '2009-03-26' ),( '2009-03-27' ),( '2009-03-28' ),( '2009-03-29' ),( '2009-03-30' ),( '2009-03-31' ),( '2009-04-01' ),( '2009-04-02' ),( '2009-04-03' ),( '2009-04-04' ),( '2009-04-05' ),( '2009-04-06' ),( '2009-04-07' ),( '2009-04-08' ),( '2009-04-09' ),( '2009-04-10' ),( '2009-04-11' ),( '2009-04-12' ),( '2009-04-13' ),( '2009-04-14' ),( '2009-04-15' ),( '2009-04-16' ),( '2009-04-17' ),( '2009-04-18' ),( '2009-04-19' ),( '2009-04-20' ),( '2009-04-21' ),( '2009-04-22' ),( '2009-04-23' ),( '2009-04-24' ),( '2009-04-25' ),( '2009-04-26' ),( '2009-04-27' ),( '2009-04-28' ),( '2009-04-29' ),( '2009-04-30' ),( '2009-05-01' ),( '2009-05-02' ),( '2009-05-03' ),( '2009-05-04' ),( '2009-05-05' ),( '2009-05-06' ),( '2009-05-07' ),( '2009-05-08' ),( '2009-05-09' ),( '2009-05-10' ),( '2009-05-11' ),( '2009-05-12' ),( '2009-05-13' ),( '2009-05-14' ),( '2009-05-15' ),( '2009-05-16' ),( '2009-05-17' ),( '2009-05-18' ),( '2009-05-19' ),( '2009-05-20' ),( '2009-05-21' ),( '2009-05-22' ),( '2009-05-23' ),( '2009-05-24' ),( '2009-05-25' ),( '2009-05-26' ),( '2009-05-27' ),( '2009-05-28' ),( '2009-05-29' ),( '2009-05-30' ),( '2009-05-31' ),( '2009-06-01' ),( '2009-06-02' ),( '2009-06-03' ),( '2009-06-04' ),( '2009-06-05' ),( '2009-06-06' ),( '2009-06-07' ),( '2009-06-08' ),( '2009-06-09' ),( '2009-06-10' ),( '2009-06-11' ),( '2009-06-12' ),( '2009-06-13' ),( '2009-06-14' ),( '2009-06-15' ),( '2009-06-16' ),( '2009-06-17' ),( '2009-06-18' ),( '2009-06-19' ),( '2009-06-20' ),( '2009-06-21' ),( '2009-06-22' ),( '2009-06-23' ),( '2009-06-24' ),( '2009-06-25' ),( '2009-06-26' ),( '2009-06-27' ),( '2009-06-28' ),( '2009-06-29' ),( '2009-06-30' ),( '2009-07-01' ),( '2009-07-02' ),( '2009-07-03' ),( '2009-07-04' ),( '2009-07-05' ),( '2009-07-06' ),( '2009-07-07' ),( '2009-07-08' ),( '2009-07-09' ),( '2009-07-10' ),( '2009-07-11' ),( '2009-07-12' ),( '2009-07-13' ),( '2009-07-14' ),( '2009-07-15' ),( '2009-07-16' ),( '2009-07-17' ),( '2009-07-18' ),( '2009-07-19' ),( '2009-07-20' ),( '2009-07-21' ),( '2009-07-22' ),( '2009-07-23' ),( '2009-07-24' ),( '2009-07-25' ),( '2009-07-26' ),( '2009-07-27' ),( '2009-07-28' ),( '2009-07-29' ),( '2009-07-30' ),( '2009-07-31' ),( '2009-08-01' ),( '2009-08-02' ),( '2009-08-03' ),( '2009-08-04' ),( '2009-08-05' ),( '2009-08-06' ),( '2009-08-07' ),( '2009-08-08' ),( '2009-08-09' ),( '2009-08-10' ),( '2009-08-11' ),( '2009-08-12' ),( '2009-08-13' ),( '2009-08-14' ),( '2009-08-15' ),( '2009-08-16' ),( '2009-08-17' ),( '2009-08-18' ),( '2009-08-19' ),( '2009-08-20' ),( '2009-08-21' ),( '2009-08-22' ),( '2009-08-23' ),( '2009-08-24' ),( '2009-08-25' ),( '2009-08-26' ),( '2009-08-27' ),( '2009-08-28' ),( '2009-08-29' ),( '2009-08-30' ),( '2009-08-31' ),( '2009-09-01' ),( '2009-09-02' ),( '2009-09-03' ),( '2009-09-04' ),( '2009-09-05' ),( '2009-09-06' ),( '2009-09-07' ),( '2009-09-08' ),( '2009-09-09' ),( '2009-09-10' ),( '2009-09-11' ),( '2009-09-12' ),( '2009-09-13' ),( '2009-09-14' ),( '2009-09-15' ),( '2009-09-16' ),( '2009-09-17' ),( '2009-09-18' ),( '2009-09-19' ),( '2009-09-20' ),( '2009-09-21' ),( '2009-09-22' ),( '2009-09-23' ),( '2009-09-24' ),( '2009-09-25' ),( '2009-09-26' ),( '2009-09-27' ),( '2009-09-28' ),( '2009-09-29' ),( '2009-09-30' ),( '2009-10-01' ),( '2009-10-02' ),( '2009-10-03' ),( '2009-10-04' ),( '2009-10-05' ),( '2009-10-06' ),( '2009-10-07' ),( '2009-10-08' ),( '2009-10-09' ),( '2009-10-10' ),( '2009-10-11' ),( '2009-10-12' ),( '2009-10-13' ),( '2009-10-14' ),( '2009-10-15' ),( '2009-10-16' ),( '2009-10-17' ),( '2009-10-18' ),( '2009-10-19' ),( '2009-10-20' ),( '2009-10-21' ),( '2009-10-22' ),( '2009-10-23' ),( '2009-10-24' ),( '2009-10-25' ),( '2009-10-26' ),( '2009-10-27' ),( '2009-10-28' ),( '2009-10-29' ),( '2009-10-30' ),( '2009-10-31' ),( '2009-11-01' ),( '2009-11-02' ),( '2009-11-03' ),( '2009-11-04' ),( '2009-11-05' ),( '2009-11-06' ),( '2009-11-07' ),( '2009-11-08' ),( '2009-11-09' ),( '2009-11-10' ),( '2009-11-11' ),( '2009-11-12' ),( '2009-11-13' ),( '2009-11-14' ),( '2009-11-15' ),( '2009-11-16' ),( '2009-11-17' ),( '2009-11-18' ),( '2009-11-19' ),( '2009-11-20' ),( '2009-11-21' ),( '2009-11-22' ),( '2009-11-23' ),( '2009-11-24' ),( '2009-11-25' ),( '2009-11-26' ),( '2009-11-27' ),( '2009-11-28' ),( '2009-11-29' ),( '2009-11-30' ),( '2009-12-01' ),( '2009-12-02' ),( '2009-12-03' ),( '2009-12-04' ),( '2009-12-05' ),( '2009-12-06' ),( '2009-12-07' ),( '2009-12-08' ),( '2009-12-09' ),( '2009-12-10' ),( '2009-12-11' ),( '2009-12-12' ),( '2009-12-13' ),( '2009-12-14' ),( '2009-12-15' ),( '2009-12-16' ),( '2009-12-17' ),( '2009-12-18' ),( '2009-12-19' ),( '2009-12-20' ),( '2009-12-21' ),( '2009-12-22' ),( '2009-12-23' ),( '2009-12-24' ),( '2009-12-25' ),( '2009-12-26' ),( '2009-12-27' ),( '2009-12-28' ),( '2009-12-29' ),( '2009-12-30' ),( '2009-12-31' ),( '2010-01-01' ),( '2010-01-02' ),( '2010-01-03' ),( '2010-01-04' ),( '2010-01-05' ),( '2010-01-06' ),( '2010-01-07' ),( '2010-01-08' ),( '2010-01-09' ),( '2010-01-10' ),( '2010-01-11' ),( '2010-01-12' ),( '2010-01-13' ),( '2010-01-14' ),( '2010-01-15' ),( '2010-01-16' ),( '2010-01-17' ),( '2010-01-18' ),( '2010-01-19' ),( '2010-01-20' ),( '2010-01-21' ),( '2010-01-22' ),( '2010-01-23' ),( '2010-01-24' ),( '2010-01-25' ),( '2010-01-26' ),( '2010-01-27' ),( '2010-01-28' ),( '2010-01-29' ),( '2010-01-30' ),( '2010-01-31' ),( '2010-02-01' ),( '2010-02-02' ),( '2010-02-03' ),( '2010-02-04' ),( '2010-02-05' ),( '2010-02-06' ),( '2010-02-07' ),( '2010-02-08' ),( '2010-02-09' ),( '2010-02-10' ),( '2010-02-11' ),( '2010-02-12' ),( '2010-02-13' ),( '2010-02-14' ),( '2010-02-15' ),( '2010-02-16' ),( '2010-02-17' ),( '2010-02-18' ),( '2010-02-19' ),( '2010-02-20' ),( '2010-02-21' ),( '2010-02-22' ),( '2010-02-23' ),( '2010-02-24' ),( '2010-02-25' ),( '2010-02-26' ),( '2010-02-27' ),( '2010-02-28' ),( '2010-03-01' ),( '2010-03-02' ),( '2010-03-03' ),( '2010-03-04' ),( '2010-03-05' ),( '2010-03-06' ),( '2010-03-07' ),( '2010-03-08' ),( '2010-03-09' ),( '2010-03-10' ),( '2010-03-11' ),( '2010-03-12' ),( '2010-03-13' ),( '2010-03-14' ),( '2010-03-15' ),( '2010-03-16' ),( '2010-03-17' ),( '2010-03-18' ),( '2010-03-19' ),( '2010-03-20' ),( '2010-03-21' ),( '2010-03-22' ),( '2010-03-23' ),( '2010-03-24' ),( '2010-03-25' ),( '2010-03-26' ),( '2010-03-27' ),( '2010-03-28' ),( '2010-03-29' ),( '2010-03-30' ),( '2010-03-31' ),( '2010-04-01' ),( '2010-04-02' ),( '2010-04-03' ),( '2010-04-04' ),( '2010-04-05' ),( '2010-04-06' ),( '2010-04-07' ),( '2010-04-08' ),( '2010-04-09' ),( '2010-04-10' ),( '2010-04-11' ),( '2010-04-12' ),( '2010-04-13' ),( '2010-04-14' ),( '2010-04-15' ),( '2010-04-16' ),( '2010-04-17' ),( '2010-04-18' ),( '2010-04-19' ),( '2010-04-20' ),( '2010-04-21' ),( '2010-04-22' ),( '2010-04-23' ),( '2010-04-24' ),( '2010-04-25' ),( '2010-04-26' ),( '2010-04-27' ),( '2010-04-28' ),( '2010-04-29' ),( '2010-04-30' ),( '2010-05-01' ),( '2010-05-02' ),( '2010-05-03' ),( '2010-05-04' ),( '2010-05-05' ),( '2010-05-06' ),( '2010-05-07' ),( '2010-05-08' ),( '2010-05-09' ),( '2010-05-10' ),( '2010-05-11' ),( '2010-05-12' ),( '2010-05-13' ),( '2010-05-14' ),( '2010-05-15' ),( '2010-05-16' ),( '2010-05-17' ),( '2010-05-18' ),( '2010-05-19' ),( '2010-05-20' ),( '2010-05-21' ),( '2010-05-22' ),( '2010-05-23' ),( '2010-05-24' ),( '2010-05-25' ),( '2010-05-26' ),( '2010-05-27' ),( '2010-05-28' ),( '2010-05-29' ),( '2010-05-30' ),( '2010-05-31' ),( '2010-06-01' ),( '2010-06-02' ),( '2010-06-03' ),( '2010-06-04' ),( '2010-06-05' ),( '2010-06-06' ),( '2010-06-07' ),( '2010-06-08' ),( '2010-06-09' ),( '2010-06-10' ),( '2010-06-11' ),( '2010-06-12' ),( '2010-06-13' ),( '2010-06-14' ),( '2010-06-15' ),( '2010-06-16' ),( '2010-06-17' ),( '2010-06-18' ),( '2010-06-19' ),( '2010-06-20' ),( '2010-06-21' ),( '2010-06-22' ),( '2010-06-23' ),( '2010-06-24' ),( '2010-06-25' ),( '2010-06-26' ),( '2010-06-27' ),( '2010-06-28' ),( '2010-06-29' ),( '2010-06-30' ),( '2010-07-01' ),( '2010-07-02' ),( '2010-07-03' ),( '2010-07-04' ),( '2010-07-05' ),( '2010-07-06' ),( '2010-07-07' ),( '2010-07-08' ),( '2010-07-09' ),( '2010-07-10' ),( '2010-07-11' ),( '2010-07-12' ),( '2010-07-13' ),( '2010-07-14' ),( '2010-07-15' ),( '2010-07-16' ),( '2010-07-17' ),( '2010-07-18' ),( '2010-07-19' ),( '2010-07-20' ),( '2010-07-21' ),( '2010-07-22' ),( '2010-07-23' ),( '2010-07-24' ),( '2010-07-25' ),( '2010-07-26' ),( '2010-07-27' ),( '2010-07-28' ),( '2010-07-29' ),( '2010-07-30' ),( '2010-07-31' ),( '2010-08-01' ),( '2010-08-02' ),( '2010-08-03' ),( '2010-08-04' ),( '2010-08-05' ),( '2010-08-06' ),( '2010-08-07' ),( '2010-08-08' ),( '2010-08-09' ),( '2010-08-10' ),( '2010-08-11' ),( '2010-08-12' ),( '2010-08-13' ),( '2010-08-14' ),( '2010-08-15' ),( '2010-08-16' ),( '2010-08-17' ),( '2010-08-18' ),( '2010-08-19' ),( '2010-08-20' ),( '2010-08-21' ),( '2010-08-22' ),( '2010-08-23' ),( '2010-08-24' ),( '2010-08-25' ),( '2010-08-26' ),( '2010-08-27' ),( '2010-08-28' ),( '2010-08-29' ),( '2010-08-30' ),( '2010-08-31' ),( '2010-09-01' ),( '2010-09-02' ),( '2010-09-03' ),( '2010-09-04' ),( '2010-09-05' ),( '2010-09-06' ),( '2010-09-07' ),( '2010-09-08' ),( '2010-09-09' ),( '2010-09-10' ),( '2010-09-11' ),( '2010-09-12' ),( '2010-09-13' ),( '2010-09-14' ),( '2010-09-15' ),( '2010-09-16' ),( '2010-09-17' ),( '2010-09-18' ),( '2010-09-19' ),( '2010-09-20' ),( '2010-09-21' ),( '2010-09-22' ),( '2010-09-23' ),( '2010-09-24' ),( '2010-09-25' ),( '2010-09-26' ),( '2010-09-27' ),( '2010-09-28' ),( '2010-09-29' ),( '2010-09-30' ),( '2010-10-01' ),( '2010-10-02' ),( '2010-10-03' ),( '2010-10-04' ),( '2010-10-05' ),( '2010-10-06' ),( '2010-10-07' ),( '2010-10-08' ),( '2010-10-09' ),( '2010-10-10' ),( '2010-10-11' ),( '2010-10-12' ),( '2010-10-13' ),( '2010-10-14' ),( '2010-10-15' ),( '2010-10-16' ),( '2010-10-17' ),( '2010-10-18' ),( '2010-10-19' ),( '2010-10-20' ),( '2010-10-21' ),( '2010-10-22' ),( '2010-10-23' ),( '2010-10-24' ),( '2010-10-25' ),( '2010-10-26' ),( '2010-10-27' ),( '2010-10-28' ),( '2010-10-29' ),( '2010-10-30' ),( '2010-10-31' ),( '2010-11-01' ),( '2010-11-02' ),( '2010-11-03' ),( '2010-11-04' ),( '2010-11-05' ),( '2010-11-06' ),( '2010-11-07' ),( '2010-11-08' ),( '2010-11-09' ),( '2010-11-10' ),( '2010-11-11' ),( '2010-11-12' ),( '2010-11-13' ),( '2010-11-14' ),( '2010-11-15' ),( '2010-11-16' ),( '2010-11-17' ),( '2010-11-18' ),( '2010-11-19' ),( '2010-11-20' ),( '2010-11-21' ),( '2010-11-22' ),( '2010-11-23' ),( '2010-11-24' ),( '2010-11-25' ),( '2010-11-26' ),( '2010-11-27' ),( '2010-11-28' ),( '2010-11-29' ),( '2010-11-30' ),( '2010-12-01' ),( '2010-12-02' ),( '2010-12-03' ),( '2010-12-04' ),( '2010-12-05' ),( '2010-12-06' ),( '2010-12-07' ),( '2010-12-08' ),( '2010-12-09' ),( '2010-12-10' ),( '2010-12-11' ),( '2010-12-12' ),( '2010-12-13' ),( '2010-12-14' ),( '2010-12-15' ),( '2010-12-16' ),( '2010-12-17' ),( '2010-12-18' ),( '2010-12-19' ),( '2010-12-20' ),( '2010-12-21' ),( '2010-12-22' ),( '2010-12-23' ),( '2010-12-24' ),( '2010-12-25' ),( '2010-12-26' ),( '2010-12-27' ),( '2010-12-28' ),( '2010-12-29' ),( '2010-12-30' ),( '2010-12-31' ),( '2011-01-01' ),( '2011-01-02' ),( '2011-01-03' ),( '2011-01-04' ),( '2011-01-05' ),( '2011-01-06' ),( '2011-01-07' ),( '2011-01-08' ),( '2011-01-09' ),( '2011-01-10' ),( '2011-01-11' ),( '2011-01-12' ),( '2011-01-13' ),( '2011-01-14' ),( '2011-01-15' ),( '2011-01-16' ),( '2011-01-17' ),( '2011-01-18' ),( '2011-01-19' ),( '2011-01-20' ),( '2011-01-21' ),( '2011-01-22' ),( '2011-01-23' ),( '2011-01-24' ),( '2011-01-25' ),( '2011-01-26' ),( '2011-01-27' ),( '2011-01-28' ),( '2011-01-29' ),( '2011-01-30' ),( '2011-01-31' ),( '2011-02-01' ),( '2011-02-02' ),( '2011-02-03' ),( '2011-02-04' ),( '2011-02-05' ),( '2011-02-06' ),( '2011-02-07' ),( '2011-02-08' ),( '2011-02-09' ),( '2011-02-10' ),( '2011-02-11' ),( '2011-02-12' ),( '2011-02-13' ),( '2011-02-14' ),( '2011-02-15' ),( '2011-02-16' ),( '2011-02-17' ),( '2011-02-18' ),( '2011-02-19' ),( '2011-02-20' ),( '2011-02-21' ),( '2011-02-22' ),( '2011-02-23' ),( '2011-02-24' ),( '2011-02-25' ),( '2011-02-26' ),( '2011-02-27' ),( '2011-02-28' ),( '2011-03-01' ),( '2011-03-02' ),( '2011-03-03' ),( '2011-03-04' ),( '2011-03-05' ),( '2011-03-06' ),( '2011-03-07' ),( '2011-03-08' ),( '2011-03-09' ),( '2011-03-10' ),( '2011-03-11' ),( '2011-03-12' ),( '2011-03-13' ),( '2011-03-14' ),( '2011-03-15' ),( '2011-03-16' ),( '2011-03-17' ),( '2011-03-18' ),( '2011-03-19' ),( '2011-03-20' ),( '2011-03-21' ),( '2011-03-22' ),( '2011-03-23' ),( '2011-03-24' ),( '2011-03-25' ),( '2011-03-26' ),( '2011-03-27' ),( '2011-03-28' ),( '2011-03-29' ),( '2011-03-30' ),( '2011-03-31' ),( '2011-04-01' ),( '2011-04-02' ),( '2011-04-03' ),( '2011-04-04' ),( '2011-04-05' ),( '2011-04-06' ),( '2011-04-07' ),( '2011-04-08' ),( '2011-04-09' ),( '2011-04-10' ),( '2011-04-11' ),( '2011-04-12' ),( '2011-04-13' ),( '2011-04-14' ),( '2011-04-15' ),( '2011-04-16' ),( '2011-04-17' ),( '2011-04-18' ),( '2011-04-19' ),( '2011-04-20' ),( '2011-04-21' ),( '2011-04-22' ),( '2011-04-23' ),( '2011-04-24' ),( '2011-04-25' ),( '2011-04-26' ),( '2011-04-27' ),( '2011-04-28' ),( '2011-04-29' ),( '2011-04-30' ),( '2011-05-01' ),( '2011-05-02' ),( '2011-05-03' ),( '2011-05-04' ),( '2011-05-05' ),( '2011-05-06' ),( '2011-05-07' ),( '2011-05-08' ),( '2011-05-09' ),( '2011-05-10' ),( '2011-05-11' ),( '2011-05-12' ),( '2011-05-13' ),( '2011-05-14' ),( '2011-05-15' ),( '2011-05-16' ),( '2011-05-17' ),( '2011-05-18' ),( '2011-05-19' ),( '2011-05-20' ),( '2011-05-21' ),( '2011-05-22' ),( '2011-05-23' ),( '2011-05-24' ),( '2011-05-25' ),( '2011-05-26' ),( '2011-05-27' ),( '2011-05-28' ),( '2011-05-29' ),( '2011-05-30' ),( '2011-05-31' ),( '2011-06-01' ),( '2011-06-02' ),( '2011-06-03' ),( '2011-06-04' ),( '2011-06-05' ),( '2011-06-06' ),( '2011-06-07' ),( '2011-06-08' ),( '2011-06-09' ),( '2011-06-10' ),( '2011-06-11' ),( '2011-06-12' ),( '2011-06-13' ),( '2011-06-14' ),( '2011-06-15' ),( '2011-06-16' ),( '2011-06-17' ),( '2011-06-18' ),( '2011-06-19' ),( '2011-06-20' ),( '2011-06-21' ),( '2011-06-22' ),( '2011-06-23' ),( '2011-06-24' ),( '2011-06-25' ),( '2011-06-26' ),( '2011-06-27' ),( '2011-06-28' ),( '2011-06-29' ),( '2011-06-30' ),( '2011-07-01' ),( '2011-07-02' ),( '2011-07-03' ),( '2011-07-04' ),( '2011-07-05' ),( '2011-07-06' ),( '2011-07-07' ),( '2011-07-08' ),( '2011-07-09' ),( '2011-07-10' ),( '2011-07-11' ),( '2011-07-12' ),( '2011-07-13' ),( '2011-07-14' ),( '2011-07-15' ),( '2011-07-16' ),( '2011-07-17' ),( '2011-07-18' ),( '2011-07-19' ),( '2011-07-20' ),( '2011-07-21' ),( '2011-07-22' ),( '2011-07-23' ),( '2011-07-24' ),( '2011-07-25' ),( '2011-07-26' ),( '2011-07-27' ),( '2011-07-28' ),( '2011-07-29' ),( '2011-07-30' ),( '2011-07-31' ),( '2011-08-01' ),( '2011-08-02' ),( '2011-08-03' ),( '2011-08-04' ),( '2011-08-05' ),( '2011-08-06' ),( '2011-08-07' ),( '2011-08-08' ),( '2011-08-09' ),( '2011-08-10' ),( '2011-08-11' ),( '2011-08-12' ),( '2011-08-13' ),( '2011-08-14' ),( '2011-08-15' ),( '2011-08-16' ),( '2011-08-17' ),( '2011-08-18' ),( '2011-08-19' ),( '2011-08-20' ),( '2011-08-21' ),( '2011-08-22' ),( '2011-08-23' ),( '2011-08-24' ),( '2011-08-25' ),( '2011-08-26' ),( '2011-08-27' ),( '2011-08-28' ),( '2011-08-29' ),( '2011-08-30' ),( '2011-08-31' ),( '2011-09-01' ),( '2011-09-02' ),( '2011-09-03' ),( '2011-09-04' ),( '2011-09-05' ),( '2011-09-06' ),( '2011-09-07' ),( '2011-09-08' ),( '2011-09-09' ),( '2011-09-10' ),( '2011-09-11' ),( '2011-09-12' ),( '2011-09-13' ),( '2011-09-14' ),( '2011-09-15' ),( '2011-09-16' ),( '2011-09-17' ),( '2011-09-18' ),( '2011-09-19' ),( '2011-09-20' ),( '2011-09-21' ),( '2011-09-22' ),( '2011-09-23' ),( '2011-09-24' ),( '2011-09-25' ),( '2011-09-26' ),( '2011-09-27' ),( '2011-09-28' ),( '2011-09-29' ),( '2011-09-30' ),( '2011-10-01' ),( '2011-10-02' ),( '2011-10-03' ),( '2011-10-04' ),( '2011-10-05' ),( '2011-10-06' ),( '2011-10-07' ),( '2011-10-08' ),( '2011-10-09' ),( '2011-10-10' ),( '2011-10-11' ),( '2011-10-12' ),( '2011-10-13' ),( '2011-10-14' ),( '2011-10-15' ),( '2011-10-16' ),( '2011-10-17' ),( '2011-10-18' ),( '2011-10-19' ),( '2011-10-20' ),( '2011-10-21' ),( '2011-10-22' ),( '2011-10-23' ),( '2011-10-24' ),( '2011-10-25' ),( '2011-10-26' ),( '2011-10-27' ),( '2011-10-28' ),( '2011-10-29' ),( '2011-10-30' ),( '2011-10-31' ),( '2011-11-01' ),( '2011-11-02' ),( '2011-11-03' ),( '2011-11-04' ),( '2011-11-05' ),( '2011-11-06' ),( '2011-11-07' ),( '2011-11-08' ),( '2011-11-09' ),( '2011-11-10' ),( '2011-11-11' ),( '2011-11-12' ),( '2011-11-13' ),( '2011-11-14' ),( '2011-11-15' ),( '2011-11-16' ),( '2011-11-17' ),( '2011-11-18' ),( '2011-11-19' ),( '2011-11-20' ),( '2011-11-21' ),( '2011-11-22' ),( '2011-11-23' ),( '2011-11-24' ),( '2011-11-25' ),( '2011-11-26' ),( '2011-11-27' ),( '2011-11-28' ),( '2011-11-29' ),( '2011-11-30' ),( '2011-12-01' ),( '2011-12-02' ),( '2011-12-03' ),( '2011-12-04' ),( '2011-12-05' ),( '2011-12-06' ),( '2011-12-07' ),( '2011-12-08' ),( '2011-12-09' ),( '2011-12-10' ),( '2011-12-11' ),( '2011-12-12' ),( '2011-12-13' ),( '2011-12-14' ),( '2011-12-15' ),( '2011-12-16' ),( '2011-12-17' ),( '2011-12-18' ),( '2011-12-19' ),( '2011-12-20' ),( '2011-12-21' ),( '2011-12-22' ),( '2011-12-23' ),( '2011-12-24' ),( '2011-12-25' ),( '2011-12-26' ),( '2011-12-27' ),( '2011-12-28' ),( '2011-12-29' ),( '2011-12-30' ),( '2011-12-31' ),( '2012-01-01' ),( '2012-01-02' ),( '2012-01-03' ),( '2012-01-04' ),( '2012-01-05' ),( '2012-01-06' ),( '2012-01-07' ),( '2012-01-08' ),( '2012-01-09' ),( '2012-01-10' ),( '2012-01-11' ),( '2012-01-12' ),( '2012-01-13' ),( '2012-01-14' ),( '2012-01-15' ),( '2012-01-16' ),( '2012-01-17' ),( '2012-01-18' ),( '2012-01-19' ),( '2012-01-20' ),( '2012-01-21' ),( '2012-01-22' ),( '2012-01-23' ),( '2012-01-24' ),( '2012-01-25' ),( '2012-01-26' ),( '2012-01-27' ),( '2012-01-28' ),( '2012-01-29' ),( '2012-01-30' ),( '2012-01-31' ),( '2012-02-01' ),( '2012-02-02' ),( '2012-02-03' ),( '2012-02-04' ),( '2012-02-05' ),( '2012-02-06' ),( '2012-02-07' ),( '2012-02-08' ),( '2012-02-09' ),( '2012-02-10' ),( '2012-02-11' ),( '2012-02-12' ),( '2012-02-13' ),( '2012-02-14' ),( '2012-02-15' ),( '2012-02-16' ),( '2012-02-17' ),( '2012-02-18' ),( '2012-02-19' ),( '2012-02-20' ),( '2012-02-21' ),( '2012-02-22' ),( '2012-02-23' ),( '2012-02-24' ),( '2012-02-25' ),( '2012-02-26' ),( '2012-02-27' ),( '2012-02-28' ),( '2012-02-29' ),( '2012-03-01' ),( '2012-03-02' ),( '2012-03-03' ),( '2012-03-04' ),( '2012-03-05' ),( '2012-03-06' ),( '2012-03-07' ),( '2012-03-08' ),( '2012-03-09' ),( '2012-03-10' ),( '2012-03-11' ),( '2012-03-12' ),( '2012-03-13' ),( '2012-03-14' ),( '2012-03-15' ),( '2012-03-16' ),( '2012-03-17' ),( '2012-03-18' ),( '2012-03-19' ),( '2012-03-20' ),( '2012-03-21' ),( '2012-03-22' ),( '2012-03-23' ),( '2012-03-24' ),( '2012-03-25' ),( '2012-03-26' ),( '2012-03-27' ),( '2012-03-28' ),( '2012-03-29' ),( '2012-03-30' ),( '2012-03-31' ),( '2012-04-01' ),( '2012-04-02' ),( '2012-04-03' ),( '2012-04-04' ),( '2012-04-05' ),( '2012-04-06' ),( '2012-04-07' ),( '2012-04-08' ),( '2012-04-09' ),( '2012-04-10' ),( '2012-04-11' ),( '2012-04-12' ),( '2012-04-13' ),( '2012-04-14' ),( '2012-04-15' ),( '2012-04-16' ),( '2012-04-17' ),( '2012-04-18' ),( '2012-04-19' ),( '2012-04-20' ),( '2012-04-21' ),( '2012-04-22' ),( '2012-04-23' ),( '2012-04-24' ),( '2012-04-25' ),( '2012-04-26' ),( '2012-04-27' ),( '2012-04-28' ),( '2012-04-29' ),( '2012-04-30' ),( '2012-05-01' ),( '2012-05-02' ),( '2012-05-03' ),( '2012-05-04' ),( '2012-05-05' ),( '2012-05-06' ),( '2012-05-07' ),( '2012-05-08' ),( '2012-05-09' ),( '2012-05-10' ),( '2012-05-11' ),( '2012-05-12' ),( '2012-05-13' ),( '2012-05-14' ),( '2012-05-15' ),( '2012-05-16' ),( '2012-05-17' ),( '2012-05-18' ),( '2012-05-19' ),( '2012-05-20' ),( '2012-05-21' ),( '2012-05-22' ),( '2012-05-23' ),( '2012-05-24' ),( '2012-05-25' ),( '2012-05-26' ),( '2012-05-27' ),( '2012-05-28' ),( '2012-05-29' ),( '2012-05-30' ),( '2012-05-31' ),( '2012-06-01' ),( '2012-06-02' ),( '2012-06-03' ),( '2012-06-04' ),( '2012-06-05' ),( '2012-06-06' ),( '2012-06-07' ),( '2012-06-08' ),( '2012-06-09' ),( '2012-06-10' ),( '2012-06-11' ),( '2012-06-12' ),( '2012-06-13' ),( '2012-06-14' ),( '2012-06-15' ),( '2012-06-16' ),( '2012-06-17' ),( '2012-06-18' ),( '2012-06-19' ),( '2012-06-20' ),( '2012-06-21' ),( '2012-06-22' ),( '2012-06-23' ),( '2012-06-24' ),( '2012-06-25' ),( '2012-06-26' ),( '2012-06-27' ),( '2012-06-28' ),( '2012-06-29' ),( '2012-06-30' ),( '2012-07-01' ),( '2012-07-02' ),( '2012-07-03' ),( '2012-07-04' ),( '2012-07-05' ),( '2012-07-06' ),( '2012-07-07' ),( '2012-07-08' ),( '2012-07-09' ),( '2012-07-10' ),( '2012-07-11' ),( '2012-07-12' ),( '2012-07-13' ),( '2012-07-14' ),( '2012-07-15' ),( '2012-07-16' ),( '2012-07-17' ),( '2012-07-18' ),( '2012-07-19' ),( '2012-07-20' ),( '2012-07-21' ),( '2012-07-22' ),( '2012-07-23' ),( '2012-07-24' ),( '2012-07-25' ),( '2012-07-26' ),( '2012-07-27' ),( '2012-07-28' ),( '2012-07-29' ),( '2012-07-30' ),( '2012-07-31' ),( '2012-08-01' ),( '2012-08-02' ),( '2012-08-03' ),( '2012-08-04' ),( '2012-08-05' ),( '2012-08-06' ),( '2012-08-07' ),( '2012-08-08' ),( '2012-08-09' ),( '2012-08-10' ),( '2012-08-11' ),( '2012-08-12' ),( '2012-08-13' ),( '2012-08-14' ),( '2012-08-15' ),( '2012-08-16' ),( '2012-08-17' ),( '2012-08-18' ),( '2012-08-19' ),( '2012-08-20' ),( '2012-08-21' ),( '2012-08-22' ),( '2012-08-23' ),( '2012-08-24' ),( '2012-08-25' ),( '2012-08-26' ),( '2012-08-27' ),( '2012-08-28' ),( '2012-08-29' ),( '2012-08-30' ),( '2012-08-31' ),( '2012-09-01' ),( '2012-09-02' ),( '2012-09-03' ),( '2012-09-04' ),( '2012-09-05' ),( '2012-09-06' ),( '2012-09-07' ),( '2012-09-08' ),( '2012-09-09' ),( '2012-09-10' ),( '2012-09-11' ),( '2012-09-12' ),( '2012-09-13' ),( '2012-09-14' ),( '2012-09-15' ),( '2012-09-16' ),( '2012-09-17' ),( '2012-09-18' ),( '2012-09-19' ),( '2012-09-20' ),( '2012-09-21' ),( '2012-09-22' ),( '2012-09-23' ),( '2012-09-24' ),( '2012-09-25' ),( '2012-09-26' ),( '2012-09-27' ),( '2012-09-28' ),( '2012-09-29' ),( '2012-09-30' ),( '2012-10-01' ),( '2012-10-02' ),( '2012-10-03' ),( '2012-10-04' ),( '2012-10-05' ),( '2012-10-06' ),( '2012-10-07' ),( '2012-10-08' ),( '2012-10-09' ),( '2012-10-10' ),( '2012-10-11' ),( '2012-10-12' ),( '2012-10-13' ),( '2012-10-14' ),( '2012-10-15' ),( '2012-10-16' ),( '2012-10-17' ),( '2012-10-18' ),( '2012-10-19' ),( '2012-10-20' ),( '2012-10-21' ),( '2012-10-22' ),( '2012-10-23' ),( '2012-10-24' ),( '2012-10-25' ),( '2012-10-26' ),( '2012-10-27' ),( '2012-10-28' ),( '2012-10-29' ),( '2012-10-30' ),( '2012-10-31' ),( '2012-11-01' ),( '2012-11-02' ),( '2012-11-03' ),( '2012-11-04' ),( '2012-11-05' ),( '2012-11-06' ),( '2012-11-07' ),( '2012-11-08' ),( '2012-11-09' ),( '2012-11-10' ),( '2012-11-11' ),( '2012-11-12' ),( '2012-11-13' ),( '2012-11-14' ),( '2012-11-15' ),( '2012-11-16' ),( '2012-11-17' ),( '2012-11-18' ),( '2012-11-19' ),( '2012-11-20' ),( '2012-11-21' ),( '2012-11-22' ),( '2012-11-23' ),( '2012-11-24' ),( '2012-11-25' ),( '2012-11-26' ),( '2012-11-27' ),( '2012-11-28' ),( '2012-11-29' ),( '2012-11-30' ),( '2012-12-01' ),( '2012-12-02' ),( '2012-12-03' ),( '2012-12-04' ),( '2012-12-05' ),( '2012-12-06' ),( '2012-12-07' ),( '2012-12-08' ),( '2012-12-09' ),( '2012-12-10' ),( '2012-12-11' ),( '2012-12-12' ),( '2012-12-13' ),( '2012-12-14' ),( '2012-12-15' ),( '2012-12-16' ),( '2012-12-17' ),( '2012-12-18' ),( '2012-12-19' ),( '2012-12-20' ),( '2012-12-21' ),( '2012-12-22' ),( '2012-12-23' ),( '2012-12-24' ),( '2012-12-25' ),( '2012-12-26' ),( '2012-12-27' ),( '2012-12-28' ),( '2012-12-29' ),( '2012-12-30' ),( '2012-12-31' ),( '2013-01-01' ),( '2013-01-02' ),( '2013-01-03' ),( '2013-01-04' ),( '2013-01-05' ),( '2013-01-06' ),( '2013-01-07' ),( '2013-01-08' ),( '2013-01-09' ),( '2013-01-10' ),( '2013-01-11' ),( '2013-01-12' ),( '2013-01-13' ),( '2013-01-14' ),( '2013-01-15' ),( '2013-01-16' ),( '2013-01-17' ),( '2013-01-18' ),( '2013-01-19' ),( '2013-01-20' ),( '2013-01-21' ),( '2013-01-22' ),( '2013-01-23' ),( '2013-01-24' ),( '2013-01-25' ),( '2013-01-26' ),( '2013-01-27' ),( '2013-01-28' ),( '2013-01-29' ),( '2013-01-30' ),( '2013-01-31' ),( '2013-02-01' ),( '2013-02-02' ),( '2013-02-03' ),( '2013-02-04' ),( '2013-02-05' ),( '2013-02-06' ),( '2013-02-07' ),( '2013-02-08' ),( '2013-02-09' ),( '2013-02-10' ),( '2013-02-11' ),( '2013-02-12' ),( '2013-02-13' ),( '2013-02-14' ),( '2013-02-15' ),( '2013-02-16' ),( '2013-02-17' ),( '2013-02-18' ),( '2013-02-19' ),( '2013-02-20' ),( '2013-02-21' ),( '2013-02-22' ),( '2013-02-23' ),( '2013-02-24' ),( '2013-02-25' ),( '2013-02-26' ),( '2013-02-27' ),( '2013-02-28' ),( '2013-03-01' ),( '2013-03-02' ),( '2013-03-03' ),( '2013-03-04' ),( '2013-03-05' ),( '2013-03-06' ),( '2013-03-07' ),( '2013-03-08' ),( '2013-03-09' ),( '2013-03-10' ),( '2013-03-11' ),( '2013-03-12' ),( '2013-03-13' ),( '2013-03-14' ),( '2013-03-15' ),( '2013-03-16' ),( '2013-03-17' ),( '2013-03-18' ),( '2013-03-19' ),( '2013-03-20' ),( '2013-03-21' ),( '2013-03-22' ),( '2013-03-23' ),( '2013-03-24' ),( '2013-03-25' ),( '2013-03-26' ),( '2013-03-27' ),( '2013-03-28' ),( '2013-03-29' ),( '2013-03-30' ),( '2013-03-31' ),( '2013-04-01' ),( '2013-04-02' ),( '2013-04-03' ),( '2013-04-04' ),( '2013-04-05' ),( '2013-04-06' ),( '2013-04-07' ),( '2013-04-08' ),( '2013-04-09' ),( '2013-04-10' ),( '2013-04-11' ),( '2013-04-12' ),( '2013-04-13' ),( '2013-04-14' ),( '2013-04-15' ),( '2013-04-16' ),( '2013-04-17' ),( '2013-04-18' ),( '2013-04-19' ),( '2013-04-20' ),( '2013-04-21' ),( '2013-04-22' ),( '2013-04-23' ),( '2013-04-24' ),( '2013-04-25' ),( '2013-04-26' ),( '2013-04-27' ),( '2013-04-28' ),( '2013-04-29' ),( '2013-04-30' ),( '2013-05-01' ),( '2013-05-02' ),( '2013-05-03' ),( '2013-05-04' ),( '2013-05-05' ),( '2013-05-06' ),( '2013-05-07' ),( '2013-05-08' ),( '2013-05-09' ),( '2013-05-10' ),( '2013-05-11' ),( '2013-05-12' ),( '2013-05-13' ),( '2013-05-14' ),( '2013-05-15' ),( '2013-05-16' ),( '2013-05-17' ),( '2013-05-18' ),( '2013-05-19' ),( '2013-05-20' ),( '2013-05-21' ),( '2013-05-22' ),( '2013-05-23' ),( '2013-05-24' ),( '2013-05-25' ),( '2013-05-26' ),( '2013-05-27' ),( '2013-05-28' ),( '2013-05-29' ),( '2013-05-30' ),( '2013-05-31' ),( '2013-06-01' ),( '2013-06-02' ),( '2013-06-03' ),( '2013-06-04' ),( '2013-06-05' ),( '2013-06-06' ),( '2013-06-07' ),( '2013-06-08' ),( '2013-06-09' ),( '2013-06-10' ),( '2013-06-11' ),( '2013-06-12' ),( '2013-06-13' ),( '2013-06-14' ),( '2013-06-15' ),( '2013-06-16' ),( '2013-06-17' ),( '2013-06-18' ),( '2013-06-19' ),( '2013-06-20' ),( '2013-06-21' ),( '2013-06-22' ),( '2013-06-23' ),( '2013-06-24' ),( '2013-06-25' ),( '2013-06-26' ),( '2013-06-27' ),( '2013-06-28' ),( '2013-06-29' ),( '2013-06-30' ),( '2013-07-01' ),( '2013-07-02' ),( '2013-07-03' ),( '2013-07-04' ),( '2013-07-05' ),( '2013-07-06' ),( '2013-07-07' ),( '2013-07-08' ),( '2013-07-09' ),( '2013-07-10' ),( '2013-07-11' ),( '2013-07-12' ),( '2013-07-13' ),( '2013-07-14' ),( '2013-07-15' ),( '2013-07-16' ),( '2013-07-17' ),( '2013-07-18' ),( '2013-07-19' ),( '2013-07-20' ),( '2013-07-21' ),( '2013-07-22' ),( '2013-07-23' ),( '2013-07-24' ),( '2013-07-25' ),( '2013-07-26' ),( '2013-07-27' ),( '2013-07-28' ),( '2013-07-29' ),( '2013-07-30' ),( '2013-07-31' ),( '2013-08-01' ),( '2013-08-02' ),( '2013-08-03' ),( '2013-08-04' ),( '2013-08-05' ),( '2013-08-06' ),( '2013-08-07' ),( '2013-08-08' ),( '2013-08-09' ),( '2013-08-10' ),( '2013-08-11' ),( '2013-08-12' ),( '2013-08-13' ),( '2013-08-14' ),( '2013-08-15' ),( '2013-08-16' ),( '2013-08-17' ),( '2013-08-18' ),( '2013-08-19' ),( '2013-08-20' ),( '2013-08-21' ),( '2013-08-22' ),( '2013-08-23' ),( '2013-08-24' ),( '2013-08-25' ),( '2013-08-26' ),( '2013-08-27' ),( '2013-08-28' ),( '2013-08-29' ),( '2013-08-30' ),( '2013-08-31' ),( '2013-09-01' ),( '2013-09-02' ),( '2013-09-03' ),( '2013-09-04' ),( '2013-09-05' ),( '2013-09-06' ),( '2013-09-07' ),( '2013-09-08' ),( '2013-09-09' ),( '2013-09-10' ),( '2013-09-11' ),( '2013-09-12' ),( '2013-09-13' ),( '2013-09-14' ),( '2013-09-15' ),( '2013-09-16' ),( '2013-09-17' ),( '2013-09-18' ),( '2013-09-19' ),( '2013-09-20' ),( '2013-09-21' ),( '2013-09-22' ),( '2013-09-23' ),( '2013-09-24' ),( '2013-09-25' ),( '2013-09-26' ),( '2013-09-27' ),( '2013-09-28' ),( '2013-09-29' ),( '2013-09-30' ),( '2013-10-01' ),( '2013-10-02' ),( '2013-10-03' ),( '2013-10-04' ),( '2013-10-05' ),( '2013-10-06' ),( '2013-10-07' ),( '2013-10-08' ),( '2013-10-09' ),( '2013-10-10' ),( '2013-10-11' ),( '2013-10-12' ),( '2013-10-13' ),( '2013-10-14' ),( '2013-10-15' ),( '2013-10-16' ),( '2013-10-17' ),( '2013-10-18' ),( '2013-10-19' ),( '2013-10-20' ),( '2013-10-21' ),( '2013-10-22' ),( '2013-10-23' ),( '2013-10-24' ),( '2013-10-25' ),( '2013-10-26' ),( '2013-10-27' ),( '2013-10-28' ),( '2013-10-29' ),( '2013-10-30' ),( '2013-10-31' ),( '2013-11-01' ),( '2013-11-02' ),( '2013-11-03' ),( '2013-11-04' ),( '2013-11-05' ),( '2013-11-06' ),( '2013-11-07' ),( '2013-11-08' ),( '2013-11-09' ),( '2013-11-10' ),( '2013-11-11' ),( '2013-11-12' ),( '2013-11-13' ),( '2013-11-14' ),( '2013-11-15' ),( '2013-11-16' ),( '2013-11-17' ),( '2013-11-18' ),( '2013-11-19' ),( '2013-11-20' ),( '2013-11-21' ),( '2013-11-22' ),( '2013-11-23' ),( '2013-11-24' ),( '2013-11-25' ),( '2013-11-26' ),( '2013-11-27' ),( '2013-11-28' ),( '2013-11-29' ),( '2013-11-30' ),( '2013-12-01' ),( '2013-12-02' ),( '2013-12-03' ),( '2013-12-04' ),( '2013-12-05' ),( '2013-12-06' ),( '2013-12-07' ),( '2013-12-08' ),( '2013-12-09' ),( '2013-12-10' ),( '2013-12-11' ),( '2013-12-12' ),( '2013-12-13' ),( '2013-12-14' ),( '2013-12-15' ),( '2013-12-16' ),( '2013-12-17' ),( '2013-12-18' ),( '2013-12-19' ),( '2013-12-20' ),( '2013-12-21' ),( '2013-12-22' ),( '2013-12-23' ),( '2013-12-24' ),( '2013-12-25' ),( '2013-12-26' ),( '2013-12-27' ),( '2013-12-28' ),( '2013-12-29' ),( '2013-12-30' ),( '2013-12-31' ),( '2014-01-01' ),( '2014-01-02' ),( '2014-01-03' ),( '2014-01-04' ),( '2014-01-05' ),( '2014-01-06' ),( '2014-01-07' ),( '2014-01-08' ),( '2014-01-09' ),( '2014-01-10' ),( '2014-01-11' ),( '2014-01-12' ),( '2014-01-13' ),( '2014-01-14' ),( '2014-01-15' ),( '2014-01-16' ),( '2014-01-17' ),( '2014-01-18' ),( '2014-01-19' ),( '2014-01-20' ),( '2014-01-21' ),( '2014-01-22' ),( '2014-01-23' ),( '2014-01-24' ),( '2014-01-25' ),( '2014-01-26' ),( '2014-01-27' ),( '2014-01-28' ),( '2014-01-29' ),( '2014-01-30' ),( '2014-01-31' ),( '2014-02-01' ),( '2014-02-02' ),( '2014-02-03' ),( '2014-02-04' ),( '2014-02-05' ),( '2014-02-06' ),( '2014-02-07' ),( '2014-02-08' ),( '2014-02-09' ),( '2014-02-10' ),( '2014-02-11' ),( '2014-02-12' ),( '2014-02-13' ),( '2014-02-14' ),( '2014-02-15' ),( '2014-02-16' ),( '2014-02-17' ),( '2014-02-18' ),( '2014-02-19' ),( '2014-02-20' ),( '2014-02-21' ),( '2014-02-22' ),( '2014-02-23' ),( '2014-02-24' ),( '2014-02-25' ),( '2014-02-26' ),( '2014-02-27' ),( '2014-02-28' ),( '2014-03-01' ),( '2014-03-02' ),( '2014-03-03' ),( '2014-03-04' ),( '2014-03-05' ),( '2014-03-06' ),( '2014-03-07' ),( '2014-03-08' ),( '2014-03-09' ),( '2014-03-10' ),( '2014-03-11' ),( '2014-03-12' ),( '2014-03-13' ),( '2014-03-14' ),( '2014-03-15' ),( '2014-03-16' ),( '2014-03-17' ),( '2014-03-18' ),( '2014-03-19' ),( '2014-03-20' ),( '2014-03-21' ),( '2014-03-22' ),( '2014-03-23' ),( '2014-03-24' ),( '2014-03-25' ),( '2014-03-26' ),( '2014-03-27' ),( '2014-03-28' ),( '2014-03-29' ),( '2014-03-30' ),( '2014-03-31' ),( '2014-04-01' ),( '2014-04-02' ),( '2014-04-03' ),( '2014-04-04' ),( '2014-04-05' ),( '2014-04-06' ),( '2014-04-07' ),( '2014-04-08' ),( '2014-04-09' ),( '2014-04-10' ),( '2014-04-11' ),( '2014-04-12' ),( '2014-04-13' ),( '2014-04-14' ),( '2014-04-15' ),( '2014-04-16' ),( '2014-04-17' ),( '2014-04-18' ),( '2014-04-19' ),( '2014-04-20' ),( '2014-04-21' ),( '2014-04-22' ),( '2014-04-23' ),( '2014-04-24' ),( '2014-04-25' ),( '2014-04-26' ),( '2014-04-27' ),( '2014-04-28' ),( '2014-04-29' ),( '2014-04-30' ),( '2014-05-01' ),( '2014-05-02' ),( '2014-05-03' ),( '2014-05-04' ),( '2014-05-05' ),( '2014-05-06' ),( '2014-05-07' ),( '2014-05-08' ),( '2014-05-09' ),( '2014-05-10' ),( '2014-05-11' ),( '2014-05-12' ),( '2014-05-13' ),( '2014-05-14' ),( '2014-05-15' ),( '2014-05-16' ),( '2014-05-17' ),( '2014-05-18' ),( '2014-05-19' ),( '2014-05-20' ),( '2014-05-21' ),( '2014-05-22' ),( '2014-05-23' ),( '2014-05-24' ),( '2014-05-25' ),( '2014-05-26' ),( '2014-05-27' ),( '2014-05-28' ),( '2014-05-29' ),( '2014-05-30' ),( '2014-05-31' ),( '2014-06-01' ),( '2014-06-02' ),( '2014-06-03' ),( '2014-06-04' ),( '2014-06-05' ),( '2014-06-06' ),( '2014-06-07' ),( '2014-06-08' ),( '2014-06-09' ),( '2014-06-10' ),( '2014-06-11' ),( '2014-06-12' ),( '2014-06-13' ),( '2014-06-14' ),( '2014-06-15' ),( '2014-06-16' ),( '2014-06-17' ),( '2014-06-18' ),( '2014-06-19' ),( '2014-06-20' ),( '2014-06-21' ),( '2014-06-22' ),( '2014-06-23' ),( '2014-06-24' ),( '2014-06-25' ),( '2014-06-26' ),( '2014-06-27' ),( '2014-06-28' ),( '2014-06-29' ),( '2014-06-30' ),( '2014-07-01' ),( '2014-07-02' ),( '2014-07-03' ),( '2014-07-04' ),( '2014-07-05' ),( '2014-07-06' ),( '2014-07-07' ),( '2014-07-08' ),( '2014-07-09' ),( '2014-07-10' ),( '2014-07-11' ),( '2014-07-12' ),( '2014-07-13' ),( '2014-07-14' ),( '2014-07-15' ),( '2014-07-16' ),( '2014-07-17' ),( '2014-07-18' ),( '2014-07-19' ),( '2014-07-20' ),( '2014-07-21' ),( '2014-07-22' ),( '2014-07-23' ),( '2014-07-24' ),( '2014-07-25' ),( '2014-07-26' ),( '2014-07-27' ),( '2014-07-28' ),( '2014-07-29' ),( '2014-07-30' ),( '2014-07-31' ),( '2014-08-01' ),( '2014-08-02' ),( '2014-08-03' ),( '2014-08-04' ),( '2014-08-05' ),( '2014-08-06' ),( '2014-08-07' ),( '2014-08-08' ),( '2014-08-09' ),( '2014-08-10' ),( '2014-08-11' ),( '2014-08-12' ),( '2014-08-13' ),( '2014-08-14' ),( '2014-08-15' ),( '2014-08-16' ),( '2014-08-17' ),( '2014-08-18' ),( '2014-08-19' ),( '2014-08-20' ),( '2014-08-21' ),( '2014-08-22' ),( '2014-08-23' ),( '2014-08-24' ),( '2014-08-25' ),( '2014-08-26' ),( '2014-08-27' ),( '2014-08-28' ),( '2014-08-29' ),( '2014-08-30' ),( '2014-08-31' ),( '2014-09-01' ),( '2014-09-02' ),( '2014-09-03' ),( '2014-09-04' ),( '2014-09-05' ),( '2014-09-06' ),( '2014-09-07' ),( '2014-09-08' ),( '2014-09-09' ),( '2014-09-10' ),( '2014-09-11' ),( '2014-09-12' ),( '2014-09-13' ),( '2014-09-14' ),( '2014-09-15' ),( '2014-09-16' ),( '2014-09-17' ),( '2014-09-18' ),( '2014-09-19' ),( '2014-09-20' ),( '2014-09-21' ),( '2014-09-22' ),( '2014-09-23' ),( '2014-09-24' ),( '2014-09-25' ),( '2014-09-26' ),( '2014-09-27' ),( '2014-09-28' ),( '2014-09-29' ),( '2014-09-30' ),( '2014-10-01' ),( '2014-10-02' ),( '2014-10-03' ),( '2014-10-04' ),( '2014-10-05' ),( '2014-10-06' ),( '2014-10-07' ),( '2014-10-08' ),( '2014-10-09' ),( '2014-10-10' ),( '2014-10-11' ),( '2014-10-12' ),( '2014-10-13' ),( '2014-10-14' ),( '2014-10-15' ),( '2014-10-16' ),( '2014-10-17' ),( '2014-10-18' ),( '2014-10-19' ),( '2014-10-20' ),( '2014-10-21' ),( '2014-10-22' ),( '2014-10-23' ),( '2014-10-24' ),( '2014-10-25' ),( '2014-10-26' ),( '2014-10-27' ),( '2014-10-28' ),( '2014-10-29' ),( '2014-10-30' ),( '2014-10-31' ),( '2014-11-01' ),( '2014-11-02' ),( '2014-11-03' ),( '2014-11-04' ),( '2014-11-05' ),( '2014-11-06' ),( '2014-11-07' ),( '2014-11-08' ),( '2014-11-09' ),( '2014-11-10' ),( '2014-11-11' ),( '2014-11-12' ),( '2014-11-13' ),( '2014-11-14' ),( '2014-11-15' ),( '2014-11-16' ),( '2014-11-17' ),( '2014-11-18' ),( '2014-11-19' ),( '2014-11-20' ),( '2014-11-21' ),( '2014-11-22' ),( '2014-11-23' ),( '2014-11-24' ),( '2014-11-25' ),( '2014-11-26' ),( '2014-11-27' ),( '2014-11-28' ),( '2014-11-29' ),( '2014-11-30' ),( '2014-12-01' ),( '2014-12-02' ),( '2014-12-03' ),( '2014-12-04' ),( '2014-12-05' ),( '2014-12-06' ),( '2014-12-07' ),( '2014-12-08' ),( '2014-12-09' ),( '2014-12-10' ),( '2014-12-11' ),( '2014-12-12' ),( '2014-12-13' ),( '2014-12-14' ),( '2014-12-15' ),( '2014-12-16' ),( '2014-12-17' ),( '2014-12-18' ),( '2014-12-19' ),( '2014-12-20' ),( '2014-12-21' ),( '2014-12-22' ),( '2014-12-23' ),( '2014-12-24' ),( '2014-12-25' ),( '2014-12-26' ),( '2014-12-27' ),( '2014-12-28' ),( '2014-12-29' ),( '2014-12-30' ),( '2014-12-31' ),( '2015-01-01' ),( '2015-01-02' ),( '2015-01-03' ),( '2015-01-04' ),( '2015-01-05' ),( '2015-01-06' ),( '2015-01-07' ),( '2015-01-08' ),( '2015-01-09' ),( '2015-01-10' ),( '2015-01-11' ),( '2015-01-12' ),( '2015-01-13' ),( '2015-01-14' ),( '2015-01-15' ),( '2015-01-16' ),( '2015-01-17' ),( '2015-01-18' ),( '2015-01-19' ),( '2015-01-20' ),( '2015-01-21' ),( '2015-01-22' ),( '2015-01-23' ),( '2015-01-24' ),( '2015-01-25' ),( '2015-01-26' ),( '2015-01-27' ),( '2015-01-28' ),( '2015-01-29' ),( '2015-01-30' ),( '2015-01-31' ),( '2015-02-01' ),( '2015-02-02' ),( '2015-02-03' ),( '2015-02-04' ),( '2015-02-05' ),( '2015-02-06' ),( '2015-02-07' ),( '2015-02-08' ),( '2015-02-09' ),( '2015-02-10' ),( '2015-02-11' ),( '2015-02-12' ),( '2015-02-13' ),( '2015-02-14' ),( '2015-02-15' ),( '2015-02-16' ),( '2015-02-17' ),( '2015-02-18' ),( '2015-02-19' ),( '2015-02-20' ),( '2015-02-21' ),( '2015-02-22' ),( '2015-02-23' ),( '2015-02-24' ),( '2015-02-25' ),( '2015-02-26' ),( '2015-02-27' ),( '2015-02-28' ),( '2015-03-01' ),( '2015-03-02' ),( '2015-03-03' ),( '2015-03-04' ),( '2015-03-05' ),( '2015-03-06' ),( '2015-03-07' ),( '2015-03-08' ),( '2015-03-09' ),( '2015-03-10' ),( '2015-03-11' ),( '2015-03-12' ),( '2015-03-13' ),( '2015-03-14' ),( '2015-03-15' ),( '2015-03-16' ),( '2015-03-17' ),( '2015-03-18' ),( '2015-03-19' ),( '2015-03-20' ),( '2015-03-21' ),( '2015-03-22' ),( '2015-03-23' ),( '2015-03-24' ),( '2015-03-25' ),( '2015-03-26' ),( '2015-03-27' ),( '2015-03-28' ),( '2015-03-29' ),( '2015-03-30' ),( '2015-03-31' ),( '2015-04-01' ),( '2015-04-02' ),( '2015-04-03' ),( '2015-04-04' ),( '2015-04-05' ),( '2015-04-06' ),( '2015-04-07' ),( '2015-04-08' ),( '2015-04-09' ),( '2015-04-10' ),( '2015-04-11' ),( '2015-04-12' ),( '2015-04-13' ),( '2015-04-14' ),( '2015-04-15' ),( '2015-04-16' ),( '2015-04-17' ),( '2015-04-18' ),( '2015-04-19' ),( '2015-04-20' ),( '2015-04-21' ),( '2015-04-22' ),( '2015-04-23' ),( '2015-04-24' ),( '2015-04-25' ),( '2015-04-26' ),( '2015-04-27' ),( '2015-04-28' ),( '2015-04-29' ),( '2015-04-30' ),( '2015-05-01' ),( '2015-05-02' ),( '2015-05-03' ),( '2015-05-04' ),( '2015-05-05' ),( '2015-05-06' ),( '2015-05-07' ),( '2015-05-08' ),( '2015-05-09' ),( '2015-05-10' ),( '2015-05-11' ),( '2015-05-12' ),( '2015-05-13' ),( '2015-05-14' ),( '2015-05-15' ),( '2015-05-16' ),( '2015-05-17' ),( '2015-05-18' ),( '2015-05-19' ),( '2015-05-20' ),( '2015-05-21' ),( '2015-05-22' ),( '2015-05-23' ),( '2015-05-24' ),( '2015-05-25' ),( '2015-05-26' ),( '2015-05-27' ),( '2015-05-28' ),( '2015-05-29' ),( '2015-05-30' ),( '2015-05-31' ),( '2015-06-01' ),( '2015-06-02' ),( '2015-06-03' ),( '2015-06-04' ),( '2015-06-05' ),( '2015-06-06' ),( '2015-06-07' ),( '2015-06-08' ),( '2015-06-09' ),( '2015-06-10' ),( '2015-06-11' ),( '2015-06-12' ),( '2015-06-13' ),( '2015-06-14' ),( '2015-06-15' ),( '2015-06-16' ),( '2015-06-17' ),( '2015-06-18' ),( '2015-06-19' ),( '2015-06-20' ),( '2015-06-21' ),( '2015-06-22' ),( '2015-06-23' ),( '2015-06-24' ),( '2015-06-25' ),( '2015-06-26' ),( '2015-06-27' ),( '2015-06-28' ),( '2015-06-29' ),( '2015-06-30' ),( '2015-07-01' ),( '2015-07-02' ),( '2015-07-03' ),( '2015-07-04' ),( '2015-07-05' ),( '2015-07-06' ),( '2015-07-07' ),( '2015-07-08' ),( '2015-07-09' ),( '2015-07-10' ),( '2015-07-11' ),( '2015-07-12' ),( '2015-07-13' ),( '2015-07-14' ),( '2015-07-15' ),( '2015-07-16' ),( '2015-07-17' ),( '2015-07-18' ),( '2015-07-19' ),( '2015-07-20' ),( '2015-07-21' ),( '2015-07-22' ),( '2015-07-23' ),( '2015-07-24' ),( '2015-07-25' ),( '2015-07-26' ),( '2015-07-27' ),( '2015-07-28' ),( '2015-07-29' ),( '2015-07-30' ),( '2015-07-31' ),( '2015-08-01' ),( '2015-08-02' ),( '2015-08-03' ),( '2015-08-04' ),( '2015-08-05' ),( '2015-08-06' ),( '2015-08-07' ),( '2015-08-08' ),( '2015-08-09' ),( '2015-08-10' ),( '2015-08-11' ),( '2015-08-12' ),( '2015-08-13' ),( '2015-08-14' ),( '2015-08-15' ),( '2015-08-16' ),( '2015-08-17' ),( '2015-08-18' ),( '2015-08-19' ),( '2015-08-20' ),( '2015-08-21' ),( '2015-08-22' ),( '2015-08-23' ),( '2015-08-24' ),( '2015-08-25' ),( '2015-08-26' ),( '2015-08-27' ),( '2015-08-28' ),( '2015-08-29' ),( '2015-08-30' ),( '2015-08-31' ),( '2015-09-01' ),( '2015-09-02' ),( '2015-09-03' ),( '2015-09-04' ),( '2015-09-05' ),( '2015-09-06' ),( '2015-09-07' ),( '2015-09-08' ),( '2015-09-09' ),( '2015-09-10' ),( '2015-09-11' ),( '2015-09-12' ),( '2015-09-13' ),( '2015-09-14' ),( '2015-09-15' ),( '2015-09-16' ),( '2015-09-17' ),( '2015-09-18' ),( '2015-09-19' ),( '2015-09-20' ),( '2015-09-21' ),( '2015-09-22' ),( '2015-09-23' ),( '2015-09-24' ),( '2015-09-25' ),( '2015-09-26' ),( '2015-09-27' ),( '2015-09-28' ),( '2015-09-29' ),( '2015-09-30' ),( '2015-10-01' ),( '2015-10-02' ),( '2015-10-03' ),( '2015-10-04' ),( '2015-10-05' ),( '2015-10-06' ),( '2015-10-07' ),( '2015-10-08' ),( '2015-10-09' ),( '2015-10-10' ),( '2015-10-11' ),( '2015-10-12' ),( '2015-10-13' ),( '2015-10-14' ),( '2015-10-15' ),( '2015-10-16' ),( '2015-10-17' ),( '2015-10-18' ),( '2015-10-19' ),( '2015-10-20' ),( '2015-10-21' ),( '2015-10-22' ),( '2015-10-23' ),( '2015-10-24' ),( '2015-10-25' ),( '2015-10-26' ),( '2015-10-27' ),( '2015-10-28' ),( '2015-10-29' ),( '2015-10-30' ),( '2015-10-31' ),( '2015-11-01' ),( '2015-11-02' ),( '2015-11-03' ),( '2015-11-04' ),( '2015-11-05' ),( '2015-11-06' ),( '2015-11-07' ),( '2015-11-08' ),( '2015-11-09' ),( '2015-11-10' ),( '2015-11-11' ),( '2015-11-12' ),( '2015-11-13' ),( '2015-11-14' ),( '2015-11-15' ),( '2015-11-16' ),( '2015-11-17' ),( '2015-11-18' ),( '2015-11-19' ),( '2015-11-20' ),( '2015-11-21' ),( '2015-11-22' ),( '2015-11-23' ),( '2015-11-24' ),( '2015-11-25' ),( '2015-11-26' ),( '2015-11-27' ),( '2015-11-28' ),( '2015-11-29' ),( '2015-11-30' ),( '2015-12-01' ),( '2015-12-02' ),( '2015-12-03' ),( '2015-12-04' ),( '2015-12-05' ),( '2015-12-06' ),( '2015-12-07' ),( '2015-12-08' ),( '2015-12-09' ),( '2015-12-10' ),( '2015-12-11' ),( '2015-12-12' ),( '2015-12-13' ),( '2015-12-14' ),( '2015-12-15' ),( '2015-12-16' ),( '2015-12-17' ),( '2015-12-18' ),( '2015-12-19' ),( '2015-12-20' ),( '2015-12-21' ),( '2015-12-22' ),( '2015-12-23' ),( '2015-12-24' ),( '2015-12-25' ),( '2015-12-26' ),( '2015-12-27' ),( '2015-12-28' ),( '2015-12-29' ),( '2015-12-30' ),( '2015-12-31' ),( '2016-01-01' ),( '2016-01-02' ),( '2016-01-03' ),( '2016-01-04' ),( '2016-01-05' ),( '2016-01-06' ),( '2016-01-07' ),( '2016-01-08' ),( '2016-01-09' ),( '2016-01-10' ),( '2016-01-11' ),( '2016-01-12' ),( '2016-01-13' ),( '2016-01-14' ),( '2016-01-15' ),( '2016-01-16' ),( '2016-01-17' ),( '2016-01-18' ),( '2016-01-19' ),( '2016-01-20' ),( '2016-01-21' ),( '2016-01-22' ),( '2016-01-23' ),( '2016-01-24' ),( '2016-01-25' ),( '2016-01-26' ),( '2016-01-27' ),( '2016-01-28' ),( '2016-01-29' ),( '2016-01-30' ),( '2016-01-31' ),( '2016-02-01' ),( '2016-02-02' ),( '2016-02-03' ),( '2016-02-04' ),( '2016-02-05' ),( '2016-02-06' ),( '2016-02-07' ),( '2016-02-08' ),( '2016-02-09' ),( '2016-02-10' ),( '2016-02-11' ),( '2016-02-12' ),( '2016-02-13' ),( '2016-02-14' ),( '2016-02-15' ),( '2016-02-16' ),( '2016-02-17' ),( '2016-02-18' ),( '2016-02-19' ),( '2016-02-20' ),( '2016-02-21' ),( '2016-02-22' ),( '2016-02-23' ),( '2016-02-24' ),( '2016-02-25' ),( '2016-02-26' ),( '2016-02-27' ),( '2016-02-28' ),( '2016-02-29' ),( '2016-03-01' ),( '2016-03-02' ),( '2016-03-03' ),( '2016-03-04' ),( '2016-03-05' ),( '2016-03-06' ),( '2016-03-07' ),( '2016-03-08' ),( '2016-03-09' ),( '2016-03-10' ),( '2016-03-11' ),( '2016-03-12' ),( '2016-03-13' ),( '2016-03-14' ),( '2016-03-15' ),( '2016-03-16' ),( '2016-03-17' ),( '2016-03-18' ),( '2016-03-19' ),( '2016-03-20' ),( '2016-03-21' ),( '2016-03-22' ),( '2016-03-23' ),( '2016-03-24' ),( '2016-03-25' ),( '2016-03-26' ),( '2016-03-27' ),( '2016-03-28' ),( '2016-03-29' ),( '2016-03-30' ),( '2016-03-31' ),( '2016-04-01' ),( '2016-04-02' ),( '2016-04-03' ),( '2016-04-04' ),( '2016-04-05' ),( '2016-04-06' ),( '2016-04-07' ),( '2016-04-08' ),( '2016-04-09' ),( '2016-04-10' ),( '2016-04-11' ),( '2016-04-12' ),( '2016-04-13' ),( '2016-04-14' ),( '2016-04-15' ),( '2016-04-16' ),( '2016-04-17' ),( '2016-04-18' ),( '2016-04-19' ),( '2016-04-20' ),( '2016-04-21' ),( '2016-04-22' ),( '2016-04-23' ),( '2016-04-24' ),( '2016-04-25' ),( '2016-04-26' ),( '2016-04-27' ),( '2016-04-28' ),( '2016-04-29' ),( '2016-04-30' ),( '2016-05-01' ),( '2016-05-02' ),( '2016-05-03' ),( '2016-05-04' ),( '2016-05-05' ),( '2016-05-06' ),( '2016-05-07' ),( '2016-05-08' ),( '2016-05-09' ),( '2016-05-10' ),( '2016-05-11' ),( '2016-05-12' ),( '2016-05-13' ),( '2016-05-14' ),( '2016-05-15' ),( '2016-05-16' ),( '2016-05-17' ),( '2016-05-18' ),( '2016-05-19' ),( '2016-05-20' ),( '2016-05-21' ),( '2016-05-22' ),( '2016-05-23' ),( '2016-05-24' ),( '2016-05-25' ),( '2016-05-26' ),( '2016-05-27' ),( '2016-05-28' ),( '2016-05-29' ),( '2016-05-30' ),( '2016-05-31' ),( '2016-06-01' ),( '2016-06-02' ),( '2016-06-03' ),( '2016-06-04' ),( '2016-06-05' ),( '2016-06-06' ),( '2016-06-07' ),( '2016-06-08' ),( '2016-06-09' ),( '2016-06-10' ),( '2016-06-11' ),( '2016-06-12' ),( '2016-06-13' ),( '2016-06-14' ),( '2016-06-15' ),( '2016-06-16' ),( '2016-06-17' ),( '2016-06-18' ),( '2016-06-19' ),( '2016-06-20' ),( '2016-06-21' ),( '2016-06-22' ),( '2016-06-23' ),( '2016-06-24' ),( '2016-06-25' ),( '2016-06-26' ),( '2016-06-27' ),( '2016-06-28' ),( '2016-06-29' ),( '2016-06-30' ),( '2016-07-01' ),( '2016-07-02' ),( '2016-07-03' ),( '2016-07-04' ),( '2016-07-05' ),( '2016-07-06' ),( '2016-07-07' ),( '2016-07-08' ),( '2016-07-09' ),( '2016-07-10' ),( '2016-07-11' ),( '2016-07-12' ),( '2016-07-13' ),( '2016-07-14' ),( '2016-07-15' ),( '2016-07-16' ),( '2016-07-17' ),( '2016-07-18' ),( '2016-07-19' ),( '2016-07-20' ),( '2016-07-21' ),( '2016-07-22' ),( '2016-07-23' ),( '2016-07-24' ),( '2016-07-25' ),( '2016-07-26' ),( '2016-07-27' ),( '2016-07-28' ),( '2016-07-29' ),( '2016-07-30' ),( '2016-07-31' ),( '2016-08-01' ),( '2016-08-02' ),( '2016-08-03' ),( '2016-08-04' ),( '2016-08-05' ),( '2016-08-06' ),( '2016-08-07' ),( '2016-08-08' ),( '2016-08-09' ),( '2016-08-10' ),( '2016-08-11' ),( '2016-08-12' ),( '2016-08-13' ),( '2016-08-14' ),( '2016-08-15' ),( '2016-08-16' ),( '2016-08-17' ),( '2016-08-18' ),( '2016-08-19' ),( '2016-08-20' ),( '2016-08-21' ),( '2016-08-22' ),( '2016-08-23' ),( '2016-08-24' ),( '2016-08-25' ),( '2016-08-26' ),( '2016-08-27' ),( '2016-08-28' ),( '2016-08-29' ),( '2016-08-30' ),( '2016-08-31' ),( '2016-09-01' ),( '2016-09-02' ),( '2016-09-03' ),( '2016-09-04' ),( '2016-09-05' ),( '2016-09-06' ),( '2016-09-07' ),( '2016-09-08' ),( '2016-09-09' ),( '2016-09-10' ),( '2016-09-11' ),( '2016-09-12' ),( '2016-09-13' ),( '2016-09-14' ),( '2016-09-15' ),( '2016-09-16' ),( '2016-09-17' ),( '2016-09-18' ),( '2016-09-19' ),( '2016-09-20' ),( '2016-09-21' ),( '2016-09-22' ),( '2016-09-23' ),( '2016-09-24' ),( '2016-09-25' ),( '2016-09-26' ),( '2016-09-27' ),( '2016-09-28' ),( '2016-09-29' ),( '2016-09-30' ),( '2016-10-01' ),( '2016-10-02' ),( '2016-10-03' ),( '2016-10-04' ),( '2016-10-05' ),( '2016-10-06' ),( '2016-10-07' ),( '2016-10-08' ),( '2016-10-09' ),( '2016-10-10' ),( '2016-10-11' ),( '2016-10-12' ),( '2016-10-13' ),( '2016-10-14' ),( '2016-10-15' ),( '2016-10-16' ),( '2016-10-17' ),( '2016-10-18' ),( '2016-10-19' ),( '2016-10-20' ),( '2016-10-21' ),( '2016-10-22' ),( '2016-10-23' ),( '2016-10-24' ),( '2016-10-25' ),( '2016-10-26' ),( '2016-10-27' ),( '2016-10-28' ),( '2016-10-29' ),( '2016-10-30' ),( '2016-10-31' ),( '2016-11-01' ),( '2016-11-02' ),( '2016-11-03' ),( '2016-11-04' ),( '2016-11-05' ),( '2016-11-06' ),( '2016-11-07' ),( '2016-11-08' ),( '2016-11-09' ),( '2016-11-10' ),( '2016-11-11' ),( '2016-11-12' ),( '2016-11-13' ),( '2016-11-14' ),( '2016-11-15' ),( '2016-11-16' ),( '2016-11-17' ),( '2016-11-18' ),( '2016-11-19' ),( '2016-11-20' ),( '2016-11-21' ),( '2016-11-22' ),( '2016-11-23' ),( '2016-11-24' ),( '2016-11-25' ),( '2016-11-26' ),( '2016-11-27' ),( '2016-11-28' ),( '2016-11-29' ),( '2016-11-30' ),( '2016-12-01' ),( '2016-12-02' ),( '2016-12-03' ),( '2016-12-04' ),( '2016-12-05' ),( '2016-12-06' ),( '2016-12-07' ),( '2016-12-08' ),( '2016-12-09' ),( '2016-12-10' ),( '2016-12-11' ),( '2016-12-12' ),( '2016-12-13' ),( '2016-12-14' ),( '2016-12-15' ),( '2016-12-16' ),( '2016-12-17' ),( '2016-12-18' ),( '2016-12-19' ),( '2016-12-20' ),( '2016-12-21' ),( '2016-12-22' ),( '2016-12-23' ),( '2016-12-24' ),( '2016-12-25' ),( '2016-12-26' ),( '2016-12-27' ),( '2016-12-28' ),( '2016-12-29' ),( '2016-12-30' ),( '2016-12-31' ),( '2017-01-01' ),( '2017-01-02' ),( '2017-01-03' ),( '2017-01-04' ),( '2017-01-05' ),( '2017-01-06' ),( '2017-01-07' ),( '2017-01-08' ),( '2017-01-09' ),( '2017-01-10' ),( '2017-01-11' ),( '2017-01-12' ),( '2017-01-13' ),( '2017-01-14' ),( '2017-01-15' ),( '2017-01-16' ),( '2017-01-17' ),( '2017-01-18' ),( '2017-01-19' ),( '2017-01-20' ),( '2017-01-21' ),( '2017-01-22' ),( '2017-01-23' ),( '2017-01-24' ),( '2017-01-25' ),( '2017-01-26' ),( '2017-01-27' ),( '2017-01-28' ),( '2017-01-29' ),( '2017-01-30' ),( '2017-01-31' ),( '2017-02-01' ),( '2017-02-02' ),( '2017-02-03' ),( '2017-02-04' ),( '2017-02-05' ),( '2017-02-06' ),( '2017-02-07' ),( '2017-02-08' ),( '2017-02-09' ),( '2017-02-10' ),( '2017-02-11' ),( '2017-02-12' ),( '2017-02-13' ),( '2017-02-14' ),( '2017-02-15' ),( '2017-02-16' ),( '2017-02-17' ),( '2017-02-18' ),( '2017-02-19' ),( '2017-02-20' ),( '2017-02-21' ),( '2017-02-22' ),( '2017-02-23' ),( '2017-02-24' ),( '2017-02-25' ),( '2017-02-26' ),( '2017-02-27' ),( '2017-02-28' ),( '2017-03-01' ),( '2017-03-02' ),( '2017-03-03' ),( '2017-03-04' ),( '2017-03-05' ),( '2017-03-06' ),( '2017-03-07' ),( '2017-03-08' ),( '2017-03-09' ),( '2017-03-10' ),( '2017-03-11' ),( '2017-03-12' ),( '2017-03-13' ),( '2017-03-14' ),( '2017-03-15' ),( '2017-03-16' ),( '2017-03-17' ),( '2017-03-18' ),( '2017-03-19' ),( '2017-03-20' ),( '2017-03-21' ),( '2017-03-22' ),( '2017-03-23' ),( '2017-03-24' ),( '2017-03-25' ),( '2017-03-26' ),( '2017-03-27' ),( '2017-03-28' ),( '2017-03-29' ),( '2017-03-30' ),( '2017-03-31' ),( '2017-04-01' ),( '2017-04-02' ),( '2017-04-03' ),( '2017-04-04' ),( '2017-04-05' ),( '2017-04-06' ),( '2017-04-07' ),( '2017-04-08' ),( '2017-04-09' ),( '2017-04-10' ),( '2017-04-11' ),( '2017-04-12' ),( '2017-04-13' ),( '2017-04-14' ),( '2017-04-15' ),( '2017-04-16' ),( '2017-04-17' ),( '2017-04-18' ),( '2017-04-19' ),( '2017-04-20' ),( '2017-04-21' ),( '2017-04-22' ),( '2017-04-23' ),( '2017-04-24' ),( '2017-04-25' ),( '2017-04-26' ),( '2017-04-27' ),( '2017-04-28' ),( '2017-04-29' ),( '2017-04-30' ),( '2017-05-01' ),( '2017-05-02' ),( '2017-05-03' ),( '2017-05-04' ),( '2017-05-05' ),( '2017-05-06' ),( '2017-05-07' ),( '2017-05-08' ),( '2017-05-09' ),( '2017-05-10' ),( '2017-05-11' ),( '2017-05-12' ),( '2017-05-13' ),( '2017-05-14' ),( '2017-05-15' ),( '2017-05-16' ),( '2017-05-17' ),( '2017-05-18' ),( '2017-05-19' ),( '2017-05-20' ),( '2017-05-21' ),( '2017-05-22' ),( '2017-05-23' ),( '2017-05-24' ),( '2017-05-25' ),( '2017-05-26' ),( '2017-05-27' ),( '2017-05-28' ),( '2017-05-29' ),( '2017-05-30' ),( '2017-05-31' ),( '2017-06-01' ),( '2017-06-02' ),( '2017-06-03' ),( '2017-06-04' ),( '2017-06-05' ),( '2017-06-06' ),( '2017-06-07' ),( '2017-06-08' ),( '2017-06-09' ),( '2017-06-10' ),( '2017-06-11' ),( '2017-06-12' ),( '2017-06-13' ),( '2017-06-14' ),( '2017-06-15' ),( '2017-06-16' ),( '2017-06-17' ),( '2017-06-18' ),( '2017-06-19' ),( '2017-06-20' ),( '2017-06-21' ),( '2017-06-22' ),( '2017-06-23' ),( '2017-06-24' ),( '2017-06-25' ),( '2017-06-26' ),( '2017-06-27' ),( '2017-06-28' ),( '2017-06-29' ),( '2017-06-30' ),( '2017-07-01' ),( '2017-07-02' ),( '2017-07-03' ),( '2017-07-04' ),( '2017-07-05' ),( '2017-07-06' ),( '2017-07-07' ),( '2017-07-08' ),( '2017-07-09' ),( '2017-07-10' ),( '2017-07-11' ),( '2017-07-12' ),( '2017-07-13' ),( '2017-07-14' ),( '2017-07-15' ),( '2017-07-16' ),( '2017-07-17' ),( '2017-07-18' ),( '2017-07-19' ),( '2017-07-20' ),( '2017-07-21' ),( '2017-07-22' ),( '2017-07-23' ),( '2017-07-24' ),( '2017-07-25' ),( '2017-07-26' ),( '2017-07-27' ),( '2017-07-28' ),( '2017-07-29' ),( '2017-07-30' ),( '2017-07-31' ),( '2017-08-01' ),( '2017-08-02' ),( '2017-08-03' ),( '2017-08-04' ),( '2017-08-05' ),( '2017-08-06' ),( '2017-08-07' ),( '2017-08-08' ),( '2017-08-09' ),( '2017-08-10' ),( '2017-08-11' ),( '2017-08-12' ),( '2017-08-13' ),( '2017-08-14' ),( '2017-08-15' ),( '2017-08-16' ),( '2017-08-17' ),( '2017-08-18' ),( '2017-08-19' ),( '2017-08-20' ),( '2017-08-21' ),( '2017-08-22' ),( '2017-08-23' ),( '2017-08-24' ),( '2017-08-25' ),( '2017-08-26' ),( '2017-08-27' ),( '2017-08-28' ),( '2017-08-29' ),( '2017-08-30' ),( '2017-08-31' ),( '2017-09-01' ),( '2017-09-02' ),( '2017-09-03' ),( '2017-09-04' ),( '2017-09-05' ),( '2017-09-06' ),( '2017-09-07' ),( '2017-09-08' ),( '2017-09-09' ),( '2017-09-10' ),( '2017-09-11' ),( '2017-09-12' ),( '2017-09-13' ),( '2017-09-14' ),( '2017-09-15' ),( '2017-09-16' ),( '2017-09-17' ),( '2017-09-18' ),( '2017-09-19' ),( '2017-09-20' ),( '2017-09-21' ),( '2017-09-22' ),( '2017-09-23' ),( '2017-09-24' ),( '2017-09-25' ),( '2017-09-26' ),( '2017-09-27' ),( '2017-09-28' ),( '2017-09-29' ),( '2017-09-30' ),( '2017-10-01' ),( '2017-10-02' ),( '2017-10-03' ),( '2017-10-04' ),( '2017-10-05' ),( '2017-10-06' ),( '2017-10-07' ),( '2017-10-08' ),( '2017-10-09' ),( '2017-10-10' ),( '2017-10-11' ),( '2017-10-12' ),( '2017-10-13' ),( '2017-10-14' ),( '2017-10-15' ),( '2017-10-16' ),( '2017-10-17' ),( '2017-10-18' ),( '2017-10-19' ),( '2017-10-20' ),( '2017-10-21' ),( '2017-10-22' ),( '2017-10-23' ),( '2017-10-24' ),( '2017-10-25' ),( '2017-10-26' ),( '2017-10-27' ),( '2017-10-28' ),( '2017-10-29' ),( '2017-10-30' ),( '2017-10-31' ),( '2017-11-01' ),( '2017-11-02' ),( '2017-11-03' ),( '2017-11-04' ),( '2017-11-05' ),( '2017-11-06' ),( '2017-11-07' ),( '2017-11-08' ),( '2017-11-09' ),( '2017-11-10' ),( '2017-11-11' ),( '2017-11-12' ),( '2017-11-13' ),( '2017-11-14' ),( '2017-11-15' ),( '2017-11-16' ),( '2017-11-17' ),( '2017-11-18' ),( '2017-11-19' ),( '2017-11-20' ),( '2017-11-21' ),( '2017-11-22' ),( '2017-11-23' ),( '2017-11-24' ),( '2017-11-25' ),( '2017-11-26' ),( '2017-11-27' ),( '2017-11-28' ),( '2017-11-29' ),( '2017-11-30' ),( '2017-12-01' ),( '2017-12-02' ),( '2017-12-03' ),( '2017-12-04' ),( '2017-12-05' ),( '2017-12-06' ),( '2017-12-07' ),( '2017-12-08' ),( '2017-12-09' ),( '2017-12-10' ),( '2017-12-11' ),( '2017-12-12' ),( '2017-12-13' ),( '2017-12-14' ),( '2017-12-15' ),( '2017-12-16' ),( '2017-12-17' ),( '2017-12-18' ),( '2017-12-19' ),( '2017-12-20' ),( '2017-12-21' ),( '2017-12-22' ),( '2017-12-23' ),( '2017-12-24' ),( '2017-12-25' ),( '2017-12-26' ),( '2017-12-27' ),( '2017-12-28' ),( '2017-12-29' ),( '2017-12-30' ),( '2017-12-31' );   DROP TABLE IF EXISTS `mitarbeiter`; CREATE TABLE `mitarbeiter` ( `pk` int (11) NOT NULL DEFAULT 0, `in_aw_liste` int (1) DEFAULT 1, `deaktiviert` int (1) NOT NULL DEFAULT 0 ) DEFAULT CHARSET=utf8;   INSERT INTO `mitarbeiter` VALUES (1,1,0),(2,1,0),(3,1,0),(4,1,1),(5,1,0),(6,1,1),(7,1,0),(10,0,0),(11,0,0),(12,1,0),(13,0,1),(14,0,1),(16,1,0),(17,0,1),(19,1,1),(20,0,1),(21,1,1),(22,1,0),(23,0,0),(26,1,0),(27,1,1),(28,1,0),(29,1,0),(30,1,1),(31,1,0),(32,0,1),(33,1,0),(34,1,0),(36,1,1),(37,1,0),(38,1,1),(39,1,1),(41,1,0),(43,1,0),(44,1,0),(45,1,0),(46,1,0),(47,1,0),(49,1,0),(50,1,0),(51,1,0),(52,1,0),(53,1,0),(54,0,1),(55,0,1),(56,1,1),(57,1,0),(58,1,1),(59,1,1),(60,1,1),(61,1,0),(63,0,0),(65,1,1),(66,1,1),(68,1,0),(72,1,1),(73,1,0),(74,1,0),(76,1,1),(77,1,1),(78,1,1),(79,1,1),(80,1,0),(81,1,1),(82,1,1),(83,1,0),(84,1,0),(85,0,1),(87,1,0),(88,1,1),(89,1,1),(90,1,1),(91,1,0),(92,1,0),(93,1,1),(94,1,0),(95,1,0),(96,1,0),(98,1,1),(99,1,0),(101,1,0),(102,1,1),(103,1,0),(104,1,1),(105,0,1),(106,1,1),(107,0,1),(108,1,0),(109,1,0),(110,1,0),(111,1,0),(112,1,1),(113,1,0),(114,1,1),(115,1,0),(116,1,0),(117,1,1),(118,1,0),(119,1,0),(120,1,0),(122,1,0),(123,1,1),(200,1,1),(5003,1,1),(5005,1,1),(5008,1,1),(5010,1,1),(5011,1,1),(5012,0,1),(5014,1,1),(5015,1,1),(5017,1,1),(5018,1,1),(5019,1,1),(5020,1,1),(5021,1,1),(5022,1,1),(5023,1,1),(5024,1,1),(5026,1,1),(5027,1,1),(5028,1,1),(5029,1,1),(5030,1,1),(5031,1,1),(5032,1,1),(5033,1,1),(5034,1,1),(5036,1,1),(100001,0,1),(100002,0,0),(100003,1,1),(100004,1,1),(100005,1,0),(100006,1,1),(100007,0,1),(100008,1,1),(100009,1,1),(100010,1,1),(100011,1,1),(100012,1,1),(100013,1,0),(100014,1,1),(100015,0,0),(100016,1,1),(100017,1,1),(100018,1,1),(100019,1,1),(100020,1,1),(100021,1,1),(100022,1,0),(100023,1,1),(100024,1,1),(100025,1,1),(100026,1,0),(100027,1,1),(100028,1,0),(100029,0,1),(100030,1,1),(100031,1,1),(100032,1,1),(100033,1,1),(100035,1,1),(100036,1,1),(100037,1,1),(100038,1,1),(100039,1,1),(100040,0,1),(100041,1,1),(100042,1,1),(100049,1,1),(100050,1,1),(100051,1,1),(100052,1,0),(100053,1,1),(100054,1,0),(100055,1,1),(100056,1,0),(100057,1,1),(100058,1,1),(100059,1,1),(100060,1,1),(100061,1,1),(100062,1,1),(100063,1,0),(100064,1,1),(100065,1,0),(100066,1,1),(100067,1,1),(100068,1,0),(100069,1,1),(100070,1,1),(100071,1,1),(100072,1,1),(100073,1,1),(100074,1,1),(100075,1,1),(100076,1,1),(100077,1,0),(100078,1,1),(100079,1,1),(100080,1,1),(100081,1,1),(100082,1,1),(100083,1,0),(100084,1,0),(100085,0,1),(100086,1,1),(100087,1,1),(100088,1,1),(100089,1,0),(100090,1,1),(100091,1,1),(100092,1,1),(100093,1,1),(100094,1,0),(100095,0,1),(100096,0,1),(100097,0,1),(100098,0,1),(100099,0,1),(100100,0,1),(100101,1,1),(100102,1,0),(100103,1,1),(100104,1,1),(100105,0,1),(100106,0,1),(100107,0,1),(100108,0,1),(100109,0,1),(100110,0,1),(100111,0,1),(100112,0,1),(100113,0,1),(100114,0,1),(100115,0,1),(100116,0,1),(100117,0,1),(100118,0,1),(100119,0,1),(100120,0,1),(100121,1,1),(100122,1,1),(100123,1,1),(100124,1,0),(100125,1,0),(100126,1,1),(100127,0,1),(100128,0,1),(100129,0,1),(100131,1,1),(100132,1,0),(100133,1,0),(100134,1,1),(100135,1,1),(100136,0,0),(100137,0,1),(100138,0,1),(100139,0,1),(100140,0,1),(100141,0,1),(100142,0,1),(100143,0,1),(100144,0,1),(100145,1,1),(100146,1,0),(100147,1,0),(100148,0,1),(100149,0,1),(100150,1,1),(100151,0,1),(100152,0,1),(100153,1,1),(100154,0,1),(100155,0,1),(100156,0,1),(100157,0,1),(100158,0,1),(100159,1,0),(100160,1,0),(100161,1,0),(100162,1,1),(100163,1,1),(100164,1,0),(100165,0,0),(100166,1,1),(100167,0,1),(100168,1,1),(100169,1,1),(100170,1,1),(100171,1,1),(100172,1,1),(100173,0,0),(100174,1,1),(100175,0,1),(100176,1,1),(100177,0,1),(100178,0,1),(100179,1,1),(100180,0,0),(100181,1,1),(100182,1,1),(100183,1,0),(100184,0,1),(100185,0,1),(100186,1,1),(100187,1,1),(100188,1,1),(100189,1,1),(100190,1,0),(100191,1,1),(100192,1,1),(100193,1,1),(100194,1,0),(100195,1,0),(100196,1,1),(100197,1,1),(100198,1,0),(100199,1,0),(100200,1,1),(100201,1,1),(100202,1,1),(100203,1,1),(100204,1,1),(100205,1,0),(100206,1,1),(100207,1,1),(100208,1,0),(100209,1,1),(100210,0,1),(100211,1,1),(100212,1,1),(100213,0,1),(100214,1,1),(100215,1,1),(100216,1,0),(100217,1,1),(100218,1,0),(100219,0,1),(100220,1,0),(100221,1,1),(100222,1,1),(100223,1,1),(100224,1,1),(100225,1,1),(100226,1,0),(100227,1,1),(100228,1,1),(100229,1,1),(100230,1,1),(100231,1,1),(100232,1,1),(100233,1,1),(100234,1,1),(100235,1,1),(100236,1,1),(100237,1,1),(100238,1,1),(100239,1,1),(100240,1,1),(100241,1,1),(100242,1,1),(100243,1,1),(100244,1,0),(100245,1,1),(100246,1,0),(100247,1,0),(100248,1,0),(100249,1,0),(100250,1,0),(100251,1,1),(100252,1,1),(100253,1,1),(100254,1,1),(100255,1,0),(100256,1,1),(100257,1,1),(100258,1,0),(100259,1,1),(100260,1,0),(100261,1,1),(100262,1,1),(100263,1,1),(100264,1,1),(100265,1,0),(100266,1,1),(100267,1,1),(100268,1,0),(100269,1,0),(100270,1,0),(100271,1,0),(100272,1,0),(100273,1,0),(100274,1,0),(100275,1,0),(100276,1,0),(100277,1,1),(100278,1,1),(100279,1,0),(100280,1,0),(100281,0,1),(100282,1,0),(100283,1,1),(100284,1,1),(100285,1,1),(100286,1,0),(100287,1,1),(100288,1,0),(100289,1,0),(100290,1,1),(100291,1,0),(100292,1,1),(100293,1,1),(100294,1,0),(100295,1,0),(100296,1,0),(100297,1,1),(100298,1,1),(100299,1,1),(100300,1,1),(100301,1,0),(100302,1,1),(100303,1,1),(100304,1,0),(100305,1,0),(100306,1,0),(100307,1,1),(100308,1,0),(100309,1,0),(100310,1,0),(100311,1,0),(100312,1,0),(100313,1,0),(100314,1,1),(100315,1,0),(100316,1,1),(100317,1,0),(100318,1,0),(100319,1,0),(100320,1,1),(100321,1,0),(100322,1,0),(100323,1,1),(100324,1,0),(100325,1,0),(100326,1,1),(100327,1,0),(100328,1,1),(100329,1,1),(100330,1,1),(100331,1,0),(100332,1,0),(100333,1,0),(100334,1,0),(100335,1,0),(100336,1,0),(100337,1,0),(100338,1,0),(100339,1,0),(100340,1,0),(100341,1,1),(100342,1,1),(100344,1,1),(100347,1,1),(100350,1,0),(100355,1,0),(100358,1,0),(100361,1,0),(100364,1,1),(100367,1,1),(100370,1,1),(100373,1,1),(100376,1,1),(100379,1,1),(100382,1,0),(100385,1,1),(100388,1,1),(100391,1,1),(100394,1,0),(100397,1,0),(100400,1,1),(100401,1,1),(100404,1,0),(100407,1,0),(100410,1,0),(100413,1,0),(100416,1,0),(100419,1,0),(100422,1,0),(100425,1,0),(100428,1,1),(100431,1,1),(100434,1,1),(100437,1,0),(100440,1,0),(100443,1,0),(100446,1,0),(100449,1,0),(100452,1,0),(100455,1,1),(100458,1,0),(100461,1,0),(100464,1,1),(100465,1,0),(100466,1,0),(100469,1,1),(100472,1,1),(100475,1,0),(100478,1,0),(100481,1,0),(100484,1,1),(100487,1,0),(100490,1,1),(100493,1,0),(100496,1,0),(100499,1,0),(100502,1,0),(100505,1,1),(100508,1,1),(100512,1,0),(100513,1,1),(100517,0,1),(100520,0,1),(100521,1,0),(100524,1,0),(100527,1,0),(100530,1,0),(100534,1,0),(100540,1,1),(100547,1,1),(100552,1,1),(100560,1,0),(100568,1,0),(100576,0,1),(100584,0,1),(100591,0,0),(100599,0,1),(100603,0,1),(100607,0,1),(100615,1,0),(100623,1,0),(100627,1,0),(100635,1,1),(100643,1,1),(100651,1,0),(100659,1,0),(100667,1,0),(100671,1,0),(100679,1,0),(100687,1,1),(100695,1,0),(100699,1,1),(100707,1,0),(100715,0,0),(100719,0,1),(100727,0,1),(100735,0,1),(100739,0,0),(100743,1,0),(100751,1,0),(100759,1,0),(100764,0,0),(100770,1,0),(100775,1,0),(100783,0,0),(100791,1,0),(100799,1,0),(100803,1,0),(100811,1,0),(100815,1,0),(100823,1,0),(100831,1,0),(100839,1,0),(100841,1,0);   select distinct mar.deaktiviert, in_aw_liste from mitarbeiter mar join tage t where t.datum >= '2017-04-01' and mar.deaktiviert = 0 and in_aw_liste=1;   DROP TABLE mitarbeiter, tage;
            elenst Elena Stepanova made changes -
            Labels index join index join need_feedback
            wandazorro Helmut Zeilinger made changes -
            Attachment tage.sql [ 43608 ]
            Attachment mitarbeiter.sql [ 43609 ]
            Description Two Tables:

            {code:sql}
            CREATE TABLE `tage` (
              `datum` date NOT NULL,
              KEY `i_datum` (`datum`)
            ) ENGINE=InnoDB DEFAULT CHARSET=utf8

            CREATE TABLE `mitarbeiter` (
              `pk` int(11) NOT NULL DEFAULT 0,
              `in_aw_liste` int(1) DEFAULT 1,
              `deaktiviert` int(1) NOT NULL DEFAULT 0
            ) ENGINE=InnoDB DEFAULT CHARSET=utf8
            {code}

            Query:

            {code:sql}
            select distinct mar.deaktiviert, in_aw_liste from mitarbeiter mar join tage t where t.datum >= '2017-04-01' and mar.deaktiviert = 0 and in_aw_liste=1;
            {code}

            Result in Version 10.2.5:

            {noformat}
            +-------------+-------------+
            | deaktiviert | in_aw_liste |
            +-------------+-------------+
            | 0 | 1 |
            | 1 | 1 |
            | 0 | 0 |
            | 1 | 0 |
            +-------------+-------------+
            {noformat}

            but should be (as in Version 10.2.3 or/and without the index i_datum):

            {noformat}
            +-------------+-------------+
            | deaktiviert | in_aw_liste |
            +-------------+-------------+
            | 0 | 1 |
            +-------------+-------------+
            {noformat}
            		Two Tables:

            {code:sql}
            CREATE TABLE `tage` (
              `datum` date NOT NULL,
              KEY `i_datum` (`datum`)
            ) ENGINE=InnoDB DEFAULT CHARSET=utf8

            CREATE TABLE `mitarbeiter` (
              `pk` int(11) NOT NULL DEFAULT 0,
              `in_aw_liste` int(1) DEFAULT 1,
              `deaktiviert` int(1) NOT NULL DEFAULT 0
            ) ENGINE=InnoDB DEFAULT CHARSET=utf8
            {code}

            Query:

            {code:sql}
            select distinct mar.deaktiviert, in_aw_liste from mitarbeiter mar join tage t where t.datum >= '2017-04-01' and mar.deaktiviert = 0 and in_aw_liste=1;
            {code}

            Result in Version 10.2.5:

            {noformat}
            +-------------+-------------+
            | deaktiviert | in_aw_liste |
            +-------------+-------------+
            | 0 | 1 |
            | 1 | 1 |
            | 0 | 0 |
            | 1 | 0 |
            +-------------+-------------+
            {noformat}

            but should be (as in Version 10.2.3 or/and without the index i_datum):

            {noformat}
            +-------------+-------------+
            | deaktiviert | in_aw_liste |
            +-------------+-------------+
            | 0 | 1 |
            +-------------+-------------+
            {noformat}

            The result of

            {code:sql}
            explain extended select distinct mar.deaktiviert, in_aw_liste from mitarbeiter mar join tage t where t.datum >= '2017-04-01' and mar.deaktiviert = 0 and in_aw_liste=1;
            {code}

            with index i_datum

            {noformat}
            +------+-------------+-------+-------+---------------+---------+---------+------+------+----------+-------------------------------------------+
            | id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
            +------+-------------+-------+-------+---------------+---------+---------+------+------+----------+-------------------------------------------+
            | 1 | SIMPLE | t | range | i_datum | i_datum | 3 | NULL | 275 | 100.00 | Using where; Using index; Using temporary |
            | 1 | SIMPLE | mar | ALL | NULL | NULL | NULL | NULL | 575 | 100.00 | Using where |
            +------+-------------+-------+-------+---------------+---------+---------+------+------+----------+-------------------------------------------+
            {noformat}

            {code:sql}
            show warnings;
            {code}

            {noformat}
            +-------+------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
            | Level | Code | Message |
            +-------+------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
            | Note | 1003 | select distinct `tmp`.`mar`.`deaktiviert` AS `deaktiviert`,`tmp`.`mar`.`in_aw_liste` AS `in_aw_liste` from `tmp`.`mitarbeiter` `mar` join `tmp`.`tage` `t` where `tmp`.`mar`.`deaktiviert` = 0 and `tmp`.`mar`.`in_aw_liste` = 1 and `tmp`.`t`.`datum` >= '2017-04-01' |
            +-------+------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
            {noformat}

            The same without index on tage (datum):

            {noformat}
            +------+-------------+-------+------+---------------+------+---------+------+------+----------+------------------------------+
            | id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
            +------+-------------+-------+------+---------------+------+---------+------+------+----------+------------------------------+
            | 1 | SIMPLE | mar | ALL | NULL | NULL | NULL | NULL | 575 | 100.00 | Using where; Using temporary |
            | 1 | SIMPLE | t | ALL | NULL | NULL | NULL | NULL | 4018 | 100.00 | Using where |
            +------+-------------+-------+------+---------------+------+---------+------+------+----------+------------------------------+
            {noformat}

            Warning:

            {noformat}
            +-------+------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
            | Level | Code | Message |
            +-------+------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
            | Note | 1003 | select distinct `tmp`.`mar`.`deaktiviert` AS `deaktiviert`,`tmp`.`mar`.`in_aw_liste` AS `in_aw_liste` from `tmp`.`mitarbeiter` `mar` join `tmp`.`tage` `t` where `tmp`.`mar`.`deaktiviert` = 0 and `tmp`.`mar`.`in_aw_liste` = 1 and `tmp`.`t`.`datum` >= '2017-04-01' |
            +-------+------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
            {noformat}
            elenst Elena Stepanova made changes -
            Labels index join need_feedback index join
            elenst Elena Stepanova made changes -
            Status Open [ 1 ] Confirmed [ 10101 ]
            elenst Elena Stepanova made changes -
            Component/s Server [ 13907 ]
            Fix Version/s 10.2 [ 14601 ]
            Assignee Sergei Golubchik [ serg ]
            Labels index join 10.2-ga index join regression
            serg Sergei Golubchik added a comment - - edited

            A smaller test case:

            --source include/have_innodb.inc
            		 
            create table t1 (c1 date not null, key (c1)) engine=innodb;
            		 
            insert t1 values ('2017-12-27');
            		 
            create table t2 (pk int, f1 int, f2 int);
            		 
            insert t2 values (4,1,1), (6,1,1);
            		 
            set join_buffer_size = 222222208;
            		 
            select f2 from t2,t1 where f2 = 0;
            		 
            drop table t1, t2;

            Returns

            f2
            		 
            1
            		 
            1

            clearly violating WHERE clause

            serg Sergei Golubchik added a comment - - edited A smaller test case: --source include/have_innodb.inc create table t1 (c1 date not null , key (c1)) engine=innodb; insert t1 values ( '2017-12-27' ); create table t2 (pk int , f1 int , f2 int ); insert t2 values (4,1,1), (6,1,1); set join_buffer_size = 222222208; select f2 from t2,t1 where f2 = 0; drop table t1, t2; Returns f2 1 1 clearly violating WHERE clause
            serg Sergei Golubchik made changes -
            Status Confirmed [ 10101 ] In Progress [ 3 ]
            serg Sergei Golubchik made changes -
            serg Sergei Golubchik made changes -
            Assignee Sergei Golubchik [ serg ] Igor Babaev [ igor ]
            Status In Progress [ 3 ] In Review [ 10002 ]
            igor Igor Babaev (Inactive) added a comment -

            Sergei,
            Can you explain why we have this change:

            @@ -772,20 +774,20 @@ WHERE alias3.c IN ( SELECT 1 UNION SELECT 6 )
            		 
             GROUP BY field1, field2, field3, field4, field5
            		 
             LIMIT ROWS EXAMINED 124;
            		 
             field1	field2	field3	field4	field5
            		 
            -00:21:38	06:07:10	a	2007-06-08 04:35:26	2007-05-28 00:00:00
            		 
             Warnings:
            		 
             Warning	1931	Query execution was interrupted. The query examined at least 125 rows, which exceeds LIMIT ROWS EXAMINED (124). The query result may be incomplete
            		 
            +Warning	1931	Query execution was interrupted. The query examined at least 127 rows, which exceeds LIMIT ROWS EXAMINED (124). The query result may be incomplete

            igor Igor Babaev (Inactive) added a comment - Sergei, Can you explain why we have this change: @@ -772,20 +774,20 @@ WHERE alias3.c IN ( SELECT 1 UNION SELECT 6 ) GROUP BY field1, field2, field3, field4, field5 LIMIT ROWS EXAMINED 124; field1 field2 field3 field4 field5 -00:21:38 06:07:10 a 2007-06-08 04:35:26 2007-05-28 00:00:00 Warnings: Warning 1931 Query execution was interrupted. The query examined at least 125 rows, which exceeds LIMIT ROWS EXAMINED (124). The query result may be incomplete +Warning 1931 Query execution was interrupted. The query examined at least 127 rows, which exceeds LIMIT ROWS EXAMINED (124). The query result may be incomplete
            serg Sergei Golubchik added a comment - - edited

            Yes. There are a couple of issues with LIMIT ROW EXAMINED.

            • if the limit is hit inside filesort, it's an error "Sort aborted", otherwise — a warning. So, what you get depends on the exact limit value, number of rows in the table, optimizer switches, etc.

            That explains the first change in limit_rows_examined.result — optimizer uses a different plan, so "Sort aborted" error is changed into a warning, the limit no longer hits filesort.

            • When the limit is hit, select stops retrieving rows and clears thd->killed.

            What happens now — the limit is hit inside a subquery, in sql_union.cc, subquery stops, but then the limit is hit again in the parent query, in handle_select(). That's why there're two warnings.

            And no result row because of the first reason — there is filesort now. If I increase limit rows examined, I hit "Sort aborted" error. If the limit is below filesort, no result rows has been produced yet.

            serg Sergei Golubchik added a comment - - edited Yes. There are a couple of issues with LIMIT ROW EXAMINED . if the limit is hit inside filesort, it's an error "Sort aborted", otherwise — a warning. So, what you get depends on the exact limit value, number of rows in the table, optimizer switches, etc. That explains the first change in limit_rows_examined.result — optimizer uses a different plan, so "Sort aborted" error is changed into a warning, the limit no longer hits filesort. When the limit is hit, select stops retrieving rows and clears thd->killed . What happens now — the limit is hit inside a subquery, in sql_union.cc , subquery stops, but then the limit is hit again in the parent query, in handle_select() . That's why there're two warnings. And no result row because of the first reason — there is filesort now. If I increase limit rows examined, I hit "Sort aborted" error. If the limit is below filesort, no result rows has been produced yet.
            igor Igor Babaev (Inactive) added a comment -

            Sergei,
            You can push this patch.

            igor Igor Babaev (Inactive) added a comment - Sergei, You can push this patch.
            igor Igor Babaev (Inactive) made changes -
            Status In Review [ 10002 ] Stalled [ 10000 ]
            igor Igor Babaev (Inactive) made changes -
            Assignee Igor Babaev [ igor ] Sergei Golubchik [ serg ]
            serg Sergei Golubchik made changes -
            Component/s Optimizer [ 10200 ]
            Component/s Server [ 13907 ]
            Fix Version/s 10.2.6 [ 22527 ]
            Fix Version/s 10.2 [ 14601 ]
            Resolution Fixed [ 1 ]
            Status Stalled [ 10000 ] Closed [ 6 ]
            serg Sergei Golubchik made changes -
            Workflow MariaDB v3 [ 80453 ] MariaDB v4 [ 152006 ]

            People

              serg Sergei Golubchik
              wandazorro Helmut Zeilinger
              Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Git Integration

                  Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.