--source include/have_innodb.inc CREATE TABLE D (a INT) ENGINE=InnoDB; CREATE TABLE E ( pk INTEGER AUTO_INCREMENT, col_int_nokey INTEGER /*! NULL */, col_int_key INTEGER AS (col_int_nokey * 2) VIRTUAL, col_date_key DATE AS (DATE_SUB(col_date_nokey, INTERVAL 1 DAY)) VIRTUAL, col_date_nokey DATE /*! NULL */, col_time_key TIME AS (TIME(col_time_nokey)) VIRTUAL, col_time_nokey TIME /*! NULL */, col_datetime_key DATETIME AS (DATE_ADD(col_datetime_nokey, INTERVAL 1 HOUR)) VIRTUAL, col_datetime_nokey DATETIME /*! NULL */, col_varchar_key VARCHAR(1) AS (CONCAT('virt-',col_varchar_nokey)) VIRTUAL, col_varchar_nokey VARCHAR(1) /*! NULL */, PRIMARY KEY (pk), KEY (col_varchar_key, col_int_key) ) ENGINE=InnoDB; INSERT INTO E ( col_int_key, col_int_nokey, col_date_key, col_date_nokey, col_time_key, col_time_nokey, col_datetime_key, col_datetime_nokey, col_varchar_key, col_varchar_nokey ) VALUES (7, 9, '2005-07-23', '2005-07-23', '15:01:53.007896', '15:01:53.007896', '2004-05-13 01:01:39.020951', '2004-05-13 01:01:39.020951', 't', 't'),(4, 2, '2009-11-01', '2009-11-01', '15:44:41.053734', '15:44:41.053734', '2003-12-24 07:39:29.020532', '2003-12-24 07:39:29.020532', 'h', 'h'),(9, 6, NULL, NULL, NULL, NULL, '2008-07-03 05:32:22.042740', '2008-07-03 05:32:22.042740', 'l', 'l'),(0, 6, '2007-07-16', '2007-07-16', '13:32:31.059995', '13:32:31.059995', '2008-08-28 18:46:11.030956', '2008-08-28 18:46:11.030956', 'j', 'j'),(3, 5, NULL, NULL, '19:08:59.062416', '19:08:59.062416', '2001-07-12 21:27:00.024781', '2001-07-12 21:27:00.024781', 'h', 'h'),(8, 3, '2007-07-22', '2007-07-22', '13:06:13.033877', '13:06:13.033877', '1900-01-01 00:00:00', '1900-01-01 00:00:00', 'p', 'p'),(9, 2, '2000-11-21', '2000-11-21', NULL, NULL, '2007-05-25 11:58:54.015689', '2007-05-25 11:58:54.015689', 'g', 'g'),(9, 6, '1900-01-01', '1900-01-01', '00:00:00', '00:00:00', '2009-06-03 17:11:10.011464', '2009-06-03 17:11:10.011464', 'i', 'i'),(4, 2, '2008-02-10', '2008-02-10', '23:02:06.047880', '23:02:06.047880', '2001-06-15 16:20:07.027178', '2001-06-15 16:20:07.027178', 'p', 'p'),(7, 3, '2009-06-04', '2009-06-04', '08:05:21.035383', '08:05:21.035383', '1900-01-01 00:00:00', '1900-01-01 00:00:00', 'h', 'h'),(1, 9, '2007-04-25', '2007-04-25', '20:26:40.010634', '20:26:40.010634', '1900-01-01 00:00:00', '1900-01-01 00:00:00', 'e', 'e'),(8, 9, '2006-03-02', '2006-03-02', '12:47:47.026796', '12:47:47.026796', '1900-01-01 00:00:00', '1900-01-01 00:00:00', 'e', 'e'),(6, 1, '1900-01-01', '1900-01-01', NULL, NULL, '2002-11-08 09:33:27.034302', '2002-11-08 09:33:27.034302', 'u', 'u'),(6, 7, '2008-07-13', '2008-07-13', '00:00:00', '00:00:00', '2007-08-07 17:35:52.017101', '2007-08-07 17:35:52.017101', 'j', 'j'),(6, 0, '2004-11-12', '2004-11-12', '20:58:23.064148', '20:58:23.064148', '2006-05-01 00:00:00', '2006-05-01 00:00:00', 'e', 'e'),(1, 0, '1900-01-01', '1900-01-01', '00:00:00', '00:00:00', '2003-05-01 00:00:00', '2003-05-01 00:00:00', 'z', 'z'),(227, 112, '2009-09-02', '2009-09-02', '07:43:46.015324', '07:43:46.015324', '2007-02-12 09:30:49.063767', '2007-02-12 09:30:49.063767', 'w', 'w'),(NULL, 0, '2004-11-06', '2004-11-06', '21:16:35.040813', '21:16:35.040813', '1900-01-01 00:00:00', '1900-01-01 00:00:00', 't', 't'),(9, 4, '2003-01-06', '2003-01-06', '15:54:47.061688', '15:54:47.061688', '2002-07-03 02:51:11.057287', '2002-07-03 02:51:11.057287', 'i', 'i'),(1, 6, '2006-01-14', '2006-01-14', '20:29:36.026082', '20:29:36.026082', '2008-02-26 04:57:32.018208', '2008-02-26 04:57:32.018208', 'i', 'i'),(8, 0, '2002-01-19', '2002-01-19', '05:18:40.006865', '05:18:40.006865', '2009-02-12 00:00:00', '2009-02-12 00:00:00', 'i', 'i'),(5, 8, '2007-02-12', '2007-02-12', NULL, NULL, '1900-01-01 00:00:00', '1900-01-01 00:00:00', 'b', 'b'),(8, 4, '1900-01-01', '1900-01-01', '00:44:45.033511', '00:44:45.033511', '2001-05-16 05:28:40.005808', '2001-05-16 05:28:40.005808', 'm', 'm'),(7, 2, '2005-07-16', '2005-07-16', '23:16:07.026979', '23:16:07.026979', NULL, NULL, 'j', 'j'),(2, 1, '2004-09-04', '2004-09-04', '02:05:51.032461', '02:05:51.032461', '2001-01-24 21:45:18.038169', '2001-01-24 21:45:18.038169', 'v', 'v'),(4, 3, '2009-07-01', '2009-07-01', '13:34:23.036481', '13:34:23.036481', NULL, NULL, NULL, NULL),(3, 2, '2009-07-21', '2009-07-21', '07:04:18.014012', '07:04:18.014012', '2002-07-24 00:00:00', '2002-07-24 00:00:00', 'h', 'h'),(1, 4, NULL, NULL, '16:19:19.003601', '16:19:19.003601', '2001-11-03 12:22:30.004586', '2001-11-03 12:22:30.004586', 'q', 'q'),(140, 144, '2002-06-22', '2002-06-22', '15:14:52.048461', '15:14:52.048461', '2008-06-17 03:17:59.000622', '2008-06-17 03:17:59.000622', 'f', 'f'),(0, 7, '2005-06-23', '2005-06-23', '23:33:23.054970', '23:33:23.054970', '2005-12-24 00:00:00', '2005-12-24 00:00:00', 'p', 'p'),(6, 6, '2001-05-20', '2001-05-20', NULL, NULL, '2008-10-23 00:00:00', '2008-10-23 00:00:00', NULL, NULL),(8, 3, '2001-10-01', '2001-10-01', '03:34:01.048002', '03:34:01.048002', '2000-10-12 16:32:35.040067', '2000-10-12 16:32:35.040067', 'o', 'o'),(6, 3, '2001-01-07', '2001-01-07', '00:00:00', '00:00:00', '2005-09-11 10:09:54.058784', '2005-09-11 10:09:54.058784', 'w', 'w'),(0, 6, '2007-11-02', '2007-11-02', '12:23:27.002886', '12:23:27.002886', '2009-09-10 01:44:18.063431', '2009-09-10 01:44:18.063431', 'l', 'l'),(0, 6, NULL, NULL, NULL, NULL, NULL, NULL, 'i', 'i'),(NULL, 9, NULL, NULL, '09:41:12.040690', '09:41:12.040690', '2002-05-18 15:21:55.029222', '2002-05-18 15:21:55.029222', 'd', 'd'),(9, 4, '2008-12-21', '2008-12-21', '01:56:54.023346', '01:56:54.023346', '2004-10-15 10:09:54.052542', '2004-10-15 10:09:54.052542', 'j', 'j'),(0, 6, '2003-10-05', '2003-10-05', '20:32:50.052486', '20:32:50.052486', '2009-07-13 03:51:02.028166', '2009-07-13 03:51:02.028166', 'e', 'e'),(5, 2, '2001-03-03', '2001-03-03', '12:24:59.017466', '12:24:59.017466', '1900-01-01 00:00:00', '1900-01-01 00:00:00', 'e', 'e'),(169, 28, '2007-04-04', '2007-04-04', '23:31:22.033214', '23:31:22.033214', '2001-11-08 21:14:52.045368', '2001-11-08 21:14:52.045368', 'q', 'q'),(8, 5, NULL, NULL, '11:11:27.003079', '11:11:27.003079', '2006-12-02 00:00:00', '2006-12-02 00:00:00', 'm', 'm'),(2, NULL, '2009-01-04', '2009-01-04', '00:00:00', '00:00:00', '1900-01-01 00:00:00', '1900-01-01 00:00:00', NULL, NULL),(8, 8, '2008-04-03', '2008-04-03', '01:17:44.047711', '01:17:44.047711', '2005-01-01 11:55:18.027373', '2005-01-01 11:55:18.027373', 'q', 'q'),(9, 8, NULL, NULL, '00:00:00', '00:00:00', '2005-02-28 03:44:02.034839', '2005-02-28 03:44:02.034839', 'w', 'w'),(NULL, 0, '2003-08-22', '2003-08-22', '22:07:31.039364', '22:07:31.039364', NULL, NULL, 'c', 'c'),(7, 9, '1900-01-01', '1900-01-01', '20:27:30.021356', '20:27:30.021356', NULL, NULL, 'y', 'y'),(8, NULL, NULL, NULL, '08:11:41.025328', '08:11:41.025328', '2006-08-25 16:28:09.055065', '2006-08-25 16:28:09.055065', 'g', 'g'),(9, 5, '2004-07-04', '2004-07-04', '00:00:00', '00:00:00', '2002-08-11 00:00:00', '2002-08-11 00:00:00', 'z', 'z'),(103, 172, '1900-01-01', '1900-01-01', '00:42:57.032859', '00:42:57.032859', '2007-07-22 21:19:18.023363', '2007-07-22 21:19:18.023363', 'm', 'm'),(3, 2, '2007-02-04', '2007-02-04', NULL, NULL, '2006-02-10 18:41:38.028428', '2006-02-10 18:41:38.028428', 't', 't'),(48, 244, '1900-01-01', '1900-01-01', NULL, NULL, '2009-02-16 14:58:58.035762', '2009-02-16 14:58:58.035762', 'd', 'd'),(8, 7, '2001-03-14', '2001-03-14', '23:28:51.063369', '23:28:51.063369', '2007-08-14 00:00:00', '2007-08-14 00:00:00', 'h', 'h'),(9, 0, NULL, NULL, NULL, NULL, '1900-01-01 00:00:00', '1900-01-01 00:00:00', NULL, NULL),(2, 1, '2008-10-05', '2008-10-05', '20:31:20.029466', '20:31:20.029466', NULL, NULL, 'f', 'f'),(0, 6, '2001-11-25', '2001-11-25', '21:39:14.036494', '21:39:14.036494', '2008-12-03 06:59:23.009921', '2008-12-03 06:59:23.009921', 'l', 'l'),(205, NULL, '2003-01-27', '2003-01-27', '02:10:00.025845', '02:10:00.025845', '2008-10-04 00:00:00', '2008-10-04 00:00:00', 'g', 'g'),(NULL, 8, '2008-08-08', '2008-08-08', '02:03:54.028936', '02:03:54.028936', '2009-07-07 07:00:21.041778', '2009-07-07 07:00:21.041778', 'v', 'v'),(3, 8, '2006-07-03', '2006-07-03', '22:37:33.064975', '22:37:33.064975', '2001-04-15 00:00:00', '2001-04-15 00:00:00', NULL, NULL),(3, 5, '2002-11-21', '2002-11-21', '12:17:48.022067', '12:17:48.022067', '2007-07-08 04:01:58.053285', '2007-07-08 04:01:58.053285', 'm', 'm'),(1, 5, '2006-04-08', '2006-04-08', '17:18:11.045199', '17:18:11.045199', '2007-09-23 00:01:35.034137', '2007-09-23 00:01:35.034137', 'i', 'i'),(4, 5, '2001-05-06', '2001-05-06', '09:10:39.028897', '09:10:39.028897', '2008-05-15 00:00:00', '2008-05-15 00:00:00', 'h', 'h'),(3, 7, '1900-01-01', '1900-01-01', NULL, NULL, '1900-01-01 00:00:00', '1900-01-01 00:00:00', 'u', 'u'),(224, 30, '2007-04-16', '2007-04-16', NULL, NULL, '2004-03-05 23:35:38.005131', '2004-03-05 23:35:38.005131', 'o', 'o'),(5, NULL, '1900-01-01', '1900-01-01', '19:22:16.015548', '19:22:16.015548', '2007-08-25 01:32:47.008806', '2007-08-25 01:32:47.008806', 'z', 'z'),(9, 6, '2004-12-03', '2004-12-03', '06:10:18.037692', '06:10:18.037692', '1900-01-01 00:00:00', '1900-01-01 00:00:00', 'o', 'o'),(1, 8, '2001-06-23', '2001-06-23', '01:13:18.058150', '01:13:18.058150', '1900-01-01 00:00:00', '1900-01-01 00:00:00', 'f', 'f'),(2, NULL, '2008-12-15', '2008-12-15', '18:52:35.005366', '18:52:35.005366', '2001-05-19 08:28:28.039933', '2001-05-19 08:28:28.039933', 'a', 'a'),(7, 9, '2000-02-15', '2000-02-15', NULL, NULL, '2009-09-03 06:07:22.008308', '2009-09-03 06:07:22.008308', 'd', 'd'),(NULL, 2, '2001-08-05', '2001-08-05', '23:06:15.000718', '23:06:15.000718', '2006-10-08 07:17:27.035884', '2006-10-08 07:17:27.035884', 'k', 'k'),(2, 5, '2004-01-17', '2004-01-17', '08:30:40.000924', '08:30:40.000924', '2003-09-06 20:36:01.002386', '2003-09-06 20:36:01.002386', 'd', 'd'),(NULL, 4, '2003-10-01', '2003-10-01', '15:34:56.022049', '15:34:56.022049', '2001-02-05 18:10:49.016231', '2001-02-05 18:10:49.016231', 'u', 'u'),(6, 4, '2003-07-28', '2003-07-28', NULL, NULL, '2001-01-07 16:11:37.029378', '2001-01-07 16:11:37.029378', 'h', 'h'),(NULL, 0, '1900-01-01', '1900-01-01', '02:12:41.017388', '02:12:41.017388', '2008-08-01 05:26:38.022655', '2008-08-01 05:26:38.022655', 'w', 'w'),(5, 9, '1900-01-01', '1900-01-01', '18:36:00.006583', '18:36:00.006583', '2001-05-08 00:00:00', '2001-05-08 00:00:00', 't', 't'),(4, 1, '2000-04-17', '2000-04-17', '00:40:07.063490', '00:40:07.063490', '2008-07-10 21:26:28.060686', '2008-07-10 21:26:28.060686', 'i', 'i'),(2, 8, '2002-01-05', '2002-01-05', '09:53:23.016697', '09:53:23.016697', '2006-08-06 20:56:35.046044', '2006-08-06 20:56:35.046044', 'k', 'k'),(NULL, 9, '2001-04-10', '2001-04-10', '13:46:23.009802', '13:46:23.009802', '2003-02-17 00:00:00', '2003-02-17 00:00:00', 'z', 'z'),(9, 0, '2009-12-04', '2009-12-04', '00:00:00', '00:00:00', NULL, NULL, 'h', 'h'),(8, 7, NULL, NULL, '16:15:25.055155', '16:15:25.055155', '2004-10-27 00:29:57.038535', '2004-10-27 00:29:57.038535', 'h', 'h'),(7, 2, '2006-03-07', '2006-03-07', '13:08:22.047664', '13:08:22.047664', '2008-03-04 06:14:13.038463', '2008-03-04 06:14:13.038463', 'b', 'b'),(8, 0, '2001-10-15', '2001-10-15', '12:54:48.043906', '12:54:48.043906', '2001-03-17 00:00:00', '2001-03-17 00:00:00', 'm', 'm'),(NULL, 5, '1900-01-01', '1900-01-01', '00:00:00', '00:00:00', '2009-02-21 11:35:50.034553', '2009-02-21 11:35:50.034553', 'i', 'i'),(0, 4, NULL, NULL, '20:56:23.065393', '20:56:23.065393', '1900-01-01 00:00:00', '1900-01-01 00:00:00', 'w', 'w'),(1, 5, '2009-04-05', '2009-04-05', '04:25:03.030845', '04:25:03.030845', '1900-01-01 00:00:00', '1900-01-01 00:00:00', 'm', 'm'),(NULL, 6, '2001-03-19', '2001-03-19', '00:00:00', '00:00:00', '2001-04-12 00:00:00', '2001-04-12 00:00:00', 'q', 'q'),(9, NULL, '2009-12-08', '2009-12-08', '00:00:00', '00:00:00', '2001-12-04 20:21:01.004651', '2001-12-04 20:21:01.004651', 'k', 'k'),(9, 2, '2005-02-09', '2005-02-09', '00:58:58.048190', '00:58:58.048190', '2001-05-27 08:41:01.063012', '2001-05-27 08:41:01.063012', 'l', 'l'),(1, 9, '2004-05-25', '2004-05-25', '18:39:28.028681', '18:39:28.028681', '2004-09-18 00:00:00', '2004-09-18 00:00:00', 'c', 'c'),(1, 3, '2005-01-17', '2005-01-17', '19:47:45.001466', '19:47:45.001466', '2002-09-12 11:18:48.011992', '2002-09-12 11:18:48.011992', 'd', 'd'),(3, 0, '2003-08-28', '2003-08-28', '05:20:00.048417', '05:20:00.048417', '1900-01-01 00:00:00', '1900-01-01 00:00:00', 'k', 'k'),(7, 6, '2006-10-11', '2006-10-11', '11:43:03.056432', '11:43:03.056432', '2003-10-28 03:31:02.009211', '2003-10-28 03:31:02.009211', 'a', 'a'),(4, 5, '1900-01-01', '1900-01-01', '02:38:39.048687', '02:38:39.048687', '2001-08-22 10:20:09.035860', '2001-08-22 10:20:09.035860', 'p', 'p'),(NULL, 8, '1900-01-01', '1900-01-01', '05:34:27.032927', '05:34:27.032927', '2008-04-24 00:00:00', '2008-04-24 00:00:00', 'o', 'o'),(4, 4, '2005-08-18', '2005-08-18', '11:13:16.013590', '11:13:16.013590', '2006-11-10 10:08:49.031891', '2006-11-10 10:08:49.031891', 'e', 'e'),(1, NULL, '2007-03-12', '2007-03-12', '00:00:00', '00:00:00', '2007-10-16 00:00:00', '2007-10-16 00:00:00', 'n', 'n'),(6, 157, '2000-11-18', '2000-11-18', '08:56:42.047453', '08:56:42.047453', '2009-05-27 12:25:07.000073', '2009-05-27 12:25:07.000073', 't', 't'),(5, 4, '2001-03-03', '2001-03-03', '03:20:29.048141', '03:20:29.048141', NULL, NULL, 'u', 'u'),(4, 3, '2003-09-11', '2003-09-11', NULL, NULL, '2001-09-10 18:10:10.061262', '2001-09-10 18:10:10.061262', 'f', 'f'),(1, 4, '2007-06-17', '2007-06-17', NULL, NULL, '1900-01-01 00:00:00', '1900-01-01 00:00:00', 't', 't'),(5, NULL, '2008-09-11', '2008-09-11', '10:39:48.064273', '10:39:48.064273', '2004-06-07 23:17:09.000266', '2004-06-07 23:17:09.000266', 'k', 'k'),(NULL, 3, '2008-05-03', '2008-05-03', '00:00:00', '00:00:00', '2007-06-09 02:05:46.008700', '2007-06-09 02:05:46.008700', 'm', 'm'),(4, 8, '2009-09-07', '2009-09-07', '10:52:33.060993', '10:52:33.060993', '2000-07-03 00:00:00', '2000-07-03 00:00:00', 'y', 'y'),(4, 6, '2005-12-15', '2005-12-15', '21:41:45.005597', '21:41:45.005597', '2001-04-15 14:12:38.049789', '2001-04-15 14:12:38.049789', 'm', 'm'),(203, 98, '2005-05-10', '2005-05-10', NULL, NULL, '2007-04-12 13:29:59.034258', '2007-04-12 13:29:59.034258', 'x', 'x'),(9, 9, '2008-01-22', '2008-01-22', '08:33:38.048965', '08:33:38.048965', '2002-03-24 01:35:46.052300', '2002-03-24 01:35:46.052300', NULL, NULL),(7, 1, '2005-10-23', '2005-10-23', '19:27:01.009576', '19:27:01.009576', '2001-12-27 07:56:29.005615', '2001-12-27 07:56:29.005615', 'q', 'q'),(NULL, NULL, '2005-11-01', '2005-11-01', '09:31:22.017074', '09:31:22.017074', '2002-06-08 09:04:13.048999', '2002-06-08 09:04:13.048999', 'f', 'f'),(NULL, 3, NULL, NULL, '17:16:58.050245', '17:16:58.050245', '2002-02-05 12:54:23.001251', '2002-02-05 12:54:23.001251', 't', 't'),(0, NULL, '2005-06-25', '2005-06-25', '16:44:24.057868', '16:44:24.057868', '2009-09-19 00:00:00', '2009-09-19 00:00:00', 'x', 'x'),(1, 1, '2005-12-09', '2005-12-09', '05:22:56.065526', '05:22:56.065526', '2006-12-18 02:43:37.038767', '2006-12-18 02:43:37.038767', 's', 's'),(5, 9, '2006-06-28', '2006-06-28', '13:32:21.055520', '13:32:21.055520', '2002-10-18 00:00:00', '2002-10-18 00:00:00', 'i', 'i'),(NULL, NULL, '2002-03-16', '2002-03-16', '15:59:32.026962', '15:59:32.026962', '2004-08-03 22:46:02.023201', '2004-08-03 22:46:02.023201', 'l', 'l'),(6, NULL, '2006-07-20', '2006-07-20', '07:19:58.006509', '07:19:58.006509', '1900-01-01 00:00:00', '1900-01-01 00:00:00', 't', 't'),(7, 3, '1900-01-01', '1900-01-01', '12:50:41.053008', '12:50:41.053008', '2006-11-15 05:00:37.028540', '2006-11-15 05:00:37.028540', 'b', 'b'),(NULL, 2, '2002-09-13', '2002-09-13', '04:38:11.003482', '04:38:11.003482', '2005-01-21 07:18:44.001886', '2005-01-21 07:18:44.001886', 'h', 'h'),(6, 4, '2002-08-17', '2002-08-17', '20:25:46.033561', '20:25:46.033561', '1900-01-01 00:00:00', '1900-01-01 00:00:00', NULL, NULL),(9, 3, NULL, NULL, '00:00:00', '00:00:00', '2002-09-22 01:36:27.063456', '2002-09-22 01:36:27.063456', NULL, NULL),(5, 2, '2007-12-08', '2007-12-08', '10:53:24.024992', '10:53:24.024992', '2003-04-22 16:42:22.052607', '2003-04-22 16:42:22.052607', NULL, NULL),(1, 9, '2008-07-05', '2008-07-05', '06:16:28.011698', '06:16:28.011698', '2000-10-18 08:28:55.018533', '2000-10-18 08:28:55.018533', 'x', 'x'),(0, 4, '2001-03-25', '2001-03-25', '13:41:03.021975', '13:41:03.021975', NULL, NULL, 'o', 'o'),(6, 5, '2002-09-27', '2002-09-27', '08:14:06.050501', '08:14:06.050501', '2007-06-12 18:50:24.018166', '2007-06-12 18:50:24.018166', NULL, NULL),(6, 4, '2000-08-26', '2000-08-26', '07:22:25.033657', '07:22:25.033657', '2004-01-21 05:17:01.015777', '2004-01-21 05:17:01.015777', 'r', 'r'),(0, 5, '1900-01-01', '1900-01-01', '16:02:31.028377', '16:02:31.028377', NULL, NULL, 'z', 'z'),(161, 132, '2009-01-20', '2009-01-20', '11:46:57.017685', '11:46:57.017685', '2001-05-01 01:51:11.057447', '2001-05-01 01:51:11.057447', 'q', 'q'),(9, 8, '2004-07-25', '2004-07-25', '12:31:54.025418', '12:31:54.025418', '1900-01-01 00:00:00', '1900-01-01 00:00:00', 'e', 'e'),(4, 0, '2007-01-08', '2007-01-08', '22:17:31.011278', '22:17:31.011278', '2008-01-22 14:23:58.061403', '2008-01-22 14:23:58.061403', NULL, NULL),(3, 7, '1900-01-01', '1900-01-01', '12:45:11.033264', '12:45:11.033264', '2006-03-04 23:40:14.016198', '2006-03-04 23:40:14.016198', 'r', 'r'),(47, 108, '2002-03-20', '2002-03-20', '08:56:28.028528', '08:56:28.028528', '2005-09-18 03:45:38.031040', '2005-09-18 03:45:38.031040', 's', 's'),(2, 4, '2009-03-11', '2009-03-11', '00:00:00', '00:00:00', '2003-11-24 21:40:19.064803', '2003-11-24 21:40:19.064803', 't', 't'),(0, 7, '2002-06-08', '2002-06-08', '01:34:16.010736', '01:34:16.010736', '2006-02-07 15:01:12.036147', '2006-02-07 15:01:12.036147', 'g', 'g'),(3, 6, '2001-03-23', '2001-03-23', NULL, NULL, '2002-02-22 00:00:00', '2002-02-22 00:00:00', 'm', 'm'),(1, NULL, '2009-03-03', '2009-03-03', '12:55:39.037290', '12:55:39.037290', NULL, NULL, 'y', 'y'),(5, 0, '1900-01-01', '1900-01-01', '06:52:09.000450', '06:52:09.000450', '2008-06-15 09:48:37.061544', '2008-06-15 09:48:37.061544', 'u', 'u'),(7, 9, '2008-04-16', '2008-04-16', '23:58:21.020974', '23:58:21.020974', '2004-01-22 23:45:50.012256', '2004-01-22 23:45:50.012256', 'x', 'x'),(9, NULL, '2000-05-04', '2000-05-04', '09:56:19.013982', '09:56:19.013982', '2000-08-14 08:35:51.018999', '2000-08-14 08:35:51.018999', 'x', 'x'),(3, 5, '2009-07-22', '2009-07-22', '09:47:26.020837', '09:47:26.020837', '2002-07-08 19:35:57.024921', '2002-07-08 19:35:57.024921', NULL, NULL),(6, 5, '2000-08-09', '2000-08-09', '04:57:44.017563', '04:57:44.017563', '2009-11-05 00:00:00', '2009-11-05 00:00:00', 'j', 'j'),(0, 2, '2008-03-17', '2008-03-17', '07:11:41.062975', '07:11:41.062975', '2000-08-21 19:09:01.049621', '2000-08-21 19:09:01.049621', 's', 's'),(5, 9, '2003-03-17', '2003-03-17', '00:00:00', '00:00:00', '2000-03-24 19:37:00.005614', '2000-03-24 19:37:00.005614', 'm', 'm'),(1, 1, '2004-05-12', '2004-05-12', '05:44:22.016820', '05:44:22.016820', '2000-05-13 00:00:00', '2000-05-13 00:00:00', 'e', 'e'),(7, 0, '2003-02-17', '2003-02-17', '00:00:00', '00:00:00', '2005-10-28 16:31:41.022417', '2005-10-28 16:31:41.022417', 'g', 'g'),(8, 0, '2001-09-23', '2001-09-23', '22:22:44.040748', '22:22:44.040748', '2009-01-12 00:00:00', '2009-01-12 00:00:00', 'y', 'y'),(2, 4, '2001-09-03', '2001-09-03', '02:09:22.035682', '02:09:22.035682', '2007-09-20 10:53:23.013950', '2007-09-20 10:53:23.013950', 'j', 'j'),(1, 6, '2007-12-06', '2007-12-06', '07:12:40.025928', '07:12:40.025928', '2007-11-12 23:18:08.016834', '2007-11-12 23:18:08.016834', 'w', 'w'),(1, 8, '2008-07-20', '2008-07-20', '20:09:41.045541', '20:09:41.045541', '1900-01-01 00:00:00', '1900-01-01 00:00:00', 'y', 'y'),(24, 123, '2000-02-20', '2000-02-20', '08:34:44.001370', '08:34:44.001370', '2004-06-22 00:00:00', '2004-06-22 00:00:00', 'x', 'x'),(8, 3, '2005-08-08', '2005-08-08', NULL, NULL, '2001-04-17 04:01:28.026167', '2001-04-17 04:01:28.026167', 'z', 'z'),(9, 3, '2005-07-10', '2005-07-10', '22:32:37.032245', '22:32:37.032245', '2008-11-07 15:56:22.007129', '2008-11-07 15:56:22.007129', NULL, NULL),(NULL, 1, '2004-09-23', '2004-09-23', '00:00:00', '00:00:00', '2008-03-12 13:55:27.047687', '2008-03-12 13:55:27.047687', 'i', 'i'),(2, 2, '2003-05-28', '2003-05-28', '12:08:24.012480', '12:08:24.012480', '2000-05-18 09:51:42.063533', '2000-05-18 09:51:42.063533', 'd', 'd'),(2, NULL, '2002-04-11', '2002-04-11', '22:27:11.024150', '22:27:11.024150', '1900-01-01 00:00:00', '1900-01-01 00:00:00', 'q', 'q'),(6, NULL, '2008-12-18', '2008-12-18', '00:00:00', '00:00:00', '2004-08-05 15:08:08.041550', '2004-08-05 15:08:08.041550', 'a', 'a'),(2, 2, '2008-12-15', '2008-12-15', '06:04:40.022308', '06:04:40.022308', '2002-08-11 00:00:00', '2002-08-11 00:00:00', 'b', 'b'),(8, 6, '2007-03-17', '2007-03-17', '02:01:19.015610', '02:01:19.015610', NULL, NULL, 't', 't'),(229, 22, '2009-01-03', '2009-01-03', '10:04:44.012250', '10:04:44.012250', '2009-02-25 13:55:36.006617', '2009-02-25 13:55:36.006617', 'z', 'z'),(8, 8, '2009-10-05', '2009-10-05', '03:15:39.029731', '03:15:39.029731', '2004-05-12 00:00:00', '2004-05-12 00:00:00', 'l', 'l'),(1, NULL, '2002-02-14', '2002-02-14', '11:40:07.064681', '11:40:07.064681', '2004-06-22 11:06:17.026497', '2004-06-22 11:06:17.026497', 'j', 'j'),(3, 4, '2002-12-03', '2002-12-03', '05:40:58.040070', '05:40:58.040070', '2008-12-12 07:44:58.043908', '2008-12-12 07:44:58.043908', 't', 't'),(NULL, 5, '2008-11-05', '2008-11-05', '08:23:12.048072', '08:23:12.048072', '2002-03-14 10:12:56.059515', '2002-03-14 10:12:56.059515', 'z', 'z'),(6, 0, '2006-06-19', '2006-06-19', '22:47:51.035634', '22:47:51.035634', '2001-06-26 00:52:28.008578', '2001-06-26 00:52:28.008578', 'l', 'l'),(1, 5, '2002-11-24', '2002-11-24', '14:00:38.064140', '14:00:38.064140', '2003-11-13 17:26:31.060212', '2003-11-13 17:26:31.060212', 'i', 'i'),(192, 144, '2008-10-06', '2008-10-06', '16:03:33.014981', '16:03:33.014981', '2004-02-09 15:46:56.055798', '2004-02-09 15:46:56.055798', 'a', 'a'),(NULL, 5, '2004-07-11', '2004-07-11', '07:58:14.034094', '07:58:14.034094', '2004-04-21 00:00:00', '2004-04-21 00:00:00', 'w', 'w'),(8, 1, NULL, NULL, NULL, NULL, '2003-07-05 00:00:00', '2003-07-05 00:00:00', 'p', 'p'),(2, 5, '2005-05-18', '2005-05-18', '12:35:20.061910', '12:35:20.061910', NULL, NULL, 'b', 'b'),(230, 35, '2005-09-05', '2005-09-05', '00:55:03.028324', '00:55:03.028324', '2002-10-05 00:00:00', '2002-10-05 00:00:00', NULL, NULL),(4, 5, '2004-12-19', '2004-12-19', '22:25:07.010419', '22:25:07.010419', '2002-02-19 00:00:00', '2002-02-19 00:00:00', 'p', 'p'),(2, 5, '2005-10-18', '2005-10-18', '18:20:08.045830', '18:20:08.045830', '2005-08-15 00:00:00', '2005-08-15 00:00:00', 'y', 'y'),(130, 171, NULL, NULL, '08:27:30.053774', '08:27:30.053774', NULL, NULL, NULL, NULL),(8, 1, '2005-10-15', '2005-10-15', '03:38:24.055204', '03:38:24.055204', '2000-10-19 21:57:19.058395', '2000-10-19 21:57:19.058395', 'm', 'm'),(9, NULL, '1900-01-01', '1900-01-01', '05:01:46.020841', '05:01:46.020841', '2002-01-19 03:06:35.062818', '2002-01-19 03:06:35.062818', 'l', 'l'),(4, 0, '2004-04-14', '2004-04-14', '02:57:15.007040', '02:57:15.007040', '2001-08-01 10:45:49.058784', '2001-08-01 10:45:49.058784', 'b', 'b'),(2, 9, '2004-11-07', '2004-11-07', '00:44:12.057454', '00:44:12.057454', '2006-02-04 14:47:09.030956', '2006-02-04 14:47:09.030956', NULL, NULL),(9, 5, '2007-02-28', '2007-02-28', '20:35:31.033783', '20:35:31.033783', '1900-01-01 00:00:00', '1900-01-01 00:00:00', NULL, NULL),(168, 28, '2004-12-16', '2004-12-16', '15:27:50.024237', '15:27:50.024237', '2009-05-18 11:17:07.013427', '2009-05-18 11:17:07.013427', 'j', 'j'),(8, NULL, '2006-10-18', '2006-10-18', NULL, NULL, '1900-01-01 00:00:00', '1900-01-01 00:00:00', 'h', 'h'),(7, NULL, '2009-09-19', '2009-09-19', '18:47:56.027699', '18:47:56.027699', '2008-06-09 05:03:20.061052', '2008-06-09 05:03:20.061052', NULL, NULL),(NULL, NULL, '2001-04-21', '2001-04-21', '20:06:48.018465', '20:06:48.018465', '2004-04-06 11:29:09.047428', '2004-04-06 11:29:09.047428', NULL, NULL),(5, NULL, '2007-09-19', '2007-09-19', '16:48:51.017385', '16:48:51.017385', '2007-11-05 13:29:33.003632', '2007-11-05 13:29:33.003632', 'y', 'y'),(1, NULL, '2006-04-11', '2006-04-11', '00:00:00', '00:00:00', '2008-03-26 00:00:00', '2008-03-26 00:00:00', 'f', 'f'),(4, 3, '2009-08-16', '2009-08-16', '16:28:15.038842', '16:28:15.038842', '2006-05-19 22:17:56.026258', '2006-05-19 22:17:56.026258', 'm', 'm'),(237, 7, '2009-02-10', '2009-02-10', '00:00:00', '00:00:00', '2002-01-11 16:39:37.030007', '2002-01-11 16:39:37.030007', 'd', 'd'),(4, 6, '2002-01-03', '2002-01-03', NULL, NULL, '2005-07-28 17:03:18.024439', '2005-07-28 17:03:18.024439', 'b', 'b'),(35, 235, '2003-11-07', '2003-11-07', '00:00:00', '00:00:00', NULL, NULL, 'z', 'z'),(162, 46, '2008-09-27', '2008-09-27', '09:36:30.005190', '09:36:30.005190', '2003-10-16 09:48:42.055969', '2003-10-16 09:48:42.055969', 'u', 'u'),(3, 0, '2000-11-02', '2000-11-02', '00:00:00', '00:00:00', '2005-07-17 08:37:44.021873', '2005-07-17 08:37:44.021873', 'b', 'b'),(8, 0, '2000-12-05', '2000-12-05', '17:10:09.006359', '17:10:09.006359', '2006-11-02 00:24:04.054859', '2006-11-02 00:24:04.054859', 'o', 'o'),(9, 0, '1900-01-01', '1900-01-01', '10:00:50.061246', '10:00:50.061246', '1900-01-01 00:00:00', '1900-01-01 00:00:00', 's', 's'),(2, 8, '2008-05-21', '2008-05-21', '12:06:31.036247', '12:06:31.036247', '2007-01-08 19:11:58.049704', '2007-01-08 19:11:58.049704', 'f', 'f'),(67, 118, NULL, NULL, '18:20:57.009809', '18:20:57.009809', '2003-12-12 13:58:32.061496', '2003-12-12 13:58:32.061496', 'x', 'x'),(1, 5, '2009-12-19', '2009-12-19', '00:45:40.017191', '00:45:40.017191', '2001-06-11 02:03:39.014331', '2001-06-11 02:03:39.014331', 'f', 'f'),(2, 0, '2007-05-12', '2007-05-12', '12:34:50.052556', '12:34:50.052556', '2009-06-16 08:00:03.019340', '2009-06-16 08:00:03.019340', 'm', 'm'),(5, 0, '2006-01-26', '2006-01-26', '07:24:44.020701', '07:24:44.020701', '1900-01-01 00:00:00', '1900-01-01 00:00:00', 'l', 'l'),(7, 9, '2007-05-19', '2007-05-19', '03:55:07.008179', '03:55:07.008179', '2006-12-11 00:00:00', '2006-12-11 00:00:00', 'n', 'n'),(4, 3, '1900-01-01', '1900-01-01', '11:18:36.020832', '11:18:36.020832', NULL, NULL, NULL, NULL),(9, 2, '2005-08-22', '2005-08-22', '22:04:46.043018', '22:04:46.043018', '2007-05-27 00:00:00', '2007-05-27 00:00:00', 'b', 'b'),(65, 114, '1900-01-01', '1900-01-01', '19:56:30.055280', '19:56:30.055280', '2008-09-23 00:00:00', '2008-09-23 00:00:00', 'm', 'm'),(NULL, 8, '2007-03-03', '2007-03-03', '18:53:08.015995', '18:53:08.015995', '2007-03-08 22:50:59.031257', '2007-03-08 22:50:59.031257', NULL, NULL),(240, 170, '2003-09-21', '2003-09-21', '00:00:00', '00:00:00', '1900-01-01 00:00:00', '1900-01-01 00:00:00', 'j', 'j'),(236, 131, '2001-12-04', '2001-12-04', '08:43:37.057479', '08:43:37.057479', '2002-07-16 23:51:09.060515', '2002-07-16 23:51:09.060515', 'w', 'w'),(1, 2, '2004-02-22', '2004-02-22', '01:23:11.014485', '01:23:11.014485', NULL, NULL, 's', 's'),(6, 2, '2009-03-21', '2009-03-21', '10:44:58.063708', '10:44:58.063708', '2002-07-19 19:06:51.053051', '2002-07-19 19:06:51.053051', 'h', 'h'),(9, 0, '2009-10-20', '2009-10-20', '11:26:59.043332', '11:26:59.043332', '2007-11-01 13:09:33.010116', '2007-11-01 13:09:33.010116', 'k', 'k'),(NULL, 2, '2001-12-13', '2001-12-13', '14:16:27.039357', '14:16:27.039357', '1900-01-01 00:00:00', '1900-01-01 00:00:00', 'o', 'o'),(120, 49, '2002-12-24', '2002-12-24', '09:29:35.050222', '09:29:35.050222', '2009-09-23 11:00:21.008223', '2009-09-23 11:00:21.008223', 'j', 'j'),(7, 6, '1900-01-01', '1900-01-01', '04:35:02.009941', '04:35:02.009941', '2004-06-05 00:00:00', '2004-06-05 00:00:00', NULL, NULL),(NULL, 7, NULL, NULL, '04:19:06.039364', '04:19:06.039364', '2007-04-08 00:22:44.025018', '2007-04-08 00:22:44.025018', 'o', 'o'),(3, 9, '2000-10-03', '2000-10-03', NULL, NULL, '2002-06-19 23:02:56.030151', '2002-06-19 23:02:56.030151', 'y', 'y'),(NULL, 2, '2001-01-08', '2001-01-08', '00:00:00', '00:00:00', '2003-04-07 19:40:54.037199', '2003-04-07 19:40:54.037199', 'd', 'd'),(NULL, 5, '2004-10-20', '2004-10-20', '23:45:21.054808', '23:45:21.054808', '2002-02-01 00:00:00', '2002-02-01 00:00:00', 'b', 'b'),(NULL, 2, '2000-10-17', '2000-10-17', '05:00:38.043922', '05:00:38.043922', '2003-03-02 13:04:36.026635', '2003-03-02 13:04:36.026635', 'u', 'u'),(NULL, 0, '2000-11-16', '2000-11-16', '16:06:03.059850', '16:06:03.059850', '2008-11-04 23:02:08.051231', '2008-11-04 23:02:08.051231', 'd', 'd'),(7, 4, '2008-08-12', '2008-08-12', '21:11:55.041754', '21:11:55.041754', '2003-11-10 13:45:37.034510', '2003-11-10 13:45:37.034510', 'w', 'w'),(121, 242, '1900-01-01', '1900-01-01', '11:40:08.038618', '11:40:08.038618', '2008-02-12 00:00:00', '2008-02-12 00:00:00', 'z', 'z'),(6, 5, '2005-02-20', '2005-02-20', '14:56:43.020077', '14:56:43.020077', '2006-10-07 14:18:30.023797', '2006-10-07 14:18:30.023797', 'u', 'u'),(8, 5, NULL, NULL, '22:03:39.059060', '22:03:39.059060', '2004-04-10 00:00:00', '2004-04-10 00:00:00', 'g', 'g'),(240, 251, '2006-02-26', '2006-02-26', '08:23:40.032186', '08:23:40.032186', NULL, NULL, 'o', 'o'),(7, 1, '2001-01-19', '2001-01-19', '10:15:37.010143', '10:15:37.010143', '2005-05-26 16:03:41.040941', '2005-05-26 16:03:41.040941', 'h', 'h'),(5, NULL, '2003-01-11', '2003-01-11', '00:00:00', '00:00:00', '2000-03-06 21:25:55.054047', '2000-03-06 21:25:55.054047', 'h', 'h'),(4, 4, NULL, NULL, '02:59:15.057629', '02:59:15.057629', '1900-01-01 00:00:00', '1900-01-01 00:00:00', 'n', 'n'),(NULL, 1, '2006-12-08', '2006-12-08', NULL, NULL, '2005-03-10 17:30:25.019829', '2005-03-10 17:30:25.019829', 't', 't'),(1, 4, '2006-10-16', '2006-10-16', '03:38:20.009625', '03:38:20.009625', NULL, NULL, 'y', 'y'),(2, 3, NULL, NULL, '03:17:35.014995', '03:17:35.014995', '2007-10-12 00:00:00', '2007-10-12 00:00:00', 't', 't'),(6, 3, NULL, NULL, '03:43:10.005369', '03:43:10.005369', '2004-09-08 01:15:20.014497', '2004-09-08 01:15:20.014497', 'a', 'a'),(NULL, 7, '2001-09-19', '2001-09-19', '00:00:00', '00:00:00', NULL, NULL, 'y', 'y'),(0, 7, '2000-08-05', '2000-08-05', '20:14:28.013061', '20:14:28.013061', '2008-01-05 18:47:14.049915', '2008-01-05 18:47:14.049915', 'p', 'p'),(NULL, 7, '2001-01-16', '2001-01-16', '19:55:14.016743', '19:55:14.016743', NULL, NULL, 'r', 'r'),(0, 4, '2009-12-26', '2009-12-26', '18:10:27.003941', '18:10:27.003941', '2004-03-25 09:04:18.055435', '2004-03-25 09:04:18.055435', 'n', 'n'),(6, 2, '2006-09-14', '2006-09-14', '00:00:00', '00:00:00', '2002-01-08 06:25:08.033286', '2002-01-08 06:25:08.033286', 'v', 'v'),(NULL, 0, '2001-06-21', '2001-06-21', '14:25:27.012332', '14:25:27.012332', '2004-09-28 12:51:04.034136', '2004-09-28 12:51:04.034136', 'u', 'u'),(4, 3, '2006-11-26', '2006-11-26', '19:45:18.001908', '19:45:18.001908', NULL, NULL, 'w', 'w'),(8, 5, '2005-03-23', '2005-03-23', '10:58:03.022898', '10:58:03.022898', '2002-10-10 15:50:58.021141', '2002-10-10 15:50:58.021141', 'x', 'x'),(8, 5, '2002-05-18', '2002-05-18', '16:57:06.041041', '16:57:06.041041', '2002-01-25 00:00:00', '2002-01-25 00:00:00', 'd', 'd'),(7, 1, '2008-01-17', '2008-01-17', '13:02:51.061359', '13:02:51.061359', '2005-10-03 04:21:29.030514', '2005-10-03 04:21:29.030514', 'm', 'm'),(9, 6, '2008-04-07', '2008-04-07', '11:28:23.037208', '11:28:23.037208', '2005-08-05 16:14:11.045568', '2005-08-05 16:14:11.045568', 'z', 'z'),(4, 4, '2002-03-21', '2002-03-21', '00:00:00', '00:00:00', '2004-10-06 23:55:56.033537', '2004-10-06 23:55:56.033537', 's', 's'),(7, 4, NULL, NULL, '05:24:40.026869', '05:24:40.026869', '2009-07-13 17:46:55.042744', '2009-07-13 17:46:55.042744', 'g', 'g'),(5, 9, '1900-01-01', '1900-01-01', '04:31:20.020509', '04:31:20.020509', '2004-03-19 00:00:00', '2004-03-19 00:00:00', 'q', 'q'),(5, 8, '2005-12-15', '2005-12-15', '01:22:10.002395', '01:22:10.002395', '2009-07-25 02:58:47.056043', '2009-07-25 02:58:47.056043', 'u', 'u'),(NULL, 1, '2007-08-20', '2007-08-20', '03:02:42.026399', '03:02:42.026399', '2008-07-06 10:09:42.026704', '2008-07-06 10:09:42.026704', 't', 't'),(5, 7, '2005-05-13', '2005-05-13', '12:40:06.058272', '12:40:06.058272', '2007-10-27 18:02:15.009624', '2007-10-27 18:02:15.009624', 'o', 'o'),(4, 8, '2000-03-21', '2000-03-21', '20:04:49.024749', '20:04:49.024749', NULL, NULL, 'w', 'w'),(176, 249, '2008-08-28', '2008-08-28', '03:56:57.045962', '03:56:57.045962', '2006-09-02 05:43:58.026431', '2006-09-02 05:43:58.026431', 'p', 'p'),(4, 8, '2005-11-23', '2005-11-23', '00:00:00', '00:00:00', '2003-03-10 23:37:10.030186', '2003-03-10 23:37:10.030186', 'y', 'y'),(5, 0, '2003-08-08', '2003-08-08', '10:00:38.013676', '10:00:38.013676', '2001-08-06 00:00:00', '2001-08-06 00:00:00', 'd', 'd'),(NULL, 1, '2009-06-27', '2009-06-27', '07:29:23.053975', '07:29:23.053975', '2005-08-08 14:14:11.050944', '2005-08-08 14:14:11.050944', 'v', 'v'),(19, NULL, '2008-08-11', '2008-08-11', '00:00:00', '00:00:00', '2002-04-05 19:25:12.055192', '2002-04-05 19:25:12.055192', 'h', 'h'),(NULL, 3, '1900-01-01', '1900-01-01', '10:45:29.048819', '10:45:29.048819', '2007-06-09 07:37:03.002789', '2007-06-09 07:37:03.002789', 'z', 'z'),(86, 51, '2003-11-21', '2003-11-21', '00:57:57.060407', '00:57:57.060407', '2005-04-06 06:43:01.058103', '2005-04-06 06:43:01.058103', 'l', 'l'),(5, 2, '2008-10-10', '2008-10-10', '16:31:18.052942', '16:31:18.052942', '2007-03-01 02:37:25.035407', '2007-03-01 02:37:25.035407', 'j', 'j'),(NULL, 5, '1900-01-01', '1900-01-01', '04:04:03.020380', '04:04:03.020380', '1900-01-01 00:00:00', '1900-01-01 00:00:00', 'g', 'g'),(3, 4, '2001-11-15', '2001-11-15', '22:07:09.020612', '22:07:09.020612', '2001-04-10 14:46:36.034710', '2001-04-10 14:46:36.034710', 'b', 'b'),(6, 0, NULL, NULL, '12:37:47.002545', '12:37:47.002545', '2007-06-04 20:05:03.026041', '2007-06-04 20:05:03.026041', 'w', 'w'),(7, 6, '2006-04-23', '2006-04-23', NULL, NULL, '1900-01-01 00:00:00', '1900-01-01 00:00:00', 'w', 'w'),(120, NULL, NULL, NULL, NULL, NULL, '2009-07-14 14:29:35.046600', '2009-07-14 14:29:35.046600', 'w', 'w'),(8, 1, NULL, NULL, '00:43:31.033296', '00:43:31.033296', '2005-06-19 00:00:00', '2005-06-19 00:00:00', 'c', 'c'),(0, 6, '2001-01-18', '2001-01-18', '02:03:25.034368', '02:03:25.034368', NULL, NULL, 'a', 'a'),(NULL, NULL, '2005-04-04', '2005-04-04', '08:38:34.034082', '08:38:34.034082', '2008-11-02 05:08:02.037855', '2008-11-02 05:08:02.037855', 'o', 'o'),(NULL, 2, '2005-05-25', '2005-05-25', '03:34:51.046375', '03:34:51.046375', '2003-07-09 17:42:09.017411', '2003-07-09 17:42:09.017411', 'h', 'h'),(NULL, 7, '2000-09-09', '2000-09-09', '13:21:14.002621', '13:21:14.002621', '2008-05-11 00:00:00', '2008-05-11 00:00:00', 'd', 'd'),(0, 7, '2007-03-18', '2007-03-18', '00:00:00', '00:00:00', '2009-02-15 00:00:00', '2009-02-15 00:00:00', 'a', 'a'),(0, 7, '2005-06-27', '2005-06-27', '00:48:34.032616', '00:48:34.032616', '2008-07-19 04:07:12.008096', '2008-07-19 04:07:12.008096', 'j', 'j'),(3, 4, '2009-01-14', '2009-01-14', '12:10:42.034634', '12:10:42.034634', '2006-07-23 05:06:48.050284', '2006-07-23 05:06:48.050284', 'w', 'w'),(2, 9, NULL, NULL, '02:28:23.047612', '02:28:23.047612', '2009-09-08 17:46:45.061382', '2009-09-08 17:46:45.061382', 'k', 'k'),(8, 9, '2004-02-15', '2004-02-15', '15:00:50.031633', '15:00:50.031633', '2008-12-04 07:43:44.022333', '2008-12-04 07:43:44.022333', 'j', 'j'),(6, 7, NULL, NULL, '08:57:46.040289', '08:57:46.040289', '2005-01-09 11:59:42.015139', '2005-01-09 11:59:42.015139', 'h', 'h'),(NULL, 1, '2007-08-23', '2007-08-23', NULL, NULL, NULL, NULL, 'r', 'r'),(4, 2, '2001-11-24', '2001-11-24', '12:31:32.060060', '12:31:32.060060', '1900-01-01 00:00:00', '1900-01-01 00:00:00', 'f', 'f'),(1, 6, NULL, NULL, '02:17:53.021687', '02:17:53.021687', '2009-03-07 06:45:51.005414', '2009-03-07 06:45:51.005414', 'e', 'e'),(1, 1, '2003-01-01', '2003-01-01', '00:00:00', '00:00:00', '2006-04-26 09:43:52.006274', '2006-04-26 09:43:52.006274', 'h', 'h'),(2, 8, '2004-06-08', '2004-06-08', '03:07:22.007318', '03:07:22.007318', '2002-01-26 16:31:31.049490', '2002-01-26 16:31:31.049490', 'r', 'r'),(2, 7, '2008-03-07', '2008-03-07', '11:36:34.013598', '11:36:34.013598', '2002-12-12 00:05:25.022192', '2002-12-12 00:05:25.022192', 'u', 'u'),(0, NULL, '2008-10-19', '2008-10-19', '14:36:51.014419', '14:36:51.014419', '2007-08-13 23:05:27.013905', '2007-08-13 23:05:27.013905', 'x', 'x'),(1, 1, '2002-02-09', '2002-02-09', '00:00:00', '00:00:00', '2009-10-17 15:02:17.031290', '2009-10-17 15:02:17.031290', 'd', 'd'),(0, 1, '2003-05-06', '2003-05-06', '13:26:21.046263', '13:26:21.046263', '2007-09-02 09:41:34.036912', '2007-09-02 09:41:34.036912', 'm', 'm'),(9, 5, '2006-05-22', '2006-05-22', '14:34:58.010309', '14:34:58.010309', '2003-10-20 09:53:57.029299', '2003-10-20 09:53:57.029299', 'w', 'w'),(8, 8, '2000-12-28', '2000-12-28', '12:36:29.059371', '12:36:29.059371', '2009-10-22 12:41:41.030410', '2009-10-22 12:41:41.030410', 'a', 'a'),(9, 8, '2008-06-09', '2008-06-09', '15:18:04.046770', '15:18:04.046770', NULL, NULL, 'g', 'g'),(2, 6, '2002-02-01', '2002-02-01', '01:44:07.000507', '01:44:07.000507', '2006-04-16 02:39:44.036931', '2006-04-16 02:39:44.036931', 'g', 'g'),(191, 207, '2009-05-01', '2009-05-01', '10:58:10.045009', '10:58:10.045009', '2001-01-25 23:04:52.027144', '2001-01-25 23:04:52.027144', 'b', 'b'),(2, 9, '2004-01-08', '2004-01-08', '20:53:12.023180', '20:53:12.023180', '1900-01-01 00:00:00', '1900-01-01 00:00:00', NULL, NULL),(6, 0, '2009-05-04', '2009-05-04', '20:58:07.042339', '20:58:07.042339', '2006-01-27 02:48:23.025881', '2006-01-27 02:48:23.025881', 'u', 'u'),(2, 2, '2005-08-16', '2005-08-16', '00:27:48.003217', '00:27:48.003217', '2004-06-08 00:00:00', '2004-06-08 00:00:00', 'l', 'l'),(1, 8, '1900-01-01', '1900-01-01', '16:22:16.021240', '16:22:16.021240', '1900-01-01 00:00:00', '1900-01-01 00:00:00', 'x', 'x'),(7, 8, '2007-10-05', '2007-10-05', '02:53:27.002185', '02:53:27.002185', '2000-10-03 15:38:51.049185', '2000-10-03 15:38:51.049185', 'q', 'q'),(0, 5, '2008-07-12', '2008-07-12', '11:18:33.000511', '11:18:33.000511', '1900-01-01 00:00:00', '1900-01-01 00:00:00', 'm', 'm'),(5, 2, '2005-09-15', '2005-09-15', '02:26:37.034908', '02:26:37.034908', '2006-07-26 02:56:37.042438', '2006-07-26 02:56:37.042438', 's', 's'),(34, 195, '2007-04-12', '2007-04-12', '03:55:19.062613', '03:55:19.062613', '2002-03-15 12:08:55.051620', '2002-03-15 12:08:55.051620', 'j', 'j'),(2, 8, '2007-12-10', '2007-12-10', '11:53:57.030553', '11:53:57.030553', '2001-06-25 00:00:00', '2001-06-25 00:00:00', 'l', 'l'),(5, 3, '2007-12-17', '2007-12-17', NULL, NULL, '1900-01-01 00:00:00', '1900-01-01 00:00:00', 'z', 'z'),(0, 7, '2009-12-08', '2009-12-08', '13:13:53.018522', '13:13:53.018522', '2002-06-13 18:30:24.001760', '2002-06-13 18:30:24.001760', 'g', 'g'),(2, 7, '2005-07-11', '2005-07-11', '01:52:16.043900', '01:52:16.043900', NULL, NULL, 'h', 'h'),(1, 5, '2005-01-14', '2005-01-14', '13:40:04.043861', '13:40:04.043861', '2002-10-17 20:37:07.051450', '2002-10-17 20:37:07.051450', 'c', 'c'),(0, 9, '2001-08-10', '2001-08-10', '19:27:42.012449', '19:27:42.012449', '2002-09-07 05:27:45.035433', '2002-09-07 05:27:45.035433', 'y', 'y'),(1, 6, '2009-03-06', '2009-03-06', '00:00:00', '00:00:00', '2005-09-19 06:01:44.045544', '2005-09-19 06:01:44.045544', 'e', 'e'),(55, 141, '2003-03-19', '2003-03-19', '04:48:49.058161', '04:48:49.058161', '2007-09-04 03:14:29.012179', '2007-09-04 03:14:29.012179', 'n', 'n'),(5, 5, '2006-03-07', '2006-03-07', '01:11:43.043720', '01:11:43.043720', '1900-01-01 00:00:00', '1900-01-01 00:00:00', 'q', 'q'),(2, 7, NULL, NULL, '20:59:44.010869', '20:59:44.010869', '2002-07-21 20:10:51.034329', '2002-07-21 20:10:51.034329', 'i', 'i'),(4, 7, '2000-02-04', '2000-02-04', '03:02:18.048166', '03:02:18.048166', '2007-11-26 10:34:39.044191', '2007-11-26 10:34:39.044191', 'f', 'f'),(NULL, 5, '2006-01-21', '2006-01-21', '14:12:47.009524', '14:12:47.009524', NULL, NULL, 'q', 'q'),(5, 7, '1900-01-01', '1900-01-01', '05:45:50.009326', '05:45:50.009326', '2009-01-08 00:00:00', '2009-01-08 00:00:00', 'r', 'r'),(4, 3, '2002-10-16', '2002-10-16', '17:16:43.030750', '17:16:43.030750', NULL, NULL, NULL, NULL),(3, 7, '2006-06-08', '2006-06-08', '09:19:46.016061', '09:19:46.016061', NULL, NULL, 'a', 'a'),(NULL, 0, NULL, NULL, '09:18:01.029961', '09:18:01.029961', '2008-08-26 05:09:30.057897', '2008-08-26 05:09:30.057897', 'u', 'u'),(2, 6, NULL, NULL, '16:17:42.045766', '16:17:42.045766', '2002-08-09 03:55:40.027669', '2002-08-09 03:55:40.027669', 'l', 'l'),(1, NULL, '2005-12-19', '2005-12-19', '12:32:23.055161', '12:32:23.055161', '2000-10-08 10:14:36.025857', '2000-10-08 10:14:36.025857', 'e', 'e'),(1, NULL, '2008-12-06', '2008-12-06', '01:41:25.012900', '01:41:25.012900', '2003-01-15 00:00:00', '2003-01-15 00:00:00', 'w', 'w'),(7, 7, '1900-01-01', '1900-01-01', '11:53:34.037526', '11:53:34.037526', NULL, NULL, 'l', 'l'),(3, 3, '2006-09-14', '2006-09-14', '00:00:00', '00:00:00', NULL, NULL, 's', 's'),(3, 2, NULL, NULL, NULL, NULL, '2000-03-16 12:37:17.006684', '2000-03-16 12:37:17.006684', NULL, NULL),(5, 6, '2003-07-18', '2003-07-18', '09:20:59.044434', '09:20:59.044434', '2009-09-07 02:14:06.050509', '2009-09-07 02:14:06.050509', 'n', 'n'),(NULL, 3, '2001-05-19', '2001-05-19', '14:44:58.033857', '14:44:58.033857', '2001-09-27 11:44:45.064834', '2001-09-27 11:44:45.064834', 'c', 'c'),(7, 4, NULL, NULL, '09:59:58.035128', '09:59:58.035128', '2004-09-03 14:19:35.058667', '2004-09-03 14:19:35.058667', 's', 's'),(3, 9, '2008-03-13', '2008-03-13', '23:46:32.053417', '23:46:32.053417', '2009-06-18 07:50:16.035104', '2009-06-18 07:50:16.035104', 'w', 'w'),(7, 7, '2000-09-26', '2000-09-26', '05:37:58.027262', '05:37:58.027262', '2001-01-04 02:26:48.033897', '2001-01-04 02:26:48.033897', 'h', 'h'),(NULL, 0, NULL, NULL, NULL, NULL, '2001-01-28 00:00:00', '2001-01-28 00:00:00', 'v', 'v'),(3, NULL, '2002-07-10', '2002-07-10', '00:05:54.016021', '00:05:54.016021', '2008-09-04 10:43:59.055331', '2008-09-04 10:43:59.055331', 'q', 'q'),(4, NULL, '2000-04-27', '2000-04-27', '18:53:46.064085', '18:53:46.064085', '2002-04-22 12:33:28.037271', '2002-04-22 12:33:28.037271', 'k', 'k'),(5, 1, '1900-01-01', '1900-01-01', NULL, NULL, '2000-10-06 19:13:11.002929', '2000-10-06 19:13:11.002929', NULL, NULL),(1, 1, '2008-02-11', '2008-02-11', '00:00:00', '00:00:00', '2001-04-19 23:14:27.022644', '2001-04-19 23:14:27.022644', 'c', 'c'),(0, NULL, '2008-07-18', '2008-07-18', '14:08:42.053972', '14:08:42.053972', '2003-04-06 06:14:54.018713', '2003-04-06 06:14:54.018713', 'd', 'd'),(2, 4, '2005-06-11', '2005-06-11', '19:56:40.015796', '19:56:40.015796', '1900-01-01 00:00:00', '1900-01-01 00:00:00', 'h', 'h'),(NULL, 1, '2000-08-23', '2000-08-23', '00:00:00', '00:00:00', '2007-11-09 01:53:02.009771', '2007-11-09 01:53:02.009771', 'v', 'v'),(7, 0, '2009-01-08', '2009-01-08', '16:24:26.054238', '16:24:26.054238', NULL, NULL, 'u', 'u'),(NULL, 2, '2005-04-18', '2005-04-18', '10:59:44.043890', '10:59:44.043890', '2004-07-11 13:09:42.021113', '2004-07-11 13:09:42.021113', NULL, NULL),(NULL, 5, '2007-09-20', '2007-09-20', '00:00:00', '00:00:00', '2002-01-18 00:00:00', '2002-01-18 00:00:00', 'w', 'w'),(3, 0, NULL, NULL, '00:00:00', '00:00:00', NULL, NULL, 'k', 'k'),(5, NULL, '2008-12-24', '2008-12-24', '15:39:26.002716', '15:39:26.002716', '2005-08-06 16:11:55.034907', '2005-08-06 16:11:55.034907', 'b', 'b'),(0, 3, '2003-01-16', '2003-01-16', '16:06:45.060711', '16:06:45.060711', '2003-09-24 00:00:00', '2003-09-24 00:00:00', 's', 's'),(4, 5, '2002-10-25', '2002-10-25', '15:54:08.053182', '15:54:08.053182', '2003-09-07 14:43:32.006553', '2003-09-07 14:43:32.006553', 'u', 'u'),(6, 6, '2001-06-01', '2001-06-01', '03:46:38.033474', '03:46:38.033474', '2002-04-22 00:00:00', '2002-04-22 00:00:00', 'r', 'r'),(1, 1, '2009-05-02', '2009-05-02', '05:43:51.047352', '05:43:51.047352', '2001-03-07 00:00:00', '2001-03-07 00:00:00', 's', 's'),(4, NULL, '1900-01-01', '1900-01-01', '12:22:14.029334', '12:22:14.029334', NULL, NULL, NULL, NULL),(NULL, 1, '2009-08-28', '2009-08-28', '05:12:03.053488', '05:12:03.053488', '2006-11-09 17:04:42.027336', '2006-11-09 17:04:42.027336', 'v', 'v'),(9, 4, '2009-02-20', '2009-02-20', '08:07:08.033992', '08:07:08.033992', '2009-11-04 21:13:34.059626', '2009-11-04 21:13:34.059626', 'f', 'f'),(4, 0, '2008-09-01', '2008-09-01', '01:00:16.028034', '01:00:16.028034', '2002-01-27 00:13:48.037339', '2002-01-27 00:13:48.037339', 's', 's'),(NULL, 3, '2001-03-27', '2001-03-27', '00:23:44.007725', '00:23:44.007725', '2009-10-24 14:35:10.057946', '2009-10-24 14:35:10.057946', 'z', 'z'),(NULL, 3, NULL, NULL, '04:52:28.016964', '04:52:28.016964', '2001-02-15 03:55:02.043581', '2001-02-15 03:55:02.043581', 'c', 'c'),(7, 1, '1900-01-01', '1900-01-01', '07:18:26.045449', '07:18:26.045449', NULL, NULL, 'w', 'w'),(3, 6, '2008-05-07', '2008-05-07', '03:52:16.015402', '03:52:16.015402', '2002-10-21 10:53:15.051193', '2002-10-21 10:53:15.051193', 'k', 'k'),(1, 3, '2000-06-15', '2000-06-15', '13:20:39.047468', '13:20:39.047468', '2005-05-04 17:14:08.003850', '2005-05-04 17:14:08.003850', 'l', 'l'),(1, 5, '2005-02-19', '2005-02-19', '16:52:16.009390', '16:52:16.009390', NULL, NULL, 'f', 'f'),(55, 108, '2000-09-02', '2000-09-02', '17:08:53.013197', '17:08:53.013197', '2009-02-16 15:41:51.039299', '2009-02-16 15:41:51.039299', 's', 's'),(8, 0, '1900-01-01', '1900-01-01', '23:52:11.052274', '23:52:11.052274', '2002-06-10 19:46:10.032204', '2002-06-10 19:46:10.032204', 'k', 'k'),(6, 6, '2008-09-16', '2008-09-16', '13:09:13.036644', '13:09:13.036644', '2003-10-21 22:19:20.017134', '2003-10-21 22:19:20.017134', 'y', 'y'),(4, 0, '2000-08-04', '2000-08-04', '16:04:58.047005', '16:04:58.047005', '2000-09-10 14:51:30.017698', '2000-09-10 14:51:30.017698', 'm', 'm'),(3, 2, '2008-05-11', '2008-05-11', '01:32:41.049358', '01:32:41.049358', NULL, NULL, 'w', 'w'),(4, 1, '2005-10-22', '2005-10-22', '09:41:14.026105', '09:41:14.026105', '2009-03-03 00:00:00', '2009-03-03 00:00:00', 'x', 'x'),(9, 9, '2000-08-28', '2000-08-28', '10:30:35.038628', '10:30:35.038628', '2008-10-26 07:50:37.014570', '2008-10-26 07:50:37.014570', 'i', 'i'),(221, NULL, '2005-02-02', '2005-02-02', '15:39:35.044057', '15:39:35.044057', '2006-09-13 18:51:43.046377', '2006-09-13 18:51:43.046377', 'z', 'z'),(5, 7, '2005-12-09', '2005-12-09', '11:39:58.038218', '11:39:58.038218', '2004-03-02 02:51:15.065237', '2004-03-02 02:51:15.065237', 'f', 'f'),(7, 2, '2003-11-21', '2003-11-21', '09:40:20.046022', '09:40:20.046022', '2005-11-13 00:00:00', '2005-11-13 00:00:00', 'c', 'c'),(7, NULL, '2008-01-19', '2008-01-19', NULL, NULL, '2007-04-19 06:55:07.002105', '2007-04-19 06:55:07.002105', 'p', 'p'),(3, 5, '2008-07-01', '2008-07-01', '04:32:34.003943', '04:32:34.003943', '2004-01-12 22:50:49.017673', '2004-01-12 22:50:49.017673', NULL, NULL),(5, 9, '1900-01-01', '1900-01-01', '03:03:29.023434', '03:03:29.023434', '2002-03-08 20:39:37.014665', '2002-03-08 20:39:37.014665', 'g', 'g'),(1, 5, '2003-06-02', '2003-06-02', '15:26:29.015592', '15:26:29.015592', '1900-01-01 00:00:00', '1900-01-01 00:00:00', 'h', 'h'),(3, 8, NULL, NULL, '11:05:51.025033', '11:05:51.025033', '2004-02-01 19:54:12.031426', '2004-02-01 19:54:12.031426', 'w', 'w'),(2, 6, '1900-01-01', '1900-01-01', '00:03:44.000534', '00:03:44.000534', '2008-01-02 07:16:21.065229', '2008-01-02 07:16:21.065229', 'h', 'h'),(1, 9, '2002-04-25', '2002-04-25', '16:43:48.050330', '16:43:48.050330', '1900-01-01 00:00:00', '1900-01-01 00:00:00', 'r', 'r'),(2, 6, '2008-08-05', '2008-08-05', '20:25:08.050337', '20:25:08.050337', NULL, NULL, 'v', 'v'),(24, 207, '2009-01-22', '2009-01-22', '18:56:19.027314', '18:56:19.027314', '2003-04-03 00:00:00', '2003-04-03 00:00:00', 'v', 'v'),(4, 9, NULL, NULL, '09:51:00.036234', '09:51:00.036234', '2009-10-15 00:00:00', '2009-10-15 00:00:00', 'f', 'f'),(5, 3, '2008-10-23', '2008-10-23', '08:16:04.015887', '08:16:04.015887', '2003-09-24 16:00:47.041116', '2003-09-24 16:00:47.041116', 'j', 'j'),(4, 7, '2009-03-15', '2009-03-15', '07:33:15.006758', '07:33:15.006758', '2009-05-06 03:49:51.019258', '2009-05-06 03:49:51.019258', NULL, NULL),(3, NULL, '2004-02-21', '2004-02-21', '22:18:07.060540', '22:18:07.060540', '2004-09-05 00:00:00', '2004-09-05 00:00:00', 'n', 'n'),(0, 1, '1900-01-01', '1900-01-01', '04:58:26.024642', '04:58:26.024642', '1900-01-01 00:00:00', '1900-01-01 00:00:00', 'g', 'g'),(9, 5, '2002-04-15', '2002-04-15', '09:46:09.023701', '09:46:09.023701', '2008-07-04 19:02:55.023893', '2008-07-04 19:02:55.023893', 'n', 'n'),(NULL, 2, '2008-03-06', '2008-03-06', '05:55:16.023106', '05:55:16.023106', '2008-09-28 08:48:36.004066', '2008-09-28 08:48:36.004066', 'k', 'k'),(4, 1, '2000-05-14', '2000-05-14', '15:52:54.061816', '15:52:54.061816', '2005-01-03 19:49:38.042368', '2005-01-03 19:49:38.042368', 't', 't'),(1, 6, '2007-03-08', '2007-03-08', '17:00:05.051810', '17:00:05.051810', '2007-10-05 00:00:00', '2007-10-05 00:00:00', 'w', 'w'),(1, 1, '2006-12-09', '2006-12-09', '06:27:23.026519', '06:27:23.026519', '2004-06-22 10:40:35.054283', '2004-06-22 10:40:35.054283', 'q', 'q'),(2, 1, '2002-07-14', '2002-07-14', '00:20:46.020456', '00:20:46.020456', '2006-10-09 09:56:18.028618', '2006-10-09 09:56:18.028618', 'z', 'z'),(4, 2, '1900-01-01', '1900-01-01', '18:30:14.025146', '18:30:14.025146', '2000-10-11 00:00:00', '2000-10-11 00:00:00', 'z', 'z'),(81, 11, '2001-01-27', '2001-01-27', '00:00:00', '00:00:00', '2008-11-01 16:39:20.040419', '2008-11-01 16:39:20.040419', 'z', 'z'),(1, 7, '2003-08-23', '2003-08-23', '11:24:08.043566', '11:24:08.043566', '2005-08-04 11:01:11.025601', '2005-08-04 11:01:11.025601', 'u', 'u'),(9, 7, '2001-01-05', '2001-01-05', '19:38:37.012379', '19:38:37.012379', '1900-01-01 00:00:00', '1900-01-01 00:00:00', 'p', 'p'),(48, 155, '2008-07-24', '2008-07-24', '21:55:15.032904', '21:55:15.032904', '2009-06-09 00:00:00', '2009-06-09 00:00:00', 'v', 'v'),(2, 7, NULL, NULL, '09:43:23.027255', '09:43:23.027255', '2007-04-01 00:00:00', '2007-04-01 00:00:00', 'a', 'a'),(3, 2, '2006-09-19', '2006-09-19', NULL, NULL, '2006-09-22 20:53:53.017932', '2006-09-22 20:53:53.017932', 'd', 'd'),(9, 0, '1900-01-01', '1900-01-01', '13:26:00.029063', '13:26:00.029063', '2005-05-11 00:00:00', '2005-05-11 00:00:00', 'a', 'a'),(6, 0, '2007-08-13', '2007-08-13', '13:10:48.033588', '13:10:48.033588', '2008-04-16 03:09:58.051805', '2008-04-16 03:09:58.051805', 'k', 'k'),(5, NULL, '1900-01-01', '1900-01-01', '13:58:12.062405', '13:58:12.062405', '2003-12-16 09:13:26.053817', '2003-12-16 09:13:26.053817', 'j', 'j'),(9, 9, '2008-05-26', '2008-05-26', '00:00:00', '00:00:00', '2001-01-06 18:04:35.059873', '2001-01-06 18:04:35.059873', 's', 's'),(2, 9, '2009-06-02', '2009-06-02', '12:03:52.057143', '12:03:52.057143', NULL, NULL, 'w', 'w'),(0, 0, '2007-04-20', '2007-04-20', '19:12:21.053786', '19:12:21.053786', '2007-07-08 17:25:18.029649', '2007-07-08 17:25:18.029649', 'k', 'k'),(NULL, NULL, '2007-06-11', '2007-06-11', '00:00:00', '00:00:00', '1900-01-01 00:00:00', '1900-01-01 00:00:00', 'n', 'n'),(9, 2, '2004-09-21', '2004-09-21', '01:03:07.021337', '01:03:07.021337', '2002-07-27 18:13:04.060783', '2002-07-27 18:13:04.060783', 'o', 'o'),(2, 5, '2006-04-20', '2006-04-20', '09:02:08.010808', '09:02:08.010808', '2007-08-28 20:09:01.055267', '2007-08-28 20:09:01.055267', 'z', 'z'),(8, 8, '2005-07-11', '2005-07-11', NULL, NULL, '2009-10-07 05:56:42.044404', '2009-10-07 05:56:42.044404', 'u', 'u'),(3, 1, '2007-09-12', '2007-09-12', '23:59:50.039828', '23:59:50.039828', '2008-02-26 23:56:03.024006', '2008-02-26 23:56:03.024006', 'v', 'v'),(0, 7, '2005-02-04', '2005-02-04', NULL, NULL, '2001-04-14 23:08:04.032395', '2001-04-14 23:08:04.032395', 'h', 'h'),(3, 2, '1900-01-01', '1900-01-01', '23:50:10.007329', '23:50:10.007329', '2007-01-04 00:27:37.054187', '2007-01-04 00:27:37.054187', 'o', 'o'),(7, 9, '2007-03-26', '2007-03-26', NULL, NULL, '2009-08-13 05:16:57.042362', '2009-08-13 05:16:57.042362', NULL, NULL),(7, 0, '2001-11-19', '2001-11-19', '16:01:04.029311', '16:01:04.029311', '2001-11-26 00:00:00', '2001-11-26 00:00:00', 'w', 'w'),(1, 8, '2007-03-06', '2007-03-06', NULL, NULL, '2004-11-15 04:59:46.025322', '2004-11-15 04:59:46.025322', 'w', 'w'),(57, NULL, NULL, NULL, '19:30:06.015423', '19:30:06.015423', '2001-05-04 01:42:59.042282', '2001-05-04 01:42:59.042282', 'l', 'l'),(7, 7, '2008-09-03', '2008-09-03', '05:02:52.027361', '05:02:52.027361', '2008-10-08 06:04:10.026309', '2008-10-08 06:04:10.026309', 's', 's'),(9, 3, '2009-01-16', '2009-01-16', '16:53:44.006887', '16:53:44.006887', '2000-02-01 19:50:27.014927', '2000-02-01 19:50:27.014927', 'i', 'i'),(7, 7, '2001-04-03', '2001-04-03', '15:57:21.059570', '15:57:21.059570', '2007-01-04 15:17:43.037883', '2007-01-04 15:17:43.037883', NULL, NULL),(0, 7, '2007-03-03', '2007-03-03', '00:00:00', '00:00:00', '2006-01-05 15:12:48.029595', '2006-01-05 15:12:48.029595', 's', 's'),(3, 2, '2000-09-08', '2000-09-08', '07:55:18.021246', '07:55:18.021246', '2003-04-18 10:43:19.024679', '2003-04-18 10:43:19.024679', 'm', 'm'),(NULL, 3, '2008-05-05', '2008-05-05', '17:59:45.001624', '17:59:45.001624', '2001-04-02 19:20:18.063445', '2001-04-02 19:20:18.063445', 'b', 'b'),(8, 3, NULL, NULL, NULL, NULL, '2007-10-21 00:00:00', '2007-10-21 00:00:00', 'o', 'o'),(114, 221, '2004-04-08', '2004-04-08', '23:20:45.021316', '23:20:45.021316', '2009-10-17 05:49:00.028196', '2009-10-17 05:49:00.028196', 'a', 'a'),(40, 34, '2003-07-14', '2003-07-14', '15:56:31.045208', '15:56:31.045208', '2007-04-13 15:56:14.029096', '2007-04-13 15:56:14.029096', 'g', 'g'),(9, 7, '2009-10-24', '2009-10-24', '05:14:36.045315', '05:14:36.045315', '2003-04-01 09:49:43.039174', '2003-04-01 09:49:43.039174', 'o', 'o'),(5, 3, '2003-06-20', '2003-06-20', '16:49:08.061670', '16:49:08.061670', '2009-02-07 19:31:27.009867', '2009-02-07 19:31:27.009867', 'y', 'y'),(0, 6, '1900-01-01', '1900-01-01', '00:00:00', '00:00:00', '1900-01-01 00:00:00', '1900-01-01 00:00:00', 'w', 'w'),(0, 1, '2003-10-10', '2003-10-10', '19:08:35.029723', '19:08:35.029723', '2008-06-16 02:12:52.054594', '2008-06-16 02:12:52.054594', 'i', 'i'),(NULL, NULL, '1900-01-01', '1900-01-01', '07:22:36.015383', '07:22:36.015383', '2000-09-16 20:06:11.021122', '2000-09-16 20:06:11.021122', 'f', 'f'),(NULL, 4, '2004-05-26', '2004-05-26', '02:14:32.012471', '02:14:32.012471', '2003-10-24 20:02:30.033726', '2003-10-24 20:02:30.033726', NULL, NULL),(0, NULL, '2006-03-17', '2006-03-17', '12:36:08.031308', '12:36:08.031308', '2009-12-07 04:29:58.001059', '2009-12-07 04:29:58.001059', 'y', 'y'),(3, 8, '2001-01-14', '2001-01-14', '09:14:08.014936', '09:14:08.014936', '2004-01-07 23:49:25.037930', '2004-01-07 23:49:25.037930', 'f', 'f'),(NULL, 9, '2006-09-08', '2006-09-08', '21:48:45.049745', '21:48:45.049745', '2008-03-02 00:07:03.039450', '2008-03-02 00:07:03.039450', 'g', 'g'),(3, 7, '2004-03-13', '2004-03-13', '00:00:00', '00:00:00', '1900-01-01 00:00:00', '1900-01-01 00:00:00', 'd', 'd'),(5, 9, NULL, NULL, '03:53:40.008828', '03:53:40.008828', '2002-05-16 20:42:48.039009', '2002-05-16 20:42:48.039009', 'm', 'm'),(8, 9, '2005-08-05', '2005-08-05', '10:39:51.040961', '10:39:51.040961', '2004-08-13 03:55:16.038602', '2004-08-13 03:55:16.038602', 'b', 'b'),(5, 1, '2000-09-07', '2000-09-07', '00:00:00', '00:00:00', '2002-05-21 23:48:48.015133', '2002-05-21 23:48:48.015133', 'r', 'r'),(101, 242, '1900-01-01', '1900-01-01', '19:38:44.001407', '19:38:44.001407', '2002-10-10 00:00:00', '2002-10-10 00:00:00', 'u', 'u'),(7, 7, NULL, NULL, '00:00:00', '00:00:00', '2001-10-28 17:35:06.003399', '2001-10-28 17:35:06.003399', 'u', 'u'),(6, 9, '2004-11-03', '2004-11-03', '09:43:13.031489', '09:43:13.031489', '2007-02-25 00:00:00', '2007-02-25 00:00:00', 'n', 'n'),(0, 3, '2004-01-23', '2004-01-23', '00:00:00', '00:00:00', '2000-04-08 03:06:41.018829', '2000-04-08 03:06:41.018829', 'b', 'b'),(5, 2, '2008-05-15', '2008-05-15', NULL, NULL, '1900-01-01 00:00:00', '1900-01-01 00:00:00', 'b', 'b'),(0, 6, '2007-05-20', '2007-05-20', '20:33:51.064039', '20:33:51.064039', NULL, NULL, 'd', 'd'),(6, 1, '1900-01-01', '1900-01-01', '00:00:00', '00:00:00', '1900-01-01 00:00:00', '1900-01-01 00:00:00', NULL, NULL),(8, 1, '2007-04-01', '2007-04-01', '15:55:06.041752', '15:55:06.041752', '2002-05-28 16:59:50.040294', '2002-05-28 16:59:50.040294', 'd', 'd'),(6, 2, '2002-01-05', '2002-01-05', NULL, NULL, '2001-06-26 08:01:40.053583', '2001-06-26 08:01:40.053583', 'e', 'e'),(18, 247, '2004-10-22', '2004-10-22', NULL, NULL, '2000-07-19 00:47:37.049348', '2000-07-19 00:47:37.049348', 'i', 'i'),(NULL, 1, '2006-03-10', '2006-03-10', '06:21:20.056375', '06:21:20.056375', '2004-09-27 17:43:01.051000', '2004-09-27 17:43:01.051000', 'i', 'i'),(NULL, 1, '1900-01-01', '1900-01-01', '16:24:00.031463', '16:24:00.031463', '1900-01-01 00:00:00', '1900-01-01 00:00:00', 's', 's'),(6, 4, '2001-03-01', '2001-03-01', '17:39:17.032723', '17:39:17.032723', NULL, NULL, NULL, NULL),(7, 3, '2005-08-21', '2005-08-21', NULL, NULL, '2006-06-26 12:57:48.030306', '2006-06-26 12:57:48.030306', 'g', 'g'),(5, 2, '2004-04-07', '2004-04-07', '21:41:53.065501', '21:41:53.065501', NULL, NULL, 'j', 'j'),(9, 9, '2004-06-02', '2004-06-02', '05:36:23.041549', '05:36:23.041549', '2007-07-26 17:21:00.000677', '2007-07-26 17:21:00.000677', 'z', 'z'),(3, 7, '2000-08-24', '2000-08-24', '15:21:53.041439', '15:21:53.041439', '2009-10-22 17:11:04.006245', '2009-10-22 17:11:04.006245', 'v', 'v'),(8, 7, '2005-04-20', '2005-04-20', '05:45:04.003839', '05:45:04.003839', '2006-03-04 06:12:34.018454', '2006-03-04 06:12:34.018454', 'v', 'v'),(53, NULL, '1900-01-01', '1900-01-01', '09:50:07.057089', '09:50:07.057089', '1900-01-01 00:00:00', '1900-01-01 00:00:00', 'm', 'm'),(5, 0, NULL, NULL, '01:08:11.042247', '01:08:11.042247', NULL, NULL, 's', 's'),(3, 6, '2008-12-17', '2008-12-17', '20:13:41.030057', '20:13:41.030057', '2008-12-05 00:01:47.059495', '2008-12-05 00:01:47.059495', 'f', 'f'),(134, 159, '2003-01-12', '2003-01-12', NULL, NULL, '2009-04-08 00:00:00', '2009-04-08 00:00:00', 'm', 'm'),(NULL, 0, '2002-04-24', '2002-04-24', '21:08:35.064143', '21:08:35.064143', '2000-12-05 05:53:11.049227', '2000-12-05 05:53:11.049227', 'j', 'j'),(1, 2, '2001-07-06', '2001-07-06', '11:12:35.007134', '11:12:35.007134', '1900-01-01 00:00:00', '1900-01-01 00:00:00', NULL, NULL),(4, 7, '2004-12-25', '2004-12-25', '23:37:35.039451', '23:37:35.039451', '2005-03-27 00:00:00', '2005-03-27 00:00:00', 'f', 'f'),(2, 4, '2007-08-08', '2007-08-08', '06:16:07.020290', '06:16:07.020290', '2007-03-08 00:00:00', '2007-03-08 00:00:00', 'n', 'n'),(NULL, 2, '2007-03-15', '2007-03-15', '07:09:49.043306', '07:09:49.043306', '2005-02-11 09:44:26.002323', '2005-02-11 09:44:26.002323', 'q', 'q'),(2, 8, NULL, NULL, '03:21:04.044293', '03:21:04.044293', '2004-06-28 10:59:34.013861', '2004-06-28 10:59:34.013861', 'w', 'w'),(8, 1, '2005-11-05', '2005-11-05', '17:39:52.005798', '17:39:52.005798', '2002-12-27 19:10:36.035034', '2002-12-27 19:10:36.035034', 's', 's'),(44, NULL, '2006-11-18', '2006-11-18', '12:04:58.057932', '12:04:58.057932', '2006-05-16 23:27:16.031447', '2006-05-16 23:27:16.031447', 'i', 'i'); CREATE TABLE CC ( pk INTEGER AUTO_INCREMENT, col_int_nokey INTEGER /*! NULL */, col_int_key INTEGER AS (col_int_nokey * 2) VIRTUAL, col_date_key DATE AS (DATE_SUB(col_date_nokey, INTERVAL 1 DAY)) VIRTUAL, col_date_nokey DATE /*! NULL */, col_time_key TIME AS (TIME(col_time_nokey)) VIRTUAL, col_time_nokey TIME /*! NULL */, col_datetime_key DATETIME AS (DATE_ADD(col_datetime_nokey, INTERVAL 1 HOUR)) VIRTUAL, col_datetime_nokey DATETIME /*! NULL */, col_varchar_key VARCHAR(1) AS (CONCAT('virt-',col_varchar_nokey)) VIRTUAL, col_varchar_nokey VARCHAR(1) /*! NULL */, PRIMARY KEY (pk), KEY (col_int_key), KEY (col_varchar_key, col_int_key) ) ENGINE=InnoDB; INSERT INTO CC ( col_int_key, col_int_nokey, col_date_key, col_date_nokey, col_time_key, col_time_nokey, col_datetime_key, col_datetime_nokey, col_varchar_key, col_varchar_nokey ) VALUES (8, NULL, '2000-12-03', '2000-12-03', '22:55:23.019225', '22:55:23.019225', '2005-07-20 00:00:00', '2005-07-20 00:00:00', 'x', 'x'),(7, 8, '2008-05-03', '2008-05-03', '10:19:31.050677', '10:19:31.050677', '2007-10-06 17:56:40.056051', '2007-10-06 17:56:40.056051', 'd', 'd'),(1, 1, '2005-12-06', '2005-12-06', '14:40:36.038608', '14:40:36.038608', NULL, NULL, 'r', 'r'),(7, 9, '2000-04-10', '2000-04-10', '04:37:47.062416', '04:37:47.062416', '2007-12-23 05:17:49.029955', '2007-12-23 05:17:49.029955', 'f', 'f'),(9, 4, '2002-11-05', '2002-11-05', '19:34:06.054514', '19:34:06.054514', NULL, NULL, 'y', 'y'),(NULL, 3, '2000-09-06', '2000-09-06', '20:35:33.022996', '20:35:33.022996', '2000-08-16 00:00:00', '2000-08-16 00:00:00', 'u', 'u'),(1, 2, NULL, NULL, NULL, NULL, NULL, NULL, 'm', 'm'),(9, NULL, '2007-06-14', '2007-06-14', '14:43:37.057393', '14:43:37.057393', '2003-02-07 09:50:39.001189', '2003-02-07 09:50:39.001189', NULL, NULL),(2, 2, '2007-11-17', '2007-11-17', '02:23:09.043438', '02:23:09.043438', '2003-08-04 23:00:25.012582', '2003-08-04 23:00:25.012582', 'o', 'o'),(9, NULL, '2009-02-23', '2009-02-23', '01:22:45.041064', '01:22:45.041064', '2009-08-07 12:57:18.026416', '2009-08-07 12:57:18.026416', 'w', 'w'),(2, 6, '2007-01-08', '2007-01-08', '00:00:00', '00:00:00', '1900-01-01 00:00:00', '1900-01-01 00:00:00', 'm', 'm'),(4, 7, '2008-06-10', '2008-06-10', '00:13:25.038482', '00:13:25.038482', '2001-06-17 01:34:03.065074', '2001-06-17 01:34:03.065074', 'q', 'q'),(0, 2, '2002-10-20', '2002-10-20', '03:47:16.042671', '03:47:16.042671', NULL, NULL, NULL, NULL),(4, 5, '2008-09-12', '2008-09-12', '01:41:48.007423', '01:41:48.007423', '1900-01-01 00:00:00', '1900-01-01 00:00:00', 'd', 'd'),(8, 7, '2006-06-16', '2006-06-16', '00:00:00', '00:00:00', NULL, NULL, 'g', 'g'),(NULL, 6, '2004-09-18', '2004-09-18', '22:32:04.047407', '22:32:04.047407', '2007-08-22 14:10:22.054447', '2007-08-22 14:10:22.054447', 'x', 'x'),(NULL, 6, '1900-01-01', '1900-01-01', '16:44:14.028443', '16:44:14.028443', '2005-01-07 12:15:05.055865', '2005-01-07 12:15:05.055865', 'f', 'f'); SELECT SQ1_alias1.* FROM ( `E` AS SQ1_alias2 INNER JOIN `CC` AS SQ1_alias3 ) LEFT JOIN `CC` AS SQ1_alias1 ON (SQ1_alias3.`col_int_key` = SQ1_alias2.`col_int_key` ) WHERE EXISTS ( SELECT * FROM `D` WHERE SQ1_alias1.`col_int_key` = 1 ) AND SQ1_alias3.`col_varchar_key` = SQ1_alias2.`col_varchar_key`; ALTER TABLE `CC` ADD KEY rkr_index_1 ( `col_varchar_nokey` );