-- MySQL dump 10.13 Distrib 6.0.6-alpha, for pc-linux-gnu (i686) -- -- Host: localhost Database: test -- ------------------------------------------------------ -- Server version 6.0.6-alpha-debug-log /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8 */; /*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */; /*!40103 SET TIME_ZONE='+00:00' */; /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */; /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */; /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; -- -- Table structure for table `A` -- DROP TABLE IF EXISTS `A`; SET @saved_cs_client = @@character_set_client; SET character_set_client = utf8; CREATE TABLE `A` ( `pk` int(11) NOT NULL AUTO_INCREMENT, `int_nokey` int(11) NOT NULL, `int_key` int(11) NOT NULL, `date_key` date NOT NULL, `date_nokey` date NOT NULL, `time_key` time NOT NULL, `time_nokey` time NOT NULL, `datetime_key` datetime NOT NULL, `datetime_nokey` datetime NOT NULL, `varchar_key` varchar(1) NOT NULL, `varchar_nokey` varchar(1) NOT NULL, PRIMARY KEY (`pk`), KEY `int_key` (`int_key`), KEY `date_key` (`date_key`), KEY `time_key` (`time_key`), KEY `datetime_key` (`datetime_key`), KEY `varchar_key` (`varchar_key`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; SET character_set_client = @saved_cs_client; -- -- Dumping data for table `A` -- LOCK TABLES `A` WRITE; /*!40000 ALTER TABLE `A` DISABLE KEYS */; /*!40000 ALTER TABLE `A` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `B` -- DROP TABLE IF EXISTS `B`; SET @saved_cs_client = @@character_set_client; SET character_set_client = utf8; CREATE TABLE `B` ( `pk` int(11) NOT NULL AUTO_INCREMENT, `int_nokey` int(11) NOT NULL, `int_key` int(11) NOT NULL, `date_key` date NOT NULL, `date_nokey` date NOT NULL, `time_key` time NOT NULL, `time_nokey` time NOT NULL, `datetime_key` datetime NOT NULL, `datetime_nokey` datetime NOT NULL, `varchar_key` varchar(1) NOT NULL, `varchar_nokey` varchar(1) NOT NULL, PRIMARY KEY (`pk`), KEY `int_key` (`int_key`), KEY `date_key` (`date_key`), KEY `time_key` (`time_key`), KEY `datetime_key` (`datetime_key`), KEY `varchar_key` (`varchar_key`) ) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=latin1; SET character_set_client = @saved_cs_client; -- -- Dumping data for table `B` -- LOCK TABLES `B` WRITE; /*!40000 ALTER TABLE `B` DISABLE KEYS */; INSERT INTO `B` VALUES (1,8,5,'0000-00-00','0000-00-00','10:37:38','10:37:38','0000-00-00 00:00:00','0000-00-00 00:00:00','p','p'); /*!40000 ALTER TABLE `B` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `C` -- DROP TABLE IF EXISTS `C`; SET @saved_cs_client = @@character_set_client; SET character_set_client = utf8; CREATE TABLE `C` ( `pk` int(11) NOT NULL AUTO_INCREMENT, `int_nokey` int(11) NOT NULL, `int_key` int(11) NOT NULL, `date_key` date NOT NULL, `date_nokey` date NOT NULL, `time_key` time NOT NULL, `time_nokey` time NOT NULL, `datetime_key` datetime NOT NULL, `datetime_nokey` datetime NOT NULL, `varchar_key` varchar(1) NOT NULL, `varchar_nokey` varchar(1) NOT NULL, PRIMARY KEY (`pk`), KEY `int_key` (`int_key`), KEY `date_key` (`date_key`), KEY `time_key` (`time_key`), KEY `datetime_key` (`datetime_key`), KEY `varchar_key` (`varchar_key`) ) ENGINE=MyISAM AUTO_INCREMENT=21 DEFAULT CHARSET=latin1; SET character_set_client = @saved_cs_client; -- -- Dumping data for table `C` -- LOCK TABLES `C` WRITE; /*!40000 ALTER TABLE `C` DISABLE KEYS */; INSERT INTO `C` VALUES (1,0,9,'0000-00-00','0000-00-00','00:00:00','00:00:00','2007-10-14 00:00:00','2007-10-14 00:00:00','d','d'),(2,1,6,'2005-12-23','2005-12-23','02:24:28','02:24:28','0000-00-00 00:00:00','0000-00-00 00:00:00','g','g'),(3,0,3,'2009-09-14','2009-09-14','00:00:00','00:00:00','2000-01-30 16:39:40','2000-01-30 16:39:40','q','q'),(4,0,3,'0000-00-00','0000-00-00','00:00:00','00:00:00','0000-00-00 00:00:00','0000-00-00 00:00:00','c','c'),(5,1,6,'2007-03-29','2007-03-29','15:49:00','15:49:00','0000-00-00 00:00:00','0000-00-00 00:00:00','m','m'),(6,4,0,'2002-12-04','2002-12-04','00:00:00','00:00:00','0000-00-00 00:00:00','0000-00-00 00:00:00','o','o'),(7,9,0,'2005-01-28','2005-01-28','00:00:00','00:00:00','2001-05-18 00:00:00','2001-05-18 00:00:00','w','w'),(8,6,0,'0000-00-00','0000-00-00','06:57:25','06:57:25','0000-00-00 00:00:00','0000-00-00 00:00:00','m','m'),(9,0,0,'0000-00-00','0000-00-00','00:00:00','00:00:00','0000-00-00 00:00:00','0000-00-00 00:00:00','z','z'),(10,4,6,'2006-08-15','2006-08-15','00:00:00','00:00:00','2002-04-12 14:44:25','2002-04-12 14:44:25','j','j'),(11,0,5,'2006-12-20','2006-12-20','10:13:53','10:13:53','2008-07-22 00:00:00','2008-07-22 00:00:00','y','y'),(12,9,7,'0000-00-00','0000-00-00','00:00:00','00:00:00','2004-07-05 00:00:00','2004-07-05 00:00:00','{','{'),(13,4,3,'2007-01-26','2007-01-26','23:00:51','23:00:51','2001-05-16 00:00:00','2001-05-16 00:00:00','f','f'),(14,7,0,'2004-03-27','2004-03-27','00:00:00','00:00:00','2005-01-24 03:30:37','2005-01-24 03:30:37','',''),(15,6,0,'2006-07-26','2006-07-26','18:43:57','18:43:57','0000-00-00 00:00:00','0000-00-00 00:00:00','{','{'),(16,0,6,'2000-01-14','2000-01-14','00:00:00','00:00:00','2000-09-21 00:00:00','2000-09-21 00:00:00','o','o'),(17,9,8,'0000-00-00','0000-00-00','21:15:08','21:15:08','0000-00-00 00:00:00','0000-00-00 00:00:00','a','a'),(18,2,0,'2004-10-27','2004-10-27','00:00:00','00:00:00','2004-03-24 22:13:43','2004-03-24 22:13:43','',''),(19,7,4,'0000-00-00','0000-00-00','08:38:27','08:38:27','2002-03-18 19:51:44','2002-03-18 19:51:44','t','t'),(20,5,3,'2008-03-07','2008-03-07','03:29:07','03:29:07','2007-12-01 18:44:44','2007-12-01 18:44:44','t','t'); /*!40000 ALTER TABLE `C` ENABLE KEYS */; UNLOCK TABLES; /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */; /*!40101 SET SQL_MODE=@OLD_SQL_MODE */; /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */; /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */; /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; -- Dump completed on 2008-07-14 17:42:56 SELECT STD( OUTR . `date_nokey` ) AS X FROM B AS OUTR WHERE OUTR . `date_key` NOT IN ( SELECT INNR . `int_nokey` AS Y FROM B AS INNR WHERE INNR . `varchar_nokey` < INNR . `varchar_nokey` OR OUTR . `varchar_key` = 'a' ) OR NOT OUTR . `date_nokey` IS NOT NULL OR OUTR . `varchar_key` >= 'd' GROUP BY OUTR . `date_nokey` ORDER BY OUTR . `date_nokey` , OUTR . `pk` LIMIT 1; SELECT OUTR . `date_nokey` AS X FROM A AS OUTR WHERE OUTR . `pk` NOT IN ( SELECT INNR . `date_key` AS Y FROM C AS INNR WHERE INNR . `date_key` < INNR . `date_nokey` OR OUTR . `date_key` <= '2006-8-21' ) AND ( OUTR . `varchar_key` < 'p' AND OUTR . `date_nokey` BETWEEN '2001-8-7' AND '2006-2-30' ) GROUP BY OUTR . `date_key` ORDER BY OUTR . `pk` , OUTR . `pk` LIMIT 1; SELECT COUNT( OUTR . `int_nokey` ) AS X FROM C AS OUTR WHERE OUTR . `date_nokey` IN ( SELECT INNR . `date_nokey` AS Y FROM C AS INNR WHERE INNR . `int_key` <= INNR . `pk` OR OUTR . `date_key` < '2002-12-4' ) AND ( OUTR . `date_key` BETWEEN '2004-12-2' AND '2002-9-17' OR OUTR . `int_key` <= 0 ) GROUP BY OUTR . `date_key` HAVING X > '2000-9-26' ORDER BY OUTR . `date_nokey` , OUTR . `pk` LIMIT 2; SELECT MAX(DISTINCT OUTR . `pk` ) AS X FROM B AS OUTR WHERE EXISTS ( SELECT INNR . `int_nokey` AS Y FROM C AS INNR WHERE OUTR . `date_nokey` IS NULL ORDER BY INNR . `date_nokey` ) OR OUTR . `varchar_nokey` < '{' GROUP BY OUTR . `pk` HAVING X >= '9:40:52' ORDER BY OUTR . `date_key` , OUTR . `pk` LIMIT 9; SELECT MAX(DISTINCT OUTR . `date_nokey` ) AS X FROM B AS OUTR WHERE ( OUTR . `int_key` , OUTR . `date_key` ) IN ( SELECT INNR . `date_nokey` AS Y , INNR . `pk` AS Z FROM C AS INNR WHERE OUTR . `varchar_key` > 'p' ) OR ( OUTR . `date_nokey` IS NOT NULL AND OUTR . `date_key` IS NULL ) ORDER BY OUTR . `date_key` , OUTR . `pk` LIMIT 5; SELECT OUTR . `date_key` AS X FROM B AS OUTR WHERE OUTR . `date_key` <= ALL ( SELECT INNR . `date_key` AS Y FROM C AS INNR WHERE INNR . `varchar_key` <> INNR . `varchar_key` OR OUTR . `date_nokey` IS NULL ) OR OUTR . `varchar_key` = 'g' AND OUTR . `int_nokey` >= 1 HAVING X < 3 ORDER BY OUTR . `pk` , OUTR . `pk`; SELECT MIN( OUTR . `date_nokey` ) AS X FROM C AS OUTR WHERE OUTR . `int_nokey` NOT IN ( SELECT INNR . `int_key` AS Y FROM C AS INNR WHERE INNR . `int_key` >= INNR . `int_key` OR NOT OUTR . `varchar_nokey` > 'k' ) AND OUTR . `date_nokey` IS NOT NULL ORDER BY OUTR . `int_nokey` , OUTR . `pk`; SELECT OUTR . `pk` AS X FROM C AS OUTR WHERE OUTR . `int_key` > ANY ( SELECT INNR . `date_nokey` AS Y FROM C AS INNR WHERE INNR . `date_nokey` >= INNR . `date_nokey` OR INNR . `int_key` > 1 ) AND OUTR . `int_nokey` <> 5 AND OUTR . `date_nokey` <= '2003-4-13' GROUP BY OUTR . `date_key` HAVING X <= '16:29:12' ORDER BY OUTR . `date_key` , OUTR . `pk` LIMIT 8; SELECT MAX(DISTINCT OUTR . `pk` ) AS X FROM A AS OUTR WHERE NOT EXISTS ( SELECT INNR . `date_key` AS Y FROM A AS INNR WHERE INNR . `varchar_nokey` >= INNR . `varchar_key` OR NOT INNR . `date_key` = INNR . `date_key` ORDER BY INNR . `date_key` ) OR ( OUTR . `pk` IS NULL OR OUTR . `int_nokey` = 7 ) GROUP BY OUTR . `date_key` HAVING X > 7 ORDER BY OUTR . `date_nokey` , OUTR . `pk`; SELECT OUTR . `int_nokey` AS X FROM A AS OUTR WHERE EXISTS ( SELECT INNR . `date_nokey` AS Y FROM A AS INNR WHERE INNR . `date_key` = INNR . `date_nokey` OR INNR . `date_nokey` >= INNR . `date_nokey` ORDER BY INNR . `pk` ) OR NOT ( OUTR . `varchar_nokey` <= 'v' OR OUTR . `date_nokey` > '2008-11-6' ) GROUP BY OUTR . `date_key` HAVING X < NULL ORDER BY OUTR . `date_nokey` , OUTR . `pk` LIMIT 4; SELECT COUNT(DISTINCT OUTR . `int_key` ) AS X FROM B AS OUTR WHERE OUTR . `pk` < ( SELECT INNR . `date_key` AS Y FROM B AS INNR WHERE INNR . `int_nokey` >= INNR . `int_nokey` OR OUTR . `pk` = 3 LIMIT 1 ) OR NOT OUTR . `pk` IS NOT NULL GROUP BY OUTR . `pk` HAVING X >= '2001-11-3' ORDER BY OUTR . `int_nokey` , OUTR . `pk` LIMIT 8; SELECT STD( OUTR . `date_nokey` ) AS X FROM C AS OUTR WHERE EXISTS ( SELECT INNR . `date_key` AS Y FROM B AS INNR WHERE OUTR . `int_key` >= 4 ORDER BY INNR . `date_key` ) OR ( OUTR . `date_nokey` IS NULL AND OUTR . `date_key` BETWEEN '2008-10-21' AND '2002-3-12' ) HAVING X = '2008-5-5' ORDER BY OUTR . `date_key` , OUTR . `pk` LIMIT 0; SELECT OUTR . `int_key` AS X FROM A AS OUTR WHERE ( OUTR . `date_key` , OUTR . `date_key` ) IN ( SELECT INNR . `date_key` AS Y , INNR . `date_nokey` AS Z FROM A AS INNR WHERE INNR . `date_key` <> INNR . `date_key` AND INNR . `pk` <= INNR . `pk` ) AND OUTR . `date_key` <= '2008-1-14' OR NOT OUTR . `varchar_key` <= 's' HAVING X <> '2007-10-1' ORDER BY OUTR . `date_key` , OUTR . `pk` LIMIT 1; SELECT COUNT(DISTINCT OUTR . `int_key` ) AS X FROM C AS OUTR WHERE OUTR . `date_key` = ( SELECT INNR . `date_nokey` AS Y FROM C AS INNR WHERE INNR . `int_key` IS NOT NULL OR OUTR . `date_key` IS NULL LIMIT 1 ) OR NOT OUTR . `int_nokey` IS NULL OR OUTR . `int_key` <> 1 GROUP BY OUTR . `int_key` HAVING X >= 6 ORDER BY OUTR . `int_nokey` , OUTR . `pk`; SELECT OUTR . `pk` AS X FROM C AS OUTR WHERE EXISTS ( SELECT INNR . `int_key` AS Y FROM A AS INNR WHERE INNR . `date_key` IS NOT NULL ) OR OUTR . `date_nokey` IS NULL GROUP BY OUTR . `int_nokey` ORDER BY OUTR . `pk` , OUTR . `pk` LIMIT 6; SELECT MIN( OUTR . `pk` ) AS X FROM C AS OUTR WHERE OUTR . `pk` IN ( SELECT INNR . `int_key` AS Y FROM B AS INNR WHERE INNR . `int_key` <> INNR . `int_key` AND OUTR . `date_nokey` < '2003-12-25' ) OR NOT ( OUTR . `date_key` < '2009-10-8' OR NOT OUTR . `varchar_nokey` <= 'd' ) GROUP BY OUTR . `pk` ORDER BY OUTR . `int_nokey` , OUTR . `pk` LIMIT 2; SELECT OUTR . `date_nokey` AS X FROM C AS OUTR WHERE ( OUTR . `pk` , OUTR . `int_key` ) NOT IN ( SELECT INNR . `date_key` AS Y , INNR . `date_key` AS Z FROM A AS INNR WHERE OUTR . `varchar_nokey` > 'n' ORDER BY INNR . `date_key` ) OR ( OUTR . `date_nokey` >= '2000-9-5' OR NOT OUTR . `varchar_nokey` >= 'q' ) HAVING X = '10:41:7' ORDER BY OUTR . `date_key` , OUTR . `pk`; SELECT AVG( OUTR . `date_nokey` ) AS X FROM A AS OUTR WHERE OUTR . `int_nokey` NOT IN ( SELECT INNR . `date_nokey` AS Y FROM B AS INNR WHERE INNR . `pk` > INNR . `int_nokey` OR OUTR . `pk` <= 5 ) OR NOT ( OUTR . `int_nokey` <= 1 AND OUTR . `pk` <= 1 ) GROUP BY OUTR . `int_key` HAVING X < 'q' ORDER BY OUTR . `date_nokey` , OUTR . `pk`; SELECT MAX(DISTINCT OUTR . `date_key` ) AS X FROM A AS OUTR WHERE OUTR . `date_key` IN ( SELECT INNR . `int_key` AS Y FROM B AS INNR WHERE INNR . `varchar_key` = INNR . `varchar_nokey` OR INNR . `int_key` IS NOT NULL ORDER BY INNR . `pk` ) OR NOT OUTR . `int_key` IS NULL GROUP BY OUTR . `date_nokey` HAVING X <= '0:13:38' ORDER BY OUTR . `date_nokey` , OUTR . `pk` LIMIT 8; SELECT STDDEV_SAMP( OUTR . `int_nokey` ) AS X FROM B AS OUTR WHERE ( OUTR . `pk` , OUTR . `date_nokey` ) NOT IN ( SELECT INNR . `date_nokey` AS Y , INNR . `int_nokey` AS Z FROM B AS INNR WHERE INNR . `varchar_key` <> 'x' ORDER BY INNR . `date_key` ) AND ( OUTR . `date_nokey` BETWEEN '2005-5-28' AND '2005-7-4' OR NOT OUTR . `varchar_key` = 'd' ) ORDER BY OUTR . `int_key` , OUTR . `pk`; SELECT BIT_OR( OUTR . `date_nokey` ) AS X FROM B AS OUTR WHERE NOT EXISTS ( SELECT INNR . `int_key` AS Y FROM B AS INNR WHERE INNR . `int_nokey` > 8 ) OR OUTR . `int_nokey` IS NULL GROUP BY OUTR . `int_nokey` ORDER BY OUTR . `date_nokey` , OUTR . `pk` LIMIT 3; SELECT OUTR . `date_key` AS X FROM B AS OUTR WHERE EXISTS ( SELECT INNR . `date_key` AS Y FROM A AS INNR WHERE INNR . `varchar_nokey` < 'h' ORDER BY INNR . `int_nokey` ) OR ( OUTR . `varchar_key` < '{' OR OUTR . `pk` < 6 ) GROUP BY OUTR . `date_nokey` ORDER BY OUTR . `int_nokey` , OUTR . `pk` LIMIT 3; SELECT STDDEV_SAMP( OUTR . `date_key` ) AS X FROM B AS OUTR WHERE OUTR . `date_nokey` = ALL ( SELECT INNR . `int_nokey` AS Y FROM A AS INNR WHERE INNR . `pk` <= 7 ) OR NOT ( OUTR . `pk` <> 9 OR NOT OUTR . `varchar_key` <> 'y' ) HAVING X < '2001-10-21' ORDER BY OUTR . `date_nokey` , OUTR . `pk` LIMIT 0; SELECT STD( OUTR . `pk` ) AS X FROM A AS OUTR WHERE OUTR . `date_nokey` = SOME ( SELECT INNR . `int_key` AS Y FROM C AS INNR WHERE OUTR . `date_key` IS NULL ) AND ( OUTR . `pk` IS NOT NULL AND OUTR . `varchar_nokey` <> 'k' ) ORDER BY OUTR . `date_nokey` , OUTR . `pk`; SELECT STDDEV_SAMP( OUTR . `date_key` ) AS X FROM A AS OUTR WHERE EXISTS ( SELECT INNR . `pk` AS Y FROM A AS INNR WHERE INNR . `date_key` = INNR . `date_nokey` OR INNR . `date_nokey` BETWEEN '2000-12-27' AND '2001-9-27' ORDER BY INNR . `pk` ) OR OUTR . `varchar_nokey` < 'f' OR OUTR . `varchar_nokey` <= 'k' GROUP BY OUTR . `pk` ORDER BY OUTR . `pk` , OUTR . `pk`; SELECT OUTR . `pk` AS X FROM A AS OUTR WHERE NOT EXISTS ( SELECT INNR . `int_key` AS Y FROM C AS INNR WHERE OUTR . `varchar_key` > 'l' ) OR OUTR . `date_key` IS NOT NULL HAVING X = 3 ORDER BY OUTR . `int_key` , OUTR . `pk` LIMIT 8; SELECT VAR_SAMP( OUTR . `date_nokey` ) AS X FROM B AS OUTR WHERE OUTR . `date_key` NOT IN ( SELECT INNR . `pk` AS Y FROM C AS INNR WHERE INNR . `pk` <> INNR . `int_nokey` AND INNR . `pk` > INNR . `pk` ORDER BY INNR . `date_nokey` ) AND ( OUTR . `date_nokey` = '2006-11-30' OR NOT OUTR . `varchar_key` >= 'w' ) GROUP BY OUTR . `int_nokey` ORDER BY OUTR . `date_key` , OUTR . `pk` LIMIT 8; SELECT OUTR . `pk` AS X FROM A AS OUTR WHERE OUTR . `date_nokey` NOT IN ( SELECT INNR . `date_key` AS Y FROM C AS INNR WHERE INNR . `varchar_nokey` < INNR . `varchar_key` OR NOT OUTR . `date_nokey` IS NOT NULL ) AND ( OUTR . `varchar_key` <= 'h' OR OUTR . `pk` IS NOT NULL ) GROUP BY OUTR . `date_key` ORDER BY OUTR . `pk` , OUTR . `pk` LIMIT 0; SELECT BIT_OR( OUTR . `date_key` ) AS X FROM A AS OUTR WHERE EXISTS ( SELECT INNR . `date_nokey` AS Y FROM A AS INNR WHERE INNR . `varchar_key` >= INNR . `varchar_nokey` OR INNR . `varchar_key` < INNR . `varchar_nokey` ) OR NOT OUTR . `pk` = 6 GROUP BY OUTR . `int_nokey` ORDER BY OUTR . `date_nokey` , OUTR . `pk` LIMIT 5; SELECT VAR_SAMP( OUTR . `date_nokey` ) AS X FROM B AS OUTR WHERE ( OUTR . `date_key` , OUTR . `pk` ) NOT IN ( SELECT INNR . `pk` AS Y , INNR . `pk` AS Z FROM B AS INNR WHERE INNR . `date_nokey` >= INNR . `date_key` AND INNR . `pk` IS NULL ) AND ( OUTR . `int_key` IS NOT NULL OR NOT OUTR . `int_key` IS NOT NULL ) GROUP BY OUTR . `int_key` HAVING X <= '2005-10-1 11:3:54' ORDER BY OUTR . `int_key` , OUTR . `pk`; SELECT OUTR . `pk` AS X FROM A AS OUTR WHERE ( OUTR . `date_nokey` , OUTR . `int_key` ) NOT IN ( SELECT INNR . `date_key` AS Y , INNR . `int_key` AS Z FROM B AS INNR WHERE INNR . `varchar_nokey` <= INNR . `varchar_key` AND OUTR . `date_nokey` >= '2008-3-26' ) OR OUTR . `int_key` > 9 GROUP BY OUTR . `int_nokey` ORDER BY OUTR . `date_key` , OUTR . `pk` LIMIT 5; SELECT OUTR . `date_nokey` AS X FROM C AS OUTR WHERE OUTR . `pk` >= ANY ( SELECT INNR . `pk` AS Y FROM B AS INNR WHERE OUTR . `pk` <= 7 ) OR NOT OUTR . `date_nokey` >= '2002-10-21' HAVING X >= NULL ORDER BY OUTR . `date_key` , OUTR . `pk` LIMIT 8 ; SELECT OUTR . `int_key` AS X FROM B AS OUTR WHERE NOT EXISTS ( SELECT INNR . `int_nokey` AS Y FROM C AS INNR WHERE OUTR . `int_key` >= 6 ) OR OUTR . `date_nokey` IS NULL GROUP BY OUTR . `date_key` HAVING X < '2001-9-4 3:53:44' ORDER BY OUTR . `int_nokey` , OUTR . `pk`; SELECT STD( OUTR . `date_key` ) AS X FROM B AS OUTR WHERE OUTR . `date_nokey` > ALL ( SELECT INNR . `date_key` AS Y FROM A AS INNR WHERE INNR . `date_nokey` >= INNR . `date_nokey` AND INNR . `varchar_nokey` > 'y' ORDER BY INNR . `int_key` ) AND OUTR . `date_key` BETWEEN '2008-4-9' AND '2009-2-30' AND OUTR . `varchar_nokey` <= 'j' ORDER BY OUTR . `date_key` , OUTR . `pk` LIMIT 3; SELECT OUTR . `int_nokey` AS X FROM C AS OUTR WHERE ( OUTR . `pk` , OUTR . `date_nokey` ) NOT IN ( SELECT INNR . `date_key` AS Y , INNR . `int_key` AS Z FROM B AS INNR WHERE INNR . `varchar_nokey` <> INNR . `varchar_nokey` OR INNR . `date_nokey` IS NULL ) OR OUTR . `int_nokey` IS NULL OR OUTR . `pk` IS NOT NULL GROUP BY OUTR . `date_key` ORDER BY OUTR . `date_key` , OUTR . `pk` LIMIT 3; SELECT OUTR . `date_key` AS X FROM C AS OUTR WHERE OUTR . `date_nokey` IN ( SELECT INNR . `date_key` AS Y FROM B AS INNR WHERE INNR . `varchar_nokey` < INNR . `varchar_key` OR NOT INNR . `date_nokey` < INNR . `date_key` ) OR NOT ( OUTR . `pk` IS NULL OR NOT OUTR . `date_nokey` = '2001-7-2' ) GROUP BY OUTR . `pk` HAVING X >= NULL ORDER BY OUTR . `date_key` , OUTR . `pk`; SELECT AVG( OUTR . `date_nokey` ) AS X FROM B AS OUTR WHERE EXISTS ( SELECT INNR . `int_nokey` AS Y FROM B AS INNR WHERE INNR . `varchar_key` < 'a' ORDER BY INNR . `pk` ) OR OUTR . `varchar_nokey` >= 'g' OR NOT OUTR . `varchar_nokey` <= 'v' GROUP BY OUTR . `date_nokey` ORDER BY OUTR . `pk` , OUTR . `pk` LIMIT 1; SELECT OUTR . `pk` AS X FROM B AS OUTR WHERE OUTR . `int_nokey` < ANY ( SELECT INNR . `int_key` AS Y FROM B AS INNR WHERE INNR . `date_key` IS NULL ORDER BY INNR . `int_nokey` ) AND OUTR . `pk` < 8 ORDER BY OUTR . `date_key` , OUTR . `pk`; SELECT OUTR . `pk` AS X FROM C AS OUTR WHERE ( OUTR . `pk` , OUTR . `int_nokey` ) IN ( SELECT INNR . `int_key` AS Y , INNR . `int_nokey` AS Z FROM C AS INNR WHERE INNR . `date_key` BETWEEN '2005-10-3' AND '2000-1-28' ORDER BY INNR . `date_nokey` ) OR OUTR . `date_nokey` IS NULL ORDER BY OUTR . `date_nokey` , OUTR . `pk`;