--echo # --echo # Bug#38445 - --echo # --disable_warnings DROP TABLE IF EXISTS `t1`; DROP TABLE IF EXISTS `t2`; --enable_warnings SET engine_condition_pushdown = 0; CREATE TABLE `t1` ( `id` varchar(4) NOT NULL, `flag1` decimal(1,0) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=ndbcluster DEFAULT CHARSET=cp932; CREATE TABLE `t2` ( `id2` varchar(20) NOT NULL DEFAULT '', `id3` varchar(8) DEFAULT NULL, `amount` decimal(10,0) DEFAULT NULL, `id` varchar(4) DEFAULT NULL, `flag2` decimal(1,0) DEFAULT NULL, PRIMARY KEY (`id2`), KEY `t2_idx1` (`id3`,`amount`,`flag2`) ) ENGINE=ndbcluster DEFAULT CHARSET=cp932; INSERT INTO `t1` VALUES ('A001','1'); INSERT INTO `t1` VALUES ('A002','1'); INSERT INTO `t1` VALUES ('A003','1'); INSERT INTO `t1` VALUES ('A004','1'); INSERT INTO `t1` VALUES ('A005','1'); INSERT INTO `t1` VALUES ('A006','1'); INSERT INTO `t1` VALUES ('A007','1'); INSERT INTO `t1` VALUES ('A008','1'); INSERT INTO `t1` VALUES ('A009','1'); INSERT INTO `t1` VALUES ('A010','1'); INSERT INTO `t1` VALUES ('A011','1'); INSERT INTO `t1` VALUES ('A012','1'); INSERT INTO `t1` VALUES ('A013','1'); INSERT INTO `t1` VALUES ('A014','1'); INSERT INTO `t1` VALUES ('A015','1'); INSERT INTO `t1` VALUES ('A016','1'); INSERT INTO `t1` VALUES ('A017','1'); INSERT INTO `t1` VALUES ('A018','1'); INSERT INTO `t1` VALUES ('A019','1'); INSERT INTO `t1` VALUES ('A020','1'); INSERT INTO `t1` VALUES ('A021','1'); INSERT INTO `t1` VALUES ('A022','1'); INSERT INTO `t1` VALUES ('A023','1'); INSERT INTO `t1` VALUES ('A024','1'); INSERT INTO `t1` VALUES ('A025','1'); INSERT INTO `t1` VALUES ('A026','1'); INSERT INTO `t1` VALUES ('A027','1'); INSERT INTO `t1` VALUES ('A028','1'); INSERT INTO `t1` VALUES ('A029','1'); INSERT INTO `t1` VALUES ('A030','1'); INSERT INTO `t1` VALUES ('A031','1'); INSERT INTO `t1` VALUES ('A032','1'); INSERT INTO `t1` VALUES ('B001','1'); INSERT INTO `t1` VALUES ('B002','1'); INSERT INTO `t1` VALUES ('B003','1'); INSERT INTO `t1` VALUES ('B004','1'); INSERT INTO `t1` VALUES ('B005','1'); INSERT INTO `t1` VALUES ('B006','1'); INSERT INTO `t1` VALUES ('B007','1'); INSERT INTO `t1` VALUES ('B008','1'); INSERT INTO `t1` VALUES ('B009','1'); INSERT INTO `t1` VALUES ('B010','1'); INSERT INTO `t1` VALUES ('B011','1'); INSERT INTO `t1` VALUES ('B012','1'); INSERT INTO `t1` VALUES ('B013','1'); INSERT INTO `t1` VALUES ('B014','1'); INSERT INTO `t1` VALUES ('B015','1'); INSERT INTO `t1` VALUES ('B016','1'); INSERT INTO `t1` VALUES ('B017','1'); INSERT INTO `t1` VALUES ('B018','1'); INSERT INTO `t1` VALUES ('B019','1'); INSERT INTO `t1` VALUES ('B020','1'); INSERT INTO `t1` VALUES ('B021','1'); INSERT INTO `t1` VALUES ('B022','1'); INSERT INTO `t1` VALUES ('B023','1'); INSERT INTO `t1` VALUES ('B024','1'); INSERT INTO `t1` VALUES ('B025','1'); INSERT INTO `t1` VALUES ('B026','1'); INSERT INTO `t1` VALUES ('B027','1'); INSERT INTO `t1` VALUES ('B028','1'); INSERT INTO `t1` VALUES ('B029','1'); INSERT INTO `t1` VALUES ('B030','1'); INSERT INTO `t1` VALUES ('B031','1'); INSERT INTO `t1` VALUES ('B032','1'); INSERT INTO `t1` VALUES ('C001','1'); INSERT INTO `t1` VALUES ('C002','1'); INSERT INTO `t1` VALUES ('C003','1'); INSERT INTO `t1` VALUES ('C004','1'); INSERT INTO `t1` VALUES ('C005','1'); INSERT INTO `t1` VALUES ('C006','1'); INSERT INTO `t1` VALUES ('C007','1'); INSERT INTO `t1` VALUES ('C008','1'); INSERT INTO `t1` VALUES ('C009','1'); INSERT INTO `t1` VALUES ('C010','1'); INSERT INTO `t1` VALUES ('C011','1'); INSERT INTO `t1` VALUES ('C012','1'); INSERT INTO `t1` VALUES ('C013','1'); INSERT INTO `t1` VALUES ('C014','1'); INSERT INTO `t1` VALUES ('C015','1'); INSERT INTO `t1` VALUES ('C016','1'); INSERT INTO `t1` VALUES ('C017','1'); INSERT INTO `t1` VALUES ('C018','1'); INSERT INTO `t1` VALUES ('C019','1'); INSERT INTO `t1` VALUES ('C020','1'); INSERT INTO `t1` VALUES ('C021','1'); INSERT INTO `t1` VALUES ('C022','1'); INSERT INTO `t1` VALUES ('C023','1'); INSERT INTO `t1` VALUES ('C024','1'); INSERT INTO `t1` VALUES ('C025','1'); INSERT INTO `t1` VALUES ('C026','1'); INSERT INTO `t1` VALUES ('C027','1'); INSERT INTO `t1` VALUES ('C028','1'); INSERT INTO `t1` VALUES ('C029','1'); INSERT INTO `t1` VALUES ('C030','1'); INSERT INTO `t1` VALUES ('C031','1'); INSERT INTO `t1` VALUES ('C032','1'); INSERT INTO `t1` VALUES ('E001','1'); INSERT INTO `t1` VALUES ('E002','1'); INSERT INTO `t1` VALUES ('E003','1'); INSERT INTO `t1` VALUES ('E004','1'); INSERT INTO `t1` VALUES ('E005','1'); INSERT INTO `t1` VALUES ('E006','1'); INSERT INTO `t1` VALUES ('E007','1'); INSERT INTO `t1` VALUES ('E009','1'); INSERT INTO `t1` VALUES ('E010','1'); INSERT INTO `t1` VALUES ('E011','1'); INSERT INTO `t1` VALUES ('E012','1'); INSERT INTO `t1` VALUES ('E013','1'); INSERT INTO `t1` VALUES ('E014','1'); INSERT INTO `t1` VALUES ('E015','1'); INSERT INTO `t1` VALUES ('E016','1'); INSERT INTO `t1` VALUES ('E017','1'); INSERT INTO `t1` VALUES ('E018','1'); INSERT INTO `t1` VALUES ('E019','1'); INSERT INTO `t1` VALUES ('E020','1'); INSERT INTO `t1` VALUES ('E021','1'); INSERT INTO `t1` VALUES ('E022','1'); INSERT INTO `t1` VALUES ('E023','1'); INSERT INTO `t1` VALUES ('E024','1'); INSERT INTO `t1` VALUES ('E025','1'); INSERT INTO `t1` VALUES ('E026','1'); INSERT INTO `t1` VALUES ('E027','1'); INSERT INTO `t1` VALUES ('E028','1'); INSERT INTO `t1` VALUES ('E029','1'); INSERT INTO `t1` VALUES ('K001','1'); INSERT INTO `t1` VALUES ('K002','1'); INSERT INTO `t1` VALUES ('K003','1'); INSERT INTO `t1` VALUES ('K004','1'); INSERT INTO `t1` VALUES ('K005','1'); INSERT INTO `t1` VALUES ('K006','1'); INSERT INTO `t1` VALUES ('K007','1'); INSERT INTO `t1` VALUES ('K009','1'); INSERT INTO `t1` VALUES ('K010','1'); INSERT INTO `t1` VALUES ('K011','1'); INSERT INTO `t1` VALUES ('K012','1'); INSERT INTO `t1` VALUES ('K013','1'); INSERT INTO `t1` VALUES ('K014','1'); INSERT INTO `t1` VALUES ('K015','1'); INSERT INTO `t1` VALUES ('K016','1'); INSERT INTO `t1` VALUES ('K017','1'); INSERT INTO `t1` VALUES ('K018','1'); INSERT INTO `t1` VALUES ('K019','1'); INSERT INTO `t1` VALUES ('K020','1'); INSERT INTO `t1` VALUES ('K021','1'); INSERT INTO `t1` VALUES ('K022','1'); INSERT INTO `t1` VALUES ('K023','1'); INSERT INTO `t1` VALUES ('K024','1'); INSERT INTO `t1` VALUES ('K025','1'); INSERT INTO `t1` VALUES ('K026','1'); INSERT INTO `t1` VALUES ('K027','1'); INSERT INTO `t1` VALUES ('K028','1'); INSERT INTO `t1` VALUES ('K029','1'); INSERT INTO `t1` VALUES ('M002','1'); INSERT INTO `t1` VALUES ('M003','1'); INSERT INTO `t1` VALUES ('M005','1'); INSERT INTO `t1` VALUES ('M006','1'); INSERT INTO `t1` VALUES ('M007','1'); INSERT INTO `t1` VALUES ('M101','1'); INSERT INTO `t1` VALUES ('M102','1'); INSERT INTO `t1` VALUES ('M103','1'); INSERT INTO `t1` VALUES ('M104','1'); INSERT INTO `t1` VALUES ('M105','1'); INSERT INTO `t1` VALUES ('M106','1'); INSERT INTO `t1` VALUES ('M107','1'); INSERT INTO `t1` VALUES ('M108','1'); INSERT INTO `t1` VALUES ('M109','1'); INSERT INTO `t1` VALUES ('M110','1'); INSERT INTO `t1` VALUES ('M111','1'); INSERT INTO `t1` VALUES ('M112','1'); INSERT INTO `t1` VALUES ('M113','1'); INSERT INTO `t1` VALUES ('M114','1'); INSERT INTO `t1` VALUES ('M115','1'); INSERT INTO `t1` VALUES ('M116','1'); INSERT INTO `t1` VALUES ('M117','1'); INSERT INTO `t1` VALUES ('M118','1'); INSERT INTO `t1` VALUES ('M119','1'); INSERT INTO `t1` VALUES ('M120','1'); INSERT INTO `t1` VALUES ('M121','1'); INSERT INTO `t1` VALUES ('M122','1'); INSERT INTO `t1` VALUES ('M123','1'); INSERT INTO `t1` VALUES ('M124','1'); INSERT INTO `t1` VALUES ('M125','1'); INSERT INTO `t1` VALUES ('M126','1'); INSERT INTO `t1` VALUES ('M127','1'); INSERT INTO `t1` VALUES ('M128','1'); INSERT INTO `t1` VALUES ('M129','1'); INSERT INTO `t1` VALUES ('M130','1'); INSERT INTO `t1` VALUES ('M131','1'); INSERT INTO `t1` VALUES ('M132','1'); INSERT INTO `t1` VALUES ('M201','1'); INSERT INTO `t1` VALUES ('M202','1'); INSERT INTO `t1` VALUES ('M203','1'); INSERT INTO `t1` VALUES ('M204','1'); INSERT INTO `t1` VALUES ('M205','1'); INSERT INTO `t1` VALUES ('M206','1'); INSERT INTO `t1` VALUES ('M207','1'); INSERT INTO `t1` VALUES ('M208','1'); INSERT INTO `t1` VALUES ('M209','1'); INSERT INTO `t1` VALUES ('M210','1'); INSERT INTO `t1` VALUES ('M211','1'); INSERT INTO `t1` VALUES ('M212','1'); INSERT INTO `t1` VALUES ('M213','1'); INSERT INTO `t1` VALUES ('M214','1'); INSERT INTO `t1` VALUES ('M215','1'); INSERT INTO `t1` VALUES ('M216','1'); INSERT INTO `t1` VALUES ('M217','1'); INSERT INTO `t1` VALUES ('M218','1'); INSERT INTO `t1` VALUES ('M219','1'); INSERT INTO `t1` VALUES ('M220','1'); INSERT INTO `t1` VALUES ('M221','1'); INSERT INTO `t1` VALUES ('M222','1'); INSERT INTO `t1` VALUES ('M223','1'); INSERT INTO `t1` VALUES ('M224','1'); INSERT INTO `t1` VALUES ('M225','1'); INSERT INTO `t1` VALUES ('M226','1'); INSERT INTO `t1` VALUES ('M227','1'); INSERT INTO `t1` VALUES ('M228','1'); INSERT INTO `t1` VALUES ('M229','1'); INSERT INTO `t1` VALUES ('M230','1'); INSERT INTO `t1` VALUES ('M231','1'); INSERT INTO `t1` VALUES ('M232','1'); INSERT INTO `t1` VALUES ('M301','1'); INSERT INTO `t1` VALUES ('M302','1'); INSERT INTO `t1` VALUES ('M303','1'); INSERT INTO `t1` VALUES ('M304','1'); INSERT INTO `t1` VALUES ('M305','1'); INSERT INTO `t1` VALUES ('M306','1'); INSERT INTO `t1` VALUES ('M307','1'); INSERT INTO `t1` VALUES ('M308','1'); INSERT INTO `t1` VALUES ('M309','1'); INSERT INTO `t1` VALUES ('M310','1'); INSERT INTO `t1` VALUES ('M311','1'); INSERT INTO `t1` VALUES ('M312','1'); INSERT INTO `t1` VALUES ('M313','1'); INSERT INTO `t1` VALUES ('M314','1'); INSERT INTO `t1` VALUES ('M315','1'); INSERT INTO `t1` VALUES ('M316','1'); INSERT INTO `t1` VALUES ('M317','1'); INSERT INTO `t1` VALUES ('M318','1'); INSERT INTO `t1` VALUES ('M319','1'); INSERT INTO `t1` VALUES ('M320','1'); INSERT INTO `t1` VALUES ('M321','1'); INSERT INTO `t1` VALUES ('M322','1'); INSERT INTO `t1` VALUES ('M323','1'); INSERT INTO `t1` VALUES ('M324','1'); INSERT INTO `t1` VALUES ('M325','1'); INSERT INTO `t1` VALUES ('M326','1'); INSERT INTO `t1` VALUES ('M327','1'); INSERT INTO `t1` VALUES ('M328','1'); INSERT INTO `t1` VALUES ('M329','1'); INSERT INTO `t1` VALUES ('M330','1'); INSERT INTO `t1` VALUES ('M331','1'); INSERT INTO `t1` VALUES ('M332','1'); INSERT INTO `t1` VALUES ('M401','1'); INSERT INTO `t1` VALUES ('M402','1'); INSERT INTO `t1` VALUES ('M403','1'); INSERT INTO `t1` VALUES ('M404','1'); INSERT INTO `t1` VALUES ('M405','1'); INSERT INTO `t1` VALUES ('M406','1'); INSERT INTO `t1` VALUES ('M407','1'); INSERT INTO `t1` VALUES ('M408','1'); INSERT INTO `t1` VALUES ('M409','1'); INSERT INTO `t1` VALUES ('M410','1'); INSERT INTO `t1` VALUES ('M411','1'); INSERT INTO `t1` VALUES ('M412','1'); INSERT INTO `t1` VALUES ('M413','1'); INSERT INTO `t1` VALUES ('M414','1'); INSERT INTO `t1` VALUES ('M415','1'); INSERT INTO `t1` VALUES ('M416','1'); INSERT INTO `t1` VALUES ('M417','1'); INSERT INTO `t1` VALUES ('M418','1'); INSERT INTO `t1` VALUES ('M419','1'); INSERT INTO `t1` VALUES ('M420','1'); INSERT INTO `t1` VALUES ('M421','1'); INSERT INTO `t1` VALUES ('M422','1'); INSERT INTO `t1` VALUES ('M423','1'); INSERT INTO `t1` VALUES ('M424','1'); INSERT INTO `t1` VALUES ('M425','1'); INSERT INTO `t1` VALUES ('M426','1'); INSERT INTO `t1` VALUES ('M427','1'); INSERT INTO `t1` VALUES ('M428','1'); INSERT INTO `t1` VALUES ('M429','1'); INSERT INTO `t1` VALUES ('M430','1'); INSERT INTO `t1` VALUES ('M431','1'); INSERT INTO `t1` VALUES ('M432','1'); INSERT INTO `t1` VALUES ('S066','1'); INSERT INTO `t1` VALUES ('S067','1'); INSERT INTO `t1` VALUES ('S068','1'); INSERT INTO `t1` VALUES ('S069','1'); INSERT INTO `t1` VALUES ('S070','1'); INSERT INTO `t1` VALUES ('S071','1'); INSERT INTO `t1` VALUES ('S072','1'); INSERT INTO `t1` VALUES ('S073','1'); INSERT INTO `t1` VALUES ('S074','1'); INSERT INTO `t1` VALUES ('S075','1'); INSERT INTO `t1` VALUES ('S076','1'); INSERT INTO `t1` VALUES ('S077','1'); INSERT INTO `t1` VALUES ('S078','1'); INSERT INTO `t1` VALUES ('S079','1'); INSERT INTO `t1` VALUES ('S080','1'); INSERT INTO `t1` VALUES ('S081','1'); INSERT INTO `t1` VALUES ('S082','1'); INSERT INTO `t1` VALUES ('S083','1'); INSERT INTO `t1` VALUES ('S084','1'); INSERT INTO `t1` VALUES ('S085','1'); INSERT INTO `t1` VALUES ('S086','1'); INSERT INTO `t1` VALUES ('S087','1'); INSERT INTO `t1` VALUES ('S088','1'); INSERT INTO `t1` VALUES ('S089','1'); INSERT INTO `t1` VALUES ('S090','1'); INSERT INTO `t1` VALUES ('S091','1'); INSERT INTO `t1` VALUES ('S092','1'); INSERT INTO `t1` VALUES ('S093','1'); INSERT INTO `t1` VALUES ('S094','1'); INSERT INTO `t1` VALUES ('S095','1'); INSERT INTO `t1` VALUES ('S096','1'); INSERT INTO `t1` VALUES ('S097','1'); INSERT INTO `t2` VALUES ('20080715CONT00008901','00000025','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00008902','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00008903','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00008904','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00008905','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00008906','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00008907','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00008908','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00008909','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00008910','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00008911','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00008912','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00008913','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00008914','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00008915','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00008916','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00008917','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00008918','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00008919','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00008920','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00008921','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00008922','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00008923','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00008924','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00008925','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00008926','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00008927','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00008928','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00008929','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00008930','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00008931','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00008932','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00008933','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00008934','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00008935','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00008936','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00008937','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00008938','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00008939','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00008940','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00008941','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00008942','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00008943','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00008944','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00008945','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00008946','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00008947','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00008948','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00008949','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00008950','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00008951','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00008952','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00008953','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00008954','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00008955','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00008956','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00008957','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00008958','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00008959','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00008960','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00008961','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00008962','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00008963','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00008964','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00008965','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00008966','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00008967','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00008968','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00008969','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00008970','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00008971','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00008972','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00008973','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00008974','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00008975','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00008976','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00008977','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00008978','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00008979','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00008980','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00008981','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00008982','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00008983','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00008984','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00008985','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00008986','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00008987','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00008988','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00008989','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00008990','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00008991','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00008992','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00008993','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00008994','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00008995','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00008996','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00008997','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00008998','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00008999','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009000','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009001','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009002','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009003','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009004','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009005','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009006','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009007','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009008','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009009','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009010','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009011','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009012','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009013','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009014','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009015','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009016','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009017','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009018','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009019','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009020','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009021','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009022','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009023','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009024','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009025','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009026','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009027','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009028','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009029','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009030','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009031','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009032','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009033','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009034','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009035','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009036','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009037','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009038','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009039','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009040','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009041','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009042','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009043','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009044','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009045','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009046','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009047','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009048','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009049','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009050','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009051','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009052','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009053','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009054','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009055','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009056','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009057','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009058','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009059','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009060','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009061','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009062','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009063','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009064','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009065','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009066','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009067','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009068','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009069','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009070','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009071','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009072','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009073','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009074','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009075','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009076','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009077','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009078','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009079','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009080','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009081','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009082','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009083','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009084','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009085','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009086','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009087','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009088','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009089','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009090','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009091','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009092','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009093','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009094','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009095','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009096','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009097','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009098','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009099','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009100','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009101','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009102','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009103','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009104','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009105','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009106','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009107','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009108','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009109','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009110','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009111','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009112','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009113','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009114','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009115','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009116','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009117','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009118','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009119','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009120','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009121','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009122','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009123','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009124','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009125','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009126','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009127','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009128','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009129','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009130','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009131','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009132','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009133','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009134','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009135','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009136','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009137','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009138','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009139','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009140','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009141','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009142','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009143','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009144','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009145','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009146','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009147','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009148','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009149','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009150','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009151','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009152','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009153','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009154','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009155','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009156','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009157','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009158','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009159','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009160','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009161','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009162','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009163','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009164','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009165','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009166','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009167','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009168','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009169','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009170','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009171','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009172','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009173','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009174','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009175','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009176','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009177','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009178','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009179','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009180','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009181','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009182','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009183','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009184','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009185','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009186','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009187','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009188','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009189','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009190','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009191','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009192','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009193','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009194','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009195','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009196','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009197','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009198','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009199','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009200','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009201','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009202','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009203','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009204','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009205','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009206','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009207','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009208','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009209','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009210','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009211','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009212','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009213','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009214','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009215','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009216','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009217','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009218','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009219','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009220','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009221','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009222','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009223','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009224','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009225','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009226','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009227','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009228','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009229','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009230','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009231','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009232','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009233','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009234','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009235','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009236','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009237','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009238','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009239','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009240','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009241','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009242','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009243','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009244','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009245','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009246','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009247','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009248','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009249','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009250','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009251','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009252','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009253','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009254','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009255','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009256','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009257','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009258','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009259','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009260','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009261','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009262','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009263','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009264','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009265','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009266','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009267','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009268','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009269','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009270','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009271','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009272','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009273','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009274','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009275','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009276','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009277','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009278','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009279','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009280','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009281','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009282','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009283','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009284','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009285','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009286','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009287','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009288','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009289','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009290','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009291','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009292','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009293','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009294','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009295','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009296','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009297','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009298','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009299','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009300','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009301','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009302','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009303','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009304','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009305','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009306','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009307','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009308','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009309','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009310','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009311','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009312','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009313','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009314','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009315','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009316','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009317','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009318','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009319','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009320','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009321','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009322','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009323','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009324','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009325','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009326','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009327','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009328','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009329','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009330','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009331','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009332','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009333','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009334','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009335','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009336','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009337','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009338','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009339','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009340','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009341','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009342','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009343','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009344','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009345','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009346','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009347','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009348','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009349','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009350','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009351','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009352','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009353','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009354','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009355','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009356','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009357','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009358','00001257','30000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009359','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009360','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009361','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009362','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009363','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009364','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009365','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009366','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009367','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009368','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009369','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009370','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009371','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009372','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009373','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009374','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009375','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009376','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009377','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009378','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009379','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009380','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009381','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009382','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009383','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009384','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009385','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009386','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009387','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009388','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009389','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009390','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009391','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009392','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009393','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009394','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009395','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009396','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009397','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009398','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009399','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009400','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009401','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009402','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009403','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009404','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009405','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009406','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009407','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009408','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009409','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009410','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009411','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009412','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009413','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009414','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009415','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009416','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009417','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009418','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009419','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009420','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009421','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009422','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009423','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009424','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009425','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009426','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009427','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009428','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009429','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009430','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009431','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009432','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009433','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009434','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009435','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009436','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009437','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009438','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009439','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009440','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009441','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009442','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009443','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009444','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009445','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009446','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009447','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009448','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009449','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009450','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009451','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009452','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009453','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009454','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009455','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009456','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009457','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009458','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009459','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009460','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009461','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009462','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009463','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009464','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009465','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009466','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009467','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009468','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009469','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009470','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009471','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009472','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009473','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009474','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009475','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009476','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009477','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009478','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009479','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009480','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009481','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009482','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009483','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009484','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009485','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009486','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009487','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009488','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009489','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009490','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009491','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009492','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009493','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009494','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009495','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009496','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009497','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009498','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009499','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009500','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009501','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009502','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009503','00004405','10000','M101','1'); INSERT INTO `t2` VALUES ('20080715CONT00009504','00000025','10000','K001','1'); INSERT INTO `t2` VALUES ('20080716CONT00009601','00000004','0','C001','1'); INSERT INTO `t2` VALUES ('20080716CONT00009602','00000004','0','C001','1'); INSERT INTO `t2` VALUES ('20080716CONT00009603','00000004','0','M101','1'); INSERT INTO `t2` VALUES ('20080716CONT00009604','00000158','10000','M101','1'); INSERT INTO `t2` VALUES ('20080716CONT00009605','00000158','0','M101','1'); INSERT INTO `t2` VALUES ('20080716CONT00009606','00000158','10000','M101','1'); INSERT INTO `t2` VALUES ('20080716CONT00009607','00000158','0','M101','1'); INSERT INTO `t2` VALUES ('20080716CONT00009608','00000158','10000','M101','1'); INSERT INTO `t2` VALUES ('20080716CONT00009609','00000158','0','M101','1'); INSERT INTO `t2` VALUES ('20080716CONT00009610','00000158','0','M101','1'); INSERT INTO `t2` VALUES ('20080716CONT00009611','00000158','0','M101','1'); INSERT INTO `t2` VALUES ('20080716CONT00009612','00000158','10000','M101','1'); SELECT t2.id2 , t2.flag2 , t1.flag1 FROM t2 JOIN t1 ON t2.id = t1.id WHERE t2.id3 = '00000025' AND t2.amount > 0 AND t2.flag2 = 1 ; SELECT t2.id2 , t2.flag2 , t1.flag1 FROM t2 JOIN t1 ON t2.id = t1.id WHERE t2.id3 = '00000025' AND t2.amount > 0 AND t2.flag2 = 1 AND t1.flag1 = 1 ; EXPLAIN SELECT t2.id2 , t2.flag2 , t1.flag1 FROM t2 JOIN t1 ON t2.id = t1.id WHERE t2.id3 = '00000025' AND t2.amount > 0 AND t2.flag2 = 1 ; EXPLAIN SELECT t2.id2 , t2.flag2 , t1.flag1 FROM t2 JOIN t1 ON t2.id = t1.id WHERE t2.id3 = '00000025' AND t2.amount > 0 AND t2.flag2 = 1 AND t1.flag1 = 1 ; ALTER TABLE t1 ADD KEY `t1_idx1` (`id`,`flag1`); SELECT t2.id2 , t2.flag2 , t1.flag1 FROM t2 JOIN t1 ON t2.id = t1.id WHERE t2.id3 = '00000025' AND t2.amount > 0 AND t2.flag2 = 1 ; SELECT t2.id2 , t2.flag2 , t1.flag1 FROM t2 JOIN t1 ON t2.id = t1.id WHERE t2.id3 = '00000025' AND t2.amount > 0 AND t2.flag2 = 1 AND t1.flag1 = 1 ; EXPLAIN SELECT t2.id2 , t2.flag2 , t1.flag1 FROM t2 JOIN t1 ON t2.id = t1.id WHERE t2.id3 = '00000025' AND t2.amount > 0 AND t2.flag2 = 1 ; EXPLAIN SELECT t2.id2 , t2.flag2 , t1.flag1 FROM t2 JOIN t1 ON t2.id = t1.id WHERE t2.id3 = '00000025' AND t2.amount > 0 AND t2.flag2 = 1 AND t1.flag1 = 1 ;