--disable_abort_on_error -- 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) DEFAULT NULL, `int_key` int(11) DEFAULT NULL, `filler` blob, PRIMARY KEY (`pk`), KEY `int_key` (`int_key`) ) ENGINE=Falcon 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) DEFAULT NULL, `int_key` int(11) DEFAULT NULL, `filler` blob, PRIMARY KEY (`pk`), KEY `int_key` (`int_key`) ) ENGINE=Falcon 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,0,0,NULL); /*!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) DEFAULT NULL, `int_key` int(11) DEFAULT NULL, `filler` blob, PRIMARY KEY (`pk`), KEY `int_key` (`int_key`) ) ENGINE=Falcon AUTO_INCREMENT=11 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,7,7,NULL),(2,8,8,NULL),(3,9,9,NULL),(4,0,0,NULL),(5,5,5,NULL),(6,4,4,NULL),(7,8,8,NULL),(8,1,1,NULL),(9,9,9,NULL),(10,6,6,NULL); /*!40000 ALTER TABLE `C` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `D` -- DROP TABLE IF EXISTS `D`; SET @saved_cs_client = @@character_set_client; SET character_set_client = utf8; CREATE TABLE `D` ( `pk` int(11) NOT NULL AUTO_INCREMENT, `int_nokey` int(11) DEFAULT NULL, `int_key` int(11) DEFAULT NULL, `filler` blob, PRIMARY KEY (`pk`), KEY `int_key` (`int_key`) ) ENGINE=Falcon AUTO_INCREMENT=101 DEFAULT CHARSET=latin1; SET character_set_client = @saved_cs_client; -- -- Dumping data for table `D` -- LOCK TABLES `D` WRITE; /*!40000 ALTER TABLE `D` DISABLE KEYS */; INSERT INTO `D` VALUES (1,12,12,NULL),(2,15,15,NULL),(3,23,23,NULL),(4,23,23,NULL),(5,12,12,NULL),(6,60,60,NULL),(7,68,68,NULL),(8,22,22,NULL),(9,41,41,NULL),(10,20,20,NULL),(11,43,43,NULL),(12,79,79,NULL),(13,16,16,NULL),(14,73,73,NULL),(15,77,77,NULL),(16,7,7,NULL),(17,86,86,NULL),(18,4,4,NULL),(19,46,46,NULL),(20,47,47,NULL),(21,82,82,NULL),(22,52,52,NULL),(23,45,45,NULL),(24,87,87,NULL),(25,33,33,NULL),(26,91,91,NULL),(27,10,10,NULL),(28,85,85,NULL),(29,64,64,NULL),(30,86,86,NULL),(31,99,99,NULL),(32,54,54,NULL),(33,30,30,NULL),(34,94,94,NULL),(35,96,96,NULL),(36,34,34,NULL),(37,97,97,NULL),(38,92,92,NULL),(39,40,40,NULL),(40,23,23,NULL),(41,63,63,NULL),(42,70,70,NULL),(43,56,56,NULL),(44,90,90,NULL),(45,90,90,NULL),(46,69,69,NULL),(47,12,12,NULL),(48,85,85,NULL),(49,59,59,NULL),(50,22,22,NULL),(51,99,99,NULL),(52,39,39,NULL),(53,81,81,NULL),(54,80,80,NULL),(55,68,68,NULL),(56,49,49,NULL),(57,55,55,NULL),(58,73,73,NULL),(59,4,4,NULL),(60,75,75,NULL),(61,80,80,NULL),(62,21,21,NULL),(63,66,66,NULL),(64,41,41,NULL),(65,42,42,NULL),(66,45,45,NULL),(67,87,87,NULL),(68,42,42,NULL),(69,38,38,NULL),(70,2,2,NULL),(71,28,28,NULL),(72,57,57,NULL),(73,33,33,NULL),(74,70,70,NULL),(75,6,6,NULL),(76,54,54,NULL),(77,49,49,NULL),(78,20,20,NULL),(79,5,5,NULL),(80,74,74,NULL),(81,72,72,NULL),(82,32,32,NULL),(83,45,45,NULL),(84,58,58,NULL),(85,19,19,NULL),(86,22,22,NULL),(87,0,0,NULL),(88,95,95,NULL),(89,56,56,NULL),(90,37,37,NULL),(91,57,57,NULL),(92,98,98,NULL),(93,86,86,NULL),(94,15,15,NULL),(95,4,4,NULL),(96,83,83,NULL),(97,81,81,NULL),(98,32,32,NULL),(99,63,63,NULL),(100,45,45,NULL); /*!40000 ALTER TABLE `D` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `E` -- DROP TABLE IF EXISTS `E`; SET @saved_cs_client = @@character_set_client; SET character_set_client = utf8; CREATE TABLE `E` ( `pk` int(11) NOT NULL AUTO_INCREMENT, `int_nokey` int(11) DEFAULT NULL, `int_key` int(11) DEFAULT NULL, `filler` blob, PRIMARY KEY (`pk`), KEY `int_key` (`int_key`) ) ENGINE=Falcon AUTO_INCREMENT=1001 DEFAULT CHARSET=latin1; SET character_set_client = @saved_cs_client; -- -- Dumping data for table `E` -- LOCK TABLES `E` WRITE; /*!40000 ALTER TABLE `E` DISABLE KEYS */; INSERT INTO `E` VALUES (1,404,404,NULL),(2,829,829,NULL),(3,519,519,NULL),(4,865,865,NULL),(5,410,410,NULL),(6,792,792,NULL),(7,976,976,NULL),(8,872,872,NULL),(9,217,217,NULL),(10,769,769,NULL),(11,705,705,NULL),(12,121,121,NULL),(13,52,52,NULL),(14,222,222,NULL),(15,636,636,NULL),(16,438,438,NULL),(17,585,585,NULL),(18,699,699,NULL),(19,845,845,NULL),(20,535,535,NULL),(21,484,484,NULL),(22,265,265,NULL),(23,35,35,NULL),(24,773,773,NULL),(25,416,416,NULL),(26,318,318,NULL),(27,833,833,NULL),(28,750,750,NULL),(29,87,87,NULL),(30,793,793,NULL),(31,337,337,NULL),(32,152,152,NULL),(33,247,247,NULL),(34,904,904,NULL),(35,986,986,NULL),(36,489,489,NULL),(37,849,849,NULL),(38,780,780,NULL),(39,837,837,NULL),(40,271,271,NULL),(41,695,695,NULL),(42,931,931,NULL),(43,290,290,NULL),(44,426,426,NULL),(45,244,244,NULL),(46,241,241,NULL),(47,750,750,NULL),(48,617,617,NULL),(49,666,666,NULL),(50,729,729,NULL),(51,579,579,NULL),(52,9,9,NULL),(53,664,664,NULL),(54,445,445,NULL),(55,298,298,NULL),(56,227,227,NULL),(57,917,917,NULL),(58,536,536,NULL),(59,492,492,NULL),(60,867,867,NULL),(61,643,643,NULL),(62,476,476,NULL),(63,469,469,NULL),(64,509,509,NULL),(65,764,764,NULL),(66,981,981,NULL),(67,752,752,NULL),(68,309,309,NULL),(69,298,298,NULL),(70,23,23,NULL),(71,960,960,NULL),(72,831,831,NULL),(73,89,89,NULL),(74,170,170,NULL),(75,237,237,NULL),(76,872,872,NULL),(77,54,54,NULL),(78,943,943,NULL),(79,815,815,NULL),(80,798,798,NULL),(81,44,44,NULL),(82,59,59,NULL),(83,568,568,NULL),(84,80,80,NULL),(85,965,965,NULL),(86,775,775,NULL),(87,18,18,NULL),(88,488,488,NULL),(89,278,278,NULL),(90,724,724,NULL),(91,442,442,NULL),(92,335,335,NULL),(93,658,658,NULL),(94,852,852,NULL),(95,807,807,NULL),(96,429,429,NULL),(97,832,832,NULL),(98,465,465,NULL),(99,748,748,NULL),(100,373,373,NULL),(101,220,220,NULL),(102,99,99,NULL),(103,828,828,NULL),(104,773,773,NULL),(105,306,306,NULL),(106,442,442,NULL),(107,571,571,NULL),(108,802,802,NULL),(109,155,155,NULL),(110,910,910,NULL),(111,310,310,NULL),(112,942,942,NULL),(113,332,332,NULL),(114,662,662,NULL),(115,561,561,NULL),(116,42,42,NULL),(117,856,856,NULL),(118,705,705,NULL),(119,342,342,NULL),(120,6,6,NULL),(121,852,852,NULL),(122,698,698,NULL),(123,777,777,NULL),(124,406,406,NULL),(125,923,923,NULL),(126,938,938,NULL),(127,956,956,NULL),(128,191,191,NULL),(129,246,246,NULL),(130,482,482,NULL),(131,45,45,NULL),(132,177,177,NULL),(133,50,50,NULL),(134,315,315,NULL),(135,218,218,NULL),(136,204,204,NULL),(137,841,841,NULL),(138,874,874,NULL),(139,61,61,NULL),(140,237,237,NULL),(141,145,145,NULL),(142,965,965,NULL),(143,673,673,NULL),(144,527,527,NULL),(145,963,963,NULL),(146,481,481,NULL),(147,981,981,NULL),(148,261,261,NULL),(149,784,784,NULL),(150,127,127,NULL),(151,558,558,NULL),(152,417,417,NULL),(153,247,247,NULL),(154,375,375,NULL),(155,968,968,NULL),(156,511,511,NULL),(157,124,124,NULL),(158,683,683,NULL),(159,940,940,NULL),(160,121,121,NULL),(161,576,576,NULL),(162,942,942,NULL),(163,263,263,NULL),(164,988,988,NULL),(165,902,902,NULL),(166,533,533,NULL),(167,508,508,NULL),(168,747,747,NULL),(169,697,697,NULL),(170,93,93,NULL),(171,615,615,NULL),(172,97,97,NULL),(173,209,209,NULL),(174,358,358,NULL),(175,104,104,NULL),(176,290,290,NULL),(177,221,221,NULL),(178,436,436,NULL),(179,588,588,NULL),(180,959,959,NULL),(181,330,330,NULL),(182,817,817,NULL),(183,188,188,NULL),(184,538,538,NULL),(185,490,490,NULL),(186,860,860,NULL),(187,79,79,NULL),(188,247,247,NULL),(189,23,23,NULL),(190,571,571,NULL),(191,352,352,NULL),(192,4,4,NULL),(193,501,501,NULL),(194,121,121,NULL),(195,618,618,NULL),(196,713,713,NULL),(197,304,304,NULL),(198,844,844,NULL),(199,676,676,NULL),(200,529,529,NULL),(201,921,921,NULL),(202,703,703,NULL),(203,434,434,NULL),(204,602,602,NULL),(205,949,949,NULL),(206,403,403,NULL),(207,198,198,NULL),(208,940,940,NULL),(209,995,995,NULL),(210,206,206,NULL),(211,24,24,NULL),(212,794,794,NULL),(213,655,655,NULL),(214,953,953,NULL),(215,16,16,NULL),(216,978,978,NULL),(217,43,43,NULL),(218,938,938,NULL),(219,976,976,NULL),(220,810,810,NULL),(221,47,47,NULL),(222,921,921,NULL),(223,573,573,NULL),(224,739,739,NULL),(225,106,106,NULL),(226,259,259,NULL),(227,86,86,NULL),(228,817,817,NULL),(229,473,473,NULL),(230,562,562,NULL),(231,484,484,NULL),(232,30,30,NULL),(233,224,224,NULL),(234,413,413,NULL),(235,412,412,NULL),(236,344,344,NULL),(237,860,860,NULL),(238,79,79,NULL),(239,876,876,NULL),(240,370,370,NULL),(241,755,755,NULL),(242,273,273,NULL),(243,732,732,NULL),(244,742,742,NULL),(245,723,723,NULL),(246,216,216,NULL),(247,563,563,NULL),(248,854,854,NULL),(249,162,162,NULL),(250,451,451,NULL),(251,54,54,NULL),(252,336,336,NULL),(253,790,790,NULL),(254,404,404,NULL),(255,562,562,NULL),(256,725,725,NULL),(257,664,664,NULL),(258,685,685,NULL),(259,207,207,NULL),(260,797,797,NULL),(261,617,617,NULL),(262,57,57,NULL),(263,369,369,NULL),(264,303,303,NULL),(265,202,202,NULL),(266,293,293,NULL),(267,301,301,NULL),(268,533,533,NULL),(269,983,983,NULL),(270,77,77,NULL),(271,149,149,NULL),(272,856,856,NULL),(273,253,253,NULL),(274,747,747,NULL),(275,758,758,NULL),(276,785,785,NULL),(277,818,818,NULL),(278,977,977,NULL),(279,499,499,NULL),(280,133,133,NULL),(281,109,109,NULL),(282,79,79,NULL),(283,953,953,NULL),(284,679,679,NULL),(285,929,929,NULL),(286,264,264,NULL),(287,705,705,NULL),(288,493,493,NULL),(289,380,380,NULL),(290,956,956,NULL),(291,8,8,NULL),(292,701,701,NULL),(293,786,786,NULL),(294,915,915,NULL),(295,507,507,NULL),(296,47,47,NULL),(297,660,660,NULL),(298,696,696,NULL),(299,121,121,NULL),(300,928,928,NULL),(301,203,203,NULL),(302,822,822,NULL),(303,190,190,NULL),(304,737,737,NULL),(305,447,447,NULL),(306,446,446,NULL),(307,928,928,NULL),(308,891,891,NULL),(309,839,839,NULL),(310,61,61,NULL),(311,502,502,NULL),(312,72,72,NULL),(313,701,701,NULL),(314,8,8,NULL),(315,792,792,NULL),(316,110,110,NULL),(317,44,44,NULL),(318,741,741,NULL),(319,237,237,NULL),(320,72,72,NULL),(321,616,616,NULL),(322,519,519,NULL),(323,561,561,NULL),(324,199,199,NULL),(325,742,742,NULL),(326,935,935,NULL),(327,579,579,NULL),(328,56,56,NULL),(329,525,525,NULL),(330,305,305,NULL),(331,324,324,NULL),(332,932,932,NULL),(333,718,718,NULL),(334,929,929,NULL),(335,222,222,NULL),(336,93,93,NULL),(337,142,142,NULL),(338,760,760,NULL),(339,912,912,NULL),(340,803,803,NULL),(341,884,884,NULL),(342,595,595,NULL),(343,54,54,NULL),(344,286,286,NULL),(345,722,722,NULL),(346,994,994,NULL),(347,396,396,NULL),(348,446,446,NULL),(349,849,849,NULL),(350,209,209,NULL),(351,725,725,NULL),(352,592,592,NULL),(353,81,81,NULL),(354,385,385,NULL),(355,668,668,NULL),(356,713,713,NULL),(357,377,377,NULL),(358,452,452,NULL),(359,731,731,NULL),(360,519,519,NULL),(361,865,865,NULL),(362,841,841,NULL),(363,221,221,NULL),(364,372,372,NULL),(365,162,162,NULL),(366,638,638,NULL),(367,725,725,NULL),(368,903,903,NULL),(369,862,862,NULL),(370,774,774,NULL),(371,654,654,NULL),(372,123,123,NULL),(373,619,619,NULL),(374,438,438,NULL),(375,677,677,NULL),(376,918,918,NULL),(377,669,669,NULL),(378,327,327,NULL),(379,32,32,NULL),(380,98,98,NULL),(381,336,336,NULL),(382,516,516,NULL),(383,124,124,NULL),(384,632,632,NULL),(385,501,501,NULL),(386,336,336,NULL),(387,178,178,NULL),(388,83,83,NULL),(389,162,162,NULL),(390,502,502,NULL),(391,214,214,NULL),(392,691,691,NULL),(393,499,499,NULL),(394,899,899,NULL),(395,151,151,NULL),(396,450,450,NULL),(397,892,892,NULL),(398,691,691,NULL),(399,460,460,NULL),(400,198,198,NULL),(401,436,436,NULL),(402,167,167,NULL),(403,694,694,NULL),(404,197,197,NULL),(405,930,930,NULL),(406,695,695,NULL),(407,117,117,NULL),(408,428,428,NULL),(409,353,353,NULL),(410,182,182,NULL),(411,149,149,NULL),(412,552,552,NULL),(413,329,329,NULL),(414,32,32,NULL),(415,890,890,NULL),(416,796,796,NULL),(417,257,257,NULL),(418,138,138,NULL),(419,424,424,NULL),(420,297,297,NULL),(421,124,124,NULL),(422,305,305,NULL),(423,227,227,NULL),(424,424,424,NULL),(425,709,709,NULL),(426,444,444,NULL),(427,912,912,NULL),(428,372,372,NULL),(429,930,930,NULL),(430,173,173,NULL),(431,807,807,NULL),(432,700,700,NULL),(433,816,816,NULL),(434,375,375,NULL),(435,861,861,NULL),(436,309,309,NULL),(437,361,361,NULL),(438,808,808,NULL),(439,963,963,NULL),(440,495,495,NULL),(441,848,848,NULL),(442,870,870,NULL),(443,619,619,NULL),(444,770,770,NULL),(445,945,945,NULL),(446,905,905,NULL),(447,671,671,NULL),(448,39,39,NULL),(449,495,495,NULL),(450,279,279,NULL),(451,304,304,NULL),(452,764,764,NULL),(453,873,873,NULL),(454,594,594,NULL),(455,444,444,NULL),(456,63,63,NULL),(457,549,549,NULL),(458,441,441,NULL),(459,943,943,NULL),(460,149,149,NULL),(461,74,74,NULL),(462,809,809,NULL),(463,922,922,NULL),(464,446,446,NULL),(465,608,608,NULL),(466,528,528,NULL),(467,847,847,NULL),(468,661,661,NULL),(469,840,840,NULL),(470,736,736,NULL),(471,209,209,NULL),(472,529,529,NULL),(473,279,279,NULL),(474,479,479,NULL),(475,987,987,NULL),(476,20,20,NULL),(477,468,468,NULL),(478,21,21,NULL),(479,53,53,NULL),(480,220,220,NULL),(481,215,215,NULL),(482,730,730,NULL),(483,471,471,NULL),(484,640,640,NULL),(485,150,150,NULL),(486,265,265,NULL),(487,737,737,NULL),(488,203,203,NULL),(489,248,248,NULL),(490,137,137,NULL),(491,761,761,NULL),(492,81,81,NULL),(493,657,657,NULL),(494,213,213,NULL),(495,206,206,NULL),(496,902,902,NULL),(497,834,834,NULL),(498,656,656,NULL),(499,158,158,NULL),(500,669,669,NULL),(501,186,186,NULL),(502,709,709,NULL),(503,262,262,NULL),(504,303,303,NULL),(505,973,973,NULL),(506,415,415,NULL),(507,219,219,NULL),(508,633,633,NULL),(509,131,131,NULL),(510,176,176,NULL),(511,879,879,NULL),(512,401,401,NULL),(513,822,822,NULL),(514,223,223,NULL),(515,174,174,NULL),(516,709,709,NULL),(517,418,418,NULL),(518,867,867,NULL),(519,586,586,NULL),(520,813,813,NULL),(521,216,216,NULL),(522,477,477,NULL),(523,150,150,NULL),(524,411,411,NULL),(525,479,479,NULL),(526,605,605,NULL),(527,596,596,NULL),(528,71,71,NULL),(529,409,409,NULL),(530,662,662,NULL),(531,951,951,NULL),(532,51,51,NULL),(533,904,904,NULL),(534,72,72,NULL),(535,881,881,NULL),(536,189,189,NULL),(537,440,440,NULL),(538,332,332,NULL),(539,456,456,NULL),(540,179,179,NULL),(541,312,312,NULL),(542,953,953,NULL),(543,637,637,NULL),(544,382,382,NULL),(545,661,661,NULL),(546,541,541,NULL),(547,208,208,NULL),(548,305,305,NULL),(549,985,985,NULL),(550,418,418,NULL),(551,684,684,NULL),(552,218,218,NULL),(553,143,143,NULL),(554,179,179,NULL),(555,605,605,NULL),(556,652,652,NULL),(557,388,388,NULL),(558,474,474,NULL),(559,171,171,NULL),(560,80,80,NULL),(561,850,850,NULL),(562,567,567,NULL),(563,238,238,NULL),(564,216,216,NULL),(565,763,763,NULL),(566,704,704,NULL),(567,573,573,NULL),(568,515,515,NULL),(569,717,717,NULL),(570,962,962,NULL),(571,279,279,NULL),(572,581,581,NULL),(573,635,635,NULL),(574,802,802,NULL),(575,404,404,NULL),(576,974,974,NULL),(577,17,17,NULL),(578,344,344,NULL),(579,506,506,NULL),(580,796,796,NULL),(581,165,165,NULL),(582,60,60,NULL),(583,234,234,NULL),(584,451,451,NULL),(585,700,700,NULL),(586,942,942,NULL),(587,531,531,NULL),(588,101,101,NULL),(589,28,28,NULL),(590,702,702,NULL),(591,568,568,NULL),(592,761,761,NULL),(593,697,697,NULL),(594,521,521,NULL),(595,982,982,NULL),(596,457,457,NULL),(597,662,662,NULL),(598,525,525,NULL),(599,911,911,NULL),(600,530,530,NULL),(601,551,551,NULL),(602,332,332,NULL),(603,960,960,NULL),(604,641,641,NULL),(605,485,485,NULL),(606,832,832,NULL),(607,868,868,NULL),(608,509,509,NULL),(609,91,91,NULL),(610,994,994,NULL),(611,856,856,NULL),(612,111,111,NULL),(613,970,970,NULL),(614,36,36,NULL),(615,432,432,NULL),(616,462,462,NULL),(617,333,333,NULL),(618,300,300,NULL),(619,697,697,NULL),(620,15,15,NULL),(621,249,249,NULL),(622,649,649,NULL),(623,725,725,NULL),(624,720,720,NULL),(625,166,166,NULL),(626,91,91,NULL),(627,561,561,NULL),(628,444,444,NULL),(629,277,277,NULL),(630,582,582,NULL),(631,314,314,NULL),(632,488,488,NULL),(633,929,929,NULL),(634,885,885,NULL),(635,241,241,NULL),(636,498,498,NULL),(637,431,431,NULL),(638,811,811,NULL),(639,910,910,NULL),(640,92,92,NULL),(641,448,448,NULL),(642,921,921,NULL),(643,244,244,NULL),(644,819,819,NULL),(645,841,841,NULL),(646,510,510,NULL),(647,648,648,NULL),(648,691,691,NULL),(649,661,661,NULL),(650,630,630,NULL),(651,435,435,NULL),(652,976,976,NULL),(653,666,666,NULL),(654,690,690,NULL),(655,430,430,NULL),(656,393,393,NULL),(657,517,517,NULL),(658,309,309,NULL),(659,117,117,NULL),(660,515,515,NULL),(661,997,997,NULL),(662,216,216,NULL),(663,750,750,NULL),(664,340,340,NULL),(665,463,463,NULL),(666,987,987,NULL),(667,95,95,NULL),(668,518,518,NULL),(669,61,61,NULL),(670,865,865,NULL),(671,250,250,NULL),(672,86,86,NULL),(673,436,436,NULL),(674,991,991,NULL),(675,329,329,NULL),(676,262,262,NULL),(677,914,914,NULL),(678,711,711,NULL),(679,793,793,NULL),(680,513,513,NULL),(681,962,962,NULL),(682,788,788,NULL),(683,108,108,NULL),(684,921,921,NULL),(685,892,892,NULL),(686,706,706,NULL),(687,199,199,NULL),(688,590,590,NULL),(689,651,651,NULL),(690,998,998,NULL),(691,283,283,NULL),(692,273,273,NULL),(693,646,646,NULL),(694,811,811,NULL),(695,894,894,NULL),(696,542,542,NULL),(697,115,115,NULL),(698,334,334,NULL),(699,5,5,NULL),(700,97,97,NULL),(701,725,725,NULL),(702,397,397,NULL),(703,670,670,NULL),(704,341,341,NULL),(705,81,81,NULL),(706,402,402,NULL),(707,549,549,NULL),(708,238,238,NULL),(709,316,316,NULL),(710,913,913,NULL),(711,383,383,NULL),(712,31,31,NULL),(713,268,268,NULL),(714,908,908,NULL),(715,317,317,NULL),(716,351,351,NULL),(717,921,921,NULL),(718,43,43,NULL),(719,952,952,NULL),(720,28,28,NULL),(721,427,427,NULL),(722,858,858,NULL),(723,788,788,NULL),(724,978,978,NULL),(725,482,482,NULL),(726,631,631,NULL),(727,219,219,NULL),(728,474,474,NULL),(729,774,774,NULL),(730,753,753,NULL),(731,238,238,NULL),(732,902,902,NULL),(733,691,691,NULL),(734,696,696,NULL),(735,291,291,NULL),(736,658,658,NULL),(737,949,949,NULL),(738,600,600,NULL),(739,349,349,NULL),(740,729,729,NULL),(741,4,4,NULL),(742,746,746,NULL),(743,787,787,NULL),(744,746,746,NULL),(745,547,547,NULL),(746,830,830,NULL),(747,375,375,NULL),(748,223,223,NULL),(749,177,177,NULL),(750,421,421,NULL),(751,28,28,NULL),(752,351,351,NULL),(753,200,200,NULL),(754,835,835,NULL),(755,440,440,NULL),(756,243,243,NULL),(757,993,993,NULL),(758,232,232,NULL),(759,533,533,NULL),(760,976,976,NULL),(761,178,178,NULL),(762,892,892,NULL),(763,635,635,NULL),(764,28,28,NULL),(765,208,208,NULL),(766,774,774,NULL),(767,422,422,NULL),(768,990,990,NULL),(769,491,491,NULL),(770,708,708,NULL),(771,45,45,NULL),(772,188,188,NULL),(773,633,633,NULL),(774,337,337,NULL),(775,176,176,NULL),(776,585,585,NULL),(777,493,493,NULL),(778,683,683,NULL),(779,522,522,NULL),(780,3,3,NULL),(781,720,720,NULL),(782,295,295,NULL),(783,993,993,NULL),(784,142,142,NULL),(785,83,83,NULL),(786,246,246,NULL),(787,990,990,NULL),(788,531,531,NULL),(789,970,970,NULL),(790,957,957,NULL),(791,455,455,NULL),(792,495,495,NULL),(793,687,687,NULL),(794,313,313,NULL),(795,385,385,NULL),(796,588,588,NULL),(797,981,981,NULL),(798,887,887,NULL),(799,481,481,NULL),(800,883,883,NULL),(801,349,349,NULL),(802,985,985,NULL),(803,815,815,NULL),(804,875,875,NULL),(805,961,961,NULL),(806,790,790,NULL),(807,651,651,NULL),(808,790,790,NULL),(809,404,404,NULL),(810,106,106,NULL),(811,402,402,NULL),(812,414,414,NULL),(813,113,113,NULL),(814,184,184,NULL),(815,786,786,NULL),(816,420,420,NULL),(817,433,433,NULL),(818,181,181,NULL),(819,374,374,NULL),(820,953,953,NULL),(821,367,367,NULL),(822,16,16,NULL),(823,333,333,NULL),(824,342,342,NULL),(825,400,400,NULL),(826,474,474,NULL),(827,327,327,NULL),(828,222,222,NULL),(829,557,557,NULL),(830,284,284,NULL),(831,469,469,NULL),(832,660,660,NULL),(833,139,139,NULL),(834,795,795,NULL),(835,313,313,NULL),(836,735,735,NULL),(837,292,292,NULL),(838,485,485,NULL),(839,77,77,NULL),(840,172,172,NULL),(841,663,663,NULL),(842,618,618,NULL),(843,299,299,NULL),(844,338,338,NULL),(845,452,452,NULL),(846,449,449,NULL),(847,666,666,NULL),(848,124,124,NULL),(849,61,61,NULL),(850,673,673,NULL),(851,834,834,NULL),(852,861,861,NULL),(853,446,446,NULL),(854,648,648,NULL),(855,105,105,NULL),(856,570,570,NULL),(857,122,122,NULL),(858,105,105,NULL),(859,235,235,NULL),(860,42,42,NULL),(861,116,116,NULL),(862,648,648,NULL),(863,523,523,NULL),(864,833,833,NULL),(865,212,212,NULL),(866,598,598,NULL),(867,422,422,NULL),(868,342,342,NULL),(869,447,447,NULL),(870,727,727,NULL),(871,95,95,NULL),(872,234,234,NULL),(873,318,318,NULL),(874,628,628,NULL),(875,608,608,NULL),(876,414,414,NULL),(877,49,49,NULL),(878,34,34,NULL),(879,482,482,NULL),(880,89,89,NULL),(881,655,655,NULL),(882,137,137,NULL),(883,418,418,NULL),(884,754,754,NULL),(885,711,711,NULL),(886,860,860,NULL),(887,600,600,NULL),(888,959,959,NULL),(889,678,678,NULL),(890,484,484,NULL),(891,620,620,NULL),(892,490,490,NULL),(893,182,182,NULL),(894,752,752,NULL),(895,31,31,NULL),(896,261,261,NULL),(897,879,879,NULL),(898,464,464,NULL),(899,628,628,NULL),(900,377,377,NULL),(901,779,779,NULL),(902,208,208,NULL),(903,836,836,NULL),(904,644,644,NULL),(905,255,255,NULL),(906,594,594,NULL),(907,84,84,NULL),(908,799,799,NULL),(909,283,283,NULL),(910,656,656,NULL),(911,757,757,NULL),(912,8,8,NULL),(913,941,941,NULL),(914,580,580,NULL),(915,356,356,NULL),(916,972,972,NULL),(917,117,117,NULL),(918,256,256,NULL),(919,778,778,NULL),(920,618,618,NULL),(921,76,76,NULL),(922,99,99,NULL),(923,529,529,NULL),(924,631,631,NULL),(925,735,735,NULL),(926,821,821,NULL),(927,807,807,NULL),(928,545,545,NULL),(929,615,615,NULL),(930,604,604,NULL),(931,528,528,NULL),(932,174,174,NULL),(933,719,719,NULL),(934,815,815,NULL),(935,816,816,NULL),(936,587,587,NULL),(937,471,471,NULL),(938,828,828,NULL),(939,325,325,NULL),(940,606,606,NULL),(941,108,108,NULL),(942,959,959,NULL),(943,93,93,NULL),(944,883,883,NULL),(945,54,54,NULL),(946,76,76,NULL),(947,822,822,NULL),(948,696,696,NULL),(949,80,80,NULL),(950,439,439,NULL),(951,416,416,NULL),(952,693,693,NULL),(953,12,12,NULL),(954,214,214,NULL),(955,854,854,NULL),(956,372,372,NULL),(957,235,235,NULL),(958,95,95,NULL),(959,848,848,NULL),(960,160,160,NULL),(961,730,730,NULL),(962,420,420,NULL),(963,961,961,NULL),(964,800,800,NULL),(965,353,353,NULL),(966,265,265,NULL),(967,534,534,NULL),(968,468,468,NULL),(969,944,944,NULL),(970,433,433,NULL),(971,21,21,NULL),(972,527,527,NULL),(973,717,717,NULL),(974,125,125,NULL),(975,384,384,NULL),(976,466,466,NULL),(977,636,636,NULL),(978,21,21,NULL),(979,569,569,NULL),(980,752,752,NULL),(981,756,756,NULL),(982,503,503,NULL),(983,734,734,NULL),(984,701,701,NULL),(985,233,233,NULL),(986,825,825,NULL),(987,637,637,NULL),(988,95,95,NULL),(989,60,60,NULL),(990,110,110,NULL),(991,138,138,NULL),(992,824,824,NULL),(993,22,22,NULL),(994,575,575,NULL),(995,274,274,NULL),(996,201,201,NULL),(997,543,543,NULL),(998,70,70,NULL),(999,252,252,NULL),(1000,486,486,NULL); /*!40000 ALTER TABLE `E` 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-09 2:40:38 SELECT pk FROM ( SELECT COUNT( pk ) FROM ( SELECT AVG( pk ) FROM ( SELECT pk FROM ( SELECT COUNT( int_nokey ) FROM B AS X WHERE X . int_key < 12 LIMIT 20 ) AS X WHERE X . int_key < 84 ORDER BY int_nokey LIMIT 20 ) AS X WHERE X . int_nokey < 39 ORDER BY pk GROUP BY int_key LIMIT 20 ) AS X WHERE X . int_nokey < 32 GROUP BY int_nokey LIMIT 20 ) AS X WHERE X . int_key < 47 ORDER BY pk GROUP BY int_key LIMIT 10; UPDATE C AS X SET pk = 32 , filler = REPEAT ( ' X ' , 9 ) WHERE X . pk < 8 ORDER BY RAND ( ) LIMIT 20; UPDATE E AS X SET pk = ( SELECT COUNT( int_nokey ) FROM ( SELECT int_key FROM ( SELECT ( SELECT ( SELECT 28 FROM E AS X WHERE X . int_nokey < 15 LIMIT 1 ) FROM ( SELECT AVG( int_nokey ) FROM B AS X WHERE X . int_key < 17 GROUP BY int_key LIMIT 20 ) AS X WHERE X . int_nokey < 59 LIMIT 1 ) FROM ( SELECT AVG( pk ) FROM E AS X WHERE X . int_key < 84 GROUP BY int_key LIMIT 20 ) AS X WHERE X . int_nokey < 61 GROUP BY pk LIMIT 20 ) AS X WHERE X . pk < 15 ORDER BY int_key LIMIT 20 ) AS X WHERE X . pk < 48 ORDER BY pk GROUP BY int_key LIMIT 1 ) , filler = REPEAT ( ' X ' , ( SELECT ( SELECT 67 FROM ( SELECT COUNT( int_key ) FROM ( SELECT int_nokey FROM ( SELECT AVG( int_nokey ) FROM A AS X WHERE X . int_key < 38 LIMIT 20 ) AS X WHERE X . pk < 6 ORDER BY pk GROUP BY pk LIMIT 20 ) AS X WHERE X . int_nokey < 68 GROUP BY int_nokey LIMIT 20 ) AS X WHERE X . int_key < 80 GROUP BY int_nokey LIMIT 1 ) FROM ( SELECT AVG( int_key ) FROM ( SELECT AVG( int_nokey ) FROM ( SELECT int_key FROM E AS X WHERE X . int_nokey < 83 GROUP BY pk LIMIT 20 ) AS X WHERE X . int_nokey < 31 ORDER BY int_nokey GROUP BY int_key LIMIT 20 ) AS X WHERE X . pk < 17 ORDER BY int_nokey GROUP BY int_key LIMIT 20 ) AS X WHERE X . int_key < 27 GROUP BY int_key LIMIT 1 ) ) WHERE X . int_key < 44 ORDER BY RAND ( ) LIMIT 20; UPDATE C AS X SET int_nokey = ( SELECT 89 FROM D AS X WHERE X . pk < 11 LIMIT 1 ) , filler = REPEAT ( ' X ' , 60 ) WHERE X . int_key < 92 ORDER BY RAND ( ) LIMIT 20; INSERT INTO A ( int_key , int_nokey ) VALUES ( 73 , ( SELECT ( SELECT AVG( int_key ) FROM ( SELECT COUNT( int_nokey ) FROM C AS X WHERE X . pk < 30 ORDER BY int_key GROUP BY int_key LIMIT 20 ) AS X WHERE X . int_key < 66 GROUP BY pk LIMIT 1 ) FROM C AS X WHERE X . pk < 77 LIMIT 1 ) ); START TRANSACTION; START TRANSACTION; UPDATE C AS X SET int_nokey = 22 , filler = REPEAT ( ' X ' , ( SELECT int_nokey FROM ( SELECT AVG( int_nokey ) FROM ( SELECT COUNT( int_nokey ) FROM ( SELECT int_key FROM ( SELECT int_nokey FROM E AS X WHERE X . int_key < 47 ORDER BY int_key GROUP BY int_key LIMIT 20 ) AS X WHERE X . int_nokey < 1 GROUP BY int_nokey LIMIT 20 ) AS X WHERE X . int_key < 86 GROUP BY int_nokey LIMIT 20 ) AS X WHERE X . pk < 72 ORDER BY int_key LIMIT 20 ) AS X WHERE X . int_nokey < 87 GROUP BY int_key LIMIT 1 ) ) WHERE X . pk < 10 ORDER BY RAND ( ) LIMIT 20; INSERT INTO E ( int_key , int_nokey ) VALUES ( ( SELECT 69 FROM A AS X WHERE X . int_nokey < 30 ORDER BY int_nokey GROUP BY pk LIMIT 1 ) , ( SELECT int_key FROM ( SELECT AVG( int_key ) FROM ( SELECT int_nokey FROM ( SELECT 92 FROM E AS X WHERE X . int_nokey < 63 LIMIT 20 ) AS X WHERE X . pk < 22 ORDER BY pk LIMIT 20 ) AS X WHERE X . int_nokey < 30 LIMIT 20 ) AS X WHERE X . int_nokey < 75 LIMIT 1 ) ); SELECT COUNT( int_key ) FROM E AS X WHERE X . int_nokey < 41 LIMIT 10; INSERT INTO D ( int_key , int_nokey ) VALUES ( 52 , ( SELECT ( SELECT AVG( int_key ) FROM A AS X WHERE X . int_nokey < 74 GROUP BY pk LIMIT 1 ) FROM ( SELECT int_nokey FROM C AS X WHERE X . int_key < 1 GROUP BY int_nokey LIMIT 20 ) AS X WHERE X . pk < 70 LIMIT 1 ) ); INSERT INTO B ( int_key , int_nokey ) VALUES ( 90 , 4 ); INSERT INTO B ( int_key , int_nokey ) VALUES ( ( SELECT COUNT( int_nokey ) FROM D AS X WHERE X . int_nokey < 12 ORDER BY int_nokey LIMIT 1 ) , 90 ); UPDATE B AS X SET int_key = 63 , filler = REPEAT ( ' X ' , ( SELECT AVG( int_nokey ) FROM ( SELECT 49 FROM ( SELECT COUNT( int_nokey ) FROM C AS X WHERE X . pk < 22 ORDER BY int_nokey LIMIT 20 ) AS X WHERE X . int_nokey < 54 ORDER BY int_key LIMIT 20 ) AS X WHERE X . int_key < 84 LIMIT 1 ) ) WHERE X . int_nokey < 75 ORDER BY RAND ( ) LIMIT 20; INSERT INTO C ( int_key , int_nokey ) VALUES ( 18 , 62 ); INSERT INTO A ( int_key , int_nokey ) VALUES ( 31 , ( SELECT ( SELECT 1 FROM A AS X WHERE X . pk < 67 ORDER BY pk GROUP BY pk LIMIT 1 ) FROM A AS X WHERE X . pk < 98 ORDER BY int_nokey LIMIT 1 ) ); UPDATE E AS X SET pk = 5 , filler = REPEAT ( ' X ' , ( SELECT int_nokey FROM E AS X WHERE X . int_nokey < 54 ORDER BY int_key GROUP BY int_key LIMIT 1 ) ) WHERE X . pk < 67 ORDER BY RAND ( ) LIMIT 20; INSERT INTO D ( int_key , int_nokey ) VALUES ( ( SELECT ( SELECT 25 FROM ( SELECT ( SELECT 42 FROM ( SELECT ( SELECT COUNT( pk ) FROM ( SELECT AVG( pk ) FROM A AS X WHERE X . int_key < 67 ORDER BY int_nokey GROUP BY pk LIMIT 20 ) AS X WHERE X . int_nokey < 37 GROUP BY pk LIMIT 1 ) FROM E AS X WHERE X . int_key < 78 ORDER BY int_key LIMIT 20 ) AS X WHERE X . pk < 31 LIMIT 1 ) FROM ( SELECT pk FROM ( SELECT ( SELECT ( SELECT AVG( int_key ) FROM D AS X WHERE X . int_nokey < 89 GROUP BY int_key LIMIT 1 ) FROM ( SELECT ( SELECT int_key FROM ( SELECT AVG( int_key ) FROM ( SELECT ( SELECT AVG( int_nokey ) FROM E AS X WHERE X . int_nokey < 13 GROUP BY int_nokey LIMIT 1 ) FROM C AS X WHERE X . int_key < 66 ORDER BY int_key LIMIT 20 ) AS X WHERE X . int_key < 97 ORDER BY int_key GROUP BY int_key LIMIT 20 ) AS X WHERE X . int_nokey < 2 LIMIT 1 ) FROM A AS X WHERE X . int_key < 47 GROUP BY int_nokey LIMIT 20 ) AS X WHERE X . pk < 81 LIMIT 1 ) FROM D AS X WHERE X . int_key < 86 LIMIT 20 ) AS X WHERE X . int_nokey < 91 ORDER BY int_key LIMIT 20 ) AS X WHERE X . int_key < 75 ORDER BY int_key LIMIT 20 ) AS X WHERE X . pk < 16 GROUP BY int_key LIMIT 1 ) FROM D AS X WHERE X . pk < 76 ORDER BY pk LIMIT 1 ) , 85 ); UPDATE D AS X SET int_nokey = ( SELECT int_nokey FROM ( SELECT int_nokey FROM A AS X WHERE X . pk < 8 ORDER BY int_nokey GROUP BY int_nokey LIMIT 20 ) AS X WHERE X . int_nokey < 98 ORDER BY pk LIMIT 1 ) , filler = REPEAT ( ' X ' , 40 ) WHERE X . int_nokey < 5 ORDER BY RAND ( ) LIMIT 20; UPDATE B AS X SET pk = 38 , filler = REPEAT ( ' X ' , ( SELECT 41 FROM D AS X WHERE X . int_key < 54 ORDER BY pk LIMIT 1 ) ) WHERE X . pk < 28 ORDER BY RAND ( ) LIMIT 20; UPDATE C AS X SET int_nokey = ( SELECT AVG( int_key ) FROM ( SELECT 70 FROM ( SELECT int_key FROM ( SELECT ( SELECT COUNT( int_nokey ) FROM D AS X WHERE X . pk < 9 ORDER BY int_key GROUP BY pk LIMIT 1 ) FROM D AS X WHERE X . pk < 45 ORDER BY int_key LIMIT 20 ) AS X WHERE X . pk < 75 GROUP BY int_key LIMIT 20 ) AS X WHERE X . int_key < 54 ORDER BY int_key LIMIT 20 ) AS X WHERE X . pk < 7 ORDER BY pk GROUP BY int_key LIMIT 1 ) , filler = REPEAT ( ' X ' , 3 ) WHERE X . int_nokey < 37 ORDER BY RAND ( ) LIMIT 20; SELECT int_nokey FROM ( SELECT pk FROM ( SELECT int_nokey FROM ( SELECT AVG( pk ) FROM ( SELECT ( SELECT AVG( int_nokey ) FROM ( SELECT COUNT( int_nokey ) FROM A AS X WHERE X . pk < 22 LIMIT 20 ) AS X WHERE X . pk < 69 LIMIT 1 ) FROM ( SELECT AVG( int_nokey ) FROM ( SELECT int_nokey FROM A AS X WHERE X . int_nokey < 7 LIMIT 20 ) AS X WHERE X . pk < 12 ORDER BY int_key GROUP BY int_key LIMIT 20 ) AS X WHERE X . pk < 29 ORDER BY int_nokey GROUP BY int_key LIMIT 20 ) AS X WHERE X . int_key < 60 ORDER BY int_key LIMIT 20 ) AS X WHERE X . int_nokey < 21 ORDER BY int_key LIMIT 20 ) AS X WHERE X . int_key < 11 GROUP BY int_key LIMIT 20 ) AS X WHERE X . int_key < 2 GROUP BY int_key LIMIT 10; START TRANSACTION; INSERT INTO D ( int_key , int_nokey ) VALUES ( ( SELECT AVG( int_key ) FROM ( SELECT 27 FROM A AS X WHERE X . int_key < 6 GROUP BY int_nokey LIMIT 20 ) AS X WHERE X . pk < 51 LIMIT 1 ) , 30 ); INSERT INTO A ( int_key , int_nokey ) VALUES ( ( SELECT COUNT( int_key ) FROM D AS X WHERE X . int_key < 70 GROUP BY int_nokey LIMIT 1 ) , ( SELECT AVG( pk ) FROM ( SELECT AVG( pk ) FROM A AS X WHERE X . int_nokey < 33 ORDER BY int_key LIMIT 20 ) AS X WHERE X . int_nokey < 42 LIMIT 1 ) ); START TRANSACTION; SELECT ( SELECT ( SELECT ( SELECT AVG( pk ) FROM E AS X WHERE X . int_key < 73 ORDER BY pk LIMIT 1 ) FROM ( SELECT COUNT( pk ) FROM A AS X WHERE X . int_key < 42 LIMIT 20 ) AS X WHERE X . int_key < 96 ORDER BY pk LIMIT 1 ) FROM B AS X WHERE X . int_nokey < 45 ORDER BY int_nokey LIMIT 1 ) FROM ( SELECT ( SELECT 87 FROM A AS X WHERE X . pk < 93 ORDER BY int_key GROUP BY int_nokey LIMIT 1 ) FROM E AS X WHERE X . int_nokey < 0 LIMIT 20 ) AS X WHERE X . pk < 82 ORDER BY int_nokey GROUP BY pk LIMIT 10; INSERT INTO A ( int_key , int_nokey ) VALUES ( 7 , 41 ); SELECT AVG( int_key ) FROM B AS X WHERE X . int_nokey < 5 GROUP BY pk LIMIT 10; INSERT INTO B ( int_key , int_nokey ) VALUES ( 4 , ( SELECT pk FROM C AS X WHERE X . int_nokey < 50 ORDER BY int_nokey GROUP BY int_nokey LIMIT 1 ) ); SELECT COUNT( pk ) FROM ( SELECT pk FROM ( SELECT AVG( int_nokey ) FROM ( SELECT COUNT( pk ) FROM B AS X WHERE X . int_key < 82 ORDER BY int_key GROUP BY int_nokey LIMIT 20 ) AS X WHERE X . int_nokey < 55 ORDER BY int_nokey LIMIT 20 ) AS X WHERE X . int_key < 72 ORDER BY int_key LIMIT 20 ) AS X WHERE X . int_key < 98 LIMIT 10; UPDATE C AS X SET int_nokey = 3 , filler = REPEAT ( ' X ' , ( SELECT COUNT( pk ) FROM ( SELECT pk FROM E AS X WHERE X . int_nokey < 55 LIMIT 20 ) AS X WHERE X . pk < 5 ORDER BY int_key LIMIT 1 ) ) WHERE X . int_key < 11 ORDER BY RAND ( ) LIMIT 20; START TRANSACTION; UPDATE D AS X SET int_key = ( SELECT ( SELECT pk FROM A AS X WHERE X . int_key < 56 ORDER BY pk LIMIT 1 ) FROM ( SELECT pk FROM ( SELECT COUNT( pk ) FROM A AS X WHERE X . pk < 28 GROUP BY int_nokey LIMIT 20 ) AS X WHERE X . int_nokey < 7 LIMIT 20 ) AS X WHERE X . int_key < 46 ORDER BY pk LIMIT 1 ) , filler = REPEAT ( ' X ' , 86 ) WHERE X . pk < 20 ORDER BY RAND ( ) LIMIT 20; INSERT INTO D ( int_key , int_nokey ) VALUES ( 93 , 77 ); ROLLBACK; ROLLBACK; UPDATE E AS X SET pk = ( SELECT COUNT( int_key ) FROM ( SELECT COUNT( int_nokey ) FROM D AS X WHERE X . int_nokey < 7 ORDER BY int_key LIMIT 20 ) AS X WHERE X . int_key < 52 ORDER BY int_key LIMIT 1 ) , filler = REPEAT ( ' X ' , ( SELECT int_key FROM ( SELECT int_nokey FROM A AS X WHERE X . int_key < 37 ORDER BY pk GROUP BY int_key LIMIT 20 ) AS X WHERE X . int_nokey < 8 ORDER BY int_key LIMIT 1 ) ) WHERE X . int_key < 8 ORDER BY RAND ( ) LIMIT 20; UPDATE C AS X SET int_nokey = ( SELECT pk FROM C AS X WHERE X . int_nokey < 50 GROUP BY int_key LIMIT 1 ) , filler = REPEAT ( ' X ' , ( SELECT ( SELECT int_nokey FROM E AS X WHERE X . int_nokey < 23 ORDER BY int_nokey LIMIT 1 ) FROM ( SELECT 93 FROM C AS X WHERE X . pk < 5 LIMIT 20 ) AS X WHERE X . pk < 88 ORDER BY int_key GROUP BY pk LIMIT 1 ) ) WHERE X . pk < 17 ORDER BY RAND ( ) LIMIT 20; UPDATE A AS X SET pk = 34 , filler = REPEAT ( ' X ' , 50 ) WHERE X . int_nokey < 27 ORDER BY RAND ( ) LIMIT 20; INSERT INTO A ( int_key , int_nokey ) VALUES ( ( SELECT ( SELECT AVG( int_key ) FROM ( SELECT ( SELECT AVG( int_nokey ) FROM C AS X WHERE X . int_key < 59 ORDER BY pk LIMIT 1 ) FROM ( SELECT AVG( int_nokey ) FROM C AS X WHERE X . int_key < 75 GROUP BY int_key LIMIT 20 ) AS X WHERE X . pk < 77 LIMIT 20 ) AS X WHERE X . int_nokey < 15 GROUP BY int_key LIMIT 1 ) FROM B AS X WHERE X . int_key < 77 LIMIT 1 ) , 12 ); UPDATE A AS X SET int_key = 79 , filler = REPEAT ( ' X ' , ( SELECT COUNT( int_key ) FROM ( SELECT COUNT( int_nokey ) FROM A AS X WHERE X . int_key < 89 LIMIT 20 ) AS X WHERE X . int_key < 70 ORDER BY pk LIMIT 1 ) ) WHERE X . pk < 93 ORDER BY RAND ( ) LIMIT 20; SELECT 44 FROM ( SELECT COUNT( pk ) FROM C AS X WHERE X . pk < 34 GROUP BY int_nokey LIMIT 20 ) AS X WHERE X . int_key < 8 GROUP BY int_key LIMIT 10; START TRANSACTION; UPDATE C AS X SET int_key = 56 , filler = REPEAT ( ' X ' , 13 ) WHERE X . int_key < 34 ORDER BY RAND ( ) LIMIT 20; UPDATE D AS X SET int_nokey = ( SELECT COUNT( pk ) FROM ( SELECT ( SELECT COUNT( int_nokey ) FROM ( SELECT AVG( pk ) FROM E AS X WHERE X . int_nokey < 76 LIMIT 20 ) AS X WHERE X . int_nokey < 22 ORDER BY int_key GROUP BY int_key LIMIT 1 ) FROM A AS X WHERE X . int_key < 63 GROUP BY int_nokey LIMIT 20 ) AS X WHERE X . pk < 42 LIMIT 1 ) , filler = REPEAT ( ' X ' , 72 ) WHERE X . int_key < 51 ORDER BY RAND ( ) LIMIT 20; UPDATE E AS X SET int_nokey = ( SELECT ( SELECT AVG( int_key ) FROM B AS X WHERE X . int_key < 88 LIMIT 1 ) FROM E AS X WHERE X . int_nokey < 2 ORDER BY int_key LIMIT 1 ) , filler = REPEAT ( ' X ' , ( SELECT int_key FROM ( SELECT COUNT( pk ) FROM B AS X WHERE X . pk < 71 LIMIT 20 ) AS X WHERE X . pk < 50 ORDER BY int_key LIMIT 1 ) ) WHERE X . pk < 22 ORDER BY RAND ( ) LIMIT 20; UPDATE C AS X SET pk = 47 , filler = REPEAT ( ' X ' , ( SELECT pk FROM B AS X WHERE X . pk < 13 GROUP BY int_nokey LIMIT 1 ) ) WHERE X . int_key < 52 ORDER BY RAND ( ) LIMIT 20; UPDATE B AS X SET pk = ( SELECT AVG( pk ) FROM ( SELECT AVG( int_nokey ) FROM ( SELECT 41 FROM B AS X WHERE X . pk < 59 ORDER BY int_key GROUP BY int_nokey LIMIT 20 ) AS X WHERE X . int_key < 41 GROUP BY pk LIMIT 20 ) AS X WHERE X . int_nokey < 89 ORDER BY pk GROUP BY int_nokey LIMIT 1 ) , filler = REPEAT ( ' X ' , 99 ) WHERE X . int_key < 83 ORDER BY RAND ( ) LIMIT 20; SELECT 14 FROM D AS X WHERE X . pk < 10 LIMIT 10; START TRANSACTION; COMMIT; UPDATE C AS X SET pk = ( SELECT ( SELECT AVG( pk ) FROM ( SELECT int_key FROM B AS X WHERE X . int_key < 21 ORDER BY int_key GROUP BY pk LIMIT 20 ) AS X WHERE X . pk < 75 GROUP BY int_key LIMIT 1 ) FROM E AS X WHERE X . pk < 3 GROUP BY int_key LIMIT 1 ) , filler = REPEAT ( ' X ' , 72 ) WHERE X . int_key < 32 ORDER BY RAND ( ) LIMIT 20; UPDATE C AS X SET int_nokey = ( SELECT int_nokey FROM ( SELECT ( SELECT int_nokey FROM ( SELECT COUNT( int_key ) FROM B AS X WHERE X . int_nokey < 99 LIMIT 20 ) AS X WHERE X . int_nokey < 47 ORDER BY pk LIMIT 1 ) FROM ( SELECT pk FROM C AS X WHERE X . int_nokey < 87 ORDER BY int_key LIMIT 20 ) AS X WHERE X . int_key < 57 ORDER BY int_key LIMIT 20 ) AS X WHERE X . int_nokey < 5 ORDER BY int_key GROUP BY int_key LIMIT 1 ) , filler = REPEAT ( ' X ' , ( SELECT COUNT( int_key ) FROM ( SELECT int_nokey FROM ( SELECT AVG( pk ) FROM ( SELECT 9 FROM E AS X WHERE X . int_nokey < 36 GROUP BY int_nokey LIMIT 20 ) AS X WHERE X . int_nokey < 27 GROUP BY pk LIMIT 20 ) AS X WHERE X . int_nokey < 41 GROUP BY pk LIMIT 20 ) AS X WHERE X . int_nokey < 50 GROUP BY int_key LIMIT 1 ) ) WHERE X . pk < 6 ORDER BY RAND ( ) LIMIT 20; START TRANSACTION; UPDATE D AS X SET int_key = ( SELECT ( SELECT AVG( int_nokey ) FROM ( SELECT pk FROM ( SELECT COUNT( pk ) FROM C AS X WHERE X . pk < 13 ORDER BY int_nokey LIMIT 20 ) AS X WHERE X . int_key < 53 ORDER BY pk GROUP BY pk LIMIT 20 ) AS X WHERE X . int_nokey < 54 ORDER BY int_key LIMIT 1 ) FROM ( SELECT AVG( int_nokey ) FROM D AS X WHERE X . pk < 25 ORDER BY int_key GROUP BY int_key LIMIT 20 ) AS X WHERE X . int_nokey < 24 ORDER BY int_nokey GROUP BY int_nokey LIMIT 1 ) , filler = REPEAT ( ' X ' , ( SELECT pk FROM ( SELECT 44 FROM C AS X WHERE X . int_nokey < 65 ORDER BY pk LIMIT 20 ) AS X WHERE X . pk < 67 ORDER BY int_nokey GROUP BY int_nokey LIMIT 1 ) ) WHERE X . int_nokey < 28 ORDER BY RAND ( ) LIMIT 20; UPDATE C AS X SET int_key = 86 , filler = REPEAT ( ' X ' , ( SELECT COUNT( int_nokey ) FROM ( SELECT AVG( pk ) FROM E AS X WHERE X . pk < 69 ORDER BY pk GROUP BY int_key LIMIT 20 ) AS X WHERE X . int_key < 63 ORDER BY pk LIMIT 1 ) ) WHERE X . pk < 16 ORDER BY RAND ( ) LIMIT 20; START TRANSACTION; INSERT INTO D ( int_key , int_nokey ) VALUES ( 38 , ( SELECT COUNT( int_nokey ) FROM D AS X WHERE X . int_nokey < 77 ORDER BY int_key GROUP BY pk LIMIT 1 ) ); SELECT AVG( pk ) FROM D AS X WHERE X . int_key < 32 ORDER BY int_nokey LIMIT 10; UPDATE B AS X SET pk = 8 , filler = REPEAT ( ' X ' , 77 ) WHERE X . int_nokey < 8 ORDER BY RAND ( ) LIMIT 20; UPDATE E AS X SET pk = 91 , filler = REPEAT ( ' X ' , 91 ) WHERE X . int_nokey < 48 ORDER BY RAND ( ) LIMIT 20; START TRANSACTION; SELECT AVG( pk ) FROM E AS X WHERE X . int_nokey < 10 ORDER BY int_nokey GROUP BY int_nokey LIMIT 10; UPDATE A AS X SET pk = 99 , filler = REPEAT ( ' X ' , ( SELECT ( SELECT int_key FROM ( SELECT int_key FROM D AS X WHERE X . int_key < 89 LIMIT 20 ) AS X WHERE X . int_nokey < 4 ORDER BY int_nokey GROUP BY int_nokey LIMIT 1 ) FROM ( SELECT ( SELECT COUNT( int_key ) FROM ( SELECT AVG( int_nokey ) FROM ( SELECT COUNT( int_key ) FROM D AS X WHERE X . int_nokey < 65 ORDER BY int_nokey LIMIT 20 ) AS X WHERE X . int_key < 56 LIMIT 20 ) AS X WHERE X . int_nokey < 41 GROUP BY pk LIMIT 1 ) FROM D AS X WHERE X . int_key < 88 ORDER BY int_key GROUP BY pk LIMIT 20 ) AS X WHERE X . int_key < 75 ORDER BY int_key GROUP BY pk LIMIT 1 ) ) WHERE X . pk < 38 ORDER BY RAND ( ) LIMIT 20; INSERT INTO E ( int_key , int_nokey ) VALUES ( 46 , 43 ); ROLLBACK; UPDATE D AS X SET int_nokey = ( SELECT int_nokey FROM ( SELECT ( SELECT COUNT( int_key ) FROM A AS X WHERE X . int_nokey < 83 LIMIT 1 ) FROM ( SELECT ( SELECT int_nokey FROM C AS X WHERE X . int_nokey < 81 GROUP BY pk LIMIT 1 ) FROM B AS X WHERE X . int_nokey < 23 ORDER BY int_key LIMIT 20 ) AS X WHERE X . int_nokey < 42 ORDER BY pk LIMIT 20 ) AS X WHERE X . int_nokey < 75 GROUP BY pk LIMIT 1 ) , filler = REPEAT ( ' X ' , ( SELECT COUNT( pk ) FROM ( SELECT COUNT( int_nokey ) FROM A AS X WHERE X . pk < 97 LIMIT 20 ) AS X WHERE X . int_nokey < 64 ORDER BY int_key LIMIT 1 ) ) WHERE X . int_nokey < 32 ORDER BY RAND ( ) LIMIT 20; COMMIT; SELECT AVG( pk ) FROM A AS X WHERE X . pk < 56 ORDER BY pk GROUP BY pk LIMIT 10; UPDATE D AS X SET int_key = 71 , filler = REPEAT ( ' X ' , ( SELECT AVG( int_nokey ) FROM B AS X WHERE X . int_key < 40 ORDER BY int_key GROUP BY int_key LIMIT 1 ) ) WHERE X . int_key < 55 ORDER BY RAND ( ) LIMIT 20; UPDATE C AS X SET pk = ( SELECT AVG( pk ) FROM ( SELECT ( SELECT COUNT( int_key ) FROM ( SELECT COUNT( pk ) FROM ( SELECT AVG( pk ) FROM ( SELECT ( SELECT AVG( int_nokey ) FROM ( SELECT pk FROM D AS X WHERE X . int_nokey < 2 GROUP BY int_key LIMIT 20 ) AS X WHERE X . pk < 14 ORDER BY pk GROUP BY pk LIMIT 1 ) FROM E AS X WHERE X . pk < 0 LIMIT 20 ) AS X WHERE X . int_nokey < 27 ORDER BY int_key LIMIT 20 ) AS X WHERE X . pk < 42 ORDER BY int_nokey LIMIT 20 ) AS X WHERE X . int_key < 44 ORDER BY int_nokey LIMIT 1 ) FROM ( SELECT 95 FROM ( SELECT AVG( pk ) FROM D AS X WHERE X . int_key < 28 LIMIT 20 ) AS X WHERE X . int_key < 65 ORDER BY pk GROUP BY int_nokey LIMIT 20 ) AS X WHERE X . int_key < 51 ORDER BY int_key LIMIT 20 ) AS X WHERE X . int_nokey < 32 ORDER BY int_nokey GROUP BY pk LIMIT 1 ) , filler = REPEAT ( ' X ' , 78 ) WHERE X . int_key < 84 ORDER BY RAND ( ) LIMIT 20; COMMIT; UPDATE A AS X SET int_key = ( SELECT AVG( int_key ) FROM E AS X WHERE X . pk < 34 GROUP BY pk LIMIT 1 ) , filler = REPEAT ( ' X ' , 34 ) WHERE X . int_key < 22 ORDER BY RAND ( ) LIMIT 20; INSERT INTO D ( int_key , int_nokey ) VALUES ( 33 , ( SELECT AVG( int_nokey ) FROM C AS X WHERE X . int_key < 21 GROUP BY int_key LIMIT 1 ) ); INSERT INTO C ( int_key , int_nokey ) VALUES ( 29 , 74 ); UPDATE E AS X SET pk = 14 , filler = REPEAT ( ' X ' , ( SELECT pk FROM B AS X WHERE X . int_key < 34 LIMIT 1 ) ) WHERE X . pk < 89 ORDER BY RAND ( ) LIMIT 20; UPDATE B AS X SET pk = ( SELECT int_key FROM ( SELECT AVG( int_key ) FROM E AS X WHERE X . pk < 16 ORDER BY int_key GROUP BY int_nokey LIMIT 20 ) AS X WHERE X . int_key < 38 ORDER BY int_key LIMIT 1 ) , filler = REPEAT ( ' X ' , 4 ) WHERE X . int_key < 75 ORDER BY RAND ( ) LIMIT 20; SELECT AVG( int_nokey ) FROM B AS X WHERE X . pk < 99 ORDER BY pk GROUP BY int_nokey LIMIT 10; UPDATE A AS X SET int_nokey = ( SELECT COUNT( pk ) FROM ( SELECT AVG( pk ) FROM ( SELECT COUNT( int_key ) FROM A AS X WHERE X . int_nokey < 74 LIMIT 20 ) AS X WHERE X . pk < 38 ORDER BY pk LIMIT 20 ) AS X WHERE X . pk < 69 ORDER BY pk LIMIT 1 ) , filler = REPEAT ( ' X ' , ( SELECT ( SELECT ( SELECT COUNT( pk ) FROM ( SELECT int_nokey FROM B AS X WHERE X . pk < 58 ORDER BY pk LIMIT 20 ) AS X WHERE X . int_nokey < 34 LIMIT 1 ) FROM ( SELECT COUNT( pk ) FROM B AS X WHERE X . int_nokey < 78 GROUP BY int_nokey LIMIT 20 ) AS X WHERE X . int_key < 24 GROUP BY int_nokey LIMIT 1 ) FROM D AS X WHERE X . int_nokey < 41 LIMIT 1 ) ) WHERE X . int_key < 74 ORDER BY RAND ( ) LIMIT 20; COMMIT; UPDATE E AS X SET pk = ( SELECT ( SELECT 88 FROM ( SELECT AVG( int_nokey ) FROM ( SELECT AVG( pk ) FROM E AS X WHERE X . pk < 10 GROUP BY pk LIMIT 20 ) AS X WHERE X . int_nokey < 9 ORDER BY int_nokey LIMIT 20 ) AS X WHERE X . int_nokey < 88 LIMIT 1 ) FROM C AS X WHERE X . pk < 49 GROUP BY pk LIMIT 1 ) , filler = REPEAT ( ' X ' , 57 ) WHERE X . int_nokey < 95 ORDER BY RAND ( ) LIMIT 20; UPDATE E AS X SET int_key = ( SELECT pk FROM ( SELECT int_nokey FROM A AS X WHERE X . int_nokey < 17 ORDER BY int_nokey GROUP BY pk LIMIT 20 ) AS X WHERE X . pk < 55 ORDER BY pk GROUP BY int_nokey LIMIT 1 ) , filler = REPEAT ( ' X ' , ( SELECT AVG( int_nokey ) FROM ( SELECT COUNT( pk ) FROM ( SELECT COUNT( int_key ) FROM C AS X WHERE X . int_key < 67 ORDER BY pk GROUP BY int_key LIMIT 20 ) AS X WHERE X . pk < 74 LIMIT 20 ) AS X WHERE X . int_key < 54 ORDER BY int_key LIMIT 1 ) ) WHERE X . int_nokey < 68 ORDER BY RAND ( ) LIMIT 20; UPDATE E AS X SET pk = ( SELECT 56 FROM ( SELECT pk FROM ( SELECT AVG( pk ) FROM D AS X WHERE X . int_nokey < 17 ORDER BY pk GROUP BY int_nokey LIMIT 20 ) AS X WHERE X . int_key < 5 ORDER BY pk LIMIT 20 ) AS X WHERE X . pk < 97 LIMIT 1 ) , filler = REPEAT ( ' X ' , 16 ) WHERE X . pk < 49 ORDER BY RAND ( ) LIMIT 20; UPDATE B AS X SET int_nokey = 26 , filler = REPEAT ( ' X ' , ( SELECT COUNT( int_key ) FROM A AS X WHERE X . int_nokey < 16 ORDER BY pk LIMIT 1 ) ) WHERE X . int_key < 9 ORDER BY RAND ( ) LIMIT 20; UPDATE B AS X SET int_nokey = 43 , filler = REPEAT ( ' X ' , ( SELECT 27 FROM ( SELECT int_key FROM ( SELECT int_key FROM D AS X WHERE X . pk < 81 LIMIT 20 ) AS X WHERE X . int_nokey < 76 GROUP BY pk LIMIT 20 ) AS X WHERE X . pk < 56 GROUP BY pk LIMIT 1 ) ) WHERE X . int_nokey < 50 ORDER BY RAND ( ) LIMIT 20; START TRANSACTION; INSERT INTO D ( int_key , int_nokey ) VALUES ( 5 , 49 ); INSERT INTO D ( int_key , int_nokey ) VALUES ( ( SELECT COUNT( pk ) FROM C AS X WHERE X . int_key < 93 ORDER BY pk LIMIT 1 ) , 92 ); INSERT INTO C ( int_key , int_nokey ) VALUES ( 65 , ( SELECT pk FROM ( SELECT COUNT( int_key ) FROM ( SELECT COUNT( pk ) FROM D AS X WHERE X . int_key < 77 ORDER BY pk GROUP BY pk LIMIT 20 ) AS X WHERE X . pk < 72 GROUP BY pk LIMIT 20 ) AS X WHERE X . int_key < 52 LIMIT 1 ) ); INSERT INTO A ( int_key , int_nokey ) VALUES ( ( SELECT 30 FROM ( SELECT COUNT( pk ) FROM E AS X WHERE X . int_nokey < 67 ORDER BY pk GROUP BY pk LIMIT 20 ) AS X WHERE X . int_nokey < 6 ORDER BY int_key GROUP BY int_key LIMIT 1 ) , 36 ); START TRANSACTION; UPDATE D AS X SET pk = 2 , filler = REPEAT ( ' X ' , ( SELECT int_key FROM ( SELECT pk FROM B AS X WHERE X . int_key < 7 ORDER BY pk LIMIT 20 ) AS X WHERE X . int_key < 42 ORDER BY int_key GROUP BY int_nokey LIMIT 1 ) ) WHERE X . int_key < 5 ORDER BY RAND ( ) LIMIT 20; UPDATE A AS X SET int_key = ( SELECT COUNT( int_key ) FROM ( SELECT ( SELECT ( SELECT AVG( int_nokey ) FROM ( SELECT AVG( int_key ) FROM A AS X WHERE X . pk < 49 ORDER BY int_nokey GROUP BY int_nokey LIMIT 20 ) AS X WHERE X . int_key < 61 LIMIT 1 ) FROM ( SELECT COUNT( pk ) FROM ( SELECT 49 FROM ( SELECT COUNT( int_nokey ) FROM ( SELECT ( SELECT ( SELECT pk FROM C AS X WHERE X . pk < 40 ORDER BY int_nokey GROUP BY int_key LIMIT 1 ) FROM E AS X WHERE X . pk < 55 GROUP BY int_nokey LIMIT 1 ) FROM B AS X WHERE X . pk < 96 GROUP BY pk LIMIT 20 ) AS X WHERE X . int_nokey < 19 GROUP BY int_nokey LIMIT 20 ) AS X WHERE X . pk < 88 GROUP BY int_key LIMIT 20 ) AS X WHERE X . int_nokey < 67 ORDER BY pk GROUP BY int_key LIMIT 20 ) AS X WHERE X . int_key < 2 GROUP BY int_nokey LIMIT 1 ) FROM E AS X WHERE X . int_key < 38 LIMIT 20 ) AS X WHERE X . int_key < 98 GROUP BY int_nokey LIMIT 1 ) , filler = REPEAT ( ' X ' , ( SELECT ( SELECT AVG( int_key ) FROM E AS X WHERE X . int_nokey < 73 LIMIT 1 ) FROM C AS X WHERE X . int_key < 1 ORDER BY int_nokey LIMIT 1 ) ) WHERE X . int_nokey < 10 ORDER BY RAND ( ) LIMIT 20; SELECT ( SELECT 26 FROM ( SELECT AVG( int_nokey ) FROM D AS X WHERE X . pk < 24 ORDER BY int_nokey LIMIT 20 ) AS X WHERE X . int_key < 34 ORDER BY int_nokey GROUP BY int_nokey LIMIT 1 ) FROM ( SELECT ( SELECT pk FROM ( SELECT AVG( int_nokey ) FROM D AS X WHERE X . int_nokey < 43 GROUP BY int_nokey LIMIT 20 ) AS X WHERE X . pk < 46 ORDER BY int_key GROUP BY pk LIMIT 1 ) FROM ( SELECT ( SELECT AVG( int_key ) FROM ( SELECT AVG( int_nokey ) FROM E AS X WHERE X . int_nokey < 88 LIMIT 20 ) AS X WHERE X . int_key < 56 GROUP BY int_key LIMIT 1 ) FROM B AS X WHERE X . int_key < 56 GROUP BY int_nokey LIMIT 20 ) AS X WHERE X . int_key < 25 ORDER BY int_key LIMIT 20 ) AS X WHERE X . pk < 8 ORDER BY int_nokey LIMIT 10; UPDATE A AS X SET int_nokey = 30 , filler = REPEAT ( ' X ' , 24 ) WHERE X . int_key < 99 ORDER BY RAND ( ) LIMIT 20; UPDATE B AS X SET pk = 64 , filler = REPEAT ( ' X ' , 57 ) WHERE X . int_key < 2 ORDER BY RAND ( ) LIMIT 20; UPDATE B AS X SET int_nokey = ( SELECT COUNT( pk ) FROM A AS X WHERE X . int_key < 89 ORDER BY int_nokey GROUP BY pk LIMIT 1 ) , filler = REPEAT ( ' X ' , 36 ) WHERE X . int_nokey < 12 ORDER BY RAND ( ) LIMIT 20; UPDATE B AS X SET pk = ( SELECT pk FROM A AS X WHERE X . int_key < 82 LIMIT 1 ) , filler = REPEAT ( ' X ' , 15 ) WHERE X . pk < 67 ORDER BY RAND ( ) LIMIT 20; COMMIT; ROLLBACK; UPDATE D AS X SET pk = 8 , filler = REPEAT ( ' X ' , ( SELECT int_nokey FROM ( SELECT int_nokey FROM ( SELECT AVG( int_nokey ) FROM ( SELECT COUNT( int_key ) FROM D AS X WHERE X . int_nokey < 50 ORDER BY pk GROUP BY int_nokey LIMIT 20 ) AS X WHERE X . int_key < 90 GROUP BY int_nokey LIMIT 20 ) AS X WHERE X . pk < 81 LIMIT 20 ) AS X WHERE X . pk < 61 ORDER BY pk LIMIT 1 ) ) WHERE X . int_nokey < 69 ORDER BY RAND ( ) LIMIT 20; SELECT COUNT( int_key ) FROM E AS X WHERE X . int_key < 38 GROUP BY int_key LIMIT 10; START TRANSACTION; INSERT INTO C ( int_key , int_nokey ) VALUES ( 46 , 45 ); SELECT AVG( int_nokey ) FROM D AS X WHERE X . int_key < 27 ORDER BY int_nokey LIMIT 10; INSERT INTO D ( int_key , int_nokey ) VALUES ( 12 , 53 ); INSERT INTO B ( int_key , int_nokey ) VALUES ( ( SELECT COUNT( int_key ) FROM B AS X WHERE X . int_nokey < 48 LIMIT 1 ) , ( SELECT AVG( pk ) FROM ( SELECT int_key FROM ( SELECT COUNT( int_nokey ) FROM ( SELECT 23 FROM C AS X WHERE X . int_nokey < 30 ORDER BY int_key GROUP BY pk LIMIT 20 ) AS X WHERE X . pk < 65 ORDER BY int_key GROUP BY int_nokey LIMIT 20 ) AS X WHERE X . int_key < 22 LIMIT 20 ) AS X WHERE X . int_key < 90 GROUP BY int_key LIMIT 1 ) ); COMMIT; SELECT COUNT( int_key ) FROM ( SELECT COUNT( int_key ) FROM A AS X WHERE X . pk < 20 GROUP BY int_nokey LIMIT 20 ) AS X WHERE X . pk < 89 LIMIT 10; UPDATE C AS X SET int_nokey = 84 , filler = REPEAT ( ' X ' , 53 ) WHERE X . pk < 51 ORDER BY RAND ( ) LIMIT 20; INSERT INTO E ( int_key , int_nokey ) VALUES ( ( SELECT AVG( int_nokey ) FROM ( SELECT ( SELECT int_key FROM ( SELECT 18 FROM ( SELECT int_nokey FROM C AS X WHERE X . int_nokey < 99 ORDER BY int_nokey LIMIT 20 ) AS X WHERE X . pk < 10 GROUP BY int_nokey LIMIT 20 ) AS X WHERE X . int_nokey < 31 LIMIT 1 ) FROM E AS X WHERE X . pk < 69 ORDER BY int_nokey GROUP BY pk LIMIT 20 ) AS X WHERE X . int_nokey < 22 ORDER BY pk LIMIT 1 ) , 83 ); SELECT AVG( pk ) FROM C AS X WHERE X . int_nokey < 35 GROUP BY int_key LIMIT 10; UPDATE B AS X SET int_nokey = ( SELECT AVG( pk ) FROM E AS X WHERE X . int_nokey < 74 LIMIT 1 ) , filler = REPEAT ( ' X ' , 73 ) WHERE X . pk < 79 ORDER BY RAND ( ) LIMIT 20; INSERT INTO B ( int_key , int_nokey ) VALUES ( 77 , 95 ); UPDATE D AS X SET pk = 91 , filler = REPEAT ( ' X ' , 0 ) WHERE X . int_key < 98 ORDER BY RAND ( ) LIMIT 20; INSERT INTO D ( int_key , int_nokey ) VALUES ( 11 , 41 ); UPDATE E AS X SET int_nokey = ( SELECT ( SELECT int_key FROM A AS X WHERE X . pk < 40 ORDER BY int_nokey LIMIT 1 ) FROM E AS X WHERE X . int_nokey < 27 ORDER BY pk LIMIT 1 ) , filler = REPEAT ( ' X ' , ( SELECT ( SELECT COUNT( int_nokey ) FROM A AS X WHERE X . int_nokey < 93 ORDER BY int_nokey GROUP BY pk LIMIT 1 ) FROM ( SELECT int_nokey FROM ( SELECT int_nokey FROM ( SELECT ( SELECT ( SELECT int_nokey FROM C AS X WHERE X . pk < 42 ORDER BY int_nokey GROUP BY int_key LIMIT 1 ) FROM B AS X WHERE X . pk < 49 ORDER BY int_key LIMIT 1 ) FROM ( SELECT ( SELECT COUNT( int_nokey ) FROM ( SELECT 81 FROM E AS X WHERE X . int_nokey < 73 LIMIT 20 ) AS X WHERE X . int_key < 2 GROUP BY int_nokey LIMIT 1 ) FROM C AS X WHERE X . int_key < 70 ORDER BY pk GROUP BY pk LIMIT 20 ) AS X WHERE X . int_key < 68 LIMIT 20 ) AS X WHERE X . int_nokey < 2 ORDER BY int_key GROUP BY pk LIMIT 20 ) AS X WHERE X . int_key < 18 ORDER BY pk LIMIT 20 ) AS X WHERE X . int_key < 28 LIMIT 1 ) ) WHERE X . int_nokey < 25 ORDER BY RAND ( ) LIMIT 20; INSERT INTO A ( int_key , int_nokey ) VALUES ( 33 , 80 ); SELECT 19 FROM E AS X WHERE X . int_nokey < 65 LIMIT 10; UPDATE D AS X SET int_nokey = ( SELECT COUNT( pk ) FROM E AS X WHERE X . pk < 82 GROUP BY pk LIMIT 1 ) , filler = REPEAT ( ' X ' , ( SELECT ( SELECT ( SELECT int_nokey FROM D AS X WHERE X . int_nokey < 5 ORDER BY int_nokey LIMIT 1 ) FROM ( SELECT AVG( pk ) FROM ( SELECT COUNT( int_key ) FROM ( SELECT ( SELECT ( SELECT AVG( int_nokey ) FROM ( SELECT int_nokey FROM E AS X WHERE X . int_key < 8 LIMIT 20 ) AS X WHERE X . int_key < 89 GROUP BY pk LIMIT 1 ) FROM ( SELECT int_nokey FROM B AS X WHERE X . int_nokey < 41 ORDER BY pk LIMIT 20 ) AS X WHERE X . pk < 47 LIMIT 1 ) FROM A AS X WHERE X . int_key < 89 LIMIT 20 ) AS X WHERE X . int_nokey < 53 ORDER BY int_key LIMIT 20 ) AS X WHERE X . int_key < 94 GROUP BY pk LIMIT 20 ) AS X WHERE X . int_key < 98 LIMIT 1 ) FROM ( SELECT COUNT( int_nokey ) FROM ( SELECT int_nokey FROM ( SELECT int_key FROM C AS X WHERE X . pk < 10 ORDER BY int_key GROUP BY int_key LIMIT 20 ) AS X WHERE X . int_key < 44 LIMIT 20 ) AS X WHERE X . int_nokey < 37 ORDER BY pk LIMIT 20 ) AS X WHERE X . int_key < 50 LIMIT 1 ) ) WHERE X . pk < 7 ORDER BY RAND ( ) LIMIT 20; START TRANSACTION; UPDATE C AS X SET pk = 49 , filler = REPEAT ( ' X ' , 94 ) WHERE X . int_key < 99 ORDER BY RAND ( ) LIMIT 20; INSERT INTO C ( int_key , int_nokey ) VALUES ( ( SELECT pk FROM D AS X WHERE X . pk < 64 GROUP BY pk LIMIT 1 ) , 97 ); UPDATE A AS X SET pk = 61 , filler = REPEAT ( ' X ' , ( SELECT int_nokey FROM C AS X WHERE X . int_key < 83 LIMIT 1 ) ) WHERE X . pk < 93 ORDER BY RAND ( ) LIMIT 20; INSERT INTO A ( int_key , int_nokey ) VALUES ( 51 , 82 ); SELECT ( SELECT COUNT( pk ) FROM E AS X WHERE X . pk < 80 GROUP BY int_key LIMIT 1 ) FROM A AS X WHERE X . int_nokey < 64 ORDER BY int_nokey LIMIT 10; SELECT COUNT( int_nokey ) FROM C AS X WHERE X . pk < 86 LIMIT 10; START TRANSACTION; UPDATE A AS X SET int_nokey = ( SELECT COUNT( pk ) FROM D AS X WHERE X . pk < 43 ORDER BY int_key GROUP BY int_nokey LIMIT 1 ) , filler = REPEAT ( ' X ' , 28 ) WHERE X . int_key < 85 ORDER BY RAND ( ) LIMIT 20; UPDATE D AS X SET int_key = 96 , filler = REPEAT ( ' X ' , 94 ) WHERE X . int_nokey < 55 ORDER BY RAND ( ) LIMIT 20; SELECT COUNT( pk ) FROM ( SELECT AVG( int_key ) FROM ( SELECT int_nokey FROM D AS X WHERE X . int_nokey < 5 ORDER BY pk GROUP BY int_nokey LIMIT 20 ) AS X WHERE X . int_key < 79 LIMIT 20 ) AS X WHERE X . int_nokey < 77 LIMIT 10; COMMIT; SELECT 26 FROM ( SELECT 89 FROM ( SELECT COUNT( int_key ) FROM ( SELECT COUNT( pk ) FROM ( SELECT 21 FROM C AS X WHERE X . pk < 38 ORDER BY int_key GROUP BY int_nokey LIMIT 20 ) AS X WHERE X . int_nokey < 13 ORDER BY int_key GROUP BY int_nokey LIMIT 20 ) AS X WHERE X . pk < 28 LIMIT 20 ) AS X WHERE X . pk < 63 LIMIT 20 ) AS X WHERE X . int_key < 39 GROUP BY int_nokey LIMIT 10; UPDATE D AS X SET int_key = ( SELECT ( SELECT 9 FROM ( SELECT ( SELECT AVG( int_key ) FROM ( SELECT int_key FROM ( SELECT AVG( int_key ) FROM E AS X WHERE X . int_key < 43 GROUP BY int_key LIMIT 20 ) AS X WHERE X . int_key < 44 LIMIT 20 ) AS X WHERE X . int_key < 69 LIMIT 1 ) FROM ( SELECT ( SELECT AVG( int_key ) FROM D AS X WHERE X . int_nokey < 63 ORDER BY pk GROUP BY int_key LIMIT 1 ) FROM ( SELECT AVG( int_key ) FROM ( SELECT pk FROM ( SELECT int_key FROM ( SELECT pk FROM ( SELECT ( SELECT COUNT( pk ) FROM ( SELECT COUNT( int_key ) FROM A AS X WHERE X . int_key < 19 ORDER BY int_key LIMIT 20 ) AS X WHERE X . int_key < 46 ORDER BY pk LIMIT 1 ) FROM B AS X WHERE X . int_key < 76 GROUP BY pk LIMIT 20 ) AS X WHERE X . int_key < 46 ORDER BY int_nokey GROUP BY pk LIMIT 20 ) AS X WHERE X . pk < 80 ORDER BY int_nokey GROUP BY pk LIMIT 20 ) AS X WHERE X . pk < 62 GROUP BY int_nokey LIMIT 20 ) AS X WHERE X . int_nokey < 39 GROUP BY pk LIMIT 20 ) AS X WHERE X . pk < 94 GROUP BY int_key LIMIT 20 ) AS X WHERE X . int_nokey < 9 LIMIT 20 ) AS X WHERE X . int_nokey < 78 ORDER BY pk GROUP BY int_nokey LIMIT 1 ) FROM ( SELECT ( SELECT ( SELECT COUNT( int_key ) FROM E AS X WHERE X . int_key < 68 ORDER BY int_key GROUP BY int_nokey LIMIT 1 ) FROM ( SELECT int_nokey FROM ( SELECT ( SELECT COUNT( int_key ) FROM D AS X WHERE X . pk < 89 ORDER BY pk LIMIT 1 ) FROM E AS X WHERE X . pk < 27 ORDER BY pk LIMIT 20 ) AS X WHERE X . pk < 65 LIMIT 20 ) AS X WHERE X . int_key < 2 ORDER BY int_nokey GROUP BY pk LIMIT 1 ) FROM A AS X WHERE X . int_key < 60 GROUP BY int_nokey LIMIT 20 ) AS X WHERE X . int_nokey < 60 ORDER BY int_nokey LIMIT 1 ) , filler = REPEAT ( ' X ' , 86 ) WHERE X . pk < 33 ORDER BY RAND ( ) LIMIT 20; SELECT ( SELECT ( SELECT AVG( int_key ) FROM E AS X WHERE X . int_key < 19 LIMIT 1 ) FROM B AS X WHERE X . int_nokey < 9 LIMIT 1 ) FROM ( SELECT int_nokey FROM ( SELECT COUNT( int_nokey ) FROM ( SELECT COUNT( pk ) FROM ( SELECT COUNT( pk ) FROM ( SELECT int_key FROM D AS X WHERE X . int_nokey < 12 GROUP BY int_key LIMIT 20 ) AS X WHERE X . pk < 23 LIMIT 20 ) AS X WHERE X . pk < 4 ORDER BY pk GROUP BY int_nokey LIMIT 20 ) AS X WHERE X . int_nokey < 47 ORDER BY int_nokey GROUP BY int_key LIMIT 20 ) AS X WHERE X . int_nokey < 55 LIMIT 20 ) AS X WHERE X . int_key < 34 GROUP BY int_key LIMIT 10; INSERT INTO C ( int_key , int_nokey ) VALUES ( ( SELECT AVG( int_nokey ) FROM B AS X WHERE X . int_nokey < 83 LIMIT 1 ) , 68 ); UPDATE A AS X SET int_nokey = 1 , filler = REPEAT ( ' X ' , ( SELECT COUNT( pk ) FROM A AS X WHERE X . pk < 43 ORDER BY int_nokey LIMIT 1 ) ) WHERE X . pk < 33 ORDER BY RAND ( ) LIMIT 20; UPDATE A AS X SET int_key = ( SELECT COUNT( int_key ) FROM ( SELECT int_nokey FROM E AS X WHERE X . pk < 70 GROUP BY int_nokey LIMIT 20 ) AS X WHERE X . int_nokey < 99 ORDER BY int_key GROUP BY int_key LIMIT 1 ) , filler = REPEAT ( ' X ' , 59 ) WHERE X . int_nokey < 55 ORDER BY RAND ( ) LIMIT 20; UPDATE D AS X SET int_key = ( SELECT COUNT( pk ) FROM B AS X WHERE X . pk < 88 ORDER BY pk LIMIT 1 ) , filler = REPEAT ( ' X ' , 42 ) WHERE X . pk < 90 ORDER BY RAND ( ) LIMIT 20; START TRANSACTION; SELECT int_nokey FROM E AS X WHERE X . int_key < 67 GROUP BY int_key LIMIT 10; SELECT 80 FROM ( SELECT 77 FROM A AS X WHERE X . pk < 23 ORDER BY int_key GROUP BY pk LIMIT 20 ) AS X WHERE X . int_nokey < 37 GROUP BY int_nokey LIMIT 10; INSERT INTO B ( int_key , int_nokey ) VALUES ( 42 , 89 ); UPDATE C AS X SET pk = 67 , filler = REPEAT ( ' X ' , 46 ) WHERE X . pk < 5 ORDER BY RAND ( ) LIMIT 20; UPDATE B AS X SET int_nokey = 38 , filler = REPEAT ( ' X ' , 53 ) WHERE X . int_nokey < 86 ORDER BY RAND ( ) LIMIT 20; INSERT INTO A ( int_key , int_nokey ) VALUES ( ( SELECT COUNT( pk ) FROM A AS X WHERE X . pk < 70 LIMIT 1 ) , ( SELECT int_key FROM D AS X WHERE X . int_key < 30 ORDER BY int_key GROUP BY int_key LIMIT 1 ) ); START TRANSACTION; SELECT ( SELECT AVG( pk ) FROM C AS X WHERE X . int_key < 37 LIMIT 1 ) FROM ( SELECT AVG( int_key ) FROM E AS X WHERE X . int_nokey < 18 ORDER BY pk LIMIT 20 ) AS X WHERE X . int_key < 29 ORDER BY int_nokey LIMIT 10; INSERT INTO B ( int_key , int_nokey ) VALUES ( 62 , 17 ); INSERT INTO C ( int_key , int_nokey ) VALUES ( ( SELECT COUNT( int_key ) FROM B AS X WHERE X . pk < 35 ORDER BY int_nokey GROUP BY int_key LIMIT 1 ) , ( SELECT int_key FROM E AS X WHERE X . int_key < 73 LIMIT 1 ) ); START TRANSACTION; INSERT INTO A ( int_key , int_nokey ) VALUES ( 81 , 27 ); UPDATE C AS X SET int_key = 56 , filler = REPEAT ( ' X ' , 83 ) WHERE X . int_nokey < 74 ORDER BY RAND ( ) LIMIT 20; UPDATE A AS X SET int_nokey = ( SELECT 69 FROM ( SELECT AVG( pk ) FROM ( SELECT pk FROM ( SELECT ( SELECT AVG( int_key ) FROM B AS X WHERE X . int_nokey < 39 LIMIT 1 ) FROM D AS X WHERE X . int_key < 65 ORDER BY int_nokey LIMIT 20 ) AS X WHERE X . int_nokey < 48 ORDER BY int_key GROUP BY pk LIMIT 20 ) AS X WHERE X . int_nokey < 20 ORDER BY int_nokey GROUP BY int_nokey LIMIT 20 ) AS X WHERE X . int_key < 42 LIMIT 1 ) , filler = REPEAT ( ' X ' , 4 ) WHERE X . pk < 48 ORDER BY RAND ( ) LIMIT 20; UPDATE C AS X SET pk = 45 , filler = REPEAT ( ' X ' , 53 ) WHERE X . pk < 58 ORDER BY RAND ( ) LIMIT 20; UPDATE E AS X SET int_key = 38 , filler = REPEAT ( ' X ' , ( SELECT AVG( int_key ) FROM B AS X WHERE X . pk < 21 LIMIT 1 ) ) WHERE X . int_nokey < 56 ORDER BY RAND ( ) LIMIT 20; UPDATE B AS X SET int_key = ( SELECT ( SELECT int_key FROM D AS X WHERE X . pk < 84 LIMIT 1 ) FROM B AS X WHERE X . int_key < 97 GROUP BY int_key LIMIT 1 ) , filler = REPEAT ( ' X ' , ( SELECT COUNT( pk ) FROM E AS X WHERE X . int_key < 11 LIMIT 1 ) ) WHERE X . int_nokey < 79 ORDER BY RAND ( ) LIMIT 20; INSERT INTO C ( int_key , int_nokey ) VALUES ( ( SELECT 72 FROM ( SELECT 16 FROM ( SELECT pk FROM ( SELECT COUNT( int_key ) FROM E AS X WHERE X . pk < 13 ORDER BY int_nokey GROUP BY int_nokey LIMIT 20 ) AS X WHERE X . int_nokey < 18 GROUP BY int_key LIMIT 20 ) AS X WHERE X . int_key < 57 ORDER BY pk LIMIT 20 ) AS X WHERE X . int_nokey < 66 ORDER BY pk GROUP BY pk LIMIT 1 ) , ( SELECT AVG( int_nokey ) FROM ( SELECT pk FROM ( SELECT COUNT( int_nokey ) FROM ( SELECT int_nokey FROM ( SELECT COUNT( pk ) FROM C AS X WHERE X . int_key < 74 LIMIT 20 ) AS X WHERE X . int_key < 91 ORDER BY int_nokey LIMIT 20 ) AS X WHERE X . int_nokey < 32 LIMIT 20 ) AS X WHERE X . pk < 48 GROUP BY int_key LIMIT 20 ) AS X WHERE X . pk < 22 ORDER BY int_nokey LIMIT 1 ) ); ROLLBACK; UPDATE E AS X SET int_key = 12 , filler = REPEAT ( ' X ' , ( SELECT COUNT( pk ) FROM ( SELECT int_key FROM E AS X WHERE X . pk < 95 ORDER BY int_nokey GROUP BY int_nokey LIMIT 20 ) AS X WHERE X . int_key < 63 ORDER BY pk GROUP BY pk LIMIT 1 ) ) WHERE X . int_key < 73 ORDER BY RAND ( ) LIMIT 20; INSERT INTO D ( int_key , int_nokey ) VALUES ( ( SELECT AVG( int_key ) FROM C AS X WHERE X . int_nokey < 8 GROUP BY pk LIMIT 1 ) , ( SELECT int_nokey FROM ( SELECT AVG( int_key ) FROM D AS X WHERE X . int_nokey < 77 ORDER BY int_nokey LIMIT 20 ) AS X WHERE X . int_key < 1 ORDER BY pk LIMIT 1 ) ); UPDATE E AS X SET pk = 61 , filler = REPEAT ( ' X ' , 62 ) WHERE X . pk < 12 ORDER BY RAND ( ) LIMIT 20; START TRANSACTION; COMMIT; UPDATE A AS X SET int_key = 96 , filler = REPEAT ( ' X ' , 56 ) WHERE X . pk < 28 ORDER BY RAND ( ) LIMIT 20; SELECT int_nokey FROM B AS X WHERE X . int_nokey < 20 ORDER BY int_nokey LIMIT 10; UPDATE E AS X SET int_key = 73 , filler = REPEAT ( ' X ' , 1 ) WHERE X . int_nokey < 35 ORDER BY RAND ( ) LIMIT 20; INSERT INTO A ( int_key , int_nokey ) VALUES ( ( SELECT ( SELECT 92 FROM ( SELECT int_nokey FROM ( SELECT 65 FROM A AS X WHERE X . int_key < 64 ORDER BY int_key LIMIT 20 ) AS X WHERE X . pk < 52 ORDER BY pk GROUP BY pk LIMIT 20 ) AS X WHERE X . int_nokey < 6 GROUP BY int_nokey LIMIT 1 ) FROM ( SELECT COUNT( int_key ) FROM ( SELECT AVG( int_key ) FROM ( SELECT COUNT( int_nokey ) FROM ( SELECT COUNT( int_nokey ) FROM D AS X WHERE X . pk < 51 ORDER BY int_key LIMIT 20 ) AS X WHERE X . int_key < 97 LIMIT 20 ) AS X WHERE X . int_nokey < 68 LIMIT 20 ) AS X WHERE X . pk < 88 GROUP BY pk LIMIT 20 ) AS X WHERE X . int_nokey < 64 LIMIT 1 ) , ( SELECT AVG( int_key ) FROM ( SELECT pk FROM ( SELECT pk FROM ( SELECT ( SELECT COUNT( pk ) FROM C AS X WHERE X . pk < 50 ORDER BY int_key LIMIT 1 ) FROM ( SELECT COUNT( int_nokey ) FROM ( SELECT ( SELECT int_key FROM ( SELECT AVG( pk ) FROM ( SELECT AVG( pk ) FROM ( SELECT 13 FROM ( SELECT AVG( pk ) FROM A AS X WHERE X . pk < 13 ORDER BY pk GROUP BY pk LIMIT 20 ) AS X WHERE X . int_nokey < 93 LIMIT 20 ) AS X WHERE X . pk < 88 ORDER BY int_nokey GROUP BY int_key LIMIT 20 ) AS X WHERE X . int_nokey < 66 LIMIT 20 ) AS X WHERE X . pk < 24 ORDER BY int_nokey GROUP BY int_nokey LIMIT 1 ) FROM ( SELECT int_nokey FROM A AS X WHERE X . int_nokey < 86 LIMIT 20 ) AS X WHERE X . int_key < 31 ORDER BY pk GROUP BY pk LIMIT 20 ) AS X WHERE X . pk < 84 LIMIT 20 ) AS X WHERE X . int_key < 87 LIMIT 20 ) AS X WHERE X . pk < 52 ORDER BY int_nokey LIMIT 20 ) AS X WHERE X . pk < 31 LIMIT 20 ) AS X WHERE X . pk < 69 GROUP BY int_key LIMIT 1 ) ); SELECT int_nokey FROM ( SELECT ( SELECT pk FROM ( SELECT int_key FROM ( SELECT COUNT( int_key ) FROM ( SELECT int_key FROM E AS X WHERE X . int_nokey < 68 LIMIT 20 ) AS X WHERE X . int_key < 3 ORDER BY pk GROUP BY pk LIMIT 20 ) AS X WHERE X . int_key < 64 GROUP BY pk LIMIT 20 ) AS X WHERE X . pk < 41 GROUP BY int_key LIMIT 1 ) FROM ( SELECT COUNT( int_key ) FROM ( SELECT ( SELECT AVG( int_nokey ) FROM ( SELECT COUNT( pk ) FROM ( SELECT ( SELECT pk FROM ( SELECT COUNT( int_nokey ) FROM ( SELECT int_key FROM ( SELECT COUNT( int_key ) FROM B AS X WHERE X . int_nokey < 73 GROUP BY pk LIMIT 20 ) AS X WHERE X . int_nokey < 9 ORDER BY pk GROUP BY int_nokey LIMIT 20 ) AS X WHERE X . int_nokey < 49 GROUP BY int_key LIMIT 20 ) AS X WHERE X . int_key < 26 LIMIT 1 ) FROM A AS X WHERE X . int_key < 5 ORDER BY pk GROUP BY pk LIMIT 20 ) AS X WHERE X . pk < 44 LIMIT 20 ) AS X WHERE X . int_key < 15 ORDER BY int_nokey LIMIT 1 ) FROM ( SELECT int_key FROM ( SELECT pk FROM ( SELECT pk FROM A AS X WHERE X . int_nokey < 59 ORDER BY int_nokey GROUP BY int_key LIMIT 20 ) AS X WHERE X . pk < 77 LIMIT 20 ) AS X WHERE X . int_nokey < 86 GROUP BY int_key LIMIT 20 ) AS X WHERE X . int_key < 64 ORDER BY int_key LIMIT 20 ) AS X WHERE X . int_key < 88 LIMIT 20 ) AS X WHERE X . int_nokey < 11 ORDER BY int_nokey GROUP BY int_nokey LIMIT 20 ) AS X WHERE X . int_nokey < 27 GROUP BY int_nokey LIMIT 10; UPDATE A AS X SET int_key = 26 , filler = REPEAT ( ' X ' , ( SELECT int_key FROM D AS X WHERE X . int_key < 82 LIMIT 1 ) ) WHERE X . int_key < 58 ORDER BY RAND ( ) LIMIT 20; SELECT 43 FROM E AS X WHERE X . int_nokey < 99 GROUP BY pk LIMIT 10; UPDATE E AS X SET int_nokey = 95 , filler = REPEAT ( ' X ' , 47 ) WHERE X . pk < 63 ORDER BY RAND ( ) LIMIT 20; UPDATE C AS X SET int_key = 36 , filler = REPEAT ( ' X ' , ( SELECT ( SELECT 66 FROM ( SELECT int_nokey FROM ( SELECT COUNT( pk ) FROM ( SELECT AVG( int_key ) FROM B AS X WHERE X . int_nokey < 99 ORDER BY int_key GROUP BY int_nokey LIMIT 20 ) AS X WHERE X . int_key < 19 GROUP BY pk LIMIT 20 ) AS X WHERE X . int_key < 24 GROUP BY int_nokey LIMIT 20 ) AS X WHERE X . int_key < 0 GROUP BY int_nokey LIMIT 1 ) FROM ( SELECT 96 FROM D AS X WHERE X . int_nokey < 0 ORDER BY int_key GROUP BY int_nokey LIMIT 20 ) AS X WHERE X . int_key < 69 GROUP BY int_key LIMIT 1 ) ) WHERE X . pk < 3 ORDER BY RAND ( ) LIMIT 20; UPDATE A AS X SET int_key = 90 , filler = REPEAT ( ' X ' , ( SELECT ( SELECT AVG( int_nokey ) FROM E AS X WHERE X . pk < 62 ORDER BY int_key GROUP BY pk LIMIT 1 ) FROM ( SELECT int_key FROM ( SELECT AVG( int_nokey ) FROM D AS X WHERE X . int_nokey < 95 LIMIT 20 ) AS X WHERE X . pk < 48 LIMIT 20 ) AS X WHERE X . pk < 27 GROUP BY int_key LIMIT 1 ) ) WHERE X . int_key < 87 ORDER BY RAND ( ) LIMIT 20; UPDATE C AS X SET pk = ( SELECT COUNT( pk ) FROM E AS X WHERE X . int_nokey < 48 GROUP BY int_nokey LIMIT 1 ) , filler = REPEAT ( ' X ' , 9 ) WHERE X . int_nokey < 70 ORDER BY RAND ( ) LIMIT 20; SELECT int_key FROM A AS X WHERE X . int_key < 46 ORDER BY int_nokey GROUP BY pk LIMIT 10; ROLLBACK; ROLLBACK; UPDATE A AS X SET pk = ( SELECT AVG( int_key ) FROM ( SELECT AVG( int_nokey ) FROM ( SELECT COUNT( int_nokey ) FROM D AS X WHERE X . pk < 6 ORDER BY int_nokey LIMIT 20 ) AS X WHERE X . int_key < 10 ORDER BY pk LIMIT 20 ) AS X WHERE X . pk < 91 ORDER BY pk LIMIT 1 ) , filler = REPEAT ( ' X ' , 82 ) WHERE X . pk < 38 ORDER BY RAND ( ) LIMIT 20; START TRANSACTION; ROLLBACK; UPDATE D AS X SET int_key = ( SELECT 67 FROM ( SELECT int_nokey FROM D AS X WHERE X . int_nokey < 87 GROUP BY int_nokey LIMIT 20 ) AS X WHERE X . int_nokey < 69 GROUP BY int_key LIMIT 1 ) , filler = REPEAT ( ' X ' , ( SELECT COUNT( int_nokey ) FROM B AS X WHERE X . int_nokey < 25 GROUP BY int_nokey LIMIT 1 ) ) WHERE X . int_nokey < 28 ORDER BY RAND ( ) LIMIT 20; UPDATE B AS X SET int_key = 12 , filler = REPEAT ( ' X ' , 79 ) WHERE X . pk < 45 ORDER BY RAND ( ) LIMIT 20; INSERT INTO C ( int_key , int_nokey ) VALUES ( 2 , ( SELECT 42 FROM ( SELECT AVG( pk ) FROM ( SELECT ( SELECT COUNT( int_key ) FROM C AS X WHERE X . pk < 43 ORDER BY int_key LIMIT 1 ) FROM D AS X WHERE X . pk < 38 GROUP BY pk LIMIT 20 ) AS X WHERE X . int_nokey < 34 ORDER BY int_key LIMIT 20 ) AS X WHERE X . int_nokey < 17 ORDER BY pk LIMIT 1 ) ); SELECT COUNT( int_nokey ) FROM ( SELECT pk FROM E AS X WHERE X . int_key < 19 LIMIT 20 ) AS X WHERE X . int_key < 74 ORDER BY pk GROUP BY int_nokey LIMIT 10; INSERT INTO B ( int_key , int_nokey ) VALUES ( ( SELECT ( SELECT COUNT( int_nokey ) FROM ( SELECT COUNT( int_nokey ) FROM A AS X WHERE X . pk < 20 LIMIT 20 ) AS X WHERE X . int_nokey < 61 GROUP BY pk LIMIT 1 ) FROM D AS X WHERE X . int_key < 13 GROUP BY int_nokey LIMIT 1 ) , 50 );;