Testdaten

INSERT INTO `person` (`Person_ID`,`Vorname`,`Nachname`,`Mobilnummer`,`Festnetznummer`,`Email`,`Homepage`,`Wohnort`,`PLZ`,`HausNr`,`Straße`) VALUES (1,"Hayes","Joyner",20,23,"euismod@aliquetsemut.edu","green.it","Massimino","60116",181,"Ap #250-9721 Orci. St."),(2,"Sydney","Conway",42,115,"urna.suscipit@sagittisfelisDonec.com","violet.xyz","Hamilton","35023",103,"336-1122 Fringilla, Avenue"),(3,"Brennan","Key",71,121,"lacinia@metus.net","yellow.de","Ikot Ekpene","29990",173,"4550 Nulla Rd."),(4,"Brandon","Miles",53,14,"Aliquam.ultrices.iaculis@auctorquis.ca","indigo","Sciacca","68406",83,"Ap #645-4430 Fusce Rd."),(5,"Hasad","Nieves",105,118,"erat.in@auctor.co.uk","red.com","Ayas","10467",130,"501-3341 Tincidunt Avenue"),(6,"Courtney","Francis",69,113,"ut.eros@semegestasblandit.edu","orange.com","Molenbeersel","58352",163,"8490 Convallis Street"),(7,"Desirae","Oconnor",39,24,"Cras.eget@Aliquamauctor.edu","yellow.de","Coltauco","58505",115,"P.O. Box 980, 2553 Eros Avenue"),(8,"Fallon","Stark",84,112,"sed.sapien.Nunc@at.net","violet.xyz","Manisa","26414",71,"578-841 Mi Rd."),(9,"Colt","Conrad",74,22,"ultricies.ornare@pellentesque.org","green.it","Moncton","32942",169,"372-4702 Tellus. Road"),(10,"Tatum","Gibbs",12,9,"consequat.dolor.vitae@nibhsit.net","violet.xyz","Stony Plain","32878",57,"Ap #143-5774 Non, St.");
INSERT INTO `person` (`Person_ID`,`Vorname`,`Nachname`,`Mobilnummer`,`Festnetznummer`,`Email`,`Homepage`,`Wohnort`,`PLZ`,`HausNr`,`Straße`) VALUES (11,"Tatum","Gutierrez",12,108,"fermentum.metus@nisi.com","indigo","San Vito al Tagliamento","08255",120,"Ap #826-7497 Nunc St."),(12,"Brenda","Hammond",84,74,"sed.pede@egestas.ca","blue.waffle","Contulmo","76130",139,"3025 Eu, Rd."),(13,"Orson","Holt",74,70,"sit.amet.dapibus@aliquet.com","green.it","Grande Cache","04009",120,"6645 Fusce St."),(14,"Meredith","Workman",18,68,"ligula.eu.enim@egetlacusMauris.org","red.com","Thalassery","01082",155,"Ap #334-962 Placerat, Avenue"),(15,"Kirsten","Nguyen",110,102,"nonummy.ultricies.ornare@urnaNullamlobortis.net","green.it","Carahue","61784",166,"5542 Feugiat Ave"),(16,"Aidan","Cantu",121,109,"metus.eu.erat@mattisCraseget.co.uk","indigo","Pickering","31084",161,"P.O. Box 861, 1692 Sociis Road"),(17,"Catherine","Barker",107,91,"Etiam@nequepellentesquemassa.edu","yellow.de","Redcliffe","25647",88,"234-6483 Nisl. Avenue"),(18,"Robert","Witt",57,12,"malesuada.vel.convallis@velquam.edu","blue.waffle","Butte","16672",186,"Ap #772-3970 Id, Avenue"),(19,"Patience","Parrish",77,85,"Phasellus@accumsanneque.com","red.com","Campli","83492",112,"P.O. Box 543, 4114 Mi Road"),(20,"Teagan","Joyce",96,82,"adipiscing.enim@eratSed.edu","violet.xyz","Modakeke","52065",178,"2902 Sociosqu St.");
INSERT INTO `person` (`Person_ID`,`Vorname`,`Nachname`,`Mobilnummer`,`Festnetznummer`,`Email`,`Homepage`,`Wohnort`,`PLZ`,`HausNr`,`Straße`) VALUES (21,"Hayley","Kramer",5,19,"Sed@urnaVivamusmolestie.co.uk","violet.xyz","Reinbek","04637",57,"P.O. Box 815, 654 Consequat, Av."),(22,"Oprah","Chan",55,22,"vestibulum.massa@dapibusgravida.com","indigo","Grande Cache","30048",198,"Ap #528-4765 Sed Ave"),(23,"Nolan","Merritt",31,49,"in.molestie@tellusjusto.org","orange.com","Quispamsis","22152",77,"258-1239 Elit, St."),(24,"Colette","Beach",25,78,"quis.massa.Mauris@leo.co.uk","violet.xyz","Carlisle","78154",179,"P.O. Box 919, 5592 Neque St."),(25,"Zeus","Torres",127,29,"iaculis@vitaeerat.co.uk","red.com","Ballarat","14835",175,"Ap #654-9823 Nunc Avenue"),(26,"Tucker","Trujillo",90,87,"fringilla@malesuadamalesuadaInteger.co.uk","yellow.de","Saint-Servais","59401",163,"3426 Eu St."),(27,"Raya","Kline",3,104,"molestie.Sed@elit.org","violet.xyz","Hertsberge","36809",186,"346-3084 Dolor Av."),(28,"Fleur","Houston",95,51,"diam.vel.arcu@pharetra.net","blue.waffle","Bremen","90792",87,"9217 Etiam Av."),(29,"Aline","Stephenson",4,64,"non.vestibulum@idrisusquis.co.uk","green.it","Valéncia","76995",122,"1509 Posuere Road"),(30,"Alvin","Rich",55,52,"sed.dui.Fusce@dictumProineget.edu","orange.com","Burns Lake","65149",120,"Ap #773-2185 Felis Rd.");
INSERT INTO `person` (`Person_ID`,`Vorname`,`Nachname`,`Mobilnummer`,`Festnetznummer`,`Email`,`Homepage`,`Wohnort`,`PLZ`,`HausNr`,`Straße`) VALUES (31,"Dillon","Glass",44,26,"quis.diam@tempor.com","violet.xyz","Oderzo","99099",49,"8058 Vestibulum, Road"),(32,"Ignacia","Clayton",47,124,"orci.in@odioPhasellus.net","blue.waffle","Gressan","35417",159,"Ap #719-4104 Urna. Rd."),(33,"Drew","Stanton",50,78,"Curabitur.egestas.nunc@eulacusQuisque.net","red.com","Firozabad","91120",9,"900-3809 A St."),(34,"Boris","Cantrell",38,28,"Duis@eu.ca","violet.xyz","Greenwich","81168",183,"Ap #209-8673 Sit Avenue"),(35,"Maile","Hodges",44,56,"egestas.Sed.pharetra@vitaevelitegestas.edu","yellow.de","Ajax","28558",93,"2156 Augue Road"),(36,"Kylan","Mccoy",45,123,"erat@Sedid.org","red.com","San Antonio","67711",199,"Ap #220-8461 Congue, Road"),(37,"Hanna","Gutierrez",37,30,"odio.tristique@Nuncsed.net","blue.waffle","Cherain","89518",6,"Ap #371-8479 Habitant Road"),(38,"Rina","Richard",55,61,"Aliquam.auctor.velit@eunibhvulputate.net","green.it","Pessac","62224",164,"P.O. Box 342, 6095 Dolor Rd."),(39,"Molly","Fields",126,52,"eu@velitPellentesqueultricies.ca","red.com","Okotoks","41868",183,"Ap #852-373 Penatibus Road"),(40,"Shay","Luna",82,33,"sodales.at.velit@consequatauctornunc.com","red.com","Queenstown","46985",139,"708-8026 Tellus Ave");
INSERT INTO `person` (`Person_ID`,`Vorname`,`Nachname`,`Mobilnummer`,`Festnetznummer`,`Email`,`Homepage`,`Wohnort`,`PLZ`,`HausNr`,`Straße`) VALUES (41,"Kathleen","Morton",9,26,"vel.pede.blandit@mitempor.co.uk","yellow.de","Winchester","72822",20,"707-3942 A, Rd."),(42,"Salvador","Gallagher",52,119,"Nam.ligula@penatibusetmagnis.org","red.com","Bhind","43896",174,"237-3741 Aliquam St."),(43,"Karyn","Andrews",44,41,"cursus@liberoMorbiaccumsan.com","indigo","Zoerle-Parwijs","61759",199,"Ap #732-4463 Nec, Rd."),(44,"Xyla","Tyson",95,85,"pellentesque@utnulla.com","violet.xyz","Vichte","54925",87,"Ap #257-1688 Sapien. Street"),(45,"Felix","Cruz",42,127,"mollis.Integer@congueelitsed.com","orange.com","Teltow","79787",183,"P.O. Box 577, 499 Vitae, St."),(46,"Christen","Roth",85,47,"mauris.Suspendisse@Nam.ca","orange.com","Wrocław","77062",10,"P.O. Box 706, 9160 Suspendisse Ave"),(47,"Vernon","Burke",30,50,"Nulla.dignissim.Maecenas@pellentesque.org","yellow.de","Vichy","35780",39,"8219 Mauris St."),(48,"Shana","Watts",105,107,"facilisis@quamCurabitur.co.uk","green.it","Ongole","89494",6,"P.O. Box 511, 169 Congue, St."),(49,"Xaviera","Kelly",45,20,"suscipit.est@Crasconvallisconvallis.ca","indigo","La Granja","83426",49,"465-6129 Suspendisse Avenue"),(50,"Amena","Kelly",33,44,"lacinia.orci@nisl.co.uk","yellow.de","Millet","32908",2,"9738 Luctus St.");
INSERT INTO `person` (`Person_ID`,`Vorname`,`Nachname`,`Mobilnummer`,`Festnetznummer`,`Email`,`Homepage`,`Wohnort`,`PLZ`,`HausNr`,`Straße`) VALUES (51,"Nehru","Lopez",11,25,"auctor.non.feugiat@insodales.ca","orange.com","Pica","00244",160,"Ap #315-3339 Blandit Street"),(52,"Kiara","Jenkins",85,80,"orci.Phasellus@temporlorem.com","green.it","Winterswijk","59358",130,"631-2258 Sagittis Av."),(53,"Omar","Banks",6,50,"lorem.lorem.luctus@miDuis.ca","orange.com","Motta Camastra","28236",100,"P.O. Box 351, 4869 In Ave"),(54,"Ina","Delacruz",65,127,"netus@Donecconsectetuermauris.com","indigo","Castelnuovo Magra","28217",39,"157 Elit, Rd."),(55,"Felix","Deleon",42,88,"neque.Nullam@sitametante.org","red.com","Villers-aux-Tours","83575",130,"942 Nibh Rd."),(56,"Damian","Abbott",52,70,"quis.arcu@felis.co.uk","blue.waffle","Lagundo/Algund","08861",106,"544-5189 Amet St."),(57,"Harper","Serrano",80,122,"imperdiet@amet.net","orange.com","Imst","59426",149,"5070 Facilisis Rd."),(58,"Ryder","Good",38,118,"Proin.ultrices@tellus.ca","blue.waffle","Bierges","93080",140,"1293 Risus. Rd."),(59,"Vanna","Snow",19,61,"velit@MaurismagnaDuis.co.uk","violet.xyz","Fayetteville","32079",18,"Ap #523-1488 Ornare, Av."),(60,"Todd","Mcmahon",40,9,"elit.Curabitur.sed@scelerisqueduiSuspendisse.net","green.it","Meetkerke","93567",153,"7771 Et St.");
INSERT INTO `person` (`Person_ID`,`Vorname`,`Nachname`,`Mobilnummer`,`Festnetznummer`,`Email`,`Homepage`,`Wohnort`,`PLZ`,`HausNr`,`Straße`) VALUES (61,"Basia","Chase",119,45,"lorem@Cum.org","violet.xyz","Mérignac","85116",60,"Ap #822-713 Magnis St."),(62,"Kennan","Zamora",43,83,"nibh.Donec.est@lectusquis.com","orange.com","Calbuco","52634",78,"6751 Fusce Street"),(63,"Amaya","Willis",40,7,"gravida.mauris.ut@libero.ca","indigo","Bristol","44052",87,"559-5690 Pede. Road"),(64,"Quail","Hatfield",9,35,"lacinia.mattis.Integer@vestibulumnequesed.org","orange.com","Cassaro","62017",136,"P.O. Box 680, 1999 Tempor Rd."),(65,"Harper","Padilla",22,65,"Proin.mi.Aliquam@egestas.com","yellow.de","Latour","49396",123,"P.O. Box 205, 8594 Proin Ave"),(66,"Ella","Tucker",67,61,"fermentum.convallis.ligula@montes.ca","indigo","Napier","85940",12,"3129 Risus. Rd."),(67,"Slade","Adams",120,104,"tortor@dignissimmagnaa.ca","indigo","Borghetto di Borbera","93157",59,"701-5651 Aliquam Rd."),(68,"Melanie","Byrd",124,88,"rutrum.Fusce@Sedeu.edu","blue.waffle","Arviat","98055",141,"449-2790 Varius St."),(69,"Quinn","Mclaughlin",5,44,"taciti.sociosqu@diamnunc.com","blue.waffle","Appels","87810",24,"P.O. Box 581, 1096 Egestas Street"),(70,"Burke","Knowles",48,66,"faucibus.orci@velvulputate.co.uk","blue.waffle","Rodez","23010",125,"P.O. Box 830, 4783 Scelerisque, Ave");
INSERT INTO `person` (`Person_ID`,`Vorname`,`Nachname`,`Mobilnummer`,`Festnetznummer`,`Email`,`Homepage`,`Wohnort`,`PLZ`,`HausNr`,`Straße`) VALUES (71,"Fiona","Morales",74,61,"eu.tellus.Phasellus@risusDonec.ca","green.it","Bikaner","42416",48,"3814 In, Street"),(72,"Melyssa","Bond",60,109,"purus.gravida@viverraMaecenas.edu","blue.waffle","Gaithersburg","41001",86,"P.O. Box 808, 5920 Et, Ave"),(73,"Dakota","Thornton",28,52,"egestas.urna@sedconsequat.co.uk","green.it","Morkhoven","15877",96,"3163 Ullamcorper Road"),(74,"Justin","Frederick",18,18,"consequat.nec.mollis@ametmetusAliquam.net","yellow.de","Hawera","10693",77,"P.O. Box 339, 490 Id Ave"),(75,"Bethany","Ryan",67,25,"a.malesuada@laciniamattis.org","green.it","Sint-Katherina-Lombeek","95997",51,"6655 Duis Ave"),(76,"Tara","Cantu",69,58,"eleifend@Nuncac.net","indigo","Diepenbeek","59472",74,"Ap #628-2937 Risus. Street"),(77,"Keelie","Boone",15,24,"Cras.eu.tellus@feugiatnec.net","orange.com","Meeuwen","94998",111,"P.O. Box 431, 4183 Proin St."),(78,"Ira","Cantu",42,8,"eu.lacus.Quisque@porttitortellusnon.ca","violet.xyz","Pudukkottai","24218",39,"210-4313 Rutrum Av."),(79,"Vielka","Pope",121,39,"elit@magnaPhasellusdolor.edu","blue.waffle","Jerez de la Frontera","22296",146,"Ap #204-2500 Nunc Street"),(80,"Yolanda","Goodman",6,56,"eleifend@ut.edu","orange.com","Saint-Vincent","39462",39,"6030 Sed Avenue");
INSERT INTO `person` (`Person_ID`,`Vorname`,`Nachname`,`Mobilnummer`,`Festnetznummer`,`Email`,`Homepage`,`Wohnort`,`PLZ`,`HausNr`,`Straße`) VALUES (81,"Hop","Dillard",107,26,"quam@lobortis.co.uk","violet.xyz","LaSalle","55026",22,"P.O. Box 417, 8273 Donec St."),(82,"Darius","Watson",105,75,"rhoncus@fringillaest.edu","orange.com","Meeswijk","66275",14,"1847 Ante. Street"),(83,"Margaret","Hunt",76,74,"ac.nulla.In@necurna.co.uk","yellow.de","Portsmouth","83396",189,"8041 Sed Rd."),(84,"Jin","Gonzales",47,97,"semper.rutrum.Fusce@turpis.edu","blue.waffle","Chiaromonte","81475",165,"2840 Odio. Rd."),(85,"Melinda","Ramos",39,97,"Cras.sed@Lorem.com","indigo","Fairbanks","26927",192,"Ap #725-5150 Lorem, Av."),(86,"Slade","Estes",52,24,"massa.Suspendisse.eleifend@Integertinciduntaliquam.ca","red.com","Pontypridd","53567",103,"884-5742 Pharetra, Avenue"),(87,"Adele","Cantrell",106,74,"bibendum.Donec@sempereratin.ca","violet.xyz","Schoonaarde","92043",144,"Ap #571-9793 Et St."),(88,"Brooke","Atkins",66,23,"aliquet.nec.imperdiet@consectetuereuismod.org","red.com","Borgomaro","26135",151,"P.O. Box 369, 4731 Arcu St."),(89,"Reece","Matthews",106,32,"ut.cursus.luctus@Donectempor.ca","yellow.de","Wiener Neustadt","14669",80,"9368 Quis, Avenue"),(90,"Daniel","Downs",78,90,"felis.eget@vel.edu","orange.com","Estevan","55943",173,"Ap #620-4317 Natoque Rd.");
INSERT INTO `person` (`Person_ID`,`Vorname`,`Nachname`,`Mobilnummer`,`Festnetznummer`,`Email`,`Homepage`,`Wohnort`,`PLZ`,`HausNr`,`Straße`) VALUES (91,"Gage","Suarez",89,116,"tellus@auctorMauris.org","orange.com","Broken Hill","48056",125,"871-3728 Rhoncus Road"),(92,"Alika","Schwartz",2,124,"quis.massa@etcommodoat.ca","yellow.de","Cagliari","17296",178,"244 Imperdiet St."),(93,"Walter","Mcleod",90,6,"ligula.Aenean@massa.co.uk","red.com","Jhansi","75423",37,"Ap #464-2934 Quis, Ave"),(94,"Tate","Henson",10,20,"sociis@Aliquamerat.edu","blue.waffle","Maringá","08312",5,"175-3144 Urna. Street"),(95,"Kermit","Mcfadden",58,35,"erat.Vivamus@scelerisque.com","yellow.de","Tilff","67273",120,"504-9942 Phasellus Av."),(96,"Cailin","Boyd",103,64,"risus.Donec.egestas@vulputate.edu","green.it","Camporotondo di Fiastrone","24891",86,"162-924 Suscipit Rd."),(97,"Chaim","Briggs",75,0,"sed.dui@ac.ca","green.it","Deventer","99744",144,"Ap #990-5039 Dictum Rd."),(98,"Dale","Goodwin",93,111,"gravida.non.sollicitudin@odio.net","blue.waffle","Słupsk","55880",189,"P.O. Box 376, 3864 Lectus. Ave"),(99,"Maite","Griffith",98,94,"aliquam.adipiscing.lacus@mollisDuis.com","red.com","Mackay","66144",187,"P.O. Box 996, 9629 Et, St."),(100,"Alexis","Holt",16,75,"taciti.sociosqu@velitPellentesqueultricies.com","indigo","Mackay","53093",147,"P.O. Box 870, 9561 Lacus, Avenue");