# Begin test case --disable_warnings DROP TABLE /*! IF EXISTS */ A; DROP TABLE /*! IF EXISTS */ B; DROP TABLE /*! IF EXISTS */ C; DROP TABLE /*! IF EXISTS */ CC; DROP TABLE /*! IF EXISTS */ D; --enable_warnings CREATE TABLE A (pk INTEGER AUTO_INCREMENT, int_nokey INTEGER NULL, int_key INTEGER NULL, date_key DATE NULL, date_nokey DATE NULL, time_key TIME NULL, time_nokey TIME NULL, datetime_key DATETIME NULL, datetime_nokey DATETIME NULL, varchar_key VARCHAR(1) NULL, varchar_nokey VARCHAR(1) NULL, PRIMARY KEY (pk), KEY (int_key), KEY (date_key), KEY (time_key), KEY (datetime_key), KEY (varchar_key, int_key)) ENGINE=MyISAM AUTO_INCREMENT=101 DEFAULT CHARSET=latin1; CREATE TABLE B (pk INTEGER AUTO_INCREMENT, int_nokey INTEGER NULL, int_key INTEGER NULL, date_key DATE NULL, date_nokey DATE NULL, time_key TIME NULL, time_nokey TIME NULL, datetime_key DATETIME NULL, datetime_nokey DATETIME NULL, varchar_key VARCHAR(1) NULL, varchar_nokey VARCHAR(1) NULL, PRIMARY KEY (pk), KEY (int_key), KEY (date_key), KEY (time_key), KEY (datetime_key), KEY (varchar_key, int_key)) ENGINE=MyISAM AUTO_INCREMENT=101 DEFAULT CHARSET=latin1; INSERT INTO B ( int_key, int_nokey, date_key, date_nokey, time_key, time_nokey, datetime_key, datetime_nokey, varchar_key, varchar_nokey ) VALUES ('7', '1', '1900-01-01', '1900-01-01', '01:13:38', '01:13:38', '2005-02-05 00:00:00', '2005-02-05 00:00:00', 'f', 'f'); CREATE TABLE C (pk INTEGER AUTO_INCREMENT, int_nokey INTEGER NULL, int_key INTEGER NULL, date_key DATE NULL, date_nokey DATE NULL, time_key TIME NULL, time_nokey TIME NULL, datetime_key DATETIME NULL, datetime_nokey DATETIME NULL, varchar_key VARCHAR(1) NULL, varchar_nokey VARCHAR(1) NULL, PRIMARY KEY (pk), KEY (int_key), KEY (date_key), KEY (time_key), KEY (datetime_key), KEY (varchar_key, int_key)) ENGINE=MyISAM AUTO_INCREMENT=101 DEFAULT CHARSET=latin1; INSERT INTO C ( int_key, int_nokey, date_key, date_nokey, time_key, time_nokey, datetime_key, datetime_nokey, varchar_key, varchar_nokey ) VALUES ('2', NULL, NULL, NULL, '11:28:45', '11:28:45', '2004-10-11 18:13:16', '2004-10-11 18:13:16', 'w', 'w'), ('9', '7', '2001-09-19', '2001-09-19', '20:25:14', '20:25:14', NULL, NULL, 'm', 'm') , ('3', '9', '2004-09-12', '2004-09-12', '13:47:24', '13:47:24', '1900-01-01 00:00:00', '1900-01-01 00:00:00', 'm', 'm'), ('9', '7', NULL, NULL, '19:24:11', '19:24:11', '2009-07-25 00:00:00', '2009-07-25 00:00:00', 'k', 'k'), (NULL, '4', '2002-07-19', '2002-07-19', '15:59:13', '15:59:13', NULL, NULL, 'r', 'r') ,('9', '2', '2002-12-16', '2002-12-16', '00:00:00', '00:00:00', '2008-07-27 00:00:00', '2008-07-27 00:00:00', 't', 't') ,('3', '6', '2006-02-08', '2006-02-08', '15:15:04', '15:15:04', '2002-11-13 16:37:31', '2002-11-13 16:37:31', 'j', 'j') , ('8', '8', '2006-08-28', '2006-08-28', '11:32:06', '11:32:06', '1900-01-01 00:00:00', '1900-01-01 00:00:00', 'u', 'u') ,('8', NULL, '2001-04-14', '2001-04-14', '18:32:33', '18:32:33', '2003-12-10 00:00:00', '2003-12-10 00:00:00', 'h', 'h') ,('53', '5', '2000-01-05', '2000-01-05', '15:19:25', '15:19:25', '2001-12-21 22:38:22', '2001-12-21 22:38:22', 'o', 'o') ,('0', NULL, '2003-12-06', '2003-12-06', '19:03:19', '19:03:19', '2008-12-13 23:16:44', '2008-12-13 23:16:44', NULL, NULL) ,('5', '6', '1900-01-01', '1900-01-01', '00:39:46', '00:39:46', '2005-08-15 12:39:41', '2005-08-15 12:39:41', 'k', 'k') , ('166', '188', '2002-11-27', '2002-11-27', NULL, NULL, NULL, NULL, 'e', 'e') ,('3', '2', NULL, NULL, '00:00:00', '00:00:00', '2006-09-11 12:06:14', '2006-09-11 12:06:14', 'n', 'n') , ('0', '1', '2003-05-27', '2003-05-27', '13:12:11', '13:12:11', '2007-12-15 12:39:34', '2007-12-15 12:39:34', 't', 't') ,('1', '1', '2005-05-03', '2005-05-03', '04:56:48', '04:56:48', '2005-08-09 00:00:00', '2005-08-09 00:00:00', 'c', 'c') , ('9', '0', '2001-04-18', '2001-04-18', '19:56:05', '19:56:05', '2001-09-02 22:50:02', '2001-09-02 22:50:02', 'm', 'm') ,('5', '9', '2005-12-27', '2005-12-27', '19:35:19', '19:35:19', '2005-12-16 22:58:11', '2005-12-16 22:58:11', 'y', 'y') ,('6', NULL, '2004-08-20', '2004-08-20', '05:03:03', '05:03:03', '2007-04-19 00:19:53', '2007-04-19 00:19:53', 'f', 'f') ,('2', '4', '1900-01-01', '1900-01-01', '18:38:59', '18:38:59', '1900-01-01 00:00:00', '1900-01-01 00:00:00', 'd', 'd') ; CREATE TABLE CC (pk INTEGER AUTO_INCREMENT, int_nokey INTEGER NULL, int_key INTEGER NULL, date_key DATE NULL, date_nokey DATE NULL, time_key TIME NULL, time_nokey TIME NULL, datetime_key DATETIME NULL, datetime_nokey DATETIME NULL, varchar_key VARCHAR(1) NULL, varchar_nokey VARCHAR(1) NULL, PRIMARY KEY (pk), KEY (int_key), KEY (date_key), KEY (time_key), KEY (datetime_key), KEY (varchar_key, int_key)) ENGINE=MyISAM AUTO_INCREMENT=101 DEFAULT CHARSET=latin1; INSERT INTO CC ( int_key, int_nokey, date_key, date_nokey, time_key, time_nokey, datetime_key, datetime_nokey, varchar_key, varchar_nokey ) VALUES ('8', '7', NULL, NULL, '01:27:35', '01:27:35', '2002-02-26 06:14:37', '2002-02-26 06:14:37', 'v', 'v') ,('9', '1', '2006-06-14', '2006-06-14', '19:48:31', '19:48:31', '1900-01-01 00:00:00', '1900-01-01 00:00:00', 'r', 'r') ,('9', '5', '2002-09-12', '2002-09-12', '00:00:00', '00:00:00', '2006-12-03 09:37:26', '2006-12-03 09:37:26', 'a', 'a') ,('186', '3', '2005-02-15', '2005-02-15', '19:53:05', '19:53:05', '2008-05-26 12:27:10', '2008-05-26 12:27:10', 'm', 'm') ,(NULL, '6', NULL, NULL, '19:18:56', '19:18:56', '2004-12-14 16:37:30', '2004-12-14 16:37:30', 'y', 'y') ,('2', '92', '2008-11-04', '2008-11-04', '10:55:12', '10:55:12', '2003-02-11 21:19:41', '2003-02-11 21:19:41', 'j', 'j') ,('3', '7', '2004-09-04', '2004-09-04', '00:25:00', '00:25:00', '2009-10-18 02:27:49', '2009-10-18 02:27:49', 'd', 'd') ,('0', NULL, '2006-06-05', '2006-06-05', '12:35:47', '12:35:47', '2000-09-26 07:45:57', '2000-09-26 07:45:57', 'z', 'z') ,('133', '3', '1900-01-01', '1900-01-01', '19:53:03', '19:53:03', NULL, NULL, 'e', 'e') ,('1', '5', '1900-01-01', '1900-01-01', '17:53:30', '17:53:30', '2005-11-10 12:40:29', '2005-11-10 12:40:29', 'h', 'h') ,('8', '1', '1900-01-01', '1900-01-01', '11:35:49', '11:35:49', '2009-04-25 00:00:00', '2009-04-25 00:00:00', 'b', 'b') ,('5', '2', '2005-01-13', '2005-01-13', NULL, NULL, '2002-11-27 00:00:00', '2002-11-27 00:00:00', 's', 's') ,('5', NULL, '2006-05-21', '2006-05-21', '06:01:40', '06:01:40', '2004-01-26 20:32:32', '2004-01-26 20:32:32', 'e', 'e') ,('8', '1', '2003-09-08', '2003-09-08', '05:45:11', '05:45:11', '2007-10-26 11:41:40', '2007-10-26 11:41:40', 'j', 'j') ,('6', '0', '2006-12-23', '2006-12-23', '00:00:00', '00:00:00', '2005-10-07 00:00:00', '2005-10-07 00:00:00', 'e', 'e') ,('51', '210', '2006-10-15', '2006-10-15', '00:00:00', '00:00:00', '2000-07-15 05:00:34', '2000-07-15 05:00:34', 'f', 'f') ,('4', '8', '2005-04-06', '2005-04-06', '06:11:01', '06:11:01', '2000-04-03 16:33:32', '2000-04-03 16:33:32', 'v', 'v') ,('7', '7', '2008-04-07', '2008-04-07', '13:02:46', '13:02:46', NULL, NULL, 'x', 'x') ,('6', '5', '2006-10-10', '2006-10-10', '21:44:25', '21:44:25', '2001-04-25 01:26:12', '2001-04-25 01:26:12', 'm', 'm') ,('4', NULL, '1900-01-01', '1900-01-01', '22:43:58', '22:43:58', '2000-12-27 00:00:00', '2000-12-27 00:00:00', 'c', 'c'); CREATE TABLE D (pk INTEGER AUTO_INCREMENT, int_nokey INTEGER NULL, int_key INTEGER NULL, date_key DATE NULL, date_nokey DATE NULL, time_key TIME NULL, time_nokey TIME NULL, datetime_key DATETIME NULL, datetime_nokey DATETIME NULL, varchar_key VARCHAR(1) NULL, varchar_nokey VARCHAR(1) NULL, PRIMARY KEY (pk), KEY (int_key), KEY (date_key), KEY (time_key), KEY (datetime_key), KEY (varchar_key, int_key)) ENGINE=MyISAM AUTO_INCREMENT=101 DEFAULT CHARSET=latin1; INSERT INTO D ( int_key, int_nokey, date_key, date_nokey, time_key, time_nokey, datetime_key, datetime_nokey, varchar_key, varchar_nokey ) VALUES (NULL, '6', '2003-05-12', '2003-05-12', NULL, NULL, '2000-09-12 00:00:00', '2000-09-12 00:00:00', 'r', 'r') ,('0', '8', '2003-01-07', '2003-01-07', '14:34:45', '14:34:45', '2004-08-10 09:09:31', '2004-08-10 09:09:31', 'c', 'c') , ('0', '6', NULL, NULL, '11:49:48', '11:49:48', '2005-03-21 04:31:40', '2005-03-21 04:31:40', 'o', 'o') , ('7', '6', '2005-03-12', '2005-03-12', '18:12:55', '18:12:55', '2002-10-25 23:50:35', '2002-10-25 23:50:35', 'c', 'c') , ('8', '3', '2000-08-02', '2000-08-02', '18:30:05', '18:30:05', '2001-04-01 21:14:04', '2001-04-01 21:14:04', 'd', 'd') , ('4', '9', '1900-01-01', '1900-01-01', '14:19:30', '14:19:30', '2005-03-12 06:02:34', '2005-03-12 06:02:34', 'v', 'v') , ('6', '2', '2006-07-06', '2006-07-06', '05:20:04', '05:20:04', '2001-05-06 14:49:12', '2001-05-06 14:49:12', 'm', 'm') , ('5', '1', '2006-12-24', '2006-12-24', '20:29:31', '20:29:31', '2004-04-25 00:00:00', '2004-04-25 00:00:00', 'j', 'j') , (NULL, '8', '2004-11-16', '2004-11-16', '07:08:09', '07:08:09', '2001-03-22 18:38:43', '2001-03-22 18:38:43', 'f', 'f') , (NULL, '0', '2002-09-09', '2002-09-09', '14:49:14', '14:49:14', '2006-04-25 21:03:02', '2006-04-25 21:03:02', 'n', 'n') , ('8', '9', NULL, NULL, '00:00:00', '00:00:00', '2009-09-07 18:40:43', '2009-09-07 18:40:43', 'z', 'z') , ('8', '8', '2008-06-24', '2008-06-24', '09:58:06', '09:58:06', '2004-03-23 00:00:00', '2004-03-23 00:00:00', 'h', 'h') , ('8', NULL, '2001-04-21', '2001-04-21', NULL, NULL, '2009-04-15 00:08:29', '2009-04-15 00:08:29', 'q', 'q') , ('1', '0', '2003-11-22', '2003-11-22', '18:24:16', '18:24:16', '2000-04-21 00:00:00', '2000-04-21 00:00:00', 'w', 'w') , ('1', '5', '2004-09-12', '2004-09-12', '17:39:57', '17:39:57', '2000-02-17 19:41:23', '2000-02-17 19:41:23', 'z', 'z') , ('5', '1', '2006-06-20', '2006-06-20', '08:23:21', '08:23:21', '2003-09-20 07:38:14', '2003-09-20 07:38:14', 'j', 'j') , ('2', '1', NULL, NULL, NULL, NULL, '2000-11-28 20:42:12', '2000-11-28 20:42:12', 'a', 'a') , ('7', '6', '2001-11-25', '2001-11-25', '21:50:46', '21:50:46', '2005-06-12 11:13:17', '2005-06-12 11:13:17', 'm', 'm') , ('6', '6', '2004-10-26', '2004-10-26', '12:33:17', '12:33:17', '1900-01-01 00:00:00', '1900-01-01 00:00:00', 'n', 'n') , ('4', '1', '2005-01-19', '2005-01-19', '03:06:43', '03:06:43', '2006-02-09 20:41:06', '2006-02-09 20:41:06', 'e', 'e') , ('7', '8', '2008-07-06', '2008-07-06', '03:46:14', '03:46:14', '2004-05-22 01:05:57', '2004-05-22 01:05:57', 'u', 'u') , ('0', '1', '1900-01-01', '1900-01-01', '20:34:52', '20:34:52', '2004-03-04 13:46:31', '2004-03-04 13:46:31', 's', 's') , ('9', '0', '1900-01-01', '1900-01-01', NULL, NULL, '1900-01-01 00:00:00', '1900-01-01 00:00:00', 'u', 'u') , ('3', '4', '2004-06-08', '2004-06-08', '10:41:20', '10:41:20', '2004-10-20 07:20:19', '2004-10-20 07:20:19', 'r', 'r') , ('5', '9', '2007-02-20', '2007-02-20', '08:43:11', '08:43:11', '2006-04-17 00:00:00', '2006-04-17 00:00:00', 'g', 'g') , ('1', '8', '2008-06-18', '2008-06-18', NULL, NULL, '2000-10-27 00:00:00', '2000-10-27 00:00:00', 'o', 'o') , ('1', '5', '2008-05-15', '2008-05-15', '10:17:51', '10:17:51', '2007-04-14 08:54:06', '2007-04-14 08:54:06', 'w', 'w') , ('5', '9', '2005-10-06', '2005-10-06', '06:34:09', '06:34:09', '2008-04-12 17:03:52', '2008-04-12 17:03:52', 'b', 'b') , ('9', '5', NULL, NULL, '21:22:47', '21:22:47', '2007-02-19 17:37:09', '2007-02-19 17:37:09', NULL, NULL) , ('2', NULL, '2006-10-12', '2006-10-12', '04:02:32', '04:02:32', '1900-01-01 00:00:00', '1900-01-01 00:00:00', 'y', 'y') , ('5', NULL, '2005-01-24', '2005-01-24', '02:33:14', '02:33:14', '2001-10-10 08:32:27', '2001-10-10 08:32:27', 'y', 'y') , ('248', '105', '2009-06-27', '2009-06-27', '16:32:56', '16:32:56', NULL, NULL, 'u', 'u') , ('0', '0', NULL, NULL, '21:32:42', '21:32:42', '2001-12-16 05:31:53', '2001-12-16 05:31:53', 'p', 'p') , ('8', '3', NULL, NULL, '23:04:47', '23:04:47', '2003-07-19 18:03:28', '2003-07-19 18:03:28', 's', 's') , ('1', '1', '1900-01-01', '1900-01-01', '22:05:43', '22:05:43', '2001-03-27 11:44:10', '2001-03-27 11:44:10', 'e', 'e') , ('255', '75', '2005-12-22', '2005-12-22', '02:05:45', '02:05:45', '2008-06-15 02:13:00', '2008-06-15 02:13:00', 'd', 'd') , ('9', '9', '2005-05-03', '2005-05-03', '00:00:00', '00:00:00', '2009-03-14 21:29:56', '2009-03-14 21:29:56', 'd', 'd') , ('9', '7', '2003-05-27', '2003-05-27', '18:09:07', '18:09:07', '2005-01-02 00:00:00', '2005-01-02 00:00:00', 'c', 'c') , ('3', NULL, '2006-05-25', '2006-05-25', '10:54:06', '10:54:06', '2007-07-16 04:44:07', '2007-07-16 04:44:07', 'b', 'b') , ('9', NULL, NULL, NULL, '23:15:50', '23:15:50', '2003-08-26 21:38:26', '2003-08-26 21:38:26', 't', 't') , ('6', '4', '2009-01-04', '2009-01-04', '10:17:40', '10:17:40', '2004-04-19 04:18:47', '2004-04-19 04:18:47', NULL, NULL) , ('4', '0', '2009-02-14', '2009-02-14', '03:37:09', '03:37:09', '2000-01-06 20:32:48', '2000-01-06 20:32:48', 'y', 'y') , ('60', '204', '2003-01-16', '2003-01-16', '22:26:06', '22:26:06', '2006-06-23 13:27:17', '2006-06-23 13:27:17', 'c', 'c') , ('7', '0', '1900-01-01', '1900-01-01', '17:10:38', '17:10:38', '2007-11-27 00:00:00', '2007-11-27 00:00:00', 'd', 'd') , ('1', '9', '2007-06-26', '2007-06-26', '00:00:00', '00:00:00', '2002-04-03 12:06:51', '2002-04-03 12:06:51', 'x', 'x') , ('6', '8', '2004-03-27', '2004-03-27', '17:08:49', '17:08:49', '2008-12-28 09:47:42', '2008-12-28 09:47:42', 'p', 'p') , ('4', '7', NULL, NULL, '19:04:40', '19:04:40', '2002-04-04 10:07:54', '2002-04-04 10:07:54', 'e', 'e') , (NULL, '8', '2005-06-06', '2005-06-06', '20:53:28', '20:53:28', '2003-04-26 02:55:13', '2003-04-26 02:55:13', 'g', 'g') , ('8', NULL, '2003-03-02', '2003-03-02', '11:46:03', '11:46:03', NULL, NULL, 'x', 'x') , ('0', '6', '2004-05-13', '2004-05-13', NULL, NULL, '2009-02-19 03:17:06', '2009-02-19 03:17:06', 's', 's') , ('8', '5', '2005-09-13', '2005-09-13', '10:58:07', '10:58:07', '1900-01-01 00:00:00', '1900-01-01 00:00:00', 'e', 'e') , ('151', '2', '2005-10-03', '2005-10-03', '00:00:00', '00:00:00', '2000-11-10 08:20:01', '2000-11-10 08:20:01', 'l', 'l') , ('7', '3', '2005-10-14', '2005-10-14', '09:43:15', '09:43:15', '2008-02-10 00:00:00', '2008-02-10 00:00:00', 'p', 'p') , ('6', '7', NULL, NULL, '21:40:32', '21:40:32', '1900-01-01 00:00:00', '1900-01-01 00:00:00', 'h', 'h') , (NULL, NULL, '2005-09-16', '2005-09-16', '00:17:44', '00:17:44', NULL, NULL, 'm', 'm') , ('23', '145', '2005-03-10', '2005-03-10', '16:47:26', '16:47:26', '2001-02-05 02:01:50', '2001-02-05 02:01:50', 'n', 'n') , ('2', '0', '2000-06-19', '2000-06-19', '00:00:00', '00:00:00', '2000-10-28 08:44:25', '2000-10-28 08:44:25', 'v', 'v') , ('4', '1', '2002-11-03', '2002-11-03', '05:25:59', '05:25:59', '2005-03-20 10:53:59', '2005-03-20 10:53:59', 'b', 'b') , (NULL, '7', '2009-01-05', '2009-01-05', '00:00:00', '00:00:00', '2001-06-02 13:54:13', '2001-06-02 13:54:13', 'x', 'x') , (NULL, '3', '2003-05-22', '2003-05-22', '20:33:04', '20:33:04', '1900-01-01 00:00:00', '1900-01-01 00:00:00', 'r', 'r') , ('77', NULL, '2005-07-02', '2005-07-02', '00:46:12', '00:46:12', '2009-07-16 13:05:43', '2009-07-16 13:05:43', 't', 't') , (NULL, '2', '1900-01-01', '1900-01-01', '00:00:00', '00:00:00', '2009-03-26 23:16:20', '2009-03-26 23:16:20', 'w', 'w') , (NULL, '2', '2006-06-21', '2006-06-21', '02:13:59', '02:13:59', '2003-02-06 18:12:15', '2003-02-06 18:12:15', 'w', 'w') , ('7', '2', NULL, NULL, '02:54:47', '02:54:47', '2006-06-05 03:22:51', '2006-06-05 03:22:51', 'k', 'k') , ('1', '8', '2005-12-16', '2005-12-16', '18:13:59', '18:13:59', '2002-02-10 05:47:27', '2002-02-10 05:47:27', 'a', 'a') , ('9', '6', '2004-11-05', '2004-11-05', '13:53:08', '13:53:08', '2001-08-01 08:50:52', '2001-08-01 08:50:52', 't', 't') , ('6', '1', NULL, NULL, '22:21:30', '22:21:30', '1900-01-01 00:00:00', '1900-01-01 00:00:00', 'z', 'z') , ('2', NULL, '2004-09-14', '2004-09-14', '11:41:50', '11:41:50', NULL, NULL, 'e', 'e') , ('3', '1', '2002-04-06', '2002-04-06', '15:20:02', '15:20:02', '1900-01-01 00:00:00', '1900-01-01 00:00:00', 'q', 'q') , ('0', '0', NULL, NULL, NULL, NULL, '2000-09-23 00:00:00', '2000-09-23 00:00:00', 'e', 'e') , (NULL, '4', '2002-11-13', '2002-11-13', NULL, NULL, '2007-07-09 08:32:49', '2007-07-09 08:32:49', 'v', 'v') , ('6', '1', '2006-05-27', '2006-05-27', '07:51:52', '07:51:52', '2000-01-05 00:00:00', '2000-01-05 00:00:00', 'd', 'd') , ('3', '1', '2000-12-22', '2000-12-22', '00:00:00', '00:00:00', '2000-09-24 00:00:00', '2000-09-24 00:00:00', 'u', 'u') , ('195', '27', '2004-02-21', '2004-02-21', NULL, NULL, '2005-05-06 00:00:00', '2005-05-06 00:00:00', 'o', 'o') , ('5', '4', '2009-05-15', '2009-05-15', NULL, NULL, '2000-03-11 00:00:00', '2000-03-11 00:00:00', 'b', 'b') , ('2', '6', '2008-12-12', '2008-12-12', '12:31:05', '12:31:05', '2001-09-02 16:17:35', '2001-09-02 16:17:35', 'c', 'c') , ('7', '2', '2000-04-15', '2000-04-15', '00:00:00', '00:00:00', '2006-04-25 05:43:44', '2006-04-25 05:43:44', 'q', 'q') , ('25', '248', NULL, NULL, '01:16:45', '01:16:45', '2009-10-25 22:04:02', '2009-10-25 22:04:02', NULL, NULL) , (NULL, NULL, '2001-10-18', '2001-10-18', '20:38:54', '20:38:54', '2004-08-06 00:00:00', '2004-08-06 00:00:00', 'h', 'h') , ('0', '9', '2008-05-25', '2008-05-25', '00:30:15', '00:30:15', '2001-11-27 05:07:57', '2001-11-27 05:07:57', 'd', 'd') , ('98', '75', '2004-12-02', '2004-12-02', '23:46:36', '23:46:36', '2009-06-28 03:18:39', '2009-06-28 03:18:39', 'w', 'w') , ('6', '2', '2002-02-15', '2002-02-15', '19:03:13', '19:03:13', '2000-03-12 00:00:00', '2000-03-12 00:00:00', 'm', 'm') , ('5', '9', '2002-03-03', '2002-03-03', '10:54:27', '10:54:27', NULL, NULL, 'i', 'i') , ('0', '4', NULL, NULL, '00:25:47', '00:25:47', '2007-10-20 00:00:00', '2007-10-20 00:00:00', 'w', 'w') , ('3', '0', '2003-01-26', '2003-01-26', '08:44:27', '08:44:27', '2009-09-27 00:00:00', '2009-09-27 00:00:00', 'f', 'f') , ('1', '0', '2001-12-19', '2001-12-19', '08:15:38', '08:15:38', '2002-07-16 00:00:00', '2002-07-16 00:00:00', 'k', 'k') , ('1', '1', '2001-08-07', '2001-08-07', '19:56:21', '19:56:21', '2005-02-20 00:00:00', '2005-02-20 00:00:00', 'v', 'v') , ('147', '119', '2005-02-16', '2005-02-16', '00:00:00', '00:00:00', NULL, NULL, 'c', 'c') , ('3', '1', '2006-06-10', '2006-06-10', '20:50:52', '20:50:52', '2001-07-16 00:00:00', '2001-07-16 00:00:00', 'y', 'y') , ('3', '7', NULL, NULL, '03:54:39', '03:54:39', '2009-05-20 21:04:12', '2009-05-20 21:04:12', 'h', 'h') , (NULL, '2', '2005-04-06', '2005-04-06', '23:58:17', '23:58:17', '2002-03-13 10:55:40', '2002-03-13 10:55:40', NULL, NULL) , ('2', '7', '2003-04-27', '2003-04-27', '12:54:58', '12:54:58', '2005-07-12 00:00:00', '2005-07-12 00:00:00', 't', 't') , ('1', '2', '2005-10-13', '2005-10-13', '04:02:43', '04:02:43', '2006-07-22 09:46:34', '2006-07-22 09:46:34', 'l', 'l') , ('8', '6', '2003-10-02', '2003-10-02', '11:31:12', '11:31:12', '2001-09-01 00:00:00', '2001-09-01 00:00:00', 'a', 'a') , ('8', '4', '2005-09-09', '2005-09-09', '20:20:04', '20:20:04', '2002-05-27 18:38:45', '2002-05-27 18:38:45', 'r', 'r') , ('8', '5', NULL, NULL, '00:22:24', '00:22:24', NULL, NULL, 's', 's') , ('0', '7', '2006-02-15', '2006-02-15', '10:09:31', '10:09:31', NULL, NULL, 'z', 'z') , ('1', '1', '1900-01-01', '1900-01-01', NULL, NULL, '2009-08-08 22:38:53', '2009-08-08 22:38:53', 'j', 'j') , ('8', '7', '2003-12-24', '2003-12-24', '18:45:35', '18:45:35', NULL, NULL, 'c', 'c') , ('5', '2', '2001-07-26', '2001-07-26', '11:49:25', '11:49:25', '2007-04-25 05:08:49', '2007-04-25 05:08:49', 'f', 'f') ; SELECT COUNT( table2 . `pk` ) AS field1 FROM ( D AS table1 STRAIGHT_JOIN ( ( B AS table2 INNER JOIN CC AS table3 ON (table3 . `varchar_key` = table2 . `varchar_key` ) ) ) ON (table3 . `varchar_key` = table2 . `varchar_key` ) ) WHERE ( NOT EXISTS ( ( SELECT SUBQUERY1_t1 . `varchar_key` AS SUBQUERY1_field1 FROM ( D AS SUBQUERY1_t1 INNER JOIN ( ( B AS SUBQUERY1_t2 STRAIGHT_JOIN C AS SUBQUERY1_t3 ON (SUBQUERY1_t3 . `varchar_key` = SUBQUERY1_t2 . `varchar_nokey` ) ) ) ON (( 'a', 'v' ) IN ( SELECT SUBQUERY1_t1 . `varchar_key` AS SUBQUERY1_field1 , MIN( DISTINCT SUBQUERY1_t1 . `varchar_key` ) AS SUBQUERY1_field2 FROM ( A AS SUBQUERY1_t4 ) ) ) ) WHERE SUBQUERY1_t2 . `int_nokey` > 2 ) ) ) AND table1 . `int_key` > 49 AND table1 . `int_key` < ( 49 + 187 ) OR ( table1 . `pk` != table2 . `pk` AND table1 . `varchar_nokey` IS NULL ) HAVING field1 <= 7 ORDER BY table1 . `pk` ASC , field1 ;