DROP TABLE IF EXISTS `derived1`; CREATE TABLE `derived1` ( `COUNT( int_nokey )` bigint(21) NOT NULL DEFAULT '0' ) ENGINE=MyISAM DEFAULT CHARSET=latin1; INSERT INTO `derived1` VALUES (2); DROP TABLE IF EXISTS `D`; 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=107 DEFAULT CHARSET=latin1; INSERT INTO `D` VALUES (1,12,67,' X '), (2,15,15,NULL), (3,23,67,' X '), (4,23,67,' X '), (5,12,67,' X '), (6,60,60,NULL), (7,68,4,' X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X '), (8,22,96,' X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X '), (9,41,96,' X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X '), (10,20,67,' X '), (11,43,96,' X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X '), (12,79,79,NULL), (13,16,67,' X '), (14,73,4,' X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X '), (15,77,77,NULL), (16,7,96,' X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X '), (17,86,86,NULL), (18,4,67,' X '), (19,46,96,' X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X '), (20,47,47,NULL), (21,82,4,' X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X '), (22,52,96,' X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X '), (23,45,45,NULL), (24,87,87,NULL), (25,33,96,' X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X '), (26,91,4,' X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X '), (27,10,67,' X '), (28,85,85,NULL), (29,64,64,NULL), (30,86,86,NULL), (31,99,99,NULL), (32,54,96,' X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X '), (33,30,30,NULL), (34,94,94,NULL), (35,96,96,NULL), (36,34,4,' X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X '), (37,97,97,NULL), (38,92,92,NULL), (39,40,4,' X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X '), (40,23,67,' X '), (41,63,63,NULL), (42,70,70,NULL), (43,56,4,' X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X '), (44,90,4,' X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X '), (45,90,90,NULL), (46,69,69,NULL), (47,12,4,' X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X '), (48,85,85,NULL), (49,59,59,NULL), (50,22,67,' X '), (51,99,4,' X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X '), (52,39,39,NULL), (53,81,4,' X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X '), (54,80,80,NULL), (55,68,68,NULL), (56,49,49,NULL), (57,55,55,NULL), (58,73,73,NULL), (59,4,67,' X '), (60,75,4,' X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X '), (61,80,80,NULL), (62,21,67,' X '), (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,67,' X '), (71,28,4,' X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X '), (72,57,57,NULL), (73,33,96,' X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X '), (74,70,4,' X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X '), (75,6,67,' X '), (76,54,4,' X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X '), (77,49,49,NULL), (78,20,96,' X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X '), (79,5,67,' X '), (80,74,4,' X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X '), (81,72,4,' X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X '), (82,32,96,' X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X '), (83,45,4,' X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X '), (84,58,58,NULL), (85,19,67,' X '), (86,22,67,' X '), (87,0,67,' X '), (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,67,' X '), (95,4,67,' X '), (96,83,83,NULL), (97,81,81,NULL), (98,32,32,NULL), (99,63,63,NULL), (100,45,96,' X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X '), (102,NULL,33,NULL), (103,49,96,' X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X '), (104,92,12,NULL), (105,53,12,NULL), (106,41,96,' X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X '); select 'KAbooom!'; SELECT (SELECT COUNT( int_nokey ) FROM derived1 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;