← Back to branch summary

~drizzle-trunk/drizzle/development

1 by brian
clean slate 
1
 
#

2
 
# This file contains a generic set of test that is run from

3
 
# different test scripts to test for example ssl encrypted

4
 
# and compressed connection

5
 
#

6
 
#

7
 









8



#










9



# Simple select test










10



#










11












12



--disable_warnings










13



drop table if exists t1,t2,t3,t4;










14



--enable_warnings










15












16



CREATE TABLE t1 (










17



  Period smallint(4) unsigned zerofill DEFAULT '0000' NOT NULL,










18



  Varor_period smallint(4) unsigned DEFAULT '0' NOT NULL










19



);










20












21



INSERT INTO t1 VALUES (9410,9412);










22



  










23



select period from t1;










24



select * from t1;










25



select t1.* from t1;










26












27



#










28



# Create test table










29



#










30












31



CREATE TABLE t2 (










32



  auto int not null auto_increment,










33



  fld1 int(6) unsigned zerofill DEFAULT '000000' NOT NULL,










34



  companynr tinyint(2) unsigned zerofill DEFAULT '00' NOT NULL,










35



  fld3 char(30) DEFAULT '' NOT NULL,










36



  fld4 char(35) DEFAULT '' NOT NULL,










37



  fld5 char(35) DEFAULT '' NOT NULL,










38



  fld6 char(4) DEFAULT '' NOT NULL,










39



  UNIQUE fld1 (fld1),










40



  KEY fld3 (fld3),










41



  PRIMARY KEY (auto)










42



);  










43












44



#










45



# Populate table










46



#










47












48



--disable_query_log










49



INSERT INTO t2 VALUES (1,000001,00,'Omaha','teethe','neat','');










50



INSERT INTO t2 VALUES (2,011401,37,'breaking','dreaded','Steinberg','W');










51



INSERT INTO t2 VALUES (3,011402,37,'Romans','scholastics','jarring','');










52



INSERT INTO t2 VALUES (4,011403,37,'intercepted','audiology','tinily','');










53



INSERT INTO t2 VALUES (5,011501,37,'bewilderingly','wallet','balled','');










54



INSERT INTO t2 VALUES (6,011701,37,'astound','parters','persist','W');










55



INSERT INTO t2 VALUES (7,011702,37,'admonishing','eschew','attainments','');










56



INSERT INTO t2 VALUES (8,011703,37,'sumac','quitter','fanatic','');










57



INSERT INTO t2 VALUES (9,012001,37,'flanking','neat','measures','FAS');










58



INSERT INTO t2 VALUES (10,012003,37,'combed','Steinberg','rightfulness','');










59



INSERT INTO t2 VALUES (11,012004,37,'subjective','jarring','capably','');










60



INSERT INTO t2 VALUES (12,012005,37,'scatterbrain','tinily','impulsive','');










61



INSERT INTO t2 VALUES (13,012301,37,'Eulerian','balled','starlet','');










62



INSERT INTO t2 VALUES (14,012302,36,'dubbed','persist','terminators','');










63



INSERT INTO t2 VALUES (15,012303,37,'Kane','attainments','untying','');










64



INSERT INTO t2 VALUES (16,012304,37,'overlay','fanatic','announces','FAS');










65



INSERT INTO t2 VALUES (17,012305,37,'perturb','measures','featherweight','FAS');










66



INSERT INTO t2 VALUES (18,012306,37,'goblins','rightfulness','pessimist','FAS');










67



INSERT INTO t2 VALUES (19,012501,37,'annihilates','capably','daughter','');










68



INSERT INTO t2 VALUES (20,012602,37,'Wotan','impulsive','decliner','FAS');










69



INSERT INTO t2 VALUES (21,012603,37,'snatching','starlet','lawgiver','');










70



INSERT INTO t2 VALUES (22,012604,37,'concludes','terminators','stated','');










71



INSERT INTO t2 VALUES (23,012605,37,'laterally','untying','readable','');










72



INSERT INTO t2 VALUES (24,012606,37,'yelped','announces','attrition','');










73



INSERT INTO t2 VALUES (25,012701,37,'grazing','featherweight','cascade','FAS');










74



INSERT INTO t2 VALUES (26,012702,37,'Baird','pessimist','motors','FAS');










75



INSERT INTO t2 VALUES (27,012703,37,'celery','daughter','interrogate','');










76



INSERT INTO t2 VALUES (28,012704,37,'misunderstander','decliner','pests','W');










77



INSERT INTO t2 VALUES (29,013601,37,'handgun','lawgiver','stairway','');










78



INSERT INTO t2 VALUES (30,013602,37,'foldout','stated','dopers','FAS');










79



INSERT INTO t2 VALUES (31,013603,37,'mystic','readable','testicle','W');










80



INSERT INTO t2 VALUES (32,013604,37,'succumbed','attrition','Parsifal','W');










81



INSERT INTO t2 VALUES (33,013605,37,'Nabisco','cascade','leavings','');










82



INSERT INTO t2 VALUES (34,013606,37,'fingerings','motors','postulation','W');










83



INSERT INTO t2 VALUES (35,013607,37,'aging','interrogate','squeaking','');










84



INSERT INTO t2 VALUES (36,013608,37,'afield','pests','contrasted','');










85



INSERT INTO t2 VALUES (37,013609,37,'ammonium','stairway','leftover','');










86



INSERT INTO t2 VALUES (38,013610,37,'boat','dopers','whiteners','');










87



INSERT INTO t2 VALUES (39,013801,37,'intelligibility','testicle','erases','W');










88



INSERT INTO t2 VALUES (40,013802,37,'Augustine','Parsifal','Punjab','W');










89



INSERT INTO t2 VALUES (41,013803,37,'teethe','leavings','Merritt','');










90



INSERT INTO t2 VALUES (42,013804,37,'dreaded','postulation','Quixotism','');










91



INSERT INTO t2 VALUES (43,013901,37,'scholastics','squeaking','sweetish','FAS');










92



INSERT INTO t2 VALUES (44,016001,37,'audiology','contrasted','dogging','FAS');










93



INSERT INTO t2 VALUES (45,016201,37,'wallet','leftover','scornfully','FAS');










94



INSERT INTO t2 VALUES (46,016202,37,'parters','whiteners','bellow','');










95



INSERT INTO t2 VALUES (47,016301,37,'eschew','erases','bills','');










96



INSERT INTO t2 VALUES (48,016302,37,'quitter','Punjab','cupboard','FAS');










97



INSERT INTO t2 VALUES (49,016303,37,'neat','Merritt','sureties','FAS');










98



INSERT INTO t2 VALUES (50,016304,37,'Steinberg','Quixotism','puddings','');










99



INSERT INTO t2 VALUES (51,018001,37,'jarring','sweetish','tapestry','');










100



INSERT INTO t2 VALUES (52,018002,37,'tinily','dogging','fetters','');










101



INSERT INTO t2 VALUES (53,018003,37,'balled','scornfully','bivalves','');










102



INSERT INTO t2 VALUES (54,018004,37,'persist','bellow','incurring','');










103



INSERT INTO t2 VALUES (55,018005,37,'attainments','bills','Adolph','');










104



INSERT INTO t2 VALUES (56,018007,37,'fanatic','cupboard','pithed','');










105



INSERT INTO t2 VALUES (57,018008,37,'measures','sureties','emergency','');










106



INSERT INTO t2 VALUES (58,018009,37,'rightfulness','puddings','Miles','');










107



INSERT INTO t2 VALUES (59,018010,37,'capably','tapestry','trimmings','');










108



INSERT INTO t2 VALUES (60,018012,37,'impulsive','fetters','tragedies','W');










109



INSERT INTO t2 VALUES (61,018013,37,'starlet','bivalves','skulking','W');










110



INSERT INTO t2 VALUES (62,018014,37,'terminators','incurring','flint','');










111



INSERT INTO t2 VALUES (63,018015,37,'untying','Adolph','flopping','W');










112



INSERT INTO t2 VALUES (64,018016,37,'announces','pithed','relaxing','FAS');










113



INSERT INTO t2 VALUES (65,018017,37,'featherweight','emergency','offload','FAS');










114



INSERT INTO t2 VALUES (66,018018,37,'pessimist','Miles','suites','W');










115



INSERT INTO t2 VALUES (67,018019,37,'daughter','trimmings','lists','FAS');










116



INSERT INTO t2 VALUES (68,018020,37,'decliner','tragedies','animized','FAS');










117



INSERT INTO t2 VALUES (69,018021,37,'lawgiver','skulking','multilayer','W');










118



INSERT INTO t2 VALUES (70,018022,37,'stated','flint','standardizes','FAS');










119



INSERT INTO t2 VALUES (71,018023,37,'readable','flopping','Judas','');










120



INSERT INTO t2 VALUES (72,018024,37,'attrition','relaxing','vacuuming','W');










121



INSERT INTO t2 VALUES (73,018025,37,'cascade','offload','dentally','W');










122



INSERT INTO t2 VALUES (74,018026,37,'motors','suites','humanness','W');










123



INSERT INTO t2 VALUES (75,018027,37,'interrogate','lists','inch','W');










124



INSERT INTO t2 VALUES (76,018028,37,'pests','animized','Weissmuller','W');










125



INSERT INTO t2 VALUES (77,018029,37,'stairway','multilayer','irresponsibly','W');










126



INSERT INTO t2 VALUES (78,018030,37,'dopers','standardizes','luckily','FAS');










127



INSERT INTO t2 VALUES (79,018032,37,'testicle','Judas','culled','W');










128



INSERT INTO t2 VALUES (80,018033,37,'Parsifal','vacuuming','medical','FAS');










129



INSERT INTO t2 VALUES (81,018034,37,'leavings','dentally','bloodbath','FAS');










130



INSERT INTO t2 VALUES (82,018035,37,'postulation','humanness','subschema','W');










131



INSERT INTO t2 VALUES (83,018036,37,'squeaking','inch','animals','W');










132



INSERT INTO t2 VALUES (84,018037,37,'contrasted','Weissmuller','Micronesia','');










133



INSERT INTO t2 VALUES (85,018038,37,'leftover','irresponsibly','repetitions','');










134



INSERT INTO t2 VALUES (86,018039,37,'whiteners','luckily','Antares','');










135



INSERT INTO t2 VALUES (87,018040,37,'erases','culled','ventilate','W');










136



INSERT INTO t2 VALUES (88,018041,37,'Punjab','medical','pityingly','');










137



INSERT INTO t2 VALUES (89,018042,37,'Merritt','bloodbath','interdependent','');










138



INSERT INTO t2 VALUES (90,018043,37,'Quixotism','subschema','Graves','FAS');










139



INSERT INTO t2 VALUES (91,018044,37,'sweetish','animals','neonatal','');










140



INSERT INTO t2 VALUES (92,018045,37,'dogging','Micronesia','scribbled','FAS');










141



INSERT INTO t2 VALUES (93,018046,37,'scornfully','repetitions','chafe','W');










142



INSERT INTO t2 VALUES (94,018048,37,'bellow','Antares','honoring','');










143



INSERT INTO t2 VALUES (95,018049,37,'bills','ventilate','realtor','');










144



INSERT INTO t2 VALUES (96,018050,37,'cupboard','pityingly','elite','');










145



INSERT INTO t2 VALUES (97,018051,37,'sureties','interdependent','funereal','');










146



INSERT INTO t2 VALUES (98,018052,37,'puddings','Graves','abrogating','');










147



INSERT INTO t2 VALUES (99,018053,50,'tapestry','neonatal','sorters','');










148



INSERT INTO t2 VALUES (100,018054,37,'fetters','scribbled','Conley','');










149



INSERT INTO t2 VALUES (101,018055,37,'bivalves','chafe','lectured','');










150



INSERT INTO t2 VALUES (102,018056,37,'incurring','honoring','Abraham','');










151



INSERT INTO t2 VALUES (103,018057,37,'Adolph','realtor','Hawaii','W');










152



INSERT INTO t2 VALUES (104,018058,37,'pithed','elite','cage','');










153



INSERT INTO t2 VALUES (105,018059,36,'emergency','funereal','hushes','');










154



INSERT INTO t2 VALUES (106,018060,37,'Miles','abrogating','Simla','');










155



INSERT INTO t2 VALUES (107,018061,37,'trimmings','sorters','reporters','');










156



INSERT INTO t2 VALUES (108,018101,37,'tragedies','Conley','Dutchman','FAS');










157



INSERT INTO t2 VALUES (109,018102,37,'skulking','lectured','descendants','FAS');










158



INSERT INTO t2 VALUES (110,018103,37,'flint','Abraham','groupings','FAS');










159



INSERT INTO t2 VALUES (111,018104,37,'flopping','Hawaii','dissociate','');










160



INSERT INTO t2 VALUES (112,018201,37,'relaxing','cage','coexist','W');










161



INSERT INTO t2 VALUES (113,018202,37,'offload','hushes','Beebe','');










162



INSERT INTO t2 VALUES (114,018402,37,'suites','Simla','Taoism','');










163



INSERT INTO t2 VALUES (115,018403,37,'lists','reporters','Connally','');










164



INSERT INTO t2 VALUES (116,018404,37,'animized','Dutchman','fetched','FAS');










165



INSERT INTO t2 VALUES (117,018405,37,'multilayer','descendants','checkpoints','FAS');










166



INSERT INTO t2 VALUES (118,018406,37,'standardizes','groupings','rusting','');










167



INSERT INTO t2 VALUES (119,018409,37,'Judas','dissociate','galling','');










168



INSERT INTO t2 VALUES (120,018601,37,'vacuuming','coexist','obliterates','');










169



INSERT INTO t2 VALUES (121,018602,37,'dentally','Beebe','traitor','');










170



INSERT INTO t2 VALUES (122,018603,37,'humanness','Taoism','resumes','FAS');










171



INSERT INTO t2 VALUES (123,018801,37,'inch','Connally','analyzable','FAS');










172



INSERT INTO t2 VALUES (124,018802,37,'Weissmuller','fetched','terminator','FAS');










173



INSERT INTO t2 VALUES (125,018803,37,'irresponsibly','checkpoints','gritty','FAS');










174



INSERT INTO t2 VALUES (126,018804,37,'luckily','rusting','firearm','W');










175



INSERT INTO t2 VALUES (127,018805,37,'culled','galling','minima','');










176



INSERT INTO t2 VALUES (128,018806,37,'medical','obliterates','Selfridge','');










177



INSERT INTO t2 VALUES (129,018807,37,'bloodbath','traitor','disable','');










178



INSERT INTO t2 VALUES (130,018808,37,'subschema','resumes','witchcraft','W');










179



INSERT INTO t2 VALUES (131,018809,37,'animals','analyzable','betroth','W');










180



INSERT INTO t2 VALUES (132,018810,37,'Micronesia','terminator','Manhattanize','');










181



INSERT INTO t2 VALUES (133,018811,37,'repetitions','gritty','imprint','');










182



INSERT INTO t2 VALUES (134,018812,37,'Antares','firearm','peeked','');










183



INSERT INTO t2 VALUES (135,019101,37,'ventilate','minima','swelling','');










184



INSERT INTO t2 VALUES (136,019102,37,'pityingly','Selfridge','interrelationships','W');










185



INSERT INTO t2 VALUES (137,019103,37,'interdependent','disable','riser','');










186



INSERT INTO t2 VALUES (138,019201,37,'Graves','witchcraft','Gandhian','W');










187



INSERT INTO t2 VALUES (139,030501,37,'neonatal','betroth','peacock','A');










188



INSERT INTO t2 VALUES (140,030502,50,'scribbled','Manhattanize','bee','A');










189



INSERT INTO t2 VALUES (141,030503,37,'chafe','imprint','kanji','');










190



INSERT INTO t2 VALUES (142,030504,37,'honoring','peeked','dental','');










191



INSERT INTO t2 VALUES (143,031901,37,'realtor','swelling','scarf','FAS');










192



INSERT INTO t2 VALUES (144,036001,37,'elite','interrelationships','chasm','A');










193



INSERT INTO t2 VALUES (145,036002,37,'funereal','riser','insolence','A');










194



INSERT INTO t2 VALUES (146,036004,37,'abrogating','Gandhian','syndicate','');










195



INSERT INTO t2 VALUES (147,036005,37,'sorters','peacock','alike','');










196



INSERT INTO t2 VALUES (148,038001,37,'Conley','bee','imperial','A');










197



INSERT INTO t2 VALUES (149,038002,37,'lectured','kanji','convulsion','A');










198



INSERT INTO t2 VALUES (150,038003,37,'Abraham','dental','railway','A');










199



INSERT INTO t2 VALUES (151,038004,37,'Hawaii','scarf','validate','A');










200



INSERT INTO t2 VALUES (152,038005,37,'cage','chasm','normalizes','A');










201



INSERT INTO t2 VALUES (153,038006,37,'hushes','insolence','comprehensive','');










202



INSERT INTO t2 VALUES (154,038007,37,'Simla','syndicate','chewing','');










203



INSERT INTO t2 VALUES (155,038008,37,'reporters','alike','denizen','');










204



INSERT INTO t2 VALUES (156,038009,37,'Dutchman','imperial','schemer','');










205



INSERT INTO t2 VALUES (157,038010,37,'descendants','convulsion','chronicle','');










206



INSERT INTO t2 VALUES (158,038011,37,'groupings','railway','Kline','');










207



INSERT INTO t2 VALUES (159,038012,37,'dissociate','validate','Anatole','');










208



INSERT INTO t2 VALUES (160,038013,37,'coexist','normalizes','partridges','');










209



INSERT INTO t2 VALUES (161,038014,37,'Beebe','comprehensive','brunch','');










210



INSERT INTO t2 VALUES (162,038015,37,'Taoism','chewing','recruited','');










211



INSERT INTO t2 VALUES (163,038016,37,'Connally','denizen','dimensions','W');










212



INSERT INTO t2 VALUES (164,038017,37,'fetched','schemer','Chicana','W');










213



INSERT INTO t2 VALUES (165,038018,37,'checkpoints','chronicle','announced','');










214



INSERT INTO t2 VALUES (166,038101,37,'rusting','Kline','praised','FAS');










215



INSERT INTO t2 VALUES (167,038102,37,'galling','Anatole','employing','');










216



INSERT INTO t2 VALUES (168,038103,37,'obliterates','partridges','linear','');










217



INSERT INTO t2 VALUES (169,038104,37,'traitor','brunch','quagmire','');










218



INSERT INTO t2 VALUES (170,038201,37,'resumes','recruited','western','A');










219



INSERT INTO t2 VALUES (171,038202,37,'analyzable','dimensions','relishing','');










220



INSERT INTO t2 VALUES (172,038203,37,'terminator','Chicana','serving','A');










221



INSERT INTO t2 VALUES (173,038204,37,'gritty','announced','scheduling','');










222



INSERT INTO t2 VALUES (174,038205,37,'firearm','praised','lore','');










223



INSERT INTO t2 VALUES (175,038206,37,'minima','employing','eventful','');










224



INSERT INTO t2 VALUES (176,038208,37,'Selfridge','linear','arteriole','A');










225



INSERT INTO t2 VALUES (177,042801,37,'disable','quagmire','disentangle','');










226



INSERT INTO t2 VALUES (178,042802,37,'witchcraft','western','cured','A');










227



INSERT INTO t2 VALUES (179,046101,37,'betroth','relishing','Fenton','W');










228



INSERT INTO t2 VALUES (180,048001,37,'Manhattanize','serving','avoidable','A');










229



INSERT INTO t2 VALUES (181,048002,37,'imprint','scheduling','drains','A');










230



INSERT INTO t2 VALUES (182,048003,37,'peeked','lore','detectably','FAS');










231



INSERT INTO t2 VALUES (183,048004,37,'swelling','eventful','husky','');










232



INSERT INTO t2 VALUES (184,048005,37,'interrelationships','arteriole','impelling','');










233



INSERT INTO t2 VALUES (185,048006,37,'riser','disentangle','undoes','');










234



INSERT INTO t2 VALUES (186,048007,37,'Gandhian','cured','evened','');










235



INSERT INTO t2 VALUES (187,048008,37,'peacock','Fenton','squeezes','');










236



INSERT INTO t2 VALUES (188,048101,37,'bee','avoidable','destroyer','FAS');










237



INSERT INTO t2 VALUES (189,048102,37,'kanji','drains','rudeness','');










238



INSERT INTO t2 VALUES (190,048201,37,'dental','detectably','beaner','FAS');










239



INSERT INTO t2 VALUES (191,048202,37,'scarf','husky','boorish','');










240



INSERT INTO t2 VALUES (192,048203,37,'chasm','impelling','Everhart','');










241



INSERT INTO t2 VALUES (193,048204,37,'insolence','undoes','encompass','A');










242



INSERT INTO t2 VALUES (194,048205,37,'syndicate','evened','mushrooms','');










243



INSERT INTO t2 VALUES (195,048301,37,'alike','squeezes','Alison','A');










244



INSERT INTO t2 VALUES (196,048302,37,'imperial','destroyer','externally','FAS');










245



INSERT INTO t2 VALUES (197,048303,37,'convulsion','rudeness','pellagra','');










246



INSERT INTO t2 VALUES (198,048304,37,'railway','beaner','cult','');










247



INSERT INTO t2 VALUES (199,048305,37,'validate','boorish','creek','A');










248



INSERT INTO t2 VALUES (200,048401,37,'normalizes','Everhart','Huffman','');










249



INSERT INTO t2 VALUES (201,048402,37,'comprehensive','encompass','Majorca','FAS');










250



INSERT INTO t2 VALUES (202,048403,37,'chewing','mushrooms','governing','A');










251



INSERT INTO t2 VALUES (203,048404,37,'denizen','Alison','gadfly','FAS');










252



INSERT INTO t2 VALUES (204,048405,37,'schemer','externally','reassigned','FAS');










253



INSERT INTO t2 VALUES (205,048406,37,'chronicle','pellagra','intentness','W');










254



INSERT INTO t2 VALUES (206,048407,37,'Kline','cult','craziness','');










255



INSERT INTO t2 VALUES (207,048408,37,'Anatole','creek','psychic','');










256



INSERT INTO t2 VALUES (208,048409,37,'partridges','Huffman','squabbled','');










257



INSERT INTO t2 VALUES (209,048410,37,'brunch','Majorca','burlesque','');










258



INSERT INTO t2 VALUES (210,048411,37,'recruited','governing','capped','');










259



INSERT INTO t2 VALUES (211,048412,37,'dimensions','gadfly','extracted','A');










260



INSERT INTO t2 VALUES (212,048413,37,'Chicana','reassigned','DiMaggio','');










261



INSERT INTO t2 VALUES (213,048601,37,'announced','intentness','exclamation','FAS');










262



INSERT INTO t2 VALUES (214,048602,37,'praised','craziness','subdirectory','');










263



INSERT INTO t2 VALUES (215,048603,37,'employing','psychic','fangs','');










264



INSERT INTO t2 VALUES (216,048604,37,'linear','squabbled','buyer','A');










265



INSERT INTO t2 VALUES (217,048801,37,'quagmire','burlesque','pithing','A');










266



INSERT INTO t2 VALUES (218,050901,37,'western','capped','transistorizing','A');










267



INSERT INTO t2 VALUES (219,051201,37,'relishing','extracted','nonbiodegradable','');










268



INSERT INTO t2 VALUES (220,056002,37,'serving','DiMaggio','dislocate','');










269



INSERT INTO t2 VALUES (221,056003,37,'scheduling','exclamation','monochromatic','FAS');










270



INSERT INTO t2 VALUES (222,056004,37,'lore','subdirectory','batting','');










271



INSERT INTO t2 VALUES (223,056102,37,'eventful','fangs','postcondition','A');










272



INSERT INTO t2 VALUES (224,056203,37,'arteriole','buyer','catalog','FAS');










273



INSERT INTO t2 VALUES (225,056204,37,'disentangle','pithing','Remus','');










274



INSERT INTO t2 VALUES (226,058003,37,'cured','transistorizing','devices','A');










275



INSERT INTO t2 VALUES (227,058004,37,'Fenton','nonbiodegradable','bike','A');










276



INSERT INTO t2 VALUES (228,058005,37,'avoidable','dislocate','qualify','');










277



INSERT INTO t2 VALUES (229,058006,37,'drains','monochromatic','detained','');










278



INSERT INTO t2 VALUES (230,058007,37,'detectably','batting','commended','');










279



INSERT INTO t2 VALUES (231,058101,37,'husky','postcondition','civilize','');










280



INSERT INTO t2 VALUES (232,058102,37,'impelling','catalog','Elmhurst','');










281



INSERT INTO t2 VALUES (233,058103,37,'undoes','Remus','anesthetizing','');










282



INSERT INTO t2 VALUES (234,058105,37,'evened','devices','deaf','');










283



INSERT INTO t2 VALUES (235,058111,37,'squeezes','bike','Brigham','');










284



INSERT INTO t2 VALUES (236,058112,37,'destroyer','qualify','title','');










285



INSERT INTO t2 VALUES (237,058113,37,'rudeness','detained','coarse','');










286



INSERT INTO t2 VALUES (238,058114,37,'beaner','commended','combinations','');










287



INSERT INTO t2 VALUES (239,058115,37,'boorish','civilize','grayness','');










288



INSERT INTO t2 VALUES (240,058116,37,'Everhart','Elmhurst','innumerable','FAS');










289



INSERT INTO t2 VALUES (241,058117,37,'encompass','anesthetizing','Caroline','A');










290



INSERT INTO t2 VALUES (242,058118,37,'mushrooms','deaf','fatty','FAS');










291



INSERT INTO t2 VALUES (243,058119,37,'Alison','Brigham','eastbound','');










292



INSERT INTO t2 VALUES (244,058120,37,'externally','title','inexperienced','');










293



INSERT INTO t2 VALUES (245,058121,37,'pellagra','coarse','hoarder','A');










294



INSERT INTO t2 VALUES (246,058122,37,'cult','combinations','scotch','W');










295



INSERT INTO t2 VALUES (247,058123,37,'creek','grayness','passport','A');










296



INSERT INTO t2 VALUES (248,058124,37,'Huffman','innumerable','strategic','FAS');










297



INSERT INTO t2 VALUES (249,058125,37,'Majorca','Caroline','gated','');










298



INSERT INTO t2 VALUES (250,058126,37,'governing','fatty','flog','');










299



INSERT INTO t2 VALUES (251,058127,37,'gadfly','eastbound','Pipestone','');










300



INSERT INTO t2 VALUES (252,058128,37,'reassigned','inexperienced','Dar','');










301



INSERT INTO t2 VALUES (253,058201,37,'intentness','hoarder','Corcoran','');










302



INSERT INTO t2 VALUES (254,058202,37,'craziness','scotch','flyers','A');










303



INSERT INTO t2 VALUES (255,058303,37,'psychic','passport','competitions','W');










304



INSERT INTO t2 VALUES (256,058304,37,'squabbled','strategic','suppliers','FAS');










305



INSERT INTO t2 VALUES (257,058602,37,'burlesque','gated','skips','');










306



INSERT INTO t2 VALUES (258,058603,37,'capped','flog','institutes','');










307



INSERT INTO t2 VALUES (259,058604,37,'extracted','Pipestone','troop','A');










308



INSERT INTO t2 VALUES (260,058605,37,'DiMaggio','Dar','connective','W');










309



INSERT INTO t2 VALUES (261,058606,37,'exclamation','Corcoran','denies','');










310



INSERT INTO t2 VALUES (262,058607,37,'subdirectory','flyers','polka','');










311



INSERT INTO t2 VALUES (263,060401,36,'fangs','competitions','observations','FAS');










312



INSERT INTO t2 VALUES (264,061701,36,'buyer','suppliers','askers','');










313



INSERT INTO t2 VALUES (265,066201,36,'pithing','skips','homeless','FAS');










314



INSERT INTO t2 VALUES (266,066501,36,'transistorizing','institutes','Anna','');










315



INSERT INTO t2 VALUES (267,068001,36,'nonbiodegradable','troop','subdirectories','W');










316



INSERT INTO t2 VALUES (268,068002,36,'dislocate','connective','decaying','FAS');










317



INSERT INTO t2 VALUES (269,068005,36,'monochromatic','denies','outwitting','W');










318



INSERT INTO t2 VALUES (270,068006,36,'batting','polka','Harpy','W');










319



INSERT INTO t2 VALUES (271,068007,36,'postcondition','observations','crazed','');










320



INSERT INTO t2 VALUES (272,068008,36,'catalog','askers','suffocate','');










321



INSERT INTO t2 VALUES (273,068009,36,'Remus','homeless','provers','FAS');










322



INSERT INTO t2 VALUES (274,068010,36,'devices','Anna','technically','');










323



INSERT INTO t2 VALUES (275,068011,36,'bike','subdirectories','Franklinizations','');










324



INSERT INTO t2 VALUES (276,068202,36,'qualify','decaying','considered','');










325



INSERT INTO t2 VALUES (277,068302,36,'detained','outwitting','tinnily','');










326



INSERT INTO t2 VALUES (278,068303,36,'commended','Harpy','uninterruptedly','');










327



INSERT INTO t2 VALUES (279,068401,36,'civilize','crazed','whistled','A');










328



INSERT INTO t2 VALUES (280,068501,36,'Elmhurst','suffocate','automate','');










329



INSERT INTO t2 VALUES (281,068502,36,'anesthetizing','provers','gutting','W');










330



INSERT INTO t2 VALUES (282,068503,36,'deaf','technically','surreptitious','');










331



INSERT INTO t2 VALUES (283,068602,36,'Brigham','Franklinizations','Choctaw','');










332



INSERT INTO t2 VALUES (284,068603,36,'title','considered','cooks','');










333



INSERT INTO t2 VALUES (285,068701,36,'coarse','tinnily','millivolt','FAS');










334



INSERT INTO t2 VALUES (286,068702,36,'combinations','uninterruptedly','counterpoise','');










335



INSERT INTO t2 VALUES (287,068703,36,'grayness','whistled','Gothicism','');










336



INSERT INTO t2 VALUES (288,076001,36,'innumerable','automate','feminine','');










337



INSERT INTO t2 VALUES (289,076002,36,'Caroline','gutting','metaphysically','W');










338



INSERT INTO t2 VALUES (290,076101,36,'fatty','surreptitious','sanding','A');










339



INSERT INTO t2 VALUES (291,076102,36,'eastbound','Choctaw','contributorily','');










340



INSERT INTO t2 VALUES (292,076103,36,'inexperienced','cooks','receivers','FAS');










341



INSERT INTO t2 VALUES (293,076302,36,'hoarder','millivolt','adjourn','');










342



INSERT INTO t2 VALUES (294,076303,36,'scotch','counterpoise','straggled','A');










343



INSERT INTO t2 VALUES (295,076304,36,'passport','Gothicism','druggists','');










344



INSERT INTO t2 VALUES (296,076305,36,'strategic','feminine','thanking','FAS');










345



INSERT INTO t2 VALUES (297,076306,36,'gated','metaphysically','ostrich','');










346



INSERT INTO t2 VALUES (298,076307,36,'flog','sanding','hopelessness','FAS');










347



INSERT INTO t2 VALUES (299,076402,36,'Pipestone','contributorily','Eurydice','');










348



INSERT INTO t2 VALUES (300,076501,36,'Dar','receivers','excitation','W');










349



INSERT INTO t2 VALUES (301,076502,36,'Corcoran','adjourn','presumes','FAS');










350



INSERT INTO t2 VALUES (302,076701,36,'flyers','straggled','imaginable','FAS');










351



INSERT INTO t2 VALUES (303,078001,36,'competitions','druggists','concoct','W');










352



INSERT INTO t2 VALUES (304,078002,36,'suppliers','thanking','peering','W');










353



INSERT INTO t2 VALUES (305,078003,36,'skips','ostrich','Phelps','FAS');










354



INSERT INTO t2 VALUES (306,078004,36,'institutes','hopelessness','ferociousness','FAS');










355



INSERT INTO t2 VALUES (307,078005,36,'troop','Eurydice','sentences','');










356



INSERT INTO t2 VALUES (308,078006,36,'connective','excitation','unlocks','');










357



INSERT INTO t2 VALUES (309,078007,36,'denies','presumes','engrossing','W');










358



INSERT INTO t2 VALUES (310,078008,36,'polka','imaginable','Ruth','');










359



INSERT INTO t2 VALUES (311,078101,36,'observations','concoct','tying','');










360



INSERT INTO t2 VALUES (312,078103,36,'askers','peering','exclaimers','');










361



INSERT INTO t2 VALUES (313,078104,36,'homeless','Phelps','synergy','');










362



INSERT INTO t2 VALUES (314,078105,36,'Anna','ferociousness','Huey','W');










363



INSERT INTO t2 VALUES (315,082101,36,'subdirectories','sentences','merging','');










364



INSERT INTO t2 VALUES (316,083401,36,'decaying','unlocks','judges','A');










365



INSERT INTO t2 VALUES (317,084001,36,'outwitting','engrossing','Shylock','W');










366



INSERT INTO t2 VALUES (318,084002,36,'Harpy','Ruth','Miltonism','');










367



INSERT INTO t2 VALUES (319,086001,36,'crazed','tying','hen','W');










368



INSERT INTO t2 VALUES (320,086102,36,'suffocate','exclaimers','honeybee','FAS');










369



INSERT INTO t2 VALUES (321,086201,36,'provers','synergy','towers','');










370



INSERT INTO t2 VALUES (322,088001,36,'technically','Huey','dilutes','W');










371



INSERT INTO t2 VALUES (323,088002,36,'Franklinizations','merging','numerals','FAS');










372



INSERT INTO t2 VALUES (324,088003,36,'considered','judges','democracy','FAS');










373



INSERT INTO t2 VALUES (325,088004,36,'tinnily','Shylock','Ibero-','');










374



INSERT INTO t2 VALUES (326,088101,36,'uninterruptedly','Miltonism','invalids','');










375



INSERT INTO t2 VALUES (327,088102,36,'whistled','hen','behavior','');










376



INSERT INTO t2 VALUES (328,088103,36,'automate','honeybee','accruing','');










377



INSERT INTO t2 VALUES (329,088104,36,'gutting','towers','relics','A');










378



INSERT INTO t2 VALUES (330,088105,36,'surreptitious','dilutes','rackets','');










379



INSERT INTO t2 VALUES (331,088106,36,'Choctaw','numerals','Fischbein','W');










380



INSERT INTO t2 VALUES (332,088201,36,'cooks','democracy','phony','W');










381



INSERT INTO t2 VALUES (333,088203,36,'millivolt','Ibero-','cross','FAS');










382



INSERT INTO t2 VALUES (334,088204,36,'counterpoise','invalids','cleanup','');










383



INSERT INTO t2 VALUES (335,088302,37,'Gothicism','behavior','conspirator','');










384



INSERT INTO t2 VALUES (336,088303,37,'feminine','accruing','label','FAS');










385



INSERT INTO t2 VALUES (337,088305,37,'metaphysically','relics','university','');










386



INSERT INTO t2 VALUES (338,088402,37,'sanding','rackets','cleansed','FAS');










387



INSERT INTO t2 VALUES (339,088501,36,'contributorily','Fischbein','ballgown','');










388



INSERT INTO t2 VALUES (340,088502,36,'receivers','phony','starlet','');










389



INSERT INTO t2 VALUES (341,088503,36,'adjourn','cross','aqueous','');










390



INSERT INTO t2 VALUES (342,098001,58,'straggled','cleanup','portrayal','A');










391



INSERT INTO t2 VALUES (343,098002,58,'druggists','conspirator','despising','W');










392



INSERT INTO t2 VALUES (344,098003,58,'thanking','label','distort','W');










393



INSERT INTO t2 VALUES (345,098004,58,'ostrich','university','palmed','');










394



INSERT INTO t2 VALUES (346,098005,58,'hopelessness','cleansed','faced','');










395



INSERT INTO t2 VALUES (347,098006,58,'Eurydice','ballgown','silverware','');










396



INSERT INTO t2 VALUES (348,141903,29,'excitation','starlet','assessor','');










397



INSERT INTO t2 VALUES (349,098008,58,'presumes','aqueous','spiders','');










398



INSERT INTO t2 VALUES (350,098009,58,'imaginable','portrayal','artificially','');










399



INSERT INTO t2 VALUES (351,098010,58,'concoct','despising','reminiscence','');










400



INSERT INTO t2 VALUES (352,098011,58,'peering','distort','Mexican','');










401



INSERT INTO t2 VALUES (353,098012,58,'Phelps','palmed','obnoxious','');










402



INSERT INTO t2 VALUES (354,098013,58,'ferociousness','faced','fragile','');










403



INSERT INTO t2 VALUES (355,098014,58,'sentences','silverware','apprehensible','');










404



INSERT INTO t2 VALUES (356,098015,58,'unlocks','assessor','births','');










405



INSERT INTO t2 VALUES (357,098016,58,'engrossing','spiders','garages','');










406



INSERT INTO t2 VALUES (358,098017,58,'Ruth','artificially','panty','');










407



INSERT INTO t2 VALUES (359,098018,58,'tying','reminiscence','anteater','');










408



INSERT INTO t2 VALUES (360,098019,58,'exclaimers','Mexican','displacement','A');










409



INSERT INTO t2 VALUES (361,098020,58,'synergy','obnoxious','drovers','A');










410



INSERT INTO t2 VALUES (362,098021,58,'Huey','fragile','patenting','A');










411



INSERT INTO t2 VALUES (363,098022,58,'merging','apprehensible','far','A');










412



INSERT INTO t2 VALUES (364,098023,58,'judges','births','shrieks','');










413



INSERT INTO t2 VALUES (365,098024,58,'Shylock','garages','aligning','W');










414



INSERT INTO t2 VALUES (366,098025,37,'Miltonism','panty','pragmatism','');










415



INSERT INTO t2 VALUES (367,106001,36,'hen','anteater','fevers','W');










416



INSERT INTO t2 VALUES (368,108001,36,'honeybee','displacement','reexamines','A');










417



INSERT INTO t2 VALUES (369,108002,36,'towers','drovers','occupancies','');










418



INSERT INTO t2 VALUES (370,108003,36,'dilutes','patenting','sweats','FAS');










419



INSERT INTO t2 VALUES (371,108004,36,'numerals','far','modulators','');










420



INSERT INTO t2 VALUES (372,108005,36,'democracy','shrieks','demand','W');










421



INSERT INTO t2 VALUES (373,108007,36,'Ibero-','aligning','Madeira','');










422



INSERT INTO t2 VALUES (374,108008,36,'invalids','pragmatism','Viennese','W');










423



INSERT INTO t2 VALUES (375,108009,36,'behavior','fevers','chillier','W');










424



INSERT INTO t2 VALUES (376,108010,36,'accruing','reexamines','wildcats','FAS');










425



INSERT INTO t2 VALUES (377,108011,36,'relics','occupancies','gentle','');










426



INSERT INTO t2 VALUES (378,108012,36,'rackets','sweats','Angles','W');










427



INSERT INTO t2 VALUES (379,108101,36,'Fischbein','modulators','accuracies','');










428



INSERT INTO t2 VALUES (380,108102,36,'phony','demand','toggle','');










429



INSERT INTO t2 VALUES (381,108103,36,'cross','Madeira','Mendelssohn','W');










430



INSERT INTO t2 VALUES (382,108111,50,'cleanup','Viennese','behaviorally','');










431



INSERT INTO t2 VALUES (383,108105,36,'conspirator','chillier','Rochford','');










432



INSERT INTO t2 VALUES (384,108106,36,'label','wildcats','mirror','W');










433



INSERT INTO t2 VALUES (385,108107,36,'university','gentle','Modula','');










434



INSERT INTO t2 VALUES (386,108108,50,'cleansed','Angles','clobbering','');










435



INSERT INTO t2 VALUES (387,108109,36,'ballgown','accuracies','chronography','');










436



INSERT INTO t2 VALUES (388,108110,36,'starlet','toggle','Eskimoizeds','');










437



INSERT INTO t2 VALUES (389,108201,36,'aqueous','Mendelssohn','British','W');










438



INSERT INTO t2 VALUES (390,108202,36,'portrayal','behaviorally','pitfalls','');










439



INSERT INTO t2 VALUES (391,108203,36,'despising','Rochford','verify','W');










440



INSERT INTO t2 VALUES (392,108204,36,'distort','mirror','scatter','FAS');










441



INSERT INTO t2 VALUES (393,108205,36,'palmed','Modula','Aztecan','');










442



INSERT INTO t2 VALUES (394,108301,36,'faced','clobbering','acuity','W');










443



INSERT INTO t2 VALUES (395,108302,36,'silverware','chronography','sinking','W');










444



INSERT INTO t2 VALUES (396,112101,36,'assessor','Eskimoizeds','beasts','FAS');










445



INSERT INTO t2 VALUES (397,112102,36,'spiders','British','Witt','W');










446



INSERT INTO t2 VALUES (398,113701,36,'artificially','pitfalls','physicists','FAS');










447



INSERT INTO t2 VALUES (399,116001,36,'reminiscence','verify','folksong','A');










448



INSERT INTO t2 VALUES (400,116201,36,'Mexican','scatter','strokes','FAS');










449



INSERT INTO t2 VALUES (401,116301,36,'obnoxious','Aztecan','crowder','');










450



INSERT INTO t2 VALUES (402,116302,36,'fragile','acuity','merry','');










451



INSERT INTO t2 VALUES (403,116601,36,'apprehensible','sinking','cadenced','');










452



INSERT INTO t2 VALUES (404,116602,36,'births','beasts','alimony','A');










453



INSERT INTO t2 VALUES (405,116603,36,'garages','Witt','principled','A');










454



INSERT INTO t2 VALUES (406,116701,36,'panty','physicists','golfing','');










455



INSERT INTO t2 VALUES (407,116702,36,'anteater','folksong','undiscovered','');










456



INSERT INTO t2 VALUES (408,118001,36,'displacement','strokes','irritates','');










457



INSERT INTO t2 VALUES (409,118002,36,'drovers','crowder','patriots','A');










458



INSERT INTO t2 VALUES (410,118003,36,'patenting','merry','rooms','FAS');










459



INSERT INTO t2 VALUES (411,118004,36,'far','cadenced','towering','W');










460



INSERT INTO t2 VALUES (412,118005,36,'shrieks','alimony','displease','');










461



INSERT INTO t2 VALUES (413,118006,36,'aligning','principled','photosensitive','');










462



INSERT INTO t2 VALUES (414,118007,36,'pragmatism','golfing','inking','');










463



INSERT INTO t2 VALUES (415,118008,36,'fevers','undiscovered','gainers','');










464



INSERT INTO t2 VALUES (416,118101,36,'reexamines','irritates','leaning','A');










465



INSERT INTO t2 VALUES (417,118102,36,'occupancies','patriots','hydrant','A');










466



INSERT INTO t2 VALUES (418,118103,36,'sweats','rooms','preserve','');










467



INSERT INTO t2 VALUES (419,118202,36,'modulators','towering','blinded','A');










468



INSERT INTO t2 VALUES (420,118203,36,'demand','displease','interactions','A');










469



INSERT INTO t2 VALUES (421,118204,36,'Madeira','photosensitive','Barry','');










470



INSERT INTO t2 VALUES (422,118302,36,'Viennese','inking','whiteness','A');










471



INSERT INTO t2 VALUES (423,118304,36,'chillier','gainers','pastimes','W');










472



INSERT INTO t2 VALUES (424,118305,36,'wildcats','leaning','Edenization','');










473



INSERT INTO t2 VALUES (425,118306,36,'gentle','hydrant','Muscat','');










474



INSERT INTO t2 VALUES (426,118307,36,'Angles','preserve','assassinated','');










475



INSERT INTO t2 VALUES (427,123101,36,'accuracies','blinded','labeled','');










476



INSERT INTO t2 VALUES (428,123102,36,'toggle','interactions','glacial','A');










477



INSERT INTO t2 VALUES (429,123301,36,'Mendelssohn','Barry','implied','W');










478



INSERT INTO t2 VALUES (430,126001,36,'behaviorally','whiteness','bibliographies','W');










479



INSERT INTO t2 VALUES (431,126002,36,'Rochford','pastimes','Buchanan','');










480



INSERT INTO t2 VALUES (432,126003,36,'mirror','Edenization','forgivably','FAS');










481



INSERT INTO t2 VALUES (433,126101,36,'Modula','Muscat','innuendo','A');










482



INSERT INTO t2 VALUES (434,126301,36,'clobbering','assassinated','den','FAS');










483



INSERT INTO t2 VALUES (435,126302,36,'chronography','labeled','submarines','W');










484



INSERT INTO t2 VALUES (436,126402,36,'Eskimoizeds','glacial','mouthful','A');










485



INSERT INTO t2 VALUES (437,126601,36,'British','implied','expiring','');










486



INSERT INTO t2 VALUES (438,126602,36,'pitfalls','bibliographies','unfulfilled','FAS');










487



INSERT INTO t2 VALUES (439,126702,36,'verify','Buchanan','precession','');










488



INSERT INTO t2 VALUES (440,128001,36,'scatter','forgivably','nullified','');










489



INSERT INTO t2 VALUES (441,128002,36,'Aztecan','innuendo','affects','');










490



INSERT INTO t2 VALUES (442,128003,36,'acuity','den','Cynthia','');










491



INSERT INTO t2 VALUES (443,128004,36,'sinking','submarines','Chablis','A');










492



INSERT INTO t2 VALUES (444,128005,36,'beasts','mouthful','betterments','FAS');










493



INSERT INTO t2 VALUES (445,128007,36,'Witt','expiring','advertising','');










494



INSERT INTO t2 VALUES (446,128008,36,'physicists','unfulfilled','rubies','A');










495



INSERT INTO t2 VALUES (447,128009,36,'folksong','precession','southwest','FAS');










496



INSERT INTO t2 VALUES (448,128010,36,'strokes','nullified','superstitious','A');










497



INSERT INTO t2 VALUES (449,128011,36,'crowder','affects','tabernacle','W');










498



INSERT INTO t2 VALUES (450,128012,36,'merry','Cynthia','silk','A');










499



INSERT INTO t2 VALUES (451,128013,36,'cadenced','Chablis','handsomest','A');










500



INSERT INTO t2 VALUES (452,128014,36,'alimony','betterments','Persian','A');










501



INSERT INTO t2 VALUES (453,128015,36,'principled','advertising','analog','W');










502



INSERT INTO t2 VALUES (454,128016,36,'golfing','rubies','complex','W');










503



INSERT INTO t2 VALUES (455,128017,36,'undiscovered','southwest','Taoist','');










504



INSERT INTO t2 VALUES (456,128018,36,'irritates','superstitious','suspend','');










505



INSERT INTO t2 VALUES (457,128019,36,'patriots','tabernacle','relegated','');










506



INSERT INTO t2 VALUES (458,128020,36,'rooms','silk','awesome','W');










507



INSERT INTO t2 VALUES (459,128021,36,'towering','handsomest','Bruxelles','');










508



INSERT INTO t2 VALUES (460,128022,36,'displease','Persian','imprecisely','A');










509



INSERT INTO t2 VALUES (461,128023,36,'photosensitive','analog','televise','');










510



INSERT INTO t2 VALUES (462,128101,36,'inking','complex','braking','');










511



INSERT INTO t2 VALUES (463,128102,36,'gainers','Taoist','true','FAS');










512



INSERT INTO t2 VALUES (464,128103,36,'leaning','suspend','disappointing','FAS');










513



INSERT INTO t2 VALUES (465,128104,36,'hydrant','relegated','navally','W');










514



INSERT INTO t2 VALUES (466,128106,36,'preserve','awesome','circus','');










515



INSERT INTO t2 VALUES (467,128107,36,'blinded','Bruxelles','beetles','');










516



INSERT INTO t2 VALUES (468,128108,36,'interactions','imprecisely','trumps','');










517



INSERT INTO t2 VALUES (469,128202,36,'Barry','televise','fourscore','W');










518



INSERT INTO t2 VALUES (470,128203,36,'whiteness','braking','Blackfoots','');










519



INSERT INTO t2 VALUES (471,128301,36,'pastimes','true','Grady','');










520



INSERT INTO t2 VALUES (472,128302,36,'Edenization','disappointing','quiets','FAS');










521



INSERT INTO t2 VALUES (473,128303,36,'Muscat','navally','floundered','FAS');










522



INSERT INTO t2 VALUES (474,128304,36,'assassinated','circus','profundity','W');










523



INSERT INTO t2 VALUES (475,128305,36,'labeled','beetles','Garrisonian','W');










524



INSERT INTO t2 VALUES (476,128307,36,'glacial','trumps','Strauss','');










525



INSERT INTO t2 VALUES (477,128401,36,'implied','fourscore','cemented','FAS');










526



INSERT INTO t2 VALUES (478,128502,36,'bibliographies','Blackfoots','contrition','A');










527



INSERT INTO t2 VALUES (479,128503,36,'Buchanan','Grady','mutations','');










528



INSERT INTO t2 VALUES (480,128504,36,'forgivably','quiets','exhibits','W');










529



INSERT INTO t2 VALUES (481,128505,36,'innuendo','floundered','tits','');










530



INSERT INTO t2 VALUES (482,128601,36,'den','profundity','mate','A');










531



INSERT INTO t2 VALUES (483,128603,36,'submarines','Garrisonian','arches','');










532



INSERT INTO t2 VALUES (484,128604,36,'mouthful','Strauss','Moll','');










533



INSERT INTO t2 VALUES (485,128702,36,'expiring','cemented','ropers','');










534



INSERT INTO t2 VALUES (486,128703,36,'unfulfilled','contrition','bombast','');










535



INSERT INTO t2 VALUES (487,128704,36,'precession','mutations','difficultly','A');










536



INSERT INTO t2 VALUES (488,138001,36,'nullified','exhibits','adsorption','');










537



INSERT INTO t2 VALUES (489,138002,36,'affects','tits','definiteness','FAS');










538



INSERT INTO t2 VALUES (490,138003,36,'Cynthia','mate','cultivation','A');










539



INSERT INTO t2 VALUES (491,138004,36,'Chablis','arches','heals','A');










540



INSERT INTO t2 VALUES (492,138005,36,'betterments','Moll','Heusen','W');










541



INSERT INTO t2 VALUES (493,138006,36,'advertising','ropers','target','FAS');










542



INSERT INTO t2 VALUES (494,138007,36,'rubies','bombast','cited','A');










543



INSERT INTO t2 VALUES (495,138008,36,'southwest','difficultly','congresswoman','W');










544



INSERT INTO t2 VALUES (496,138009,36,'superstitious','adsorption','Katherine','');










545



INSERT INTO t2 VALUES (497,138102,36,'tabernacle','definiteness','titter','A');










546



INSERT INTO t2 VALUES (498,138103,36,'silk','cultivation','aspire','A');










547



INSERT INTO t2 VALUES (499,138104,36,'handsomest','heals','Mardis','');










548



INSERT INTO t2 VALUES (500,138105,36,'Persian','Heusen','Nadia','W');










549



INSERT INTO t2 VALUES (501,138201,36,'analog','target','estimating','FAS');










550



INSERT INTO t2 VALUES (502,138302,36,'complex','cited','stuck','A');










551



INSERT INTO t2 VALUES (503,138303,36,'Taoist','congresswoman','fifteenth','A');










552



INSERT INTO t2 VALUES (504,138304,36,'suspend','Katherine','Colombo','');










553



INSERT INTO t2 VALUES (505,138401,29,'relegated','titter','survey','A');










554



INSERT INTO t2 VALUES (506,140102,29,'awesome','aspire','staffing','');










555



INSERT INTO t2 VALUES (507,140103,29,'Bruxelles','Mardis','obtain','');










556



INSERT INTO t2 VALUES (508,140104,29,'imprecisely','Nadia','loaded','');










557



INSERT INTO t2 VALUES (509,140105,29,'televise','estimating','slaughtered','');










558



INSERT INTO t2 VALUES (510,140201,29,'braking','stuck','lights','A');










559



INSERT INTO t2 VALUES (511,140701,29,'true','fifteenth','circumference','');










560



INSERT INTO t2 VALUES (512,141501,29,'disappointing','Colombo','dull','A');










561



INSERT INTO t2 VALUES (513,141502,29,'navally','survey','weekly','A');










562



INSERT INTO t2 VALUES (514,141901,29,'circus','staffing','wetness','');










563



INSERT INTO t2 VALUES (515,141902,29,'beetles','obtain','visualized','');










564



INSERT INTO t2 VALUES (516,142101,29,'trumps','loaded','Tannenbaum','');










565



INSERT INTO t2 VALUES (517,142102,29,'fourscore','slaughtered','moribund','');










566



INSERT INTO t2 VALUES (518,142103,29,'Blackfoots','lights','demultiplex','');










567



INSERT INTO t2 VALUES (519,142701,29,'Grady','circumference','lockings','');










568



INSERT INTO t2 VALUES (520,143001,29,'quiets','dull','thugs','FAS');










569



INSERT INTO t2 VALUES (521,143501,29,'floundered','weekly','unnerves','');










570



INSERT INTO t2 VALUES (522,143502,29,'profundity','wetness','abut','');










571



INSERT INTO t2 VALUES (523,148001,29,'Garrisonian','visualized','Chippewa','A');










572



INSERT INTO t2 VALUES (524,148002,29,'Strauss','Tannenbaum','stratifications','A');










573



INSERT INTO t2 VALUES (525,148003,29,'cemented','moribund','signaled','');










574



INSERT INTO t2 VALUES (526,148004,29,'contrition','demultiplex','Italianizes','A');










575



INSERT INTO t2 VALUES (527,148005,29,'mutations','lockings','algorithmic','A');










576



INSERT INTO t2 VALUES (528,148006,29,'exhibits','thugs','paranoid','FAS');










577



INSERT INTO t2 VALUES (529,148007,29,'tits','unnerves','camping','A');










578



INSERT INTO t2 VALUES (530,148009,29,'mate','abut','signifying','A');










579



INSERT INTO t2 VALUES (531,148010,29,'arches','Chippewa','Patrice','W');










580



INSERT INTO t2 VALUES (532,148011,29,'Moll','stratifications','search','A');










581



INSERT INTO t2 VALUES (533,148012,29,'ropers','signaled','Angeles','A');










582



INSERT INTO t2 VALUES (534,148013,29,'bombast','Italianizes','semblance','');










583



INSERT INTO t2 VALUES (535,148023,36,'difficultly','algorithmic','taxed','');










584



INSERT INTO t2 VALUES (536,148015,29,'adsorption','paranoid','Beatrice','');










585



INSERT INTO t2 VALUES (537,148016,29,'definiteness','camping','retrace','');










586



INSERT INTO t2 VALUES (538,148017,29,'cultivation','signifying','lockout','');










587



INSERT INTO t2 VALUES (539,148018,29,'heals','Patrice','grammatic','');










588



INSERT INTO t2 VALUES (540,148019,29,'Heusen','search','helmsman','');










589



INSERT INTO t2 VALUES (541,148020,29,'target','Angeles','uniform','W');










590



INSERT INTO t2 VALUES (542,148021,29,'cited','semblance','hamming','');










591



INSERT INTO t2 VALUES (543,148022,29,'congresswoman','taxed','disobedience','');










592



INSERT INTO t2 VALUES (544,148101,29,'Katherine','Beatrice','captivated','A');










593



INSERT INTO t2 VALUES (545,148102,29,'titter','retrace','transferals','A');










594



INSERT INTO t2 VALUES (546,148201,29,'aspire','lockout','cartographer','A');










595



INSERT INTO t2 VALUES (547,148401,29,'Mardis','grammatic','aims','FAS');










596



INSERT INTO t2 VALUES (548,148402,29,'Nadia','helmsman','Pakistani','');










597



INSERT INTO t2 VALUES (549,148501,29,'estimating','uniform','burglarized','FAS');










598



INSERT INTO t2 VALUES (550,148502,29,'stuck','hamming','saucepans','A');










599



INSERT INTO t2 VALUES (551,148503,29,'fifteenth','disobedience','lacerating','A');










600



INSERT INTO t2 VALUES (552,148504,29,'Colombo','captivated','corny','');










601



INSERT INTO t2 VALUES (553,148601,29,'survey','transferals','megabytes','FAS');










602



INSERT INTO t2 VALUES (554,148602,29,'staffing','cartographer','chancellor','');










603



INSERT INTO t2 VALUES (555,150701,29,'obtain','aims','bulk','A');










604



INSERT INTO t2 VALUES (556,152101,29,'loaded','Pakistani','commits','A');










605



INSERT INTO t2 VALUES (557,152102,29,'slaughtered','burglarized','meson','W');










606



INSERT INTO t2 VALUES (558,155202,36,'lights','saucepans','deputies','');










607



INSERT INTO t2 VALUES (559,155203,29,'circumference','lacerating','northeaster','A');










608



INSERT INTO t2 VALUES (560,155204,29,'dull','corny','dipole','');










609



INSERT INTO t2 VALUES (561,155205,29,'weekly','megabytes','machining','0');










610



INSERT INTO t2 VALUES (562,156001,29,'wetness','chancellor','therefore','');










611



INSERT INTO t2 VALUES (563,156002,29,'visualized','bulk','Telefunken','');










612



INSERT INTO t2 VALUES (564,156102,29,'Tannenbaum','commits','salvaging','');










613



INSERT INTO t2 VALUES (565,156301,29,'moribund','meson','Corinthianizes','A');










614



INSERT INTO t2 VALUES (566,156302,29,'demultiplex','deputies','restlessly','A');










615



INSERT INTO t2 VALUES (567,156303,29,'lockings','northeaster','bromides','');










616



INSERT INTO t2 VALUES (568,156304,29,'thugs','dipole','generalized','A');










617



INSERT INTO t2 VALUES (569,156305,29,'unnerves','machining','mishaps','');










618



INSERT INTO t2 VALUES (570,156306,29,'abut','therefore','quelling','');










619



INSERT INTO t2 VALUES (571,156501,29,'Chippewa','Telefunken','spiritual','A');










620



INSERT INTO t2 VALUES (572,158001,29,'stratifications','salvaging','beguiles','FAS');










621



INSERT INTO t2 VALUES (573,158002,29,'signaled','Corinthianizes','Trobriand','FAS');










622



INSERT INTO t2 VALUES (574,158101,29,'Italianizes','restlessly','fleeing','A');










623



INSERT INTO t2 VALUES (575,158102,29,'algorithmic','bromides','Armour','A');










624



INSERT INTO t2 VALUES (576,158103,29,'paranoid','generalized','chin','A');










625



INSERT INTO t2 VALUES (577,158201,29,'camping','mishaps','provers','A');










626



INSERT INTO t2 VALUES (578,158202,29,'signifying','quelling','aeronautic','A');










627



INSERT INTO t2 VALUES (579,158203,29,'Patrice','spiritual','voltage','W');










628



INSERT INTO t2 VALUES (580,158204,29,'search','beguiles','sash','');










629



INSERT INTO t2 VALUES (581,158301,29,'Angeles','Trobriand','anaerobic','A');










630



INSERT INTO t2 VALUES (582,158302,29,'semblance','fleeing','simultaneous','A');










631



INSERT INTO t2 VALUES (583,158303,29,'taxed','Armour','accumulating','A');










632



INSERT INTO t2 VALUES (584,158304,29,'Beatrice','chin','Medusan','A');










633



INSERT INTO t2 VALUES (585,158305,29,'retrace','provers','shouted','A');










634



INSERT INTO t2 VALUES (586,158306,29,'lockout','aeronautic','freakish','');










635



INSERT INTO t2 VALUES (587,158501,29,'grammatic','voltage','index','FAS');










636



INSERT INTO t2 VALUES (588,160301,29,'helmsman','sash','commercially','');










637



INSERT INTO t2 VALUES (589,166101,50,'uniform','anaerobic','mistiness','A');










638



INSERT INTO t2 VALUES (590,166102,50,'hamming','simultaneous','endpoint','');










639



INSERT INTO t2 VALUES (591,168001,29,'disobedience','accumulating','straight','A');










640



INSERT INTO t2 VALUES (592,168002,29,'captivated','Medusan','flurried','');










641



INSERT INTO t2 VALUES (593,168003,29,'transferals','shouted','denotative','A');










642



INSERT INTO t2 VALUES (594,168101,29,'cartographer','freakish','coming','FAS');










643



INSERT INTO t2 VALUES (595,168102,29,'aims','index','commencements','FAS');










644



INSERT INTO t2 VALUES (596,168103,29,'Pakistani','commercially','gentleman','');










645



INSERT INTO t2 VALUES (597,168104,29,'burglarized','mistiness','gifted','');










646



INSERT INTO t2 VALUES (598,168202,29,'saucepans','endpoint','Shanghais','');










647



INSERT INTO t2 VALUES (599,168301,29,'lacerating','straight','sportswriting','A');










648



INSERT INTO t2 VALUES (600,168502,29,'corny','flurried','sloping','A');










649



INSERT INTO t2 VALUES (601,168503,29,'megabytes','denotative','navies','');










650



INSERT INTO t2 VALUES (602,168601,29,'chancellor','coming','leaflet','A');










651



INSERT INTO t2 VALUES (603,173001,40,'bulk','commencements','shooter','');










652



INSERT INTO t2 VALUES (604,173701,40,'commits','gentleman','Joplin','FAS');










653



INSERT INTO t2 VALUES (605,173702,40,'meson','gifted','babies','');










654



INSERT INTO t2 VALUES (606,176001,40,'deputies','Shanghais','subdivision','FAS');










655



INSERT INTO t2 VALUES (607,176101,40,'northeaster','sportswriting','burstiness','W');










656



INSERT INTO t2 VALUES (608,176201,40,'dipole','sloping','belted','FAS');










657



INSERT INTO t2 VALUES (609,176401,40,'machining','navies','assails','FAS');










658



INSERT INTO t2 VALUES (610,176501,40,'therefore','leaflet','admiring','W');










659



INSERT INTO t2 VALUES (611,176601,40,'Telefunken','shooter','swaying','0');










660



INSERT INTO t2 VALUES (612,176602,40,'salvaging','Joplin','Goldstine','FAS');










661



INSERT INTO t2 VALUES (613,176603,40,'Corinthianizes','babies','fitting','');










662



INSERT INTO t2 VALUES (614,178001,40,'restlessly','subdivision','Norwalk','W');










663



INSERT INTO t2 VALUES (615,178002,40,'bromides','burstiness','weakening','W');










664



INSERT INTO t2 VALUES (616,178003,40,'generalized','belted','analogy','FAS');










665



INSERT INTO t2 VALUES (617,178004,40,'mishaps','assails','deludes','');










666



INSERT INTO t2 VALUES (618,178005,40,'quelling','admiring','cokes','');










667



INSERT INTO t2 VALUES (619,178006,40,'spiritual','swaying','Clayton','');










668



INSERT INTO t2 VALUES (620,178007,40,'beguiles','Goldstine','exhausts','');










669



INSERT INTO t2 VALUES (621,178008,40,'Trobriand','fitting','causality','');










670



INSERT INTO t2 VALUES (622,178101,40,'fleeing','Norwalk','sating','FAS');










671



INSERT INTO t2 VALUES (623,178102,40,'Armour','weakening','icon','');










672



INSERT INTO t2 VALUES (624,178103,40,'chin','analogy','throttles','');










673



INSERT INTO t2 VALUES (625,178201,40,'provers','deludes','communicants','FAS');










674



INSERT INTO t2 VALUES (626,178202,40,'aeronautic','cokes','dehydrate','FAS');










675



INSERT INTO t2 VALUES (627,178301,40,'voltage','Clayton','priceless','FAS');










676



INSERT INTO t2 VALUES (628,178302,40,'sash','exhausts','publicly','');










677



INSERT INTO t2 VALUES (629,178401,40,'anaerobic','causality','incidentals','FAS');










678



INSERT INTO t2 VALUES (630,178402,40,'simultaneous','sating','commonplace','');










679



INSERT INTO t2 VALUES (631,178403,40,'accumulating','icon','mumbles','');










680



INSERT INTO t2 VALUES (632,178404,40,'Medusan','throttles','furthermore','W');










681



INSERT INTO t2 VALUES (633,178501,40,'shouted','communicants','cautioned','W');










682



INSERT INTO t2 VALUES (634,186002,37,'freakish','dehydrate','parametrized','A');










683



INSERT INTO t2 VALUES (635,186102,37,'index','priceless','registration','A');










684



INSERT INTO t2 VALUES (636,186201,40,'commercially','publicly','sadly','FAS');










685



INSERT INTO t2 VALUES (637,186202,40,'mistiness','incidentals','positioning','');










686



INSERT INTO t2 VALUES (638,186203,40,'endpoint','commonplace','babysitting','');










687



INSERT INTO t2 VALUES (639,186302,37,'straight','mumbles','eternal','A');










688



INSERT INTO t2 VALUES (640,188007,37,'flurried','furthermore','hoarder','');










689



INSERT INTO t2 VALUES (641,188008,37,'denotative','cautioned','congregates','');










690



INSERT INTO t2 VALUES (642,188009,37,'coming','parametrized','rains','');










691



INSERT INTO t2 VALUES (643,188010,37,'commencements','registration','workers','W');










692



INSERT INTO t2 VALUES (644,188011,37,'gentleman','sadly','sags','A');










693



INSERT INTO t2 VALUES (645,188012,37,'gifted','positioning','unplug','W');










694



INSERT INTO t2 VALUES (646,188013,37,'Shanghais','babysitting','garage','A');










695



INSERT INTO t2 VALUES (647,188014,37,'sportswriting','eternal','boulder','A');










696



INSERT INTO t2 VALUES (648,188015,37,'sloping','hoarder','hollowly','A');










697



INSERT INTO t2 VALUES (649,188016,37,'navies','congregates','specifics','');










698



INSERT INTO t2 VALUES (650,188017,37,'leaflet','rains','Teresa','');










699



INSERT INTO t2 VALUES (651,188102,37,'shooter','workers','Winsett','');










700



INSERT INTO t2 VALUES (652,188103,37,'Joplin','sags','convenient','A');










701



INSERT INTO t2 VALUES (653,188202,37,'babies','unplug','buckboards','FAS');










702



INSERT INTO t2 VALUES (654,188301,40,'subdivision','garage','amenities','');










703



INSERT INTO t2 VALUES (655,188302,40,'burstiness','boulder','resplendent','FAS');










704



INSERT INTO t2 VALUES (656,188303,40,'belted','hollowly','priding','FAS');










705



INSERT INTO t2 VALUES (657,188401,37,'assails','specifics','configurations','');










706



INSERT INTO t2 VALUES (658,188402,37,'admiring','Teresa','untidiness','A');










707



INSERT INTO t2 VALUES (659,188503,37,'swaying','Winsett','Brice','W');










708



INSERT INTO t2 VALUES (660,188504,37,'Goldstine','convenient','sews','FAS');










709



INSERT INTO t2 VALUES (661,188505,37,'fitting','buckboards','participated','');










710



INSERT INTO t2 VALUES (662,190701,37,'Norwalk','amenities','Simon','FAS');










711



INSERT INTO t2 VALUES (663,190703,50,'weakening','resplendent','certificates','');










712



INSERT INTO t2 VALUES (664,191701,37,'analogy','priding','Fitzpatrick','');










713



INSERT INTO t2 VALUES (665,191702,37,'deludes','configurations','Evanston','A');










714



INSERT INTO t2 VALUES (666,191703,37,'cokes','untidiness','misted','');










715



INSERT INTO t2 VALUES (667,196001,37,'Clayton','Brice','textures','A');










716



INSERT INTO t2 VALUES (668,196002,37,'exhausts','sews','save','');










717



INSERT INTO t2 VALUES (669,196003,37,'causality','participated','count','');










718



INSERT INTO t2 VALUES (670,196101,37,'sating','Simon','rightful','A');










719



INSERT INTO t2 VALUES (671,196103,37,'icon','certificates','chaperone','');










720



INSERT INTO t2 VALUES (672,196104,37,'throttles','Fitzpatrick','Lizzy','A');










721



INSERT INTO t2 VALUES (673,196201,37,'communicants','Evanston','clenched','A');










722



INSERT INTO t2 VALUES (674,196202,37,'dehydrate','misted','effortlessly','');










723



INSERT INTO t2 VALUES (675,196203,37,'priceless','textures','accessed','');










724



INSERT INTO t2 VALUES (676,198001,37,'publicly','save','beaters','A');










725



INSERT INTO t2 VALUES (677,198003,37,'incidentals','count','Hornblower','FAS');










726



INSERT INTO t2 VALUES (678,198004,37,'commonplace','rightful','vests','A');










727



INSERT INTO t2 VALUES (679,198005,37,'mumbles','chaperone','indulgences','FAS');










728



INSERT INTO t2 VALUES (680,198006,37,'furthermore','Lizzy','infallibly','A');










729



INSERT INTO t2 VALUES (681,198007,37,'cautioned','clenched','unwilling','FAS');










730



INSERT INTO t2 VALUES (682,198008,37,'parametrized','effortlessly','excrete','FAS');










731



INSERT INTO t2 VALUES (683,198009,37,'registration','accessed','spools','A');










732



INSERT INTO t2 VALUES (684,198010,37,'sadly','beaters','crunches','FAS');










733



INSERT INTO t2 VALUES (685,198011,37,'positioning','Hornblower','overestimating','FAS');










734



INSERT INTO t2 VALUES (686,198012,37,'babysitting','vests','ineffective','');










735



INSERT INTO t2 VALUES (687,198013,37,'eternal','indulgences','humiliation','A');










736



INSERT INTO t2 VALUES (688,198014,37,'hoarder','infallibly','sophomore','');










737



INSERT INTO t2 VALUES (689,198015,37,'congregates','unwilling','star','');










738



INSERT INTO t2 VALUES (690,198017,37,'rains','excrete','rifles','');










739



INSERT INTO t2 VALUES (691,198018,37,'workers','spools','dialysis','');










740



INSERT INTO t2 VALUES (692,198019,37,'sags','crunches','arriving','');










741



INSERT INTO t2 VALUES (693,198020,37,'unplug','overestimating','indulge','');










742



INSERT INTO t2 VALUES (694,198021,37,'garage','ineffective','clockers','');










743



INSERT INTO t2 VALUES (695,198022,37,'boulder','humiliation','languages','');










744



INSERT INTO t2 VALUES (696,198023,50,'hollowly','sophomore','Antarctica','A');










745



INSERT INTO t2 VALUES (697,198024,37,'specifics','star','percentage','');










746



INSERT INTO t2 VALUES (698,198101,37,'Teresa','rifles','ceiling','A');










747



INSERT INTO t2 VALUES (699,198103,37,'Winsett','dialysis','specification','');










748



INSERT INTO t2 VALUES (700,198105,37,'convenient','arriving','regimented','A');










749



INSERT INTO t2 VALUES (701,198106,37,'buckboards','indulge','ciphers','');










750



INSERT INTO t2 VALUES (702,198201,37,'amenities','clockers','pictures','A');










751



INSERT INTO t2 VALUES (703,198204,37,'resplendent','languages','serpents','A');










752



INSERT INTO t2 VALUES (704,198301,53,'priding','Antarctica','allot','A');










753



INSERT INTO t2 VALUES (705,198302,53,'configurations','percentage','realized','A');










754



INSERT INTO t2 VALUES (706,198303,53,'untidiness','ceiling','mayoral','A');










755



INSERT INTO t2 VALUES (707,198304,53,'Brice','specification','opaquely','A');










756



INSERT INTO t2 VALUES (708,198401,37,'sews','regimented','hostess','FAS');










757



INSERT INTO t2 VALUES (709,198402,37,'participated','ciphers','fiftieth','');










758



INSERT INTO t2 VALUES (710,198403,37,'Simon','pictures','incorrectly','');










759



INSERT INTO t2 VALUES (711,202101,37,'certificates','serpents','decomposition','FAS');










760



INSERT INTO t2 VALUES (712,202301,37,'Fitzpatrick','allot','stranglings','');










761



INSERT INTO t2 VALUES (713,202302,37,'Evanston','realized','mixture','FAS');










762



INSERT INTO t2 VALUES (714,202303,37,'misted','mayoral','electroencephalography','FAS');










763



INSERT INTO t2 VALUES (715,202304,37,'textures','opaquely','similarities','FAS');










764



INSERT INTO t2 VALUES (716,202305,37,'save','hostess','charges','W');










765



INSERT INTO t2 VALUES (717,202601,37,'count','fiftieth','freest','FAS');










766



INSERT INTO t2 VALUES (718,202602,37,'rightful','incorrectly','Greenberg','FAS');










767



INSERT INTO t2 VALUES (719,202605,37,'chaperone','decomposition','tinting','');










768



INSERT INTO t2 VALUES (720,202606,37,'Lizzy','stranglings','expelled','W');










769



INSERT INTO t2 VALUES (721,202607,37,'clenched','mixture','warm','');










770



INSERT INTO t2 VALUES (722,202901,37,'effortlessly','electroencephalography','smoothed','');










771



INSERT INTO t2 VALUES (723,202902,37,'accessed','similarities','deductions','FAS');










772



INSERT INTO t2 VALUES (724,202903,37,'beaters','charges','Romano','W');










773



INSERT INTO t2 VALUES (725,202904,37,'Hornblower','freest','bitterroot','');










774



INSERT INTO t2 VALUES (726,202907,37,'vests','Greenberg','corset','');










775



INSERT INTO t2 VALUES (727,202908,37,'indulgences','tinting','securing','');










776



INSERT INTO t2 VALUES (728,203101,37,'infallibly','expelled','environing','FAS');










777



INSERT INTO t2 VALUES (729,203103,37,'unwilling','warm','cute','');










778



INSERT INTO t2 VALUES (730,203104,37,'excrete','smoothed','Crays','');










779



INSERT INTO t2 VALUES (731,203105,37,'spools','deductions','heiress','FAS');










780



INSERT INTO t2 VALUES (732,203401,37,'crunches','Romano','inform','FAS');










781



INSERT INTO t2 VALUES (733,203402,37,'overestimating','bitterroot','avenge','');










782



INSERT INTO t2 VALUES (734,203404,37,'ineffective','corset','universals','');










783



INSERT INTO t2 VALUES (735,203901,37,'humiliation','securing','Kinsey','W');










784



INSERT INTO t2 VALUES (736,203902,37,'sophomore','environing','ravines','FAS');










785



INSERT INTO t2 VALUES (737,203903,37,'star','cute','bestseller','');










786



INSERT INTO t2 VALUES (738,203906,37,'rifles','Crays','equilibrium','');










787



INSERT INTO t2 VALUES (739,203907,37,'dialysis','heiress','extents','0');










788



INSERT INTO t2 VALUES (740,203908,37,'arriving','inform','relatively','');










789



INSERT INTO t2 VALUES (741,203909,37,'indulge','avenge','pressure','FAS');










790



INSERT INTO t2 VALUES (742,206101,37,'clockers','universals','critiques','FAS');










791



INSERT INTO t2 VALUES (743,206201,37,'languages','Kinsey','befouled','');










792



INSERT INTO t2 VALUES (744,206202,37,'Antarctica','ravines','rightfully','FAS');










793



INSERT INTO t2 VALUES (745,206203,37,'percentage','bestseller','mechanizing','FAS');










794



INSERT INTO t2 VALUES (746,206206,37,'ceiling','equilibrium','Latinizes','');










795



INSERT INTO t2 VALUES (747,206207,37,'specification','extents','timesharing','');










796



INSERT INTO t2 VALUES (748,206208,37,'regimented','relatively','Aden','');










797



INSERT INTO t2 VALUES (749,208001,37,'ciphers','pressure','embassies','');










798



INSERT INTO t2 VALUES (750,208002,37,'pictures','critiques','males','FAS');










799



INSERT INTO t2 VALUES (751,208003,37,'serpents','befouled','shapelessly','FAS');










800



INSERT INTO t2 VALUES (752,208004,37,'allot','rightfully','genres','FAS');










801



INSERT INTO t2 VALUES (753,208008,37,'realized','mechanizing','mastering','');










802



INSERT INTO t2 VALUES (754,208009,37,'mayoral','Latinizes','Newtonian','');










803



INSERT INTO t2 VALUES (755,208010,37,'opaquely','timesharing','finishers','FAS');










804



INSERT INTO t2 VALUES (756,208011,37,'hostess','Aden','abates','');










805



INSERT INTO t2 VALUES (757,208101,37,'fiftieth','embassies','teem','');










806



INSERT INTO t2 VALUES (758,208102,37,'incorrectly','males','kiting','FAS');










807



INSERT INTO t2 VALUES (759,208103,37,'decomposition','shapelessly','stodgy','FAS');










808



INSERT INTO t2 VALUES (760,208104,37,'stranglings','genres','scalps','FAS');










809



INSERT INTO t2 VALUES (761,208105,37,'mixture','mastering','feed','FAS');










810



INSERT INTO t2 VALUES (762,208110,37,'electroencephalography','Newtonian','guitars','');










811



INSERT INTO t2 VALUES (763,208111,37,'similarities','finishers','airships','');










812



INSERT INTO t2 VALUES (764,208112,37,'charges','abates','store','');










813



INSERT INTO t2 VALUES (765,208113,37,'freest','teem','denounces','');










814



INSERT INTO t2 VALUES (766,208201,37,'Greenberg','kiting','Pyle','FAS');










815



INSERT INTO t2 VALUES (767,208203,37,'tinting','stodgy','Saxony','');










816



INSERT INTO t2 VALUES (768,208301,37,'expelled','scalps','serializations','FAS');










817



INSERT INTO t2 VALUES (769,208302,37,'warm','feed','Peruvian','FAS');










818



INSERT INTO t2 VALUES (770,208305,37,'smoothed','guitars','taxonomically','FAS');










819



INSERT INTO t2 VALUES (771,208401,37,'deductions','airships','kingdom','A');










820



INSERT INTO t2 VALUES (772,208402,37,'Romano','store','stint','A');










821



INSERT INTO t2 VALUES (773,208403,37,'bitterroot','denounces','Sault','A');










822



INSERT INTO t2 VALUES (774,208404,37,'corset','Pyle','faithful','');










823



INSERT INTO t2 VALUES (775,208501,37,'securing','Saxony','Ganymede','FAS');










824



INSERT INTO t2 VALUES (776,208502,37,'environing','serializations','tidiness','FAS');










825



INSERT INTO t2 VALUES (777,208503,37,'cute','Peruvian','gainful','FAS');










826



INSERT INTO t2 VALUES (778,208504,37,'Crays','taxonomically','contrary','FAS');










827



INSERT INTO t2 VALUES (779,208505,37,'heiress','kingdom','Tipperary','FAS');










828



INSERT INTO t2 VALUES (780,210101,37,'inform','stint','tropics','W');










829



INSERT INTO t2 VALUES (781,210102,37,'avenge','Sault','theorizers','');










830



INSERT INTO t2 VALUES (782,210103,37,'universals','faithful','renew','0');










831



INSERT INTO t2 VALUES (783,210104,37,'Kinsey','Ganymede','already','');










832



INSERT INTO t2 VALUES (784,210105,37,'ravines','tidiness','terminal','');










833



INSERT INTO t2 VALUES (785,210106,37,'bestseller','gainful','Hegelian','');










834



INSERT INTO t2 VALUES (786,210107,37,'equilibrium','contrary','hypothesizer','');










835



INSERT INTO t2 VALUES (787,210401,37,'extents','Tipperary','warningly','FAS');










836



INSERT INTO t2 VALUES (788,213201,37,'relatively','tropics','journalizing','FAS');










837



INSERT INTO t2 VALUES (789,213203,37,'pressure','theorizers','nested','');










838



INSERT INTO t2 VALUES (790,213204,37,'critiques','renew','Lars','');










839



INSERT INTO t2 VALUES (791,213205,37,'befouled','already','saplings','');










840



INSERT INTO t2 VALUES (792,213206,37,'rightfully','terminal','foothill','');










841



INSERT INTO t2 VALUES (793,213207,37,'mechanizing','Hegelian','labeled','');










842



INSERT INTO t2 VALUES (794,216101,37,'Latinizes','hypothesizer','imperiously','FAS');










843



INSERT INTO t2 VALUES (795,216103,37,'timesharing','warningly','reporters','FAS');










844



INSERT INTO t2 VALUES (796,218001,37,'Aden','journalizing','furnishings','FAS');










845



INSERT INTO t2 VALUES (797,218002,37,'embassies','nested','precipitable','FAS');










846



INSERT INTO t2 VALUES (798,218003,37,'males','Lars','discounts','FAS');










847



INSERT INTO t2 VALUES (799,218004,37,'shapelessly','saplings','excises','FAS');










848



INSERT INTO t2 VALUES (800,143503,50,'genres','foothill','Stalin','');










849



INSERT INTO t2 VALUES (801,218006,37,'mastering','labeled','despot','FAS');










850



INSERT INTO t2 VALUES (802,218007,37,'Newtonian','imperiously','ripeness','FAS');










851



INSERT INTO t2 VALUES (803,218008,37,'finishers','reporters','Arabia','');










852



INSERT INTO t2 VALUES (804,218009,37,'abates','furnishings','unruly','');










853



INSERT INTO t2 VALUES (805,218010,37,'teem','precipitable','mournfulness','');










854



INSERT INTO t2 VALUES (806,218011,37,'kiting','discounts','boom','FAS');










855



INSERT INTO t2 VALUES (807,218020,37,'stodgy','excises','slaughter','A');










856



INSERT INTO t2 VALUES (808,218021,50,'scalps','Stalin','Sabine','');










857



INSERT INTO t2 VALUES (809,218022,37,'feed','despot','handy','FAS');










858



INSERT INTO t2 VALUES (810,218023,37,'guitars','ripeness','rural','');










859



INSERT INTO t2 VALUES (811,218024,37,'airships','Arabia','organizer','');










860



INSERT INTO t2 VALUES (812,218101,37,'store','unruly','shipyard','FAS');










861



INSERT INTO t2 VALUES (813,218102,37,'denounces','mournfulness','civics','FAS');










862



INSERT INTO t2 VALUES (814,218103,37,'Pyle','boom','inaccuracy','FAS');










863



INSERT INTO t2 VALUES (815,218201,37,'Saxony','slaughter','rules','FAS');










864



INSERT INTO t2 VALUES (816,218202,37,'serializations','Sabine','juveniles','FAS');










865



INSERT INTO t2 VALUES (817,218203,37,'Peruvian','handy','comprised','W');










866



INSERT INTO t2 VALUES (818,218204,37,'taxonomically','rural','investigations','');










867



INSERT INTO t2 VALUES (819,218205,37,'kingdom','organizer','stabilizes','A');










868



INSERT INTO t2 VALUES (820,218301,37,'stint','shipyard','seminaries','FAS');










869



INSERT INTO t2 VALUES (821,218302,37,'Sault','civics','Hunter','A');










870



INSERT INTO t2 VALUES (822,218401,37,'faithful','inaccuracy','sporty','FAS');










871



INSERT INTO t2 VALUES (823,218402,37,'Ganymede','rules','test','FAS');










872



INSERT INTO t2 VALUES (824,218403,37,'tidiness','juveniles','weasels','');










873



INSERT INTO t2 VALUES (825,218404,37,'gainful','comprised','CERN','');










874



INSERT INTO t2 VALUES (826,218407,37,'contrary','investigations','tempering','');










875



INSERT INTO t2 VALUES (827,218408,37,'Tipperary','stabilizes','afore','FAS');










876



INSERT INTO t2 VALUES (828,218409,37,'tropics','seminaries','Galatean','');










877



INSERT INTO t2 VALUES (829,218410,37,'theorizers','Hunter','techniques','W');










878



INSERT INTO t2 VALUES (830,226001,37,'renew','sporty','error','');










879



INSERT INTO t2 VALUES (831,226002,37,'already','test','veranda','');










880



INSERT INTO t2 VALUES (832,226003,37,'terminal','weasels','severely','');










881



INSERT INTO t2 VALUES (833,226004,37,'Hegelian','CERN','Cassites','FAS');










882



INSERT INTO t2 VALUES (834,226005,37,'hypothesizer','tempering','forthcoming','');










883



INSERT INTO t2 VALUES (835,226006,37,'warningly','afore','guides','');










884



INSERT INTO t2 VALUES (836,226007,37,'journalizing','Galatean','vanish','FAS');










885



INSERT INTO t2 VALUES (837,226008,37,'nested','techniques','lied','A');










886



INSERT INTO t2 VALUES (838,226203,37,'Lars','error','sawtooth','FAS');










887



INSERT INTO t2 VALUES (839,226204,37,'saplings','veranda','fated','FAS');










888



INSERT INTO t2 VALUES (840,226205,37,'foothill','severely','gradually','');










889



INSERT INTO t2 VALUES (841,226206,37,'labeled','Cassites','widens','');










890



INSERT INTO t2 VALUES (842,226207,37,'imperiously','forthcoming','preclude','');










891



INSERT INTO t2 VALUES (843,226208,37,'reporters','guides','Jobrel','');










892



INSERT INTO t2 VALUES (844,226209,37,'furnishings','vanish','hooker','');










893



INSERT INTO t2 VALUES (845,226210,37,'precipitable','lied','rainstorm','');










894



INSERT INTO t2 VALUES (846,226211,37,'discounts','sawtooth','disconnects','');










895



INSERT INTO t2 VALUES (847,228001,37,'excises','fated','cruelty','');










896



INSERT INTO t2 VALUES (848,228004,37,'Stalin','gradually','exponentials','A');










897



INSERT INTO t2 VALUES (849,228005,37,'despot','widens','affective','A');










898



INSERT INTO t2 VALUES (850,228006,37,'ripeness','preclude','arteries','');










899



INSERT INTO t2 VALUES (851,228007,37,'Arabia','Jobrel','Crosby','FAS');










900



INSERT INTO t2 VALUES (852,228008,37,'unruly','hooker','acquaint','');










901



INSERT INTO t2 VALUES (853,228009,37,'mournfulness','rainstorm','evenhandedly','');










902



INSERT INTO t2 VALUES (854,228101,37,'boom','disconnects','percentage','');










903



INSERT INTO t2 VALUES (855,228108,37,'slaughter','cruelty','disobedience','');










904



INSERT INTO t2 VALUES (856,228109,37,'Sabine','exponentials','humility','');










905



INSERT INTO t2 VALUES (857,228110,37,'handy','affective','gleaning','A');










906



INSERT INTO t2 VALUES (858,228111,37,'rural','arteries','petted','A');










907



INSERT INTO t2 VALUES (859,228112,37,'organizer','Crosby','bloater','A');










908



INSERT INTO t2 VALUES (860,228113,37,'shipyard','acquaint','minion','A');










909



INSERT INTO t2 VALUES (861,228114,37,'civics','evenhandedly','marginal','A');










910



INSERT INTO t2 VALUES (862,228115,37,'inaccuracy','percentage','apiary','A');










911



INSERT INTO t2 VALUES (863,228116,37,'rules','disobedience','measures','');










912



INSERT INTO t2 VALUES (864,228117,37,'juveniles','humility','precaution','');










913



INSERT INTO t2 VALUES (865,228118,37,'comprised','gleaning','repelled','');










914



INSERT INTO t2 VALUES (866,228119,37,'investigations','petted','primary','FAS');










915



INSERT INTO t2 VALUES (867,228120,37,'stabilizes','bloater','coverings','');










916



INSERT INTO t2 VALUES (868,228121,37,'seminaries','minion','Artemia','A');










917



INSERT INTO t2 VALUES (869,228122,37,'Hunter','marginal','navigate','');










918



INSERT INTO t2 VALUES (870,228201,37,'sporty','apiary','spatial','');










919



INSERT INTO t2 VALUES (871,228206,37,'test','measures','Gurkha','');










920



INSERT INTO t2 VALUES (872,228207,37,'weasels','precaution','meanwhile','A');










921



INSERT INTO t2 VALUES (873,228208,37,'CERN','repelled','Melinda','A');










922



INSERT INTO t2 VALUES (874,228209,37,'tempering','primary','Butterfield','');










923



INSERT INTO t2 VALUES (875,228210,37,'afore','coverings','Aldrich','A');










924



INSERT INTO t2 VALUES (876,228211,37,'Galatean','Artemia','previewing','A');










925



INSERT INTO t2 VALUES (877,228212,37,'techniques','navigate','glut','A');










926



INSERT INTO t2 VALUES (878,228213,37,'error','spatial','unaffected','');










927



INSERT INTO t2 VALUES (879,228214,37,'veranda','Gurkha','inmate','');










928



INSERT INTO t2 VALUES (880,228301,37,'severely','meanwhile','mineral','');










929



INSERT INTO t2 VALUES (881,228305,37,'Cassites','Melinda','impending','A');










930



INSERT INTO t2 VALUES (882,228306,37,'forthcoming','Butterfield','meditation','A');










931



INSERT INTO t2 VALUES (883,228307,37,'guides','Aldrich','ideas','');










932



INSERT INTO t2 VALUES (884,228308,37,'vanish','previewing','miniaturizes','W');










933



INSERT INTO t2 VALUES (885,228309,37,'lied','glut','lewdly','');










934



INSERT INTO t2 VALUES (886,228310,37,'sawtooth','unaffected','title','');










935



INSERT INTO t2 VALUES (887,228311,37,'fated','inmate','youthfulness','');










936



INSERT INTO t2 VALUES (888,228312,37,'gradually','mineral','creak','FAS');










937



INSERT INTO t2 VALUES (889,228313,37,'widens','impending','Chippewa','');










938



INSERT INTO t2 VALUES (890,228314,37,'preclude','meditation','clamored','');










939



INSERT INTO t2 VALUES (891,228401,65,'Jobrel','ideas','freezes','');










940



INSERT INTO t2 VALUES (892,228402,65,'hooker','miniaturizes','forgivably','FAS');










941



INSERT INTO t2 VALUES (893,228403,65,'rainstorm','lewdly','reduce','FAS');










942



INSERT INTO t2 VALUES (894,228404,65,'disconnects','title','McGovern','W');










943



INSERT INTO t2 VALUES (895,228405,65,'cruelty','youthfulness','Nazis','W');










944



INSERT INTO t2 VALUES (896,228406,65,'exponentials','creak','epistle','W');










945



INSERT INTO t2 VALUES (897,228407,65,'affective','Chippewa','socializes','W');










946



INSERT INTO t2 VALUES (898,228408,65,'arteries','clamored','conceptions','');










947



INSERT INTO t2 VALUES (899,228409,65,'Crosby','freezes','Kevin','');










948



INSERT INTO t2 VALUES (900,228410,65,'acquaint','forgivably','uncovering','');










949



INSERT INTO t2 VALUES (901,230301,37,'evenhandedly','reduce','chews','FAS');










950



INSERT INTO t2 VALUES (902,230302,37,'percentage','McGovern','appendixes','FAS');










951



INSERT INTO t2 VALUES (903,230303,37,'disobedience','Nazis','raining','');










952



INSERT INTO t2 VALUES (904,018062,37,'humility','epistle','infest','');










953



INSERT INTO t2 VALUES (905,230501,37,'gleaning','socializes','compartment','');










954



INSERT INTO t2 VALUES (906,230502,37,'petted','conceptions','minting','');










955



INSERT INTO t2 VALUES (907,230503,37,'bloater','Kevin','ducks','');










956



INSERT INTO t2 VALUES (908,230504,37,'minion','uncovering','roped','A');










957



INSERT INTO t2 VALUES (909,230505,37,'marginal','chews','waltz','');










958



INSERT INTO t2 VALUES (910,230506,37,'apiary','appendixes','Lillian','');










959



INSERT INTO t2 VALUES (911,230507,37,'measures','raining','repressions','A');










960



INSERT INTO t2 VALUES (912,230508,37,'precaution','infest','chillingly','');










961



INSERT INTO t2 VALUES (913,230509,37,'repelled','compartment','noncritical','');










962



INSERT INTO t2 VALUES (914,230901,37,'primary','minting','lithograph','');










963



INSERT INTO t2 VALUES (915,230902,37,'coverings','ducks','spongers','');










964



INSERT INTO t2 VALUES (916,230903,37,'Artemia','roped','parenthood','');










965



INSERT INTO t2 VALUES (917,230904,37,'navigate','waltz','posed','');










966



INSERT INTO t2 VALUES (918,230905,37,'spatial','Lillian','instruments','');










967



INSERT INTO t2 VALUES (919,230906,37,'Gurkha','repressions','filial','');










968



INSERT INTO t2 VALUES (920,230907,37,'meanwhile','chillingly','fixedly','');










969



INSERT INTO t2 VALUES (921,230908,37,'Melinda','noncritical','relives','');










970



INSERT INTO t2 VALUES (922,230909,37,'Butterfield','lithograph','Pandora','');










971



INSERT INTO t2 VALUES (923,230910,37,'Aldrich','spongers','watering','A');










972



INSERT INTO t2 VALUES (924,230911,37,'previewing','parenthood','ungrateful','');










973



INSERT INTO t2 VALUES (925,230912,37,'glut','posed','secures','');










974



INSERT INTO t2 VALUES (926,230913,37,'unaffected','instruments','chastisers','');










975



INSERT INTO t2 VALUES (927,230914,37,'inmate','filial','icon','');










976



INSERT INTO t2 VALUES (928,231304,37,'mineral','fixedly','reuniting','A');










977



INSERT INTO t2 VALUES (929,231305,37,'impending','relives','imagining','A');










978



INSERT INTO t2 VALUES (930,231306,37,'meditation','Pandora','abiding','A');










979



INSERT INTO t2 VALUES (931,231307,37,'ideas','watering','omnisciently','');










980



INSERT INTO t2 VALUES (932,231308,37,'miniaturizes','ungrateful','Britannic','');










981



INSERT INTO t2 VALUES (933,231309,37,'lewdly','secures','scholastics','A');










982



INSERT INTO t2 VALUES (934,231310,37,'title','chastisers','mechanics','A');










983



INSERT INTO t2 VALUES (935,231311,37,'youthfulness','icon','humidly','A');










984



INSERT INTO t2 VALUES (936,231312,37,'creak','reuniting','masterpiece','');










985



INSERT INTO t2 VALUES (937,231313,37,'Chippewa','imagining','however','');










986



INSERT INTO t2 VALUES (938,231314,37,'clamored','abiding','Mendelian','');










987



INSERT INTO t2 VALUES (939,231315,37,'freezes','omnisciently','jarred','');










988



INSERT INTO t2 VALUES (940,232102,37,'forgivably','Britannic','scolds','');










989



INSERT INTO t2 VALUES (941,232103,37,'reduce','scholastics','infatuate','');










990



INSERT INTO t2 VALUES (942,232104,37,'McGovern','mechanics','willed','A');










991



INSERT INTO t2 VALUES (943,232105,37,'Nazis','humidly','joyfully','');










992



INSERT INTO t2 VALUES (944,232106,37,'epistle','masterpiece','Microsoft','');










993



INSERT INTO t2 VALUES (945,232107,37,'socializes','however','fibrosities','');










994



INSERT INTO t2 VALUES (946,232108,37,'conceptions','Mendelian','Baltimorean','');










995



INSERT INTO t2 VALUES (947,232601,37,'Kevin','jarred','equestrian','');










996



INSERT INTO t2 VALUES (948,232602,37,'uncovering','scolds','Goodrich','');










997



INSERT INTO t2 VALUES (949,232603,37,'chews','infatuate','apish','A');










998



INSERT INTO t2 VALUES (950,232605,37,'appendixes','willed','Adlerian','');










999



INSERT INTO t2 VALUES (5950,1232605,37,'appendixes','willed','Adlerian','');










1000



INSERT INTO t2 VALUES (5951,1232606,37,'appendixes','willed','Adlerian','');










1001



INSERT INTO t2 VALUES (5952,1232607,37,'appendixes','willed','Adlerian','');










1002



INSERT INTO t2 VALUES (5953,1232608,37,'appendixes','willed','Adlerian','');










1003



INSERT INTO t2 VALUES (5954,1232609,37,'appendixes','willed','Adlerian','');










1004



INSERT INTO t2 VALUES (951,232606,37,'raining','joyfully','Tropez','');










1005



INSERT INTO t2 VALUES (952,232607,37,'infest','Microsoft','nouns','');










1006



INSERT INTO t2 VALUES (953,232608,37,'compartment','fibrosities','distracting','');










1007



INSERT INTO t2 VALUES (954,232609,37,'minting','Baltimorean','mutton','');










1008



INSERT INTO t2 VALUES (955,236104,37,'ducks','equestrian','bridgeable','A');










1009



INSERT INTO t2 VALUES (956,236105,37,'roped','Goodrich','stickers','A');










1010



INSERT INTO t2 VALUES (957,236106,37,'waltz','apish','transcontinental','A');










1011



INSERT INTO t2 VALUES (958,236107,37,'Lillian','Adlerian','amateurish','');










1012



INSERT INTO t2 VALUES (959,236108,37,'repressions','Tropez','Gandhian','');










1013



INSERT INTO t2 VALUES (960,236109,37,'chillingly','nouns','stratified','');










1014



INSERT INTO t2 VALUES (961,236110,37,'noncritical','distracting','chamberlains','');










1015



INSERT INTO t2 VALUES (962,236111,37,'lithograph','mutton','creditably','');










1016



INSERT INTO t2 VALUES (963,236112,37,'spongers','bridgeable','philosophic','');










1017



INSERT INTO t2 VALUES (964,236113,37,'parenthood','stickers','ores','');










1018



INSERT INTO t2 VALUES (965,238005,37,'posed','transcontinental','Carleton','');










1019



INSERT INTO t2 VALUES (966,238006,37,'instruments','amateurish','tape','A');










1020



INSERT INTO t2 VALUES (967,238007,37,'filial','Gandhian','afloat','A');










1021



INSERT INTO t2 VALUES (968,238008,37,'fixedly','stratified','goodness','A');










1022



INSERT INTO t2 VALUES (969,238009,37,'relives','chamberlains','welcoming','');










1023



INSERT INTO t2 VALUES (970,238010,37,'Pandora','creditably','Pinsky','FAS');










1024



INSERT INTO t2 VALUES (971,238011,37,'watering','philosophic','halting','');










1025



INSERT INTO t2 VALUES (972,238012,37,'ungrateful','ores','bibliography','');










1026



INSERT INTO t2 VALUES (973,238013,37,'secures','Carleton','decoding','');










1027



INSERT INTO t2 VALUES (974,240401,41,'chastisers','tape','variance','A');










1028



INSERT INTO t2 VALUES (975,240402,41,'icon','afloat','allowed','A');










1029



INSERT INTO t2 VALUES (976,240901,41,'reuniting','goodness','dire','A');










1030



INSERT INTO t2 VALUES (977,240902,41,'imagining','welcoming','dub','A');










1031



INSERT INTO t2 VALUES (978,241801,41,'abiding','Pinsky','poisoning','');










1032



INSERT INTO t2 VALUES (979,242101,41,'omnisciently','halting','Iraqis','A');










1033



INSERT INTO t2 VALUES (980,242102,41,'Britannic','bibliography','heaving','');










1034



INSERT INTO t2 VALUES (981,242201,41,'scholastics','decoding','population','A');










1035



INSERT INTO t2 VALUES (982,242202,41,'mechanics','variance','bomb','A');










1036



INSERT INTO t2 VALUES (983,242501,41,'humidly','allowed','Majorca','A');










1037



INSERT INTO t2 VALUES (984,242502,41,'masterpiece','dire','Gershwins','');










1038



INSERT INTO t2 VALUES (985,246201,41,'however','dub','explorers','');










1039



INSERT INTO t2 VALUES (986,246202,41,'Mendelian','poisoning','libretto','A');










1040



INSERT INTO t2 VALUES (987,246203,41,'jarred','Iraqis','occurred','');










1041



INSERT INTO t2 VALUES (988,246204,41,'scolds','heaving','Lagos','');










1042



INSERT INTO t2 VALUES (989,246205,41,'infatuate','population','rats','');










1043



INSERT INTO t2 VALUES (990,246301,41,'willed','bomb','bankruptcies','A');










1044



INSERT INTO t2 VALUES (991,246302,41,'joyfully','Majorca','crying','');










1045



INSERT INTO t2 VALUES (992,248001,41,'Microsoft','Gershwins','unexpected','');










1046



INSERT INTO t2 VALUES (993,248002,41,'fibrosities','explorers','accessed','A');










1047



INSERT INTO t2 VALUES (994,248003,41,'Baltimorean','libretto','colorful','A');










1048



INSERT INTO t2 VALUES (995,248004,41,'equestrian','occurred','versatility','A');










1049



INSERT INTO t2 VALUES (996,248005,41,'Goodrich','Lagos','cosy','');










1050



INSERT INTO t2 VALUES (997,248006,41,'apish','rats','Darius','A');










1051



INSERT INTO t2 VALUES (998,248007,41,'Adlerian','bankruptcies','mastering','A');










1052



INSERT INTO t2 VALUES (999,248008,41,'Tropez','crying','Asiaticizations','A');










1053



INSERT INTO t2 VALUES (1000,248009,41,'nouns','unexpected','offerers','A');










1054



INSERT INTO t2 VALUES (1001,248010,41,'distracting','accessed','uncles','A');










1055



INSERT INTO t2 VALUES (1002,248011,41,'mutton','colorful','sleepwalk','');










1056



INSERT INTO t2 VALUES (1003,248012,41,'bridgeable','versatility','Ernestine','');










1057



INSERT INTO t2 VALUES (1004,248013,41,'stickers','cosy','checksumming','');










1058



INSERT INTO t2 VALUES (1005,248014,41,'transcontinental','Darius','stopped','');










1059



INSERT INTO t2 VALUES (1006,248015,41,'amateurish','mastering','sicker','');










1060



INSERT INTO t2 VALUES (1007,248016,41,'Gandhian','Asiaticizations','Italianization','');










1061



INSERT INTO t2 VALUES (1008,248017,41,'stratified','offerers','alphabetic','');










1062



INSERT INTO t2 VALUES (1009,248018,41,'chamberlains','uncles','pharmaceutic','');










1063



INSERT INTO t2 VALUES (1010,248019,41,'creditably','sleepwalk','creator','');










1064



INSERT INTO t2 VALUES (1011,248020,41,'philosophic','Ernestine','chess','');










1065



INSERT INTO t2 VALUES (1012,248021,41,'ores','checksumming','charcoal','');










1066



INSERT INTO t2 VALUES (1013,248101,41,'Carleton','stopped','Epiphany','A');










1067



INSERT INTO t2 VALUES (1014,248102,41,'tape','sicker','bulldozes','A');










1068



INSERT INTO t2 VALUES (1015,248201,41,'afloat','Italianization','Pygmalion','A');










1069



INSERT INTO t2 VALUES (1016,248202,41,'goodness','alphabetic','caressing','A');










1070



INSERT INTO t2 VALUES (1017,248203,41,'welcoming','pharmaceutic','Palestine','A');










1071



INSERT INTO t2 VALUES (1018,248204,41,'Pinsky','creator','regimented','A');










1072



INSERT INTO t2 VALUES (1019,248205,41,'halting','chess','scars','A');










1073



INSERT INTO t2 VALUES (1020,248206,41,'bibliography','charcoal','realest','A');










1074



INSERT INTO t2 VALUES (1021,248207,41,'decoding','Epiphany','diffusing','A');










1075



INSERT INTO t2 VALUES (1022,248208,41,'variance','bulldozes','clubroom','A');










1076



INSERT INTO t2 VALUES (1023,248209,41,'allowed','Pygmalion','Blythe','A');










1077



INSERT INTO t2 VALUES (1024,248210,41,'dire','caressing','ahead','');










1078



INSERT INTO t2 VALUES (1025,248211,50,'dub','Palestine','reviver','');










1079



INSERT INTO t2 VALUES (1026,250501,34,'poisoning','regimented','retransmitting','A');










1080



INSERT INTO t2 VALUES (1027,250502,34,'Iraqis','scars','landslide','');










1081



INSERT INTO t2 VALUES (1028,250503,34,'heaving','realest','Eiffel','');










1082



INSERT INTO t2 VALUES (1029,250504,34,'population','diffusing','absentee','');










1083



INSERT INTO t2 VALUES (1030,250505,34,'bomb','clubroom','aye','');










1084



INSERT INTO t2 VALUES (1031,250601,34,'Majorca','Blythe','forked','A');










1085



INSERT INTO t2 VALUES (1032,250602,34,'Gershwins','ahead','Peruvianizes','');










1086



INSERT INTO t2 VALUES (1033,250603,34,'explorers','reviver','clerked','');










1087



INSERT INTO t2 VALUES (1034,250604,34,'libretto','retransmitting','tutor','');










1088



INSERT INTO t2 VALUES (1035,250605,34,'occurred','landslide','boulevard','');










1089



INSERT INTO t2 VALUES (1036,251001,34,'Lagos','Eiffel','shuttered','');










1090



INSERT INTO t2 VALUES (1037,251002,34,'rats','absentee','quotes','A');










1091



INSERT INTO t2 VALUES (1038,251003,34,'bankruptcies','aye','Caltech','');










1092



INSERT INTO t2 VALUES (1039,251004,34,'crying','forked','Mossberg','');










1093



INSERT INTO t2 VALUES (1040,251005,34,'unexpected','Peruvianizes','kept','');










1094



INSERT INTO t2 VALUES (1041,251301,34,'accessed','clerked','roundly','');










1095



INSERT INTO t2 VALUES (1042,251302,34,'colorful','tutor','features','A');










1096



INSERT INTO t2 VALUES (1043,251303,34,'versatility','boulevard','imaginable','A');










1097



INSERT INTO t2 VALUES (1044,251304,34,'cosy','shuttered','controller','');










1098



INSERT INTO t2 VALUES (1045,251305,34,'Darius','quotes','racial','');










1099



INSERT INTO t2 VALUES (1046,251401,34,'mastering','Caltech','uprisings','A');










1100



INSERT INTO t2 VALUES (1047,251402,34,'Asiaticizations','Mossberg','narrowed','A');










1101



INSERT INTO t2 VALUES (1048,251403,34,'offerers','kept','cannot','A');










1102



INSERT INTO t2 VALUES (1049,251404,34,'uncles','roundly','vest','');










1103



INSERT INTO t2 VALUES (1050,251405,34,'sleepwalk','features','famine','');










1104



INSERT INTO t2 VALUES (1051,251406,34,'Ernestine','imaginable','sugars','');










1105



INSERT INTO t2 VALUES (1052,251801,34,'checksumming','controller','exterminated','A');










1106



INSERT INTO t2 VALUES (1053,251802,34,'stopped','racial','belays','');










1107



INSERT INTO t2 VALUES (1054,252101,34,'sicker','uprisings','Hodges','A');










1108



INSERT INTO t2 VALUES (1055,252102,34,'Italianization','narrowed','translatable','');










1109



INSERT INTO t2 VALUES (1056,252301,34,'alphabetic','cannot','duality','A');










1110



INSERT INTO t2 VALUES (1057,252302,34,'pharmaceutic','vest','recording','A');










1111



INSERT INTO t2 VALUES (1058,252303,34,'creator','famine','rouses','A');










1112



INSERT INTO t2 VALUES (1059,252304,34,'chess','sugars','poison','');










1113



INSERT INTO t2 VALUES (1060,252305,34,'charcoal','exterminated','attitude','');










1114



INSERT INTO t2 VALUES (1061,252306,34,'Epiphany','belays','dusted','');










1115



INSERT INTO t2 VALUES (1062,252307,34,'bulldozes','Hodges','encompasses','');










1116



INSERT INTO t2 VALUES (1063,252308,34,'Pygmalion','translatable','presentation','');










1117



INSERT INTO t2 VALUES (1064,252309,34,'caressing','duality','Kantian','');










1118



INSERT INTO t2 VALUES (1065,256001,34,'Palestine','recording','imprecision','A');










1119



INSERT INTO t2 VALUES (1066,256002,34,'regimented','rouses','saving','');










1120



INSERT INTO t2 VALUES (1067,256003,34,'scars','poison','maternal','');










1121



INSERT INTO t2 VALUES (1068,256004,34,'realest','attitude','hewed','');










1122



INSERT INTO t2 VALUES (1069,256005,34,'diffusing','dusted','kerosene','');










1123



INSERT INTO t2 VALUES (1070,258001,34,'clubroom','encompasses','Cubans','');










1124



INSERT INTO t2 VALUES (1071,258002,34,'Blythe','presentation','photographers','');










1125



INSERT INTO t2 VALUES (1072,258003,34,'ahead','Kantian','nymph','A');










1126



INSERT INTO t2 VALUES (1073,258004,34,'reviver','imprecision','bedlam','A');










1127



INSERT INTO t2 VALUES (1074,258005,34,'retransmitting','saving','north','A');










1128



INSERT INTO t2 VALUES (1075,258006,34,'landslide','maternal','Schoenberg','A');










1129



INSERT INTO t2 VALUES (1076,258007,34,'Eiffel','hewed','botany','A');










1130



INSERT INTO t2 VALUES (1077,258008,34,'absentee','kerosene','curs','');










1131



INSERT INTO t2 VALUES (1078,258009,34,'aye','Cubans','solidification','');










1132



INSERT INTO t2 VALUES (1079,258010,34,'forked','photographers','inheritresses','');










1133



INSERT INTO t2 VALUES (1080,258011,34,'Peruvianizes','nymph','stiller','');










1134



INSERT INTO t2 VALUES (1081,258101,68,'clerked','bedlam','t1','A');










1135



INSERT INTO t2 VALUES (1082,258102,68,'tutor','north','suite','A');










1136



INSERT INTO t2 VALUES (1083,258103,34,'boulevard','Schoenberg','ransomer','');










1137



INSERT INTO t2 VALUES (1084,258104,68,'shuttered','botany','Willy','');










1138



INSERT INTO t2 VALUES (1085,258105,68,'quotes','curs','Rena','A');










1139



INSERT INTO t2 VALUES (1086,258106,68,'Caltech','solidification','Seattle','A');










1140



INSERT INTO t2 VALUES (1087,258107,68,'Mossberg','inheritresses','relaxes','A');










1141



INSERT INTO t2 VALUES (1088,258108,68,'kept','stiller','exclaim','');










1142



INSERT INTO t2 VALUES (1089,258109,68,'roundly','t1','implicated','A');










1143



INSERT INTO t2 VALUES (1090,258110,68,'features','suite','distinguish','');










1144



INSERT INTO t2 VALUES (1091,258111,68,'imaginable','ransomer','assayed','');










1145



INSERT INTO t2 VALUES (1092,258112,68,'controller','Willy','homeowner','');










1146



INSERT INTO t2 VALUES (1093,258113,68,'racial','Rena','and','');










1147



INSERT INTO t2 VALUES (1094,258201,34,'uprisings','Seattle','stealth','');










1148



INSERT INTO t2 VALUES (1095,258202,34,'narrowed','relaxes','coinciding','A');










1149



INSERT INTO t2 VALUES (1096,258203,34,'cannot','exclaim','founder','A');










1150



INSERT INTO t2 VALUES (1097,258204,34,'vest','implicated','environing','');










1151



INSERT INTO t2 VALUES (1098,258205,34,'famine','distinguish','jewelry','');










1152



INSERT INTO t2 VALUES (1099,258301,34,'sugars','assayed','lemons','A');










1153



INSERT INTO t2 VALUES (1100,258401,34,'exterminated','homeowner','brokenness','A');










1154



INSERT INTO t2 VALUES (1101,258402,34,'belays','and','bedpost','A');










1155



INSERT INTO t2 VALUES (1102,258403,34,'Hodges','stealth','assurers','A');










1156



INSERT INTO t2 VALUES (1103,258404,34,'translatable','coinciding','annoyers','');










1157



INSERT INTO t2 VALUES (1104,258405,34,'duality','founder','affixed','');










1158



INSERT INTO t2 VALUES (1105,258406,34,'recording','environing','warbling','');










1159



INSERT INTO t2 VALUES (1106,258407,34,'rouses','jewelry','seriously','');










1160



INSERT INTO t2 VALUES (1107,228123,37,'poison','lemons','boasted','');










1161



INSERT INTO t2 VALUES (1108,250606,34,'attitude','brokenness','Chantilly','');










1162



INSERT INTO t2 VALUES (1109,208405,37,'dusted','bedpost','Iranizes','');










1163



INSERT INTO t2 VALUES (1110,212101,37,'encompasses','assurers','violinist','');










1164



INSERT INTO t2 VALUES (1111,218206,37,'presentation','annoyers','extramarital','');










1165



INSERT INTO t2 VALUES (1112,150401,37,'Kantian','affixed','spates','');










1166



INSERT INTO t2 VALUES (1113,248212,41,'imprecision','warbling','cloakroom','');










1167



INSERT INTO t2 VALUES (1114,128026,00,'saving','seriously','gazer','');










1168



INSERT INTO t2 VALUES (1115,128024,00,'maternal','boasted','hand','');










1169



INSERT INTO t2 VALUES (1116,128027,00,'hewed','Chantilly','tucked','');










1170



INSERT INTO t2 VALUES (1117,128025,00,'kerosene','Iranizes','gems','');










1171



INSERT INTO t2 VALUES (1118,128109,00,'Cubans','violinist','clinker','');










1172



INSERT INTO t2 VALUES (1119,128705,00,'photographers','extramarital','refiner','');










1173



INSERT INTO t2 VALUES (1120,126303,00,'nymph','spates','callus','');










1174



INSERT INTO t2 VALUES (1121,128308,00,'bedlam','cloakroom','leopards','');










1175



INSERT INTO t2 VALUES (1122,128204,00,'north','gazer','comfortingly','');










1176



INSERT INTO t2 VALUES (1123,128205,00,'Schoenberg','hand','generically','');










1177



INSERT INTO t2 VALUES (1124,128206,00,'botany','tucked','getters','');










1178



INSERT INTO t2 VALUES (1125,128207,00,'curs','gems','sexually','');










1179



INSERT INTO t2 VALUES (1126,118205,00,'solidification','clinker','spear','');










1180



INSERT INTO t2 VALUES (1127,116801,00,'inheritresses','refiner','serums','');










1181



INSERT INTO t2 VALUES (1128,116803,00,'stiller','callus','Italianization','');










1182



INSERT INTO t2 VALUES (1129,116804,00,'t1','leopards','attendants','');










1183



INSERT INTO t2 VALUES (1130,116802,00,'suite','comfortingly','spies','');










1184



INSERT INTO t2 VALUES (1131,128605,00,'ransomer','generically','Anthony','');










1185



INSERT INTO t2 VALUES (1132,118308,00,'Willy','getters','planar','');










1186



INSERT INTO t2 VALUES (1133,113702,00,'Rena','sexually','cupped','');










1187



INSERT INTO t2 VALUES (1134,113703,00,'Seattle','spear','cleanser','');










1188



INSERT INTO t2 VALUES (1135,112103,00,'relaxes','serums','commuters','');










1189



INSERT INTO t2 VALUES (1136,118009,00,'exclaim','Italianization','honeysuckle','');










1190



INSERT INTO t2 VALUES (5136,1118009,00,'exclaim','Italianization','honeysuckle','');










1191



INSERT INTO t2 VALUES (1137,138011,00,'implicated','attendants','orphanage','');










1192



INSERT INTO t2 VALUES (1138,138010,00,'distinguish','spies','skies','');










1193



INSERT INTO t2 VALUES (1139,138012,00,'assayed','Anthony','crushers','');










1194



INSERT INTO t2 VALUES (1140,068304,00,'homeowner','planar','Puritan','');










1195



INSERT INTO t2 VALUES (1141,078009,00,'and','cupped','squeezer','');










1196



INSERT INTO t2 VALUES (1142,108013,00,'stealth','cleanser','bruises','');










1197



INSERT INTO t2 VALUES (1143,084004,00,'coinciding','commuters','bonfire','');










1198



INSERT INTO t2 VALUES (1144,083402,00,'founder','honeysuckle','Colombo','');










1199



INSERT INTO t2 VALUES (1145,084003,00,'environing','orphanage','nondecreasing','');










1200



INSERT INTO t2 VALUES (1146,088504,00,'jewelry','skies','innocents','');










1201



INSERT INTO t2 VALUES (1147,088005,00,'lemons','crushers','masked','');










1202



INSERT INTO t2 VALUES (1148,088007,00,'brokenness','Puritan','file','');










1203



INSERT INTO t2 VALUES (1149,088006,00,'bedpost','squeezer','brush','');










1204



INSERT INTO t2 VALUES (1150,148025,00,'assurers','bruises','mutilate','');










1205



INSERT INTO t2 VALUES (1151,148024,00,'annoyers','bonfire','mommy','');










1206



INSERT INTO t2 VALUES (1152,138305,00,'affixed','Colombo','bulkheads','');










1207



INSERT INTO t2 VALUES (1153,138306,00,'warbling','nondecreasing','undeclared','');










1208



INSERT INTO t2 VALUES (1154,152701,00,'seriously','innocents','displacements','');










1209



INSERT INTO t2 VALUES (1155,148505,00,'boasted','masked','nieces','');










1210



INSERT INTO t2 VALUES (1156,158003,00,'Chantilly','file','coeducation','');










1211



INSERT INTO t2 VALUES (1157,156201,00,'Iranizes','brush','brassy','');










1212



INSERT INTO t2 VALUES (1158,156202,00,'violinist','mutilate','authenticator','');










1213



INSERT INTO t2 VALUES (1159,158307,00,'extramarital','mommy','Washoe','');










1214



INSERT INTO t2 VALUES (1160,158402,00,'spates','bulkheads','penny','');










1215



INSERT INTO t2 VALUES (1161,158401,00,'cloakroom','undeclared','Flagler','');










1216



INSERT INTO t2 VALUES (1162,068013,00,'gazer','displacements','stoned','');










1217



INSERT INTO t2 VALUES (1163,068012,00,'hand','nieces','cranes','');










1218



INSERT INTO t2 VALUES (1164,068203,00,'tucked','coeducation','masterful','');










1219



INSERT INTO t2 VALUES (1165,088205,00,'gems','brassy','biracial','');










1220



INSERT INTO t2 VALUES (1166,068704,00,'clinker','authenticator','steamships','');










1221



INSERT INTO t2 VALUES (1167,068604,00,'refiner','Washoe','windmills','');










1222



INSERT INTO t2 VALUES (1168,158502,00,'callus','penny','exploit','');










1223



INSERT INTO t2 VALUES (1169,123103,00,'leopards','Flagler','riverfront','');










1224



INSERT INTO t2 VALUES (1170,148026,00,'comfortingly','stoned','sisterly','');










1225



INSERT INTO t2 VALUES (1171,123302,00,'generically','cranes','sharpshoot','');










1226



INSERT INTO t2 VALUES (1172,076503,00,'getters','masterful','mittens','');










1227



INSERT INTO t2 VALUES (1173,126304,00,'sexually','biracial','interdependency','');










1228



INSERT INTO t2 VALUES (1174,068306,00,'spear','steamships','policy','');










1229



INSERT INTO t2 VALUES (1175,143504,00,'serums','windmills','unleashing','');










1230



INSERT INTO t2 VALUES (1176,160201,00,'Italianization','exploit','pretenders','');










1231



INSERT INTO t2 VALUES (1177,148028,00,'attendants','riverfront','overstatements','');










1232



INSERT INTO t2 VALUES (1178,148027,00,'spies','sisterly','birthed','');










1233



INSERT INTO t2 VALUES (1179,143505,00,'Anthony','sharpshoot','opportunism','');










1234



INSERT INTO t2 VALUES (1180,108014,00,'planar','mittens','showroom','');










1235



INSERT INTO t2 VALUES (1181,076104,00,'cupped','interdependency','compromisingly','');










1236



INSERT INTO t2 VALUES (1182,078106,00,'cleanser','policy','Medicare','');










1237



INSERT INTO t2 VALUES (1183,126102,00,'commuters','unleashing','corresponds','');










1238



INSERT INTO t2 VALUES (1184,128029,00,'honeysuckle','pretenders','hardware','');










1239



INSERT INTO t2 VALUES (1185,128028,00,'orphanage','overstatements','implant','');










1240



INSERT INTO t2 VALUES (1186,018410,00,'skies','birthed','Alicia','');










1241



INSERT INTO t2 VALUES (1187,128110,00,'crushers','opportunism','requesting','');










1242



INSERT INTO t2 VALUES (1188,148506,00,'Puritan','showroom','produced','');










1243



INSERT INTO t2 VALUES (1189,123303,00,'squeezer','compromisingly','criticizes','');










1244



INSERT INTO t2 VALUES (1190,123304,00,'bruises','Medicare','backer','');










1245



INSERT INTO t2 VALUES (1191,068504,00,'bonfire','corresponds','positively','');










1246



INSERT INTO t2 VALUES (1192,068305,00,'Colombo','hardware','colicky','');










1247



INSERT INTO t2 VALUES (1193,000000,00,'nondecreasing','implant','thrillingly','');










1248



--enable_query_log










1249












1250



#










1251



# Search with a key










1252



#










1253












1254



select t2.fld3 from t2 where companynr = 58 and fld3 like "%imaginable%";










1255



select fld3 from t2 where fld3 like "%cultivation" ;










1256












1257



#










1258



# Search with a key using sorting and limit the same time










1259



#










1260












1261



select t2.fld3,companynr from t2 where companynr = 57+1 order by fld3;










1262



select fld3,companynr from t2 where companynr = 58 order by fld3;










1263












1264



select fld3 from t2 order by fld3 desc limit 10;










1265



select fld3 from t2 order by fld3 desc limit 5;










1266



select fld3 from t2 order by fld3 desc limit 5,5;










1267












1268



#










1269



# Search with a key having a constant with each unique key.










1270



# The table is read directly with read-next on fld3










1271



#










1272












1273



select t2.fld3 from t2 where fld3 = 'honeysuckle';










1274



select t2.fld3 from t2 where fld3 LIKE 'honeysuckl_';










1275



select t2.fld3 from t2 where fld3 LIKE 'hon_ysuckl_';










1276



select t2.fld3 from t2 where fld3 LIKE 'honeysuckle%';










1277



select t2.fld3 from t2 where fld3 LIKE 'h%le';










1278












1279



select t2.fld3 from t2 where fld3 LIKE 'honeysuckle_';










1280



select t2.fld3 from t2 where fld3 LIKE 'don_t_find_me_please%';










1281












1282



#










1283



# Test using INDEX and IGNORE INDEX










1284



#










1285












1286



explain select t2.fld3 from t2 where fld3 = 'honeysuckle';










1287












1288



explain select fld3 from t2 ignore index (fld3) where fld3 = 'honeysuckle';










1289



explain select fld3 from t2 use index (fld1) where fld3 = 'honeysuckle';










1290












1291



explain select fld3 from t2 use index (fld3) where fld3 = 'honeysuckle';










1292



explain select fld3 from t2 use index (fld1,fld3) where fld3 = 'honeysuckle';










1293












1294



#










1295



# NOTE NOTE NOTE










1296



# The next should give an error










1297



#










1298












1299



-- error 1176










1300



explain select fld3 from t2 ignore index (fld3,not_used);










1301



-- error 1176










1302



explain select fld3 from t2 use index (not_used);










1303












1304



#










1305



# Test sorting with a used key (there is no need for sorting)










1306



#










1307












1308



select t2.fld3 from t2 where fld3 >= 'honeysuckle' and fld3 <= 'honoring' order by fld3;










1309



explain select t2.fld3 from t2 where fld3 >= 'honeysuckle' and fld3 <= 'honoring' order by fld3;










1310



select fld1,fld3 from t2 where fld3="Colombo" or fld3 = "nondecreasing" order by fld3;










1311












1312



# 










1313



# Search with a key having a constant with many occurrences










1314



# The table is read directly with read-next having fld3 to get the










1315



# occurrences










1316



#










1317












1318



select fld1,fld3 from t2 where companynr = 37 and fld3 = 'appendixes';










1319












1320



#










1321



# Search with bunched 'or's.










1322



# If one can limit the key to a certain interval only the possible










1323



# alternatives will be gone through










1324



#










1325












1326



select fld1 from t2 where fld1=250501 or fld1="250502";










1327



explain select fld1 from t2 where fld1=250501 or fld1="250502"; 










1328



select fld1 from t2 where fld1=250501 or fld1=250502 or fld1 >= 250505 and fld1 <= 250601 or fld1 between 250501 and 250502;










1329



explain select fld1 from t2 where fld1=250501 or fld1=250502 or fld1 >= 250505 and fld1 <= 250601 or fld1 between 250501 and 250502;










1330












1331



#










1332



# Search with a key with LIKE constant










1333



# If the like starts with a certain letter key will be used.










1334



#










1335












1336



select fld1,fld3 from t2 where companynr = 37 and fld3 like 'f%';










1337



select fld3 from t2 where fld3 like "L%" and fld3 = "ok";










1338



select fld3 from t2 where (fld3 like "C%" and fld3 = "Chantilly");










1339



select fld1,fld3 from t2 where fld1 like "25050%";










1340



select fld1,fld3 from t2 where fld1 like "25050_";










1341












1342



# 










1343



# Search using distinct. An automatic grouping will be done over all the fields,










1344



# if only distinct is used. In any other case a temporary table will always










1345



# be created. If only the field used for sorting is from the main register,










1346



# it will be sorted first before the distinct table is created.










1347



#










1348












1349



select distinct companynr from t2;










1350



select distinct companynr from t2 order by companynr;










1351



select distinct companynr from t2 order by companynr desc;










1352



select distinct t2.fld3,period from t2,t1 where companynr=37 and fld3 like "O%";










1353












1354



select distinct fld3 from t2 where companynr = 34 order by fld3;










1355



select distinct fld3 from t2 limit 10;










1356



select distinct fld3 from t2 having fld3 like "A%" limit 10;










1357



select distinct substring(fld3,1,3) from t2 where fld3 like "A%";










1358



select distinct substring(fld3,1,3) as a from t2 having a like "A%" order by a limit 10;










1359



select distinct substring(fld3,1,3) from t2 where fld3 like "A%" limit 10;










1360



select distinct substring(fld3,1,3) as a from t2 having a like "A%" limit 10;










1361












1362



# make a big table.










1363












1364



create table t3 (










1365



 period    int not null,










1366



 name      char(32) not null,










1367



 companynr int not null,










1368



 price     double(11,0),










1369



 price2     double(11,0),










1370



 key (period),










1371



 key (name)










1372



);










1373












1374



--disable_query_log










1375



INSERT INTO t3 (period,name,companynr,price,price2) VALUES (1001,"Iranizes",37,5987435,234724);










1376



INSERT INTO t3 (period,name,companynr,price,price2) VALUES (1002,"violinist",37,28357832,8723648);










1377



INSERT INTO t3 (period,name,companynr,price,price2) VALUES (1003,"extramarital",37,39654943,235872);










1378



INSERT INTO t3 (period,name,companynr,price,price2) VALUES (1004,"spates",78,726498,72987523);










1379



INSERT INTO t3 (period,name,companynr,price,price2) VALUES (1005,"cloakroom",78,98439034,823742);










1380



INSERT INTO t3 (period,name,companynr,price,price2) VALUES (1006,"gazer",101,834598,27348324);










1381



INSERT INTO t3 (period,name,companynr,price,price2) VALUES (1007,"hand",154,983543950,29837423);










1382



INSERT INTO t3 (period,name,companynr,price,price2) VALUES (1008,"tucked",311,234298,3275892);










1383



INSERT INTO t3 (period,name,companynr,price,price2) VALUES (1009,"gems",447,2374834,9872392);










1384



INSERT INTO t3 (period,name,companynr,price,price2) VALUES (1010,"clinker",512,786542,76234234);










1385



--enable_query_log










1386












1387



create temporary table tmp engine = myisam select * from t3;










1388












1389



insert into t3 select * from tmp;










1390



insert into tmp select * from t3;










1391



insert into t3 select * from tmp;










1392



insert into tmp select * from t3;










1393



insert into t3 select * from tmp;










1394



insert into tmp select * from t3;










1395



insert into t3 select * from tmp;










1396



insert into tmp select * from t3;










1397



insert into t3 select * from tmp;










1398



insert into tmp select * from t3;










1399



insert into t3 select * from tmp;










1400



insert into tmp select * from t3;










1401



insert into t3 select * from tmp;










1402



insert into tmp select * from t3;










1403



insert into t3 select * from tmp;










1404



insert into tmp select * from t3;










1405



insert into t3 select * from tmp;










1406



#insert into tmp select * from t3;










1407



#insert into t3 select * from tmp;










1408












1409



alter table t3 add t2nr int not null auto_increment primary key first;










1410












1411



drop table tmp;










1412












1413



# big table done










1414












1415



SET SQL_BIG_TABLES=1;










1416



select distinct concat(fld3," ",fld3) as namn from t2,t3 where t2.fld1=t3.t2nr order by namn limit 10;










1417



SET SQL_BIG_TABLES=0;










1418



select distinct concat(fld3," ",fld3) from t2,t3 where t2.fld1=t3.t2nr order by fld3 limit 10;










1419



select distinct fld5 from t2 limit 10;










1420












1421



#










1422



# Force use of remove_dupp










1423



#










1424












1425



select distinct fld3,count(*) from t2 group by companynr,fld3 limit 10;










1426



SET SQL_BIG_TABLES=1; # Force use of MyISAM










1427



select distinct fld3,count(*) from t2 group by companynr,fld3 limit 10;










1428



SET SQL_BIG_TABLES=0;










1429



select distinct fld3,repeat("a",length(fld3)),count(*) from t2 group by companynr,fld3 limit 100,10;










1430












1431



#










1432



# A big order by that should trigger a merge in filesort










1433



#










1434












1435



select distinct companynr,rtrim(space(512+companynr)) from t3 order by 1,2;










1436












1437



#










1438



# Search with distinct and order by with many table.










1439



#










1440












1441



select distinct fld3 from t2,t3 where t2.companynr = 34 and t2.fld1=t3.t2nr order by fld3;










1442












1443



#










1444



# Here the last fld3 is optimized away from the order by










1445



#










1446












1447



explain select t3.t2nr,fld3 from t2,t3 where t2.companynr = 34 and t2.fld1=t3.t2nr order by t3.t2nr,fld3;










1448












1449



#










1450



# Some test with ORDER BY and limit










1451



#










1452












1453



explain select * from t3 as t1,t3 where t1.period=t3.period order by t3.period;










1454



explain select * from t3 as t1,t3 where t1.period=t3.period order by t3.period limit 10;










1455



explain select * from t3 as t1,t3 where t1.period=t3.period order by t1.period limit 10;










1456












1457



#










1458



# Search with a constant table.










1459



#










1460












1461



select period from t1;










1462



select period from t1 where period=1900;










1463



select fld3,period from t1,t2 where fld1 = 011401 order by period;










1464












1465



#










1466



# Search with a constant table and several keyparts. (Rows are read only once










1467



# in the beginning of the search)










1468



#










1469












1470



select fld3,period from t2,t3 where t2.fld1 = 011401 and t2.fld1=t3.t2nr and t3.period=1001;










1471












1472



explain select fld3,period from t2,t3 where t2.fld1 = 011401 and t3.t2nr=t2.fld1 and 1001 = t3.period;










1473












1474



#










1475



# Search with a constant table and several rows from another table










1476



#










1477












1478



select fld3,period from t2,t1 where companynr*10 = 37*10;










1479












1480



#










1481



# Search with a table reference and without a key.










1482



# t3 will be the main table.










1483



#










1484












1485



select fld3,period,price,price2 from t2,t3 where t2.fld1=t3.t2nr and period >= 1001 and period <= 1002 and t2.companynr = 37 order by fld3,period, price;










1486












1487



#










1488



# Search with an interval on a table with full key on reference table.










1489



# Here t2 will be the main table and only records matching the










1490



# t2nr will be checked.










1491



#










1492












1493



select t2.fld1,fld3,period,price,price2 from t2,t3 where t2.fld1>= 18201 and t2.fld1 <= 18811 and t2.fld1=t3.t2nr and period = 1001 and t2.companynr = 37;










1494












1495



#










1496



# We need another table for join stuff..










1497



#










1498












1499



create table t4 (










1500



  companynr tinyint(2) unsigned zerofill NOT NULL default '00',










1501



  companyname char(30) NOT NULL default '',










1502



  PRIMARY KEY (companynr),










1503



  UNIQUE KEY companyname(companyname)










1504



) ENGINE=MyISAM MAX_ROWS=50 PACK_KEYS=1 COMMENT='companynames';










1505












1506



--disable_query_log










1507



INSERT INTO t4 (companynr, companyname) VALUES (29,'company 1');










1508



INSERT INTO t4 (companynr, companyname) VALUES (34,'company 2');










1509



INSERT INTO t4 (companynr, companyname) VALUES (36,'company 3');










1510



INSERT INTO t4 (companynr, companyname) VALUES (37,'company 4');










1511



INSERT INTO t4 (companynr, companyname) VALUES (40,'company 5');










1512



INSERT INTO t4 (companynr, companyname) VALUES (41,'company 6');










1513



INSERT INTO t4 (companynr, companyname) VALUES (53,'company 7');










1514



INSERT INTO t4 (companynr, companyname) VALUES (58,'company 8');










1515



INSERT INTO t4 (companynr, companyname) VALUES (65,'company 9');










1516



INSERT INTO t4 (companynr, companyname) VALUES (68,'company 10');










1517



INSERT INTO t4 (companynr, companyname) VALUES (50,'company 11');










1518



INSERT INTO t4 (companynr, companyname) VALUES (00,'Unknown');










1519



--enable_query_log










1520












1521



#










1522



# Test of stright join to force a full join.










1523



#










1524












1525



select STRAIGHT_JOIN t2.companynr,companyname from t4,t2 where t2.companynr=t4.companynr group by t2.companynr;










1526












1527



select SQL_SMALL_RESULT t2.companynr,companyname from t4,t2 where t2.companynr=t4.companynr group by t2.companynr;










1528












1529



#










1530



# Full join (same alias)










1531



#










1532












1533



select * from t1,t1 t12;










1534



select t2.fld1,t22.fld1 from t2,t2 t22 where t2.fld1 >= 250501 and t2.fld1 <= 250505 and t22.fld1 >= 250501 and t22.fld1 <= 250505;










1535












1536



#










1537



# Test of left join.










1538



#










1539



insert into t2 (fld1, companynr) values (999999,99);










1540












1541



select t2.companynr,companyname from t2 left join t4 using (companynr) where t4.companynr is null;










1542



select count(*) from t2 left join t4 using (companynr) where t4.companynr is not null;










1543



explain select t2.companynr,companyname from t2 left join t4 using (companynr) where t4.companynr is null;










1544



explain select t2.companynr,companyname from t4 left join t2 using (companynr) where t2.companynr is null;










1545












1546



select companynr,companyname from t2 left join t4 using (companynr) where companynr is null;










1547



select count(*) from t2 left join t4 using (companynr) where companynr is not null;










1548



explain select companynr,companyname from t2 left join t4 using (companynr) where companynr is null;










1549



explain select companynr,companyname from t4 left join t2 using (companynr) where companynr is null;










1550



delete from t2 where fld1=999999;










1551












1552



#










1553



# Test left join optimization










1554












1555



explain select t2.companynr,companyname from t4 left join t2 using (companynr) where t2.companynr > 0;










1556



explain select t2.companynr,companyname from t4 left join t2 using (companynr) where t2.companynr > 0 or t2.companynr < 0;










1557



explain select t2.companynr,companyname from t4 left join t2 using (companynr) where t2.companynr > 0 and t4.companynr > 0;










1558












1559



explain select companynr,companyname from t4 left join t2 using (companynr) where companynr > 0;










1560



explain select companynr,companyname from t4 left join t2 using (companynr) where companynr > 0 or companynr < 0;










1561



explain select companynr,companyname from t4 left join t2 using (companynr) where companynr > 0 and companynr > 0;










1562



# Following can't be optimized










1563



explain select t2.companynr,companyname from t4 left join t2 using (companynr) where t2.companynr > 0 or t2.companynr is null;










1564



explain select t2.companynr,companyname from t4 left join t2 using (companynr) where t2.companynr > 0 or t2.companynr < 0 or t4.companynr > 0;










1565



explain select t2.companynr,companyname from t4 left join t2 using (companynr) where ifnull(t2.companynr,1)>0;










1566












1567



explain select companynr,companyname from t4 left join t2 using (companynr) where companynr > 0 or companynr is null;










1568



explain select companynr,companyname from t4 left join t2 using (companynr) where companynr > 0 or companynr < 0 or companynr > 0;










1569



explain select companynr,companyname from t4 left join t2 using (companynr) where ifnull(companynr,1)>0;










1570












1571



#










1572



# Joins with forms.










1573



#










1574












1575



select distinct t2.companynr,t4.companynr from t2,t4 where t2.companynr=t4.companynr+1;










1576



explain select distinct t2.companynr,t4.companynr from t2,t4 where t2.companynr=t4.companynr+1;










1577












1578



#










1579



# Search using 'or' with the same referens group.










1580



# An interval search will be done first with the first table and after that










1581



# the other table is referenced with a key with a 'test if key in use' for










1582



# each record










1583



#










1584












1585



select t2.fld1,t2.companynr,fld3,period from t3,t2 where t2.fld1 = 38208 and t2.fld1=t3.t2nr and period = 1008 or t2.fld1 = 38008 and t2.fld1 =t3.t2nr and period = 1008;










1586












1587



select t2.fld1,t2.companynr,fld3,period from t3,t2 where (t2.fld1 = 38208 or t2.fld1 = 38008) and t2.fld1=t3.t2nr and period>=1008 and period<=1009;










1588












1589



select t2.fld1,t2.companynr,fld3,period from t3,t2 where (t3.t2nr = 38208 or t3.t2nr = 38008) and t2.fld1=t3.t2nr and period>=1008 and period<=1009;










1590












1591



#










1592



# Test of many parenthesis levels










1593



#










1594












1595



select period from t1 where (((period > 0) or period < 10000 or (period = 1900)) and (period=1900 and period <= 1901) or (period=1903 and (period=1903)) and period>=1902) or ((period=1904 or period=1905) or (period=1906 or period>1907)) or (period=1908 and period = 1909);










1596



select period from t1 where ((period > 0 and period < 1) or (((period > 0 and period < 100) and (period > 10)) or (period > 10)) or (period > 0 and (period > 5 or period > 6)));










1597












1598



select a.fld1 from t2 as a,t2 b where ((a.fld1 = 250501 and a.fld1=b.fld1) or a.fld1=250502 or a.fld1=250503 or (a.fld1=250505 and a.fld1<=b.fld1 and b.fld1>=a.fld1)) and a.fld1=b.fld1;










1599












1600



select fld1 from t2 where fld1 in (250502,98005,98006,250503,250605,250606) and fld1 >=250502 and fld1 not in (250605,250606);










1601












1602



select fld1 from t2 where fld1 between 250502 and 250504;










1603












1604



select fld3 from t2 where (((fld3 like "_%L%" ) or (fld3 like "%ok%")) and ( fld3 like "L%" or fld3 like "G%")) and fld3 like "L%" ;










1605












1606



#










1607



# Group on one table.










1608



# optimizer: sort table by group and send rows.










1609



#










1610












1611



select count(*) from t1;










1612



select companynr,count(*),sum(fld1) from t2 group by companynr;










1613



select companynr,count(*) from t2 group by companynr order by companynr desc limit 5;










1614



select count(*),min(fld4),max(fld4),sum(fld1),avg(fld1),std(fld1),variance(fld1) from t2 where companynr = 34 and fld4<>"";










1615



explain extended select count(*),min(fld4),max(fld4),sum(fld1),avg(fld1),std(fld1),variance(fld1) from t2 where companynr = 34 and fld4<>"";










1616



select companynr,count(*),min(fld4),max(fld4),sum(fld1),avg(fld1),std(fld1),variance(fld1) from t2 group by companynr limit 3;










1617



select companynr,t2nr,count(price),sum(price),min(price),max(price),avg(price) from t3 where companynr = 37 group by companynr,t2nr limit 10;










1618



select /*! SQL_SMALL_RESULT */ companynr,t2nr,count(price),sum(price),min(price),max(price),avg(price) from t3 where companynr = 37 group by companynr,t2nr limit 10;










1619



select companynr,count(price),sum(price),min(price),max(price),avg(price) from t3 group by companynr ;










1620



select distinct mod(companynr,10) from t4 group by companynr;










1621



select distinct 1 from t4 group by companynr;










1622



select count(distinct fld1) from t2;










1623



select companynr,count(distinct fld1) from t2 group by companynr;










1624



select companynr,count(*) from t2 group by companynr;










1625



select companynr,count(distinct concat(fld1,repeat(65,1000))) from t2 group by companynr;










1626



select companynr,count(distinct concat(fld1,repeat(65,200))) from t2 group by companynr;










1627



select companynr,count(distinct floor(fld1/100)) from t2 group by companynr;










1628



select companynr,count(distinct concat(repeat(65,1000),floor(fld1/100))) from t2 group by companynr;










1629












1630



#










1631



# group with where on a key field










1632



#










1633












1634



select sum(fld1),fld3 from t2 where fld3="Romans" group by fld1 limit 10;










1635



select name,count(*) from t3 where name='cloakroom' group by name;










1636



select name,count(*) from t3 where name='cloakroom' and price>10 group by name;










1637



select count(*) from t3 where name='cloakroom' and price2=823742;










1638



select name,count(*) from t3 where name='cloakroom' and price2=823742 group by name;










1639



select name,count(*) from t3 where name >= "extramarital" and price <= 39654943 group by name;










1640



select t2.fld3,count(*) from t2,t3 where t2.fld1=158402 and t3.name=t2.fld3 group by t3.name;










1641












1642



#










1643



# Group with extra not group fields.










1644



#










1645












1646



select companynr|0,companyname from t4 group by 1;










1647



select t2.companynr,companyname,count(*) from t2,t4 where t2.companynr=t4.companynr group by t2.companynr order by companyname;










1648



select t2.fld1,count(*) from t2,t3 where t2.fld1=158402 and t3.name=t2.fld3 group by t3.name;










1649












1650



#










1651



# Calculation with group functions










1652



#










1653












1654



select sum(Period)/count(*) from t1;










1655



select companynr,count(price) as "count",sum(price) as "sum" ,abs(sum(price)/count(price)-avg(price)) as "diff",(0+count(price))*companynr as func from t3 group by companynr;










1656



select companynr,sum(price)/count(price) as avg from t3 group by companynr having avg > 70000000 order by avg;










1657












1658



#










1659



# Group with order on not first table










1660



# optimizer: sort table by group and write group records to tmp table.










1661



#            sort tmp_table and send rows.










1662



#










1663












1664



select companynr,count(*) from t2 group by companynr order by 2 desc;










1665



select companynr,count(*) from t2 where companynr > 40 group by companynr order by 2 desc;










1666



select t2.fld4,t2.fld1,count(price),sum(price),min(price),max(price),avg(price) from t3,t2 where t3.companynr = 37 and t2.fld1 = t3.t2nr group by fld1,t2.fld4;










1667












1668



#










1669



# group by with many tables










1670



# optimizer: create tmp table with group-by uniq index.










1671



#           write with update to tmp table.










1672



#           sort tmp table according to order (or group if no order)










1673



#	    send rows










1674



#










1675












1676



select t3.companynr,fld3,sum(price) from t3,t2 where t2.fld1 = t3.t2nr and t3.companynr = 512 group by companynr,fld3;










1677



select t2.companynr,count(*),min(fld3),max(fld3),sum(price),avg(price) from t2,t3 where t3.companynr >= 30 and t3.companynr <= 58 and t3.t2nr = t2.fld1 and 1+1=2 group by t2.companynr;










1678












1679



#










1680



# group with many tables and long group on many tables. group on formula










1681



# optimizer: create tmp table with neaded fields










1682



#           sort tmp table by group and calculate sums to new table










1683



#	    if different order by than group, sort tmp table










1684



#	    send rows










1685



#










1686












1687



select t3.companynr+0,t3.t2nr,fld3,sum(price) from t3,t2 where t2.fld1 = t3.t2nr and t3.companynr = 37 group by 1,t3.t2nr,fld3,fld3,fld3,fld3,fld3 order by fld1;










1688












1689



#










1690



# WHERE const folding










1691



# optimize: If there is a "field = const" part in the where, change all










1692



#           instances of field in the and level to const.










1693



#	    All instances of const = const are checked once and removed.










1694



#










1695












1696



#










1697



# Where -> t3.t2nr = 98005 and t2.fld1 = 98005










1698



#










1699












1700



select sum(price) from t3,t2 where t2.fld1 = t3.t2nr and t3.companynr = 512 and t3.t2nr = 38008 and t2.fld1 = 38008 or t2.fld1= t3.t2nr and t3.t2nr = 38008 and t2.fld1 = 38008;










1701












1702



select t2.fld1,sum(price) from t3,t2 where t2.fld1 = t3.t2nr and t3.companynr = 512 and t3.t2nr = 38008 and t2.fld1 = 38008 or t2.fld1 = t3.t2nr and t3.t2nr = 38008 and t2.fld1 = 38008 or t3.t2nr = t2.fld1 and t2.fld1 = 38008 group by t2.fld1;










1703












1704



explain select fld3 from t2 where 1>2 or 2>3;










1705



explain select fld3 from t2 where fld1=fld1;










1706












1707



#










1708



# HAVING










1709



#










1710












1711



select companynr,fld1 from t2 HAVING fld1=250501 or fld1=250502; 










1712



select companynr,fld1 from t2 WHERE fld1>=250501 HAVING fld1<=250502;










1713



select companynr,count(*) as count,sum(fld1) as sum from t2 group by companynr having count > 40 and sum/count >= 120000;










1714



select companynr from t2 group by companynr having count(*) > 40 and sum(fld1)/count(*) >= 120000 ;










1715



select t2.companynr,companyname,count(*) from t2,t4 where t2.companynr=t4.companynr group by companyname having t2.companynr >= 40;










1716












1717



#










1718



# MIN(), MAX() and COUNT() optimizing










1719



#










1720












1721



select count(*) from t2;










1722



select count(*) from t2 where fld1 < 098024;










1723



# PS does correct pre-zero here. MySQL can't do it as it returns a number.










1724



--disable_ps_protocol










1725



select min(fld1) from t2 where fld1>= 098024;










1726



--enable_ps_protocol










1727



select max(fld1) from t2 where fld1>= 098024;










1728



select count(*) from t3 where price2=76234234;










1729



select count(*) from t3 where companynr=512 and price2=76234234;










1730



explain select min(fld1),max(fld1),count(*) from t2;










1731



# PS does correct pre-zero here. MySQL can't do it as it returns a number.










1732



--disable_ps_protocol










1733



select min(fld1),max(fld1),count(*) from t2;










1734



--enable_ps_protocol










1735



select min(t2nr),max(t2nr) from t3 where t2nr=2115 and price2=823742;










1736



select count(*),min(t2nr),max(t2nr) from t3 where name='spates' and companynr=78;










1737



select t2nr,count(*) from t3 where name='gems' group by t2nr limit 20;










1738



select max(t2nr) from t3 where price=983543950;










1739












1740



#










1741



# Test of alias










1742



#










1743












1744



select t1.period from t3 = t1 limit 1;










1745



select t1.period from t1 as t1 limit 1;










1746



select t1.period as "Nuvarande period" from t1 as t1 limit 1;










1747



select period as ok_period from t1 limit 1;










1748



select period as ok_period from t1 group by ok_period limit 1;










1749



select 1+1 as summa from t1 group by summa limit 1;










1750



select period as "Nuvarande period" from t1 group by "Nuvarande period" limit 1;










1751












1752



#










1753



# Some simple show commands










1754



#










1755












1756



show tables;










1757



show tables from test like "s%";










1758



show tables from test like "t?";










1759



# We mask out the Privileges column because it differs with embedded server










1760



--replace_column 8 #










1761



show full columns from t2;










1762



--replace_column 8 #










1763



show full columns from t2 from test like 'f%';










1764



--replace_column 8 #










1765



show full columns from t2 from test like 's%';










1766



show keys from t2;










1767












1768



drop table t4, t3, t2, t1;










1769












1770












1771



CREATE TABLE t1 (










1772



  cont_nr int(11) NOT NULL auto_increment,










1773



  ver_nr int(11) NOT NULL default '0',










1774



  aufnr int(11) NOT NULL default '0',










1775



  username varchar(50) NOT NULL default '',










1776



  hdl_nr int(11) NOT NULL default '0',










1777



  eintrag date NOT NULL default '0000-00-00',










1778



  st_klasse varchar(40) NOT NULL default '',










1779



  st_wert varchar(40) NOT NULL default '',










1780



  st_zusatz varchar(40) NOT NULL default '',










1781



  st_bemerkung varchar(255) NOT NULL default '',










1782



  kunden_art varchar(40) NOT NULL default '',










1783



  mcbs_knr int(11) default NULL,










1784



  mcbs_aufnr int(11) NOT NULL default '0',










1785



  schufa_status char(1) default '?',










1786



  bemerkung text,










1787



  wirknetz text,










1788



  wf_igz int(11) NOT NULL default '0',










1789



  tarifcode varchar(80) default NULL,










1790



  recycle char(1) default NULL,










1791



  sim varchar(30) default NULL,










1792



  mcbs_tpl varchar(30) default NULL,










1793



  emp_nr int(11) NOT NULL default '0',










1794



  laufzeit int(11) default NULL,










1795



  hdl_name varchar(30) default NULL,










1796



  prov_hdl_nr int(11) NOT NULL default '0',










1797



  auto_wirknetz varchar(50) default NULL,










1798



  auto_billing varchar(50) default NULL,










1799



  touch timestamp NOT NULL,










1800



  kategorie varchar(50) default NULL,










1801



  kundentyp varchar(20) NOT NULL default '',










1802



  sammel_rech_msisdn varchar(30) NOT NULL default '',










1803



  p_nr varchar(9) NOT NULL default '',










1804



  suffix char(3) NOT NULL default '',










1805



  PRIMARY KEY (cont_nr),










1806



  KEY idx_aufnr(aufnr),










1807



  KEY idx_hdl_nr(hdl_nr),










1808



  KEY idx_st_klasse(st_klasse),










1809



  KEY ver_nr(ver_nr),










1810



  KEY eintrag_idx(eintrag),










1811



  KEY emp_nr_idx(emp_nr),










1812



  KEY wf_igz(wf_igz),










1813



  KEY touch(touch),










1814



  KEY hdl_tag(eintrag,hdl_nr),










1815



  KEY prov_hdl_nr(prov_hdl_nr),










1816



  KEY mcbs_aufnr(mcbs_aufnr),










1817



  KEY kundentyp(kundentyp),










1818



  KEY p_nr(p_nr,suffix)










1819



) ENGINE=MyISAM;










1820












1821



INSERT INTO t1 VALUES (3359356,405,3359356,'Mustermann Musterfrau',52500,'2000-05-20','workflow','Auftrag erledigt','Originalvertrag eingegangen und geprüft','','privat',1485525,2122316,'+','','N',1909160,'MobilComSuper92000D2',NULL,NULL,'MS9ND2',3,24,'MobilCom Shop Koeln',52500,NULL,'auto',20010202105916,'Mobilfunk','PP','','','');










1822



INSERT INTO t1 VALUES (3359357,468,3359357,'Mustermann Musterfrau',7001,'2000-05-20','workflow','Auftrag erledigt','Originalvertrag eingegangen und geprüft','','privat',1503580,2139699,'+','','P',1909171,'MobilComSuper9D1T10SFreisprech(Akquise)',NULL,NULL,'MS9NS1',327,24,'MobilCom Intern',7003,NULL,'auto',20010202105916,'Mobilfunk','PP','','','');










1823



INSERT INTO t1 VALUES (3359358,407,3359358,'Mustermann Musterfrau',7001,'2000-05-20','workflow','Auftrag erledigt','Originalvertrag eingegangen und geprüft','','privat',1501358,2137473,'N','','N',1909159,'MobilComSuper92000D2',NULL,NULL,'MS9ND2',325,24,'MobilCom Intern',7003,NULL,'auto',20010202105916,'Mobilfunk','PP','','','');










1824



INSERT INTO t1 VALUES (3359359,468,3359359,'Mustermann Musterfrau',7001,'2000-05-20','workflow','Auftrag erledigt','Originalvertrag eingegangen und geprüft','','privat',1507831,2143894,'+','','P',1909162,'MobilComSuper9D1T10SFreisprech(Akquise)',NULL,NULL,'MS9NS1',327,24,'MobilCom Intern',7003,NULL,'auto',20010202105916,'Mobilfunk','PP','','','');










1825



INSERT INTO t1 VALUES (3359360,0,0,'Mustermann Musterfrau',29674907,'2000-05-20','workflow','Auftrag erledigt','Originalvertrag eingegangen und geprüft','','privat',1900169997,2414578,'+',NULL,'N',1909148,'',NULL,NULL,'RV99066_2',20,NULL,'POS',29674907,NULL,NULL,20010202105916,'Mobilfunk','','','97317481','007');










1826



INSERT INTO t1 VALUES (3359361,406,3359361,'Mustermann Musterfrau',7001,'2000-05-20','workflow','Auftrag storniert','','(7001-84):Storno, Kd. möchte nicht mehr','privat',NULL,0,'+','','P',1909150,'MobilComSuper92000D1(Akquise)',NULL,NULL,'MS9ND1',325,24,'MobilCom Intern',7003,NULL,'auto',20010202105916,'Mobilfunk','PP','','','');










1827



INSERT INTO t1 VALUES (3359362,406,3359362,'Mustermann Musterfrau',7001,'2000-05-20','workflow','Auftrag erledigt','Originalvertrag eingegangen und geprüft','','privat',1509984,2145874,'+','','P',1909154,'MobilComSuper92000D1(Akquise)',NULL,NULL,'MS9ND1',327,24,'MobilCom Intern',7003,NULL,'auto',20010202105916,'Mobilfunk','PP','','','');










1828












1829



--disable_ps_protocol










1830



SELECT ELT(FIELD(kundentyp,'PP','PPA','PG','PGA','FK','FKA','FP','FPA','K','KA','V','VA',''), 'Privat (Private Nutzung)','Privat (Private Nutzung) Sitz im Ausland','Privat (geschaeftliche Nutzung)','Privat (geschaeftliche Nutzung) Sitz im Ausland','Firma (Kapitalgesellschaft)','Firma (Kapitalgesellschaft) Sitz im Ausland','Firma (Personengesellschaft)','Firma (Personengesellschaft) Sitz im Ausland','oeff. rechtl. Koerperschaft','oeff. rechtl. Koerperschaft Sitz im Ausland','Eingetragener Verein','Eingetragener Verein Sitz im Ausland','Typ unbekannt') AS Kundentyp ,kategorie FROM t1 WHERE hdl_nr < 2000000 AND kategorie IN ('Prepaid','Mobilfunk') AND st_klasse = 'Workflow' GROUP BY kundentyp ORDER BY kategorie;










1831



--enable_ps_protocol










1832



drop table t1;