
insert into wedstrijd (speeldag,thuisid,uitid,referee,dag,uur,aantaltoeschouwers) value ("1","STA","STVV","LUCWOUTERS","2009-07-31","20:30:00","26000");

	insert into persoonwedstrijd (persoonid,matchid) values ("SINANBOLAT",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("MARCOSCAMOZZATO",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("MOHAMEDSARR",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("TOMISLAVMIKULIC",(select last_insert_id()));
	
		insert into kaart (matchid,persoonid,kleur,minuut) values ((select last_insert_id()),"TOMISLAVMIKULIC","geel","41");
	
	insert into persoonwedstrijd (persoonid,matchid) values ("LANDRYMULEMO",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("STEVENDEFOUR",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("IGORDECAMARGO",(select last_insert_id()));
	
			insert into doelpunt (matchid,persoonid,minuut,owngoal) values ((select last_insert_id()),"IGORDECAMARGO","37",false);
		
			insert into doelpunt (matchid,persoonid,minuut,owngoal) values ((select last_insert_id()),"IGORDECAMARGO","55",false);
		
	insert into persoonwedstrijd (persoonid,matchid) values ("AXELWITSEL",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("WILFRIEDDALMAT",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("DIEUMERCIMBOKANI",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("MILANJOVANOVIC",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("MEHDICARCELA-GONZALEZ",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("MOUSSATRAORE",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("SIMONMIGNOLET",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("MARCWAGEMAKERS",(select last_insert_id()));
	
		insert into kaart (matchid,persoonid,kleur,minuut) values ((select last_insert_id()),"MARCWAGEMAKERS","geel","27");
	
	insert into persoonwedstrijd (persoonid,matchid) values ("MARIOCANTALUPPI",(select last_insert_id()));
	
		insert into kaart (matchid,persoonid,kleur,minuut) values ((select last_insert_id()),"MARIOCANTALUPPI","geel","62");
	
	insert into persoonwedstrijd (persoonid,matchid) values ("VINCENTEUVRARD",(select last_insert_id()));
	
			insert into doelpunt (matchid,persoonid,minuut,owngoal) values ((select last_insert_id()),"VINCENTEUVRARD","72",false);
		
	insert into persoonwedstrijd (persoonid,matchid) values ("DENISODOI",(select last_insert_id()));
	
		insert into kaart (matchid,persoonid,kleur,minuut) values ((select last_insert_id()),"DENISODOI","geel","63");
	
	insert into persoonwedstrijd (persoonid,matchid) values ("WIMMENNES",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("PETERDELORGE",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("JONATHANWILMET",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("CEPHASCHIMEDZA",(select last_insert_id()));
	
			insert into doelpunt (matchid,persoonid,minuut,owngoal) values ((select last_insert_id()),"CEPHASCHIMEDZA","24",false);
		
	insert into persoonwedstrijd (persoonid,matchid) values ("ALEXDASILVA",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("IBRAHIMSIDIBE",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("HERVEONANA",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("LUDOVICBUYSENS",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("JEROENAPPELTANS",(select last_insert_id()));
	
insert into wissel (matchid,inid,uitid,minuut) values ((select last_insert_id()),"MEHDICARCELA-GONZALEZ","WILFRIEDDALMAT","83");

insert into wissel (matchid,inid,uitid,minuut) values ((select last_insert_id()),"MOUSSATRAORE","MILANJOVANOVIC","83");

insert into wissel (matchid,inid,uitid,minuut) values ((select last_insert_id()),"HERVEONANA","ALEXDASILVA","
          68
        ");

insert into wissel (matchid,inid,uitid,minuut) values ((select last_insert_id()),"LUDOVICBUYSENS","MARCWAGEMAKERS","
          81
        ");

insert into wissel (matchid,inid,uitid,minuut) values ((select last_insert_id()),"JEROENAPPELTANS","CEPHASCHIMEDZA","
          85
        ");

insert into wedstrijd (speeldag,thuisid,uitid,referee,dag,uur,aantaltoeschouwers) value ("1","LOK","ZWA","SEBASTIENDELFERIERE","2009-08-01","20:00:00","6553");

	insert into persoonwedstrijd (persoonid,matchid) values ("BOUBACARCOPA",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("OLIVIERDOLL",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("FRÉDÉRICDUPRÉ",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("HASSANELMOUATAZ",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("IBRAHIMAGUEYE",(select last_insert_id()));
	
		insert into kaart (matchid,persoonid,kleur,minuut) values ((select last_insert_id()),"IBRAHIMAGUEYE","rood","22");
	
	insert into persoonwedstrijd (persoonid,matchid) values ("SULEJMANSMAJIC",(select last_insert_id()));
	
			insert into doelpunt (matchid,persoonid,minuut,owngoal) values ((select last_insert_id()),"SULEJMANSMAJIC","9",false);
		
	insert into persoonwedstrijd (persoonid,matchid) values ("MARCELMBAYO",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("TSHINYAMATIKO",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("MARIOCAREVIC",(select last_insert_id()));
	
		insert into kaart (matchid,persoonid,kleur,minuut) values ((select last_insert_id()),"MARIOCAREVIC","geel","78");
	
	insert into persoonwedstrijd (persoonid,matchid) values ("NILLDEPAUW",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("TOMISLAVSOKOTA",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("AVISTRUL",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("KILLIANOVERMEIRE",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("OMERGOLAN",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("SAMMYBOSSUT",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("STIJNMINNE",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("KARELDHAENE",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("BARTBUYSSE",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("JÉRÉMYTARAVEL",(select last_insert_id()));
	
		insert into kaart (matchid,persoonid,kleur,minuut) values ((select last_insert_id()),"JÉRÉMYTARAVEL","geel","80");
	
	insert into persoonwedstrijd (persoonid,matchid) values ("STIJNMEERT",(select last_insert_id()));
	
			insert into doelpunt (matchid,persoonid,minuut,owngoal) values ((select last_insert_id()),"STIJNMEERT","83",false);
		
		insert into kaart (matchid,persoonid,kleur,minuut) values ((select last_insert_id()),"STIJNMEERT","geel","26");
	
	insert into persoonwedstrijd (persoonid,matchid) values ("KEVINROELANDTS",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("STEVECOLPAERT",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("FRANCKBERRIER",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("KHALEEMHYLAND",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("CHRISMAKIESE",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("ERNESTNFOR",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("TEDDYCHEVALIER",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("MIGUELDACHELET",(select last_insert_id()));
	
insert into wissel (matchid,inid,uitid,minuut) values ((select last_insert_id()),"AVISTRUL","NILLDEPAUW","
		63
		");

insert into wissel (matchid,inid,uitid,minuut) values ((select last_insert_id()),"KILLIANOVERMEIRE","SULEJMANSMAJIC","
		72
		");

insert into wissel (matchid,inid,uitid,minuut) values ((select last_insert_id()),"OMERGOLAN","TOMISLAVSOKOTA","
		80
		");

insert into wissel (matchid,inid,uitid,minuut) values ((select last_insert_id()),"ERNESTNFOR","KHALEEMHYLAND","
		51
		");

insert into wissel (matchid,inid,uitid,minuut) values ((select last_insert_id()),"TEDDYCHEVALIER","STEVECOLPAERT","
		60
		");

insert into wissel (matchid,inid,uitid,minuut) values ((select last_insert_id()),"MIGUELDACHELET","CHRISMAKIESE","
		88
		");

insert into wedstrijd (speeldag,thuisid,uitid,referee,dag,uur,aantaltoeschouwers) value ("1","GNK","MOE","PETERVERVECKEN","2009-08-01","20:00:00","17122");

	insert into persoonwedstrijd (persoonid,matchid) values ("DAVINOVERHULST",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("HANSCORNELIS",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("JOAOCARLOS",(select last_insert_id()));
	
			insert into doelpunt (matchid,persoonid,minuut,owngoal) values ((select last_insert_id()),"JOAOCARLOS","93",false);
		
	insert into persoonwedstrijd (persoonid,matchid) values ("ERICMATOUKOU",(select last_insert_id()));
	
		insert into kaart (matchid,persoonid,kleur,minuut) values ((select last_insert_id()),"ERICMATOUKOU","geel","60");
	
	insert into persoonwedstrijd (persoonid,matchid) values ("DAVIDHUBERT",(select last_insert_id()));
	
		insert into kaart (matchid,persoonid,kleur,minuut) values ((select last_insert_id()),"DAVIDHUBERT","geel","53");
	
	insert into persoonwedstrijd (persoonid,matchid) values ("DANIELPUDIL",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("DANIELTOZSER",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("ANELENGCONGCA",(select last_insert_id()));
	
		insert into kaart (matchid,persoonid,kleur,minuut) values ((select last_insert_id()),"ANELENGCONGCA","geel","44");
	
	insert into persoonwedstrijd (persoonid,matchid) values ("STEINHUYSEGEMS",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("FABIENCAMUS",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("ELYANIVBARDA",(select last_insert_id()));
	
		insert into kaart (matchid,persoonid,kleur,minuut) values ((select last_insert_id()),"ELYANIVBARDA","geel","64");
	
	insert into persoonwedstrijd (persoonid,matchid) values ("ISTVANBAKX",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("MOUSSAKOITA",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("KEVINDEBRUYNE",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("JOSÉANTONIOSALCEDO",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("GONZAGUEVANDOOREN",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("CHEMCEDINEELARAICHI",(select last_insert_id()));
	
		insert into kaart (matchid,persoonid,kleur,minuut) values ((select last_insert_id()),"CHEMCEDINEELARAICHI","geel","66");
	
	insert into persoonwedstrijd (persoonid,matchid) values ("DAANVANGYSEGHEM",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("CARLOSDAVIDMORENOHERNANDEZ",(select last_insert_id()));
	
		insert into kaart (matchid,persoonid,kleur,minuut) values ((select last_insert_id()),"CARLOSDAVIDMORENOHERNANDEZ","geel","26");
	
	insert into persoonwedstrijd (persoonid,matchid) values ("GUILLAUMEFRANÇOIS",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("JONATHANJUNCAL",(select last_insert_id()));
	
		insert into kaart (matchid,persoonid,kleur,minuut) values ((select last_insert_id()),"JONATHANJUNCAL","geel","32");
	
	insert into persoonwedstrijd (persoonid,matchid) values ("MATHIEUASSOU-EKOTTO",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("IDIROUALI",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("ZVONIMIRDERANJA",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("OKWUNWANNEJAYCEE",(select last_insert_id()));
	
			insert into doelpunt (matchid,persoonid,minuut,owngoal) values ((select last_insert_id()),"OKWUNWANNEJAYCEE","4",false);
		
			insert into doelpunt (matchid,persoonid,minuut,owngoal) values ((select last_insert_id()),"OKWUNWANNEJAYCEE","77",false);
		
	insert into persoonwedstrijd (persoonid,matchid) values ("MAMADOUDIAKITE",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("BASTIENCHANTRY",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("MAXIMELESTIENNE",(select last_insert_id()));
	
insert into wissel (matchid,inid,uitid,minuut) values ((select last_insert_id()),"ISTVANBAKX","STEINHUYSEGEMS","
		61
		");

insert into wissel (matchid,inid,uitid,minuut) values ((select last_insert_id()),"MOUSSAKOITA","ERICMATOUKOU","
		68
		");

insert into wissel (matchid,inid,uitid,minuut) values ((select last_insert_id()),"KEVINDEBRUYNE","ELYANIVBARDA","
		80
		");

insert into wissel (matchid,inid,uitid,minuut) values ((select last_insert_id()),"MAMADOUDIAKITE","MATHIEUASSOU-EKOTTO","
		68
		");

insert into wissel (matchid,inid,uitid,minuut) values ((select last_insert_id()),"BASTIENCHANTRY","CHEMCEDINEELARAICHI","
		85
		");

insert into wissel (matchid,inid,uitid,minuut) values ((select last_insert_id()),"MAXIMELESTIENNE","OKWUNWANNEJAYCEE","
		90
		");

insert into wedstrijd (speeldag,thuisid,uitid,referee,dag,uur,aantaltoeschouwers) value ("1","ROE","GBA","JOERIVANDEVELDE","2009-08-01","20:00:00","4884");

	insert into persoonwedstrijd (persoonid,matchid) values ("JURGENSIERENS",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("BRAMVANDENBUSSCHE",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("ANTHONYVANLOO",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("JEREMYHUYGHEBAERT",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("DAMIRMIRVIC",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("STEFAANTANGHE",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("VINCENTPROVOOST",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("JOERIDEQUEVY",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("ARTUROTENHEUVEL",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("MAHAMADOUDISSA",(select last_insert_id()));
	
			insert into doelpunt (matchid,persoonid,minuut,owngoal) values ((select last_insert_id()),"MAHAMADOUDISSA","82",false);
		
	insert into persoonwedstrijd (persoonid,matchid) values ("JOHNCOLLINS",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("SERGIOHELLINGS",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("TOMISLAVPACOVSKI",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("KURTVANDOOREN",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("PIETERJANMONTEYNE",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("MARTIJNMONTEYNE",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("JUSTICEWAMFOR",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("BARTGOOR",(select last_insert_id()));
	
		insert into kaart (matchid,persoonid,kleur,minuut) values ((select last_insert_id()),"BARTGOOR","geel","65");
	
	insert into persoonwedstrijd (persoonid,matchid) values ("WIMDEDECKER",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("FARISHAROUN",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("IVANLEKO",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("SHERJILLMACDONALD",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("SANHARIBMALKI",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("TOSINDOSUMNU",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("DANIELCRUZ",(select last_insert_id()));
	
			insert into doelpunt (matchid,persoonid,minuut,owngoal) values ((select last_insert_id()),"DANIELCRUZ","93",false);
		
	insert into persoonwedstrijd (persoonid,matchid) values ("MARKDEMAN",(select last_insert_id()));
	
insert into wissel (matchid,inid,uitid,minuut) values ((select last_insert_id()),"SERGIOHELLINGS","JOHNCOLLINS","
		85
		");

insert into wissel (matchid,inid,uitid,minuut) values ((select last_insert_id()),"TOSINDOSUMNU","SANHARIBMALKI","
		69
		");

insert into wissel (matchid,inid,uitid,minuut) values ((select last_insert_id()),"DANIELCRUZ","MARTIJNMONTEYNE","
		85
		");

insert into wissel (matchid,inid,uitid,minuut) values ((select last_insert_id()),"MARKDEMAN","IVANLEKO","
		85
		");

insert into wedstrijd (speeldag,thuisid,uitid,referee,dag,uur,aantaltoeschouwers) value ("1","KVM","WES","PAULALLAERTS","2009-08-01","20:00:00","11200");

	insert into persoonwedstrijd (persoonid,matchid) values ("WOUTERBIEBAUW",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("KENNYVANHOEVELEN",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("XAVIERCHEN",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("JONASIVENS",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("ANTONIOGHOMSI",(select last_insert_id()));
	
		insert into kaart (matchid,persoonid,kleur,minuut) values ((select last_insert_id()),"ANTONIOGHOMSI","geel","55");
	
	insert into persoonwedstrijd (persoonid,matchid) values ("DAVIDDESTORME",(select last_insert_id()));
	
			insert into doelpunt (matchid,persoonid,minuut,owngoal) values ((select last_insert_id()),"DAVIDDESTORME","28",false);
		
			insert into doelpunt (matchid,persoonid,minuut,owngoal) values ((select last_insert_id()),"DAVIDDESTORME","72",false);
		
		insert into kaart (matchid,persoonid,kleur,minuut) values ((select last_insert_id()),"DAVIDDESTORME","geel","37");
	
	insert into persoonwedstrijd (persoonid,matchid) values ("WOUTERVRANCKEN",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("KOENPERSOONS",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("JULIENGORIUS",(select last_insert_id()));
	
			insert into doelpunt (matchid,persoonid,minuut,owngoal) values ((select last_insert_id()),"JULIENGORIUS","66",false);
		
	insert into persoonwedstrijd (persoonid,matchid) values ("ABDULYAKUNIIDDI",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("ALOISNONG",(select last_insert_id()));
	
			insert into doelpunt (matchid,persoonid,minuut,owngoal) values ((select last_insert_id()),"ALOISNONG","16",false);
		
		insert into kaart (matchid,persoonid,kleur,minuut) values ((select last_insert_id()),"ALOISNONG","geel","36");
	
	insert into persoonwedstrijd (persoonid,matchid) values ("KENNETHVANGOETHEM",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("JOACHIMMUNUNGA",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("YONIBUYENS",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("YVESDEWINTER",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("NICOVANKERCKHOVEN",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("JEFDELEN",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("GUNTHERVANAUDENAERDE",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("WOUTERCORSTJENS",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("WOUTERSCHEELEN",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("STEVENDEPETTER",(select last_insert_id()));
	
		insert into kaart (matchid,persoonid,kleur,minuut) values ((select last_insert_id()),"STEVENDEPETTER","geel","26");
	
	insert into persoonwedstrijd (persoonid,matchid) values ("LUKASZELENKA",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("EMMANUELSARKI",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("MOSESADAMS",(select last_insert_id()));
	
		insert into kaart (matchid,persoonid,kleur,minuut) values ((select last_insert_id()),"MOSESADAMS","geel","55");
	
	insert into persoonwedstrijd (persoonid,matchid) values ("ODITAOBIORA",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("MOMODOUCEESAY",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("GLENNVANASTEN",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("BERTINTOMOU",(select last_insert_id()));
	
			insert into doelpunt (matchid,persoonid,minuut,owngoal) values ((select last_insert_id()),"BERTINTOMOU","85",false);
		
insert into wissel (matchid,inid,uitid,minuut) values ((select last_insert_id()),"KENNETHVANGOETHEM","ABDULYAKUNIIDDI","
		71
		");

insert into wissel (matchid,inid,uitid,minuut) values ((select last_insert_id()),"JOACHIMMUNUNGA","ALOISNONG","
		79
		");

insert into wissel (matchid,inid,uitid,minuut) values ((select last_insert_id()),"YONIBUYENS","WOUTERVRANCKEN","
		81
		");

insert into wissel (matchid,inid,uitid,minuut) values ((select last_insert_id()),"MOMODOUCEESAY","EMMANUELSARKI","
		33
		");

insert into wissel (matchid,inid,uitid,minuut) values ((select last_insert_id()),"GLENNVANASTEN","LUKASZELENKA","
		61	
		");

insert into wissel (matchid,inid,uitid,minuut) values ((select last_insert_id()),"BERTINTOMOU","ODITAOBIORA","
		78
		");

insert into wedstrijd (speeldag,thuisid,uitid,referee,dag,uur,aantaltoeschouwers) value ("1","KOR","AND","SERGEGUMIENNY","2009-08-01","20:00:00","8640");

	insert into persoonwedstrijd (persoonid,matchid) values ("GLENNVERBAUWHEDE",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("BRECHTVERBRUGGHE",(select last_insert_id()));
	
		insert into kaart (matchid,persoonid,kleur,minuut) values ((select last_insert_id()),"BRECHTVERBRUGGHE","geel","52");
	
	insert into persoonwedstrijd (persoonid,matchid) values ("BRAMDELY",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("LORISREINA",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("MLADENLAZAREVIC",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("JIMMYHEMPTE",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("DAVYDEBEULE",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("SVENKUMS",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("DANIELCALVO",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("LEONBENKO",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("EBRAHIMIBOU",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("WILLIAMXAVIERBARBOSA",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("MOHAMEDMESSOUDI",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("TOMSOETAERS",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("SILVIOPROTO",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("OLIVIERDESCHACHT",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("JELLEVANDAMME",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("ROLANDJUHASZ",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("MARCINWASILEWSKI",(select last_insert_id()));
	
			insert into doelpunt (matchid,persoonid,minuut,owngoal) values ((select last_insert_id()),"MARCINWASILEWSKI","71",false);
		
	insert into persoonwedstrijd (persoonid,matchid) values ("LUCASBIGLIA",(select last_insert_id()));
	
		insert into kaart (matchid,persoonid,kleur,minuut) values ((select last_insert_id()),"LUCASBIGLIA","geel","73");
	
	insert into persoonwedstrijd (persoonid,matchid) values ("GUILLAUMEGILLET",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("JONATHANLEGEAR",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("MBARKBOUSSOUFA",(select last_insert_id()));
	
			insert into doelpunt (matchid,persoonid,minuut,owngoal) values ((select last_insert_id()),"MBARKBOUSSOUFA","8",false);
		
		insert into kaart (matchid,persoonid,kleur,minuut) values ((select last_insert_id()),"MBARKBOUSSOUFA","geel","45");
	
	insert into persoonwedstrijd (persoonid,matchid) values ("MATIASSUAREZ",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("TOMDESUTTER",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("THOMASCHATELLE",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("NICOLASFRUTOS",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("REYNALDO",(select last_insert_id()));
	
insert into wissel (matchid,inid,uitid,minuut) values ((select last_insert_id()),"MOHAMEDMESSOUDI","DANIELCALVO","63");

insert into wissel (matchid,inid,uitid,minuut) values ((select last_insert_id()),"WILLIAMXAVIERBARBOSA","EBRAHIMIBOU","63");

insert into wissel (matchid,inid,uitid,minuut) values ((select last_insert_id()),"TOMSOETAERS","DAVYDEBEULE","83");

insert into wissel (matchid,inid,uitid,minuut) values ((select last_insert_id()),"THOMASCHATELLE","JONATHANLEGEAR","70");

insert into wissel (matchid,inid,uitid,minuut) values ((select last_insert_id()),"NICOLASFRUTOS","TOMDESUTTER","75");

insert into wissel (matchid,inid,uitid,minuut) values ((select last_insert_id()),"REYNALDO","MATIASSUAREZ","84");

insert into wedstrijd (speeldag,thuisid,uitid,referee,dag,uur,aantaltoeschouwers) value ("1","CHA","CLU","STEPHANEBREDA","2009-08-02","18:00:00","10349");

	insert into persoonwedstrijd (persoonid,matchid) values ("SÉBASTIENCHABBERT",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("ORLANDODOSSANTOSCOSTA",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("MAHAMOUDOUKERE",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("MAXIMEBRILLAULT",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("MOHAMEDCHAKOURI",(select last_insert_id()));
	
		insert into kaart (matchid,persoonid,kleur,minuut) values ((select last_insert_id()),"MOHAMEDCHAKOURI","rood","29");
	
	insert into persoonwedstrijd (persoonid,matchid) values ("ADLENEGUEDIOURA",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("GREGORYCHRIST",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("ABDELMAJIDOULMERS",(select last_insert_id()));
	
		insert into kaart (matchid,persoonid,kleur,minuut) values ((select last_insert_id()),"ABDELMAJIDOULMERS","rood","41");
	
	insert into persoonwedstrijd (persoonid,matchid) values ("MOUHSINEIAJOUR",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("ILOMBEMBOYO",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("CYRILTHÉREAU",(select last_insert_id()));
	
			insert into doelpunt (matchid,persoonid,minuut,owngoal) values ((select last_insert_id()),"CYRILTHÉREAU","28",false);
		
	insert into persoonwedstrijd (persoonid,matchid) values ("HERVEKAGE",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("ALESSANDROCORDARO",(select last_insert_id()));
	
		insert into kaart (matchid,persoonid,kleur,minuut) values ((select last_insert_id()),"ALESSANDROCORDARO","rood","69");
	
	insert into persoonwedstrijd (persoonid,matchid) values ("HABIBHABIBOU",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("STIJNSTIJNEN",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("KOENDAERDEN",(select last_insert_id()));
	
		insert into kaart (matchid,persoonid,kleur,minuut) values ((select last_insert_id()),"KOENDAERDEN","geel","53");
	
	insert into persoonwedstrijd (persoonid,matchid) values ("JORNVERMEULEN",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("RYANDONK",(select last_insert_id()));
	
		insert into kaart (matchid,persoonid,kleur,minuut) values ((select last_insert_id()),"RYANDONK","geel","29");
	
	insert into persoonwedstrijd (persoonid,matchid) values ("ANTOLINALCARAZ",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("JONATHANBLONDEL",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("JEROENSIMAEYS",(select last_insert_id()));
	
		insert into kaart (matchid,persoonid,kleur,minuut) values ((select last_insert_id()),"JEROENSIMAEYS","geel","87");
	
	insert into persoonwedstrijd (persoonid,matchid) values ("VADISODJIDJAOFOE",(select last_insert_id()));
	
			insert into doelpunt (matchid,persoonid,minuut,owngoal) values ((select last_insert_id()),"VADISODJIDJAOFOE","4",false);
		
	insert into persoonwedstrijd (persoonid,matchid) values ("NABILDIRAR",(select last_insert_id()));
	
			insert into doelpunt (matchid,persoonid,minuut,owngoal) values ((select last_insert_id()),"NABILDIRAR","37",false);
		
	insert into persoonwedstrijd (persoonid,matchid) values ("RONALDVARGAS",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("JOSEPHAKPALA",(select last_insert_id()));
	
		insert into kaart (matchid,persoonid,kleur,minuut) values ((select last_insert_id()),"JOSEPHAKPALA","geel","53");
	
	insert into persoonwedstrijd (persoonid,matchid) values ("KARELGERAERTS",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("MOHAMEDDAHMANE",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("WESLEYSONCK",(select last_insert_id()));
	
insert into wissel (matchid,inid,uitid,minuut) values ((select last_insert_id()),"HERVEKAGE","MOUHSINEIAJOUR","35");

insert into wissel (matchid,inid,uitid,minuut) values ((select last_insert_id()),"ALESSANDROCORDARO","CYRILTHÉREAU","45");

insert into wissel (matchid,inid,uitid,minuut) values ((select last_insert_id()),"HABIBHABIBOU","ILOMBEMBOYO","79");

insert into wissel (matchid,inid,uitid,minuut) values ((select last_insert_id()),"KARELGERAERTS","JORNVERMEULEN","54");

insert into wissel (matchid,inid,uitid,minuut) values ((select last_insert_id()),"MOHAMEDDAHMANE","RONALDVARGAS","56");

insert into wissel (matchid,inid,uitid,minuut) values ((select last_insert_id()),"WESLEYSONCK","JONATHANBLONDEL","73");

insert into wedstrijd (speeldag,thuisid,uitid,referee,dag,uur,aantaltoeschouwers) value ("1","CER","GNT","ALEXANDREBOUCAUT","2009-08-02","20:30:00","8619");

	insert into persoonwedstrijd (persoonid,matchid) values ("BRAMVERBIST",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("DENISVIANE",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("BERNTEVENS",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("ANTHONYPORTIER",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("FREDERIKBOI",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("TONYSERGEANT",(select last_insert_id()));
	
		insert into kaart (matchid,persoonid,kleur,minuut) values ((select last_insert_id()),"TONYSERGEANT","geel","22");
	
	insert into persoonwedstrijd (persoonid,matchid) values ("SERHIJSEREBRENNIKOV",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("HONOURGOMBAMI",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("VUSUMUZINYONI",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("OLEGIACHTCHOUK",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("DOMINICFOLEY",(select last_insert_id()));
	
			insert into doelpunt (matchid,persoonid,minuut,owngoal) values ((select last_insert_id()),"DOMINICFOLEY","7",false);
		
	insert into persoonwedstrijd (persoonid,matchid) values ("THOMASBUFFEL",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("BOJANBOZOVIC",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("WANGYANG",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("BOJANJORGACEVIC",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("STEFWILS",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("KENNYTHOMPSON",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("CHRISTOPHEGRONDIN",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("MARKOSULER",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("TIMSMOLDERS",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("CHRISTOPHELEPOINT",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("STIJNDESMET",(select last_insert_id()));
	
			insert into doelpunt (matchid,persoonid,minuut,owngoal) values ((select last_insert_id()),"STIJNDESMET","61",false);
		
	insert into persoonwedstrijd (persoonid,matchid) values ("ADRIANODUARTE",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("MBAYELEYE",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("ZLATANLJUBIJANKIC",(select last_insert_id()));
	
			insert into doelpunt (matchid,persoonid,minuut,owngoal) values ((select last_insert_id()),"ZLATANLJUBIJANKIC","47",false);
		
		insert into kaart (matchid,persoonid,kleur,minuut) values ((select last_insert_id()),"ZLATANLJUBIJANKIC","geel","32");
	
	insert into persoonwedstrijd (persoonid,matchid) values ("MILOSMARIC",(select last_insert_id()));
	
			insert into doelpunt (matchid,persoonid,minuut,owngoal) values ((select last_insert_id()),"MILOSMARIC","81",false);
		
	insert into persoonwedstrijd (persoonid,matchid) values ("YASSINEELGHANASSY",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("ELIMANECOULIBALY",(select last_insert_id()));
	
insert into wissel (matchid,inid,uitid,minuut) values ((select last_insert_id()),"THOMASBUFFEL","SERHIJSEREBRENNIKOV","69");

insert into wissel (matchid,inid,uitid,minuut) values ((select last_insert_id()),"BOJANBOZOVIC","DOMINICFOLEY","69");

insert into wissel (matchid,inid,uitid,minuut) values ((select last_insert_id()),"WANGYANG","VUSUMUZINYONI","85");

insert into wissel (matchid,inid,uitid,minuut) values ((select last_insert_id()),"MILOSMARIC","ADRIANODUARTE","59");

insert into wissel (matchid,inid,uitid,minuut) values ((select last_insert_id()),"YASSINEELGHANASSY","STIJNDESMET","75");

insert into wissel (matchid,inid,uitid,minuut) values ((select last_insert_id()),"ELIMANECOULIBALY","ZLATANLJUBIJANKIC","97");

insert into wedstrijd (speeldag,thuisid,uitid,referee,dag,uur,aantaltoeschouwers) value ("2","GBA","STA","CLAUDEBOURDOUXHE","2009-08-07","20:30:00","12500");

	insert into persoonwedstrijd (persoonid,matchid) values ("TOMISLAVPACOVSKI",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("PHILIPPECLEMENT",(select last_insert_id()));
	
		insert into kaart (matchid,persoonid,kleur,minuut) values ((select last_insert_id()),"PHILIPPECLEMENT","geel","68");
	
	insert into persoonwedstrijd (persoonid,matchid) values ("KURTVANDOOREN",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("PIETERJANMONTEYNE",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("JUSTICEWAMFOR",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("BARTGOOR",(select last_insert_id()));
	
			insert into doelpunt (matchid,persoonid,minuut,owngoal) values ((select last_insert_id()),"BARTGOOR","72",false);
		
	insert into persoonwedstrijd (persoonid,matchid) values ("WIMDEDECKER",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("FARISHAROUN",(select last_insert_id()));
	
		insert into kaart (matchid,persoonid,kleur,minuut) values ((select last_insert_id()),"FARISHAROUN","geel","26");
	
	insert into persoonwedstrijd (persoonid,matchid) values ("IVANLEKO",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("DANIELCRUZ",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("SHERJILLMACDONALD",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("MARKDEMAN",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("TOSINDOSUMNU",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("SANHARIBMALKI",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("SINANBOLAT",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("LANDRYMULEMO",(select last_insert_id()));
	
		insert into kaart (matchid,persoonid,kleur,minuut) values ((select last_insert_id()),"LANDRYMULEMO","geel","28");
	
	insert into persoonwedstrijd (persoonid,matchid) values ("MARCOSCAMOZZATO",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("ELIAQUIMMANGALA",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("MOHAMEDSARR",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("STEVENDEFOUR",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("AXELWITSEL",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("IGORDECAMARGO",(select last_insert_id()));
	
		insert into kaart (matchid,persoonid,kleur,minuut) values ((select last_insert_id()),"IGORDECAMARGO","geel","46");
	
	insert into persoonwedstrijd (persoonid,matchid) values ("MOUSSATRAORE",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("DIEUMERCIMBOKANI",(select last_insert_id()));
	
		insert into kaart (matchid,persoonid,kleur,minuut) values ((select last_insert_id()),"DIEUMERCIMBOKANI","geel","60");
	
	insert into persoonwedstrijd (persoonid,matchid) values ("MILANJOVANOVIC",(select last_insert_id()));
	
			insert into doelpunt (matchid,persoonid,minuut,owngoal) values ((select last_insert_id()),"MILANJOVANOVIC","79",false);
		
	insert into persoonwedstrijd (persoonid,matchid) values ("WILFRIEDDALMAT",(select last_insert_id()));
	
insert into wissel (matchid,inid,uitid,minuut) values ((select last_insert_id()),"MARKDEMAN","IVANLEKO","81");

insert into wissel (matchid,inid,uitid,minuut) values ((select last_insert_id()),"TOSINDOSUMNU","DANIELCRUZ","81");

insert into wissel (matchid,inid,uitid,minuut) values ((select last_insert_id()),"SANHARIBMALKI","SHERJILLMACDONALD","86");

insert into wissel (matchid,inid,uitid,minuut) values ((select last_insert_id()),"WILFRIEDDALMAT","MOUSSATRAORE","61");

insert into wedstrijd (speeldag,thuisid,uitid,referee,dag,uur,aantaltoeschouwers) value ("2","STVV","CHA","SAMLOEMAN","2009-08-08","20:00:00","7000");

	insert into persoonwedstrijd (persoonid,matchid) values ("SIMONMIGNOLET",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("MARCWAGEMAKERS",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("VINCENTEUVRARD",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("DENISODOI",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("MARIOCANTALUPPI",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("WIMMENNES",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("PETERDELORGE",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("CEPHASCHIMEDZA",(select last_insert_id()));
	
		insert into kaart (matchid,persoonid,kleur,minuut) values ((select last_insert_id()),"CEPHASCHIMEDZA","geel","88");
	
	insert into persoonwedstrijd (persoonid,matchid) values ("JONATHANWILMET",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("ALEXDASILVA",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("IBRAHIMSIDIBE",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("HERVEONANA",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("SÉBASTIENCHABBERT",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("DAVIDVANDENBROECK",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("ORLANDODOSSANTOSCOSTA",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("MAHAMOUDOUKERE",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("MAXIMEBRILLAULT",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("HERVEKAGE",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("JANLELLA",(select last_insert_id()));
	
		insert into kaart (matchid,persoonid,kleur,minuut) values ((select last_insert_id()),"JANLELLA","geel","43");
	
	insert into persoonwedstrijd (persoonid,matchid) values ("SEBASTIENCHABOUD",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("GREGORYCHRIST",(select last_insert_id()));
	
		insert into kaart (matchid,persoonid,kleur,minuut) values ((select last_insert_id()),"GREGORYCHRIST","geel","37");
	
	insert into persoonwedstrijd (persoonid,matchid) values ("CYRILTHÉREAU",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("HABIBHABIBOU",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("IBRAHIMADIALLO",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("MOUHSINEIAJOUR",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("MICHAELBLANC",(select last_insert_id()));
	
insert into wissel (matchid,inid,uitid,minuut) values ((select last_insert_id()),"HERVEONANA","ALEXDASILVA","66");

insert into wissel (matchid,inid,uitid,minuut) values ((select last_insert_id()),"IBRAHIMADIALLO","JANLELLA","45");

insert into wissel (matchid,inid,uitid,minuut) values ((select last_insert_id()),"MOUHSINEIAJOUR","ORLANDODOSSANTOSCOSTA","64");

insert into wissel (matchid,inid,uitid,minuut) values ((select last_insert_id()),"MICHAELBLANC","HERVEKAGE","91");

insert into wedstrijd (speeldag,thuisid,uitid,referee,dag,uur,aantaltoeschouwers) value ("2","AND","CER","TIMPOTS","2009-08-08","20:00:00","22400");

	insert into persoonwedstrijd (persoonid,matchid) values ("SILVIOPROTO",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("OLIVIERDESCHACHT",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("JELLEVANDAMME",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("ROLANDJUHASZ",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("MARCINWASILEWSKI",(select last_insert_id()));
	
		insert into kaart (matchid,persoonid,kleur,minuut) values ((select last_insert_id()),"MARCINWASILEWSKI","geel","63");
	
	insert into persoonwedstrijd (persoonid,matchid) values ("LUCASBIGLIA",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("JONATHANLEGEAR",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("JANPOLAK",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("MBARKBOUSSOUFA",(select last_insert_id()));
	
			insert into doelpunt (matchid,persoonid,minuut,owngoal) values ((select last_insert_id()),"MBARKBOUSSOUFA","64",false);
		
	insert into persoonwedstrijd (persoonid,matchid) values ("MATIASSUAREZ",(select last_insert_id()));
	
			insert into doelpunt (matchid,persoonid,minuut,owngoal) values ((select last_insert_id()),"MATIASSUAREZ","13",false);
		
	insert into persoonwedstrijd (persoonid,matchid) values ("TOMDESUTTER",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("THOMASCHATELLE",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("RUBENILSONKANU",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("GUILLAUMEGILLET",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("JOCOPPENS",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("DENISVIANE",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("BERNTEVENS",(select last_insert_id()));
	
		insert into kaart (matchid,persoonid,kleur,minuut) values ((select last_insert_id()),"BERNTEVENS","geel","46");
	
	insert into persoonwedstrijd (persoonid,matchid) values ("ANTHONYPORTIER",(select last_insert_id()));
	
			insert into doelpunt (matchid,persoonid,minuut,owngoal) values ((select last_insert_id()),"ANTHONYPORTIER","28",false);
		
	insert into persoonwedstrijd (persoonid,matchid) values ("FREDERIKBOI",(select last_insert_id()));
	
			insert into doelpunt (matchid,persoonid,minuut,owngoal) values ((select last_insert_id()),"FREDERIKBOI","43",true);
		
		insert into kaart (matchid,persoonid,kleur,minuut) values ((select last_insert_id()),"FREDERIKBOI","geel","59");
	
	insert into persoonwedstrijd (persoonid,matchid) values ("TONYSERGEANT",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("OLEGIACHTCHOUK",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("THOMASBUFFEL",(select last_insert_id()));
	
			insert into doelpunt (matchid,persoonid,minuut,owngoal) values ((select last_insert_id()),"THOMASBUFFEL","74",false);
		
	insert into persoonwedstrijd (persoonid,matchid) values ("HONOURGOMBAMI",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("VUSUMUZINYONI",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("BOJANBOZOVIC",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("SERHIJSEREBRENNIKOV",(select last_insert_id()));
	
insert into wissel (matchid,inid,uitid,minuut) values ((select last_insert_id()),"THOMASCHATELLE","JONATHANLEGEAR","77");

insert into wissel (matchid,inid,uitid,minuut) values ((select last_insert_id()),"RUBENILSONKANU","TOMDESUTTER","80");

insert into wissel (matchid,inid,uitid,minuut) values ((select last_insert_id()),"GUILLAUMEGILLET","MATIASSUAREZ","91");

insert into wissel (matchid,inid,uitid,minuut) values ((select last_insert_id()),"SERHIJSEREBRENNIKOV","TONYSERGEANT","69");

insert into wedstrijd (speeldag,thuisid,uitid,referee,dag,uur,aantaltoeschouwers) value ("2","ZWA","GNK","STEPHANEBREDA","2009-08-08","20:00:00","6000");

	insert into persoonwedstrijd (persoonid,matchid) values ("SAMMYBOSSUT",(select last_insert_id()));
	
		insert into kaart (matchid,persoonid,kleur,minuut) values ((select last_insert_id()),"SAMMYBOSSUT","geel","77");
	
	insert into persoonwedstrijd (persoonid,matchid) values ("STIJNMINNE",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("KARELDHAENE",(select last_insert_id()));
	
			insert into doelpunt (matchid,persoonid,minuut,owngoal) values ((select last_insert_id()),"KARELDHAENE","21",false);
		
		insert into kaart (matchid,persoonid,kleur,minuut) values ((select last_insert_id()),"KARELDHAENE","geel","93");
	
	insert into persoonwedstrijd (persoonid,matchid) values ("BARTBUYSSE",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("JÉRÉMYTARAVEL",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("STIJNMEERT",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("KEVINROELANDTS",(select last_insert_id()));
	
		insert into kaart (matchid,persoonid,kleur,minuut) values ((select last_insert_id()),"KEVINROELANDTS","geel","75");
	
	insert into persoonwedstrijd (persoonid,matchid) values ("FRANCKBERRIER",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("TEDDYCHEVALIER",(select last_insert_id()));
	
			insert into doelpunt (matchid,persoonid,minuut,owngoal) values ((select last_insert_id()),"TEDDYCHEVALIER","51",false);
		
	insert into persoonwedstrijd (persoonid,matchid) values ("KHALEEMHYLAND",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("ERNESTNFOR",(select last_insert_id()));
	
		insert into kaart (matchid,persoonid,kleur,minuut) values ((select last_insert_id()),"ERNESTNFOR","geel","25");
	
	insert into persoonwedstrijd (persoonid,matchid) values ("CHRISMAKIESE",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("DAVINOVERHULST",(select last_insert_id()));
	
		insert into kaart (matchid,persoonid,kleur,minuut) values ((select last_insert_id()),"DAVINOVERHULST","geel","88");
	
	insert into persoonwedstrijd (persoonid,matchid) values ("DAVIDHUBERT",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("JOAOCARLOS",(select last_insert_id()));
	
		insert into kaart (matchid,persoonid,kleur,minuut) values ((select last_insert_id()),"JOAOCARLOS","rood","32");
	
	insert into persoonwedstrijd (persoonid,matchid) values ("ANELENGCONGCA",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("DIMITRIDAESELEIRE",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("DANIELPUDIL",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("BALAZSTOTH",(select last_insert_id()));
	
		insert into kaart (matchid,persoonid,kleur,minuut) values ((select last_insert_id()),"BALAZSTOTH","geel","18");
	
	insert into persoonwedstrijd (persoonid,matchid) values ("DANIELTOZSER",(select last_insert_id()));
	
			insert into doelpunt (matchid,persoonid,minuut,owngoal) values ((select last_insert_id()),"DANIELTOZSER","12",false);
		
			insert into doelpunt (matchid,persoonid,minuut,owngoal) values ((select last_insert_id()),"DANIELTOZSER","78",false);
		
	insert into persoonwedstrijd (persoonid,matchid) values ("KEVINDEBRUYNE",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("MOUSSAKOITA",(select last_insert_id()));
	
		insert into kaart (matchid,persoonid,kleur,minuut) values ((select last_insert_id()),"MOUSSAKOITA","geel","90");
	
	insert into persoonwedstrijd (persoonid,matchid) values ("ELYANIVBARDA",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("ERICMATOUKOU",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("JELLEVOSSEN",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("FABIENCAMUS",(select last_insert_id()));
	
insert into wissel (matchid,inid,uitid,minuut) values ((select last_insert_id()),"CHRISMAKIESE","TEDDYCHEVALIER","75");

insert into wissel (matchid,inid,uitid,minuut) values ((select last_insert_id()),"ERICMATOUKOU","ELYANIVBARDA","45");

insert into wissel (matchid,inid,uitid,minuut) values ((select last_insert_id()),"JELLEVOSSEN","KEVINDEBRUYNE","65");

insert into wissel (matchid,inid,uitid,minuut) values ((select last_insert_id()),"FABIENCAMUS","DANIELPUDIL","93");

insert into wedstrijd (speeldag,thuisid,uitid,referee,dag,uur,aantaltoeschouwers) value ("2","MOE","ROE","CHRISTOPHEDELACOUR","2009-08-08","20:00:00","5000");

	insert into persoonwedstrijd (persoonid,matchid) values ("JOSÉANTONIOSALCEDO",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("BASTIENCHANTRY",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("DAANVANGYSEGHEM",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("CARLOSDAVIDMORENOHERNANDEZ",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("MANUELMICOYEBANA",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("GUILLAUMEFRANÇOIS",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("JONATHANJUNCAL",(select last_insert_id()));
	
		insert into kaart (matchid,persoonid,kleur,minuut) values ((select last_insert_id()),"JONATHANJUNCAL","geel","72");
	
	insert into persoonwedstrijd (persoonid,matchid) values ("MATHIEUASSOU-EKOTTO",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("IDIROUALI",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("ZVONIMIRDERANJA",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("OKWUNWANNEJAYCEE",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("ALEJANDROCORTELL",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("ASANDASISHUBA",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("MAXIMELESTIENNE",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("JURGENSIERENS",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("BRAMVANDENBUSSCHE",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("ANTHONYVANLOO",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("JEREMYHUYGHEBAERT",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("DAMIRMIRVIC",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("STEFAANTANGHE",(select last_insert_id()));
	
		insert into kaart (matchid,persoonid,kleur,minuut) values ((select last_insert_id()),"STEFAANTANGHE","geel","34");
	
	insert into persoonwedstrijd (persoonid,matchid) values ("VINCENTPROVOOST",(select last_insert_id()));
	
		insert into kaart (matchid,persoonid,kleur,minuut) values ((select last_insert_id()),"VINCENTPROVOOST","geel","79");
	
	insert into persoonwedstrijd (persoonid,matchid) values ("JOERIDEQUEVY",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("ARTUROTENHEUVEL",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("MAHAMADOUDISSA",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("JOHNCOLLINS",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("SAMIRELGAAOUIRI",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("JIMMYMULISA",(select last_insert_id()));
	
insert into wissel (matchid,inid,uitid,minuut) values ((select last_insert_id()),"ALEJANDROCORTELL","ZVONIMIRDERANJA","5");

insert into wissel (matchid,inid,uitid,minuut) values ((select last_insert_id()),"ASANDASISHUBA","IDIROUALI","66");

insert into wissel (matchid,inid,uitid,minuut) values ((select last_insert_id()),"MAXIMELESTIENNE","OKWUNWANNEJAYCEE","85");

insert into wissel (matchid,inid,uitid,minuut) values ((select last_insert_id()),"SAMIRELGAAOUIRI","ARTUROTENHEUVEL","64");

insert into wissel (matchid,inid,uitid,minuut) values ((select last_insert_id()),"JIMMYMULISA","MAHAMADOUDISSA","88");

insert into wedstrijd (speeldag,thuisid,uitid,referee,dag,uur,aantaltoeschouwers) value ("2","WES","KOR","CHRISTOFVIRANT","2009-08-08","20:00:00","5000");

	insert into persoonwedstrijd (persoonid,matchid) values ("YVESDEWINTER",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("NICOVANKERCKHOVEN",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("JEFDELEN",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("GUNTHERVANAUDENAERDE",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("WOUTERCORSTJENS",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("STEVENDEPETTER",(select last_insert_id()));
	
		insert into kaart (matchid,persoonid,kleur,minuut) values ((select last_insert_id()),"STEVENDEPETTER","geel","86");
	
	insert into persoonwedstrijd (persoonid,matchid) values ("BERTINTOMOU",(select last_insert_id()));
	
			insert into doelpunt (matchid,persoonid,minuut,owngoal) values ((select last_insert_id()),"BERTINTOMOU","42",false);
		
	insert into persoonwedstrijd (persoonid,matchid) values ("EMMANUELSARKI",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("MOSESADAMS",(select last_insert_id()));
	
		insert into kaart (matchid,persoonid,kleur,minuut) values ((select last_insert_id()),"MOSESADAMS","geel","24");
	
	insert into persoonwedstrijd (persoonid,matchid) values ("MOMODOUCEESAY",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("ODITAOBIORA",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("WOUTERSCHEELEN",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("DIETERDEKELVER",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("GLENNVERBAUWHEDE",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("BRECHTVERBRUGGHE",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("BRAMDELY",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("KARIMBELHOCINE",(select last_insert_id()));
	
			insert into doelpunt (matchid,persoonid,minuut,owngoal) values ((select last_insert_id()),"KARIMBELHOCINE","11",false);
		
		insert into kaart (matchid,persoonid,kleur,minuut) values ((select last_insert_id()),"KARIMBELHOCINE","geel","78");
	
	insert into persoonwedstrijd (persoonid,matchid) values ("MLADENLAZAREVIC",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("JIMMYHEMPTE",(select last_insert_id()));
	
		insert into kaart (matchid,persoonid,kleur,minuut) values ((select last_insert_id()),"JIMMYHEMPTE","geel","17");
	
	insert into persoonwedstrijd (persoonid,matchid) values ("DAVYDEBEULE",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("SVENKUMS",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("NEBOJSAPAVLOVIC",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("BRECHTCAPON",(select last_insert_id()));
	
		insert into kaart (matchid,persoonid,kleur,minuut) values ((select last_insert_id()),"BRECHTCAPON","geel","63");
	
	insert into persoonwedstrijd (persoonid,matchid) values ("LEONBENKO",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("EBRAHIMIBOU",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("TRISTANLAHAYE",(select last_insert_id()));
	
insert into wissel (matchid,inid,uitid,minuut) values ((select last_insert_id()),"WOUTERSCHEELEN","ODITAOBIORA","45");

insert into wissel (matchid,inid,uitid,minuut) values ((select last_insert_id()),"DIETERDEKELVER","BERTINTOMOU","81");

insert into wissel (matchid,inid,uitid,minuut) values ((select last_insert_id()),"EBRAHIMIBOU","SVENKUMS","86");

insert into wissel (matchid,inid,uitid,minuut) values ((select last_insert_id()),"TRISTANLAHAYE","BRECHTCAPON","86");

insert into wedstrijd (speeldag,thuisid,uitid,referee,dag,uur,aantaltoeschouwers) value ("2","GNT","KVM","CHRISTOFDIERICK","2009-08-09","18:00:00","11523");

	insert into persoonwedstrijd (persoonid,matchid) values ("BOJANJORGACEVIC",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("STEFWILS",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("KENNYTHOMPSON",(select last_insert_id()));
	
		insert into kaart (matchid,persoonid,kleur,minuut) values ((select last_insert_id()),"KENNYTHOMPSON","geel","78");
	
	insert into persoonwedstrijd (persoonid,matchid) values ("ADRIANODUARTE",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("MARKOSULER",(select last_insert_id()));
	
		insert into kaart (matchid,persoonid,kleur,minuut) values ((select last_insert_id()),"MARKOSULER","geel","67");
	
	insert into persoonwedstrijd (persoonid,matchid) values ("TIMSMOLDERS",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("CHRISTOPHELEPOINT",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("RANDALLAZOFEIFA",(select last_insert_id()));
	
			insert into doelpunt (matchid,persoonid,minuut,owngoal) values ((select last_insert_id()),"RANDALLAZOFEIFA","63",false);
		
			insert into doelpunt (matchid,persoonid,minuut,owngoal) values ((select last_insert_id()),"RANDALLAZOFEIFA","77",false);
		
	insert into persoonwedstrijd (persoonid,matchid) values ("ELIMANECOULIBALY",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("MILOSMARIC",(select last_insert_id()));
	
		insert into kaart (matchid,persoonid,kleur,minuut) values ((select last_insert_id()),"MILOSMARIC","geel","52");
	
	insert into persoonwedstrijd (persoonid,matchid) values ("ZLATANLJUBIJANKIC",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("CHRISTOPHEGRONDIN",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("YASSINEELGHANASSY",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("ERLENDHANSTVEIT",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("WOUTERBIEBAUW",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("KENNYVANHOEVELEN",(select last_insert_id()));
	
		insert into kaart (matchid,persoonid,kleur,minuut) values ((select last_insert_id()),"KENNYVANHOEVELEN","geel","76");
	
	insert into persoonwedstrijd (persoonid,matchid) values ("XAVIERCHEN",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("JONASIVENS",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("ANTONIOGHOMSI",(select last_insert_id()));
	
		insert into kaart (matchid,persoonid,kleur,minuut) values ((select last_insert_id()),"ANTONIOGHOMSI","geel","83");
	
	insert into persoonwedstrijd (persoonid,matchid) values ("DAVIDDESTORME",(select last_insert_id()));
	
			insert into doelpunt (matchid,persoonid,minuut,owngoal) values ((select last_insert_id()),"DAVIDDESTORME","57",false);
		
	insert into persoonwedstrijd (persoonid,matchid) values ("WOUTERVRANCKEN",(select last_insert_id()));
	
		insert into kaart (matchid,persoonid,kleur,minuut) values ((select last_insert_id()),"WOUTERVRANCKEN","geel","91");
	
	insert into persoonwedstrijd (persoonid,matchid) values ("KOENPERSOONS",(select last_insert_id()));
	
		insert into kaart (matchid,persoonid,kleur,minuut) values ((select last_insert_id()),"KOENPERSOONS","rood","92");
	
	insert into persoonwedstrijd (persoonid,matchid) values ("JULIENGORIUS",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("ABDULYAKUNIIDDI",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("ALOISNONG",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("JOACHIMMUNUNGA",(select last_insert_id()));
	
		insert into kaart (matchid,persoonid,kleur,minuut) values ((select last_insert_id()),"JOACHIMMUNUNGA","geel","91");
	
	insert into persoonwedstrijd (persoonid,matchid) values ("ABDALLAHSALIM",(select last_insert_id()));
	
insert into wissel (matchid,inid,uitid,minuut) values ((select last_insert_id()),"CHRISTOPHEGRONDIN","TIMSMOLDERS","33");

insert into wissel (matchid,inid,uitid,minuut) values ((select last_insert_id()),"YASSINEELGHANASSY","MILOSMARIC","80");

insert into wissel (matchid,inid,uitid,minuut) values ((select last_insert_id()),"ERLENDHANSTVEIT","CHRISTOPHEGRONDIN","83");

insert into wissel (matchid,inid,uitid,minuut) values ((select last_insert_id()),"JOACHIMMUNUNGA","ABDULYAKUNIIDDI","68");

insert into wissel (matchid,inid,uitid,minuut) values ((select last_insert_id()),"ABDALLAHSALIM","XAVIERCHEN","88");

insert into wedstrijd (speeldag,thuisid,uitid,referee,dag,uur,aantaltoeschouwers) value ("2","CLU","LOK","JEAN-BAPTISTBULTYNCK","2009-08-09","20:30:00","23555");

	insert into persoonwedstrijd (persoonid,matchid) values ("STIJNSTIJNEN",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("JORNVERMEULEN",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("MICHAELKLUKOWSKI",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("RYANDONK",(select last_insert_id()));
	
		insert into kaart (matchid,persoonid,kleur,minuut) values ((select last_insert_id()),"RYANDONK","geel","89");
	
	insert into persoonwedstrijd (persoonid,matchid) values ("ANTOLINALCARAZ",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("KARELGERAERTS",(select last_insert_id()));
	
			insert into doelpunt (matchid,persoonid,minuut,owngoal) values ((select last_insert_id()),"KARELGERAERTS","90",false);
		
		insert into kaart (matchid,persoonid,kleur,minuut) values ((select last_insert_id()),"KARELGERAERTS","geel","91");
	
	insert into persoonwedstrijd (persoonid,matchid) values ("JONATHANBLONDEL",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("JEROENSIMAEYS",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("NABILDIRAR",(select last_insert_id()));
	
		insert into kaart (matchid,persoonid,kleur,minuut) values ((select last_insert_id()),"NABILDIRAR","geel","64");
	
	insert into persoonwedstrijd (persoonid,matchid) values ("WESLEYSONCK",(select last_insert_id()));
	
		insert into kaart (matchid,persoonid,kleur,minuut) values ((select last_insert_id()),"WESLEYSONCK","geel","86");
	
	insert into persoonwedstrijd (persoonid,matchid) values ("JOSEPHAKPALA",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("MOHAMEDDAHMANE",(select last_insert_id()));
	
		insert into kaart (matchid,persoonid,kleur,minuut) values ((select last_insert_id()),"MOHAMEDDAHMANE","geel","79");
	
	insert into persoonwedstrijd (persoonid,matchid) values ("DANIELCHAVEZ",(select last_insert_id()));
	
			insert into doelpunt (matchid,persoonid,minuut,owngoal) values ((select last_insert_id()),"DANIELCHAVEZ","93",false);
		
	insert into persoonwedstrijd (persoonid,matchid) values ("VADISODJIDJAOFOE",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("BOUBACARCOPA",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("OLIVIERDOLL",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("FRÉDÉRICDUPRÉ",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("AVISTRUL",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("YOAVZIV",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("SULEJMANSMAJIC",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("MARCELMBAYO",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("TSHINYAMATIKO",(select last_insert_id()));
	
		insert into kaart (matchid,persoonid,kleur,minuut) values ((select last_insert_id()),"TSHINYAMATIKO","geel","21");
	
	insert into persoonwedstrijd (persoonid,matchid) values ("MARIOCAREVIC",(select last_insert_id()));
	
		insert into kaart (matchid,persoonid,kleur,minuut) values ((select last_insert_id()),"MARIOCAREVIC","rood","61");
	
	insert into persoonwedstrijd (persoonid,matchid) values ("NILLDEPAUW",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("TOMISLAVSOKOTA",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("DONOVANDEEKMAN",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("VELDINMUHAREMOVIC",(select last_insert_id()));
	
insert into wissel (matchid,inid,uitid,minuut) values ((select last_insert_id()),"MOHAMEDDAHMANE","JORNVERMEULEN","69");

insert into wissel (matchid,inid,uitid,minuut) values ((select last_insert_id()),"DANIELCHAVEZ","JOSEPHAKPALA","80");

insert into wissel (matchid,inid,uitid,minuut) values ((select last_insert_id()),"VADISODJIDJAOFOE","JONATHANBLONDEL","84");

insert into wissel (matchid,inid,uitid,minuut) values ((select last_insert_id()),"DONOVANDEEKMAN","SULEJMANSMAJIC","91");

insert into wissel (matchid,inid,uitid,minuut) values ((select last_insert_id()),"VELDINMUHAREMOVIC","AVISTRUL","49");

insert into wedstrijd (speeldag,thuisid,uitid,referee,dag,uur,aantaltoeschouwers) value ("3","AND","WES","LUCWOUTERS","2009-08-15","18:00:00","22553");

	insert into persoonwedstrijd (persoonid,matchid) values ("SILVIOPROTO",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("OLIVIERDESCHACHT",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("JELLEVANDAMME",(select last_insert_id()));
	
			insert into doelpunt (matchid,persoonid,minuut,owngoal) values ((select last_insert_id()),"JELLEVANDAMME","29",false);
		
	insert into persoonwedstrijd (persoonid,matchid) values ("ROLANDJUHASZ",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("MARCINWASILEWSKI",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("LUCASBIGLIA",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("THOMASCHATELLE",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("GUILLAUMEGILLET",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("MBARKBOUSSOUFA",(select last_insert_id()));
	
			insert into doelpunt (matchid,persoonid,minuut,owngoal) values ((select last_insert_id()),"MBARKBOUSSOUFA","74",false);
		
	insert into persoonwedstrijd (persoonid,matchid) values ("MATIASSUAREZ",(select last_insert_id()));
	
			insert into doelpunt (matchid,persoonid,minuut,owngoal) values ((select last_insert_id()),"MATIASSUAREZ","46",false);
		
	insert into persoonwedstrijd (persoonid,matchid) values ("TOMDESUTTER",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("RUBENILSONKANU",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("VICTORBERNARDEZ",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("REYNALDO",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("YVESDEWINTER",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("NICOVANKERCKHOVEN",(select last_insert_id()));
	
		insert into kaart (matchid,persoonid,kleur,minuut) values ((select last_insert_id()),"NICOVANKERCKHOVEN","geel","82");
	
	insert into persoonwedstrijd (persoonid,matchid) values ("JEFDELEN",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("GUNTHERVANAUDENAERDE",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("WOUTERCORSTJENS",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("STEVENDEPETTER",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("EMMANUELSARKI",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("MOSESADAMS",(select last_insert_id()));
	
		insert into kaart (matchid,persoonid,kleur,minuut) values ((select last_insert_id()),"MOSESADAMS","geel","11");
	
	insert into persoonwedstrijd (persoonid,matchid) values ("MICHAELMODUBI",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("BERTINTOMOU",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("MOMODOUCEESAY",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("JORISVANHOUT",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("WOUTERSCHEELEN",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("ODITAOBIORA",(select last_insert_id()));
	
insert into wissel (matchid,inid,uitid,minuut) values ((select last_insert_id()),"RUBENILSONKANU","TOMDESUTTER","62");

insert into wissel (matchid,inid,uitid,minuut) values ((select last_insert_id()),"VICTORBERNARDEZ","JELLEVANDAMME","75");

insert into wissel (matchid,inid,uitid,minuut) values ((select last_insert_id()),"REYNALDO","MBARKBOUSSOUFA","79");

insert into wissel (matchid,inid,uitid,minuut) values ((select last_insert_id()),"JORISVANHOUT","WOUTERCORSTJENS","30");

insert into wissel (matchid,inid,uitid,minuut) values ((select last_insert_id()),"WOUTERSCHEELEN","MOSESADAMS","45");

insert into wissel (matchid,inid,uitid,minuut) values ((select last_insert_id()),"ODITAOBIORA","STEVENDEPETTER","83");

insert into wedstrijd (speeldag,thuisid,uitid,referee,dag,uur,aantaltoeschouwers) value ("3","LOK","STVV","PHILIPPEFLAMENT","2009-08-15","20:00:00","4821");

	insert into persoonwedstrijd (persoonid,matchid) values ("BOUBACARCOPA",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("OLIVIERDOLL",(select last_insert_id()));
	
		insert into kaart (matchid,persoonid,kleur,minuut) values ((select last_insert_id()),"OLIVIERDOLL","geel","87");
	
	insert into persoonwedstrijd (persoonid,matchid) values ("FRÉDÉRICDUPRÉ",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("YOAVZIV",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("ALIBOUABE",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("KILLIANOVERMEIRE",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("SULEJMANSMAJIC",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("MARCELMBAYO",(select last_insert_id()));
	
			insert into doelpunt (matchid,persoonid,minuut,owngoal) values ((select last_insert_id()),"MARCELMBAYO","64",false);
		
	insert into persoonwedstrijd (persoonid,matchid) values ("TSHINYAMATIKO",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("TOMISLAVSOKOTA",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("OMERGOLAN",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("DAWIDJANCZYK",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("DONOVANDEEKMAN",(select last_insert_id()));
	
		insert into kaart (matchid,persoonid,kleur,minuut) values ((select last_insert_id()),"DONOVANDEEKMAN","geel","67");
	
	insert into persoonwedstrijd (persoonid,matchid) values ("SIMONMIGNOLET",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("MARCWAGEMAKERS",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("VINCENTEUVRARD",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("DENISODOI",(select last_insert_id()));
	
		insert into kaart (matchid,persoonid,kleur,minuut) values ((select last_insert_id()),"DENISODOI","geel","66");
	
	insert into persoonwedstrijd (persoonid,matchid) values ("MARIOCANTALUPPI",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("WIMMENNES",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("PETERDELORGE",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("JONATHANWILMET",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("CEPHASCHIMEDZA",(select last_insert_id()));
	
			insert into doelpunt (matchid,persoonid,minuut,owngoal) values ((select last_insert_id()),"CEPHASCHIMEDZA","80",false);
		
	insert into persoonwedstrijd (persoonid,matchid) values ("ALEXDASILVA",(select last_insert_id()));
	
		insert into kaart (matchid,persoonid,kleur,minuut) values ((select last_insert_id()),"ALEXDASILVA","geel","76");
	
	insert into persoonwedstrijd (persoonid,matchid) values ("IBRAHIMSIDIBE",(select last_insert_id()));
	
			insert into doelpunt (matchid,persoonid,minuut,owngoal) values ((select last_insert_id()),"IBRAHIMSIDIBE","50",false);
		
	insert into persoonwedstrijd (persoonid,matchid) values ("HERVEONANA",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("LUDOVICBUYSENS",(select last_insert_id()));
	
insert into wissel (matchid,inid,uitid,minuut) values ((select last_insert_id()),"DAWIDJANCZYK","KILLIANOVERMEIRE","56");

insert into wissel (matchid,inid,uitid,minuut) values ((select last_insert_id()),"DONOVANDEEKMAN","OMERGOLAN","56");

insert into wissel (matchid,inid,uitid,minuut) values ((select last_insert_id()),"HERVEONANA","ALEXDASILVA","84");

insert into wissel (matchid,inid,uitid,minuut) values ((select last_insert_id()),"LUDOVICBUYSENS","IBRAHIMSIDIBE","91");

insert into wedstrijd (speeldag,thuisid,uitid,referee,dag,uur,aantaltoeschouwers) value ("3","ROE","STA","FRANKDEBLEECKERE","2009-08-15","20:00:00","6253");

	insert into persoonwedstrijd (persoonid,matchid) values ("JURGENSIERENS",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("BRAMVANDENBUSSCHE",(select last_insert_id()));
	
		insert into kaart (matchid,persoonid,kleur,minuut) values ((select last_insert_id()),"BRAMVANDENBUSSCHE","rood","20");
	
	insert into persoonwedstrijd (persoonid,matchid) values ("ANTHONYVANLOO",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("JEREMYHUYGHEBAERT",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("DAMIRMIRVIC",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("STEPANKUCERA",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("STEFAANTANGHE",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("VINCENTPROVOOST",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("JOERIDEQUEVY",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("SAMIRELGAAOUIRI",(select last_insert_id()));
	
			insert into doelpunt (matchid,persoonid,minuut,owngoal) values ((select last_insert_id()),"SAMIRELGAAOUIRI","22",false);
		
	insert into persoonwedstrijd (persoonid,matchid) values ("JOHNCOLLINS",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("BARTGOOSSENS",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("SERGIOHELLINGS",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("JIMMYMULISA",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("SINANBOLAT",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("MARCOSCAMOZZATO",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("CÉDRICCOLLET",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("ELIAQUIMMANGALA",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("MOHAMEDSARR",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("STEVENDEFOUR",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("AXELWITSEL",(select last_insert_id()));
	
		insert into kaart (matchid,persoonid,kleur,minuut) values ((select last_insert_id()),"AXELWITSEL","geel","24");
	
	insert into persoonwedstrijd (persoonid,matchid) values ("MEHDICARCELA-GONZALEZ",(select last_insert_id()));
	
			insert into doelpunt (matchid,persoonid,minuut,owngoal) values ((select last_insert_id()),"MEHDICARCELA-GONZALEZ","30",false);
		
	insert into persoonwedstrijd (persoonid,matchid) values ("IGORDECAMARGO",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("DIEUMERCIMBOKANI",(select last_insert_id()));
	
			insert into doelpunt (matchid,persoonid,minuut,owngoal) values ((select last_insert_id()),"DIEUMERCIMBOKANI","41",false);
		
	insert into persoonwedstrijd (persoonid,matchid) values ("MILANJOVANOVIC",(select last_insert_id()));
	
			insert into doelpunt (matchid,persoonid,minuut,owngoal) values ((select last_insert_id()),"MILANJOVANOVIC","21",false);
		
			insert into doelpunt (matchid,persoonid,minuut,owngoal) values ((select last_insert_id()),"MILANJOVANOVIC","50",false);
		
			insert into doelpunt (matchid,persoonid,minuut,owngoal) values ((select last_insert_id()),"MILANJOVANOVIC","65",false);
		
	insert into persoonwedstrijd (persoonid,matchid) values ("MOUSSATRAORE",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("GOHIBICYRIAC",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("GREGORYDUFER",(select last_insert_id()));
	
insert into wissel (matchid,inid,uitid,minuut) values ((select last_insert_id()),"BARTGOOSSENS","STEFAANTANGHE","67");

insert into wissel (matchid,inid,uitid,minuut) values ((select last_insert_id()),"SERGIOHELLINGS","VINCENTPROVOOST","67");

insert into wissel (matchid,inid,uitid,minuut) values ((select last_insert_id()),"JIMMYMULISA","JOHNCOLLINS","80");

insert into wissel (matchid,inid,uitid,minuut) values ((select last_insert_id()),"MOUSSATRAORE","DIEUMERCIMBOKANI","70");

insert into wissel (matchid,inid,uitid,minuut) values ((select last_insert_id()),"GOHIBICYRIAC","IGORDECAMARGO","73");

insert into wissel (matchid,inid,uitid,minuut) values ((select last_insert_id()),"GREGORYDUFER","STEVENDEFOUR","74");

insert into wedstrijd (speeldag,thuisid,uitid,referee,dag,uur,aantaltoeschouwers) value ("3","CER","ZWA","PETERVERVECKEN","2009-08-15","20:00:00","7047");

	insert into persoonwedstrijd (persoonid,matchid) values ("JOCOPPENS",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("DENISVIANE",(select last_insert_id()));
	
		insert into kaart (matchid,persoonid,kleur,minuut) values ((select last_insert_id()),"DENISVIANE","geel","72");
	
	insert into persoonwedstrijd (persoonid,matchid) values ("BERNTEVENS",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("ANTHONYPORTIER",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("FREDERIKBOI",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("TONYSERGEANT",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("OLEGIACHTCHOUK",(select last_insert_id()));
	
			insert into doelpunt (matchid,persoonid,minuut,owngoal) values ((select last_insert_id()),"OLEGIACHTCHOUK","73",false);
		
	insert into persoonwedstrijd (persoonid,matchid) values ("THOMASBUFFEL",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("ARNARVIDARSSON",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("HONOURGOMBAMI",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("BOJANBOZOVIC",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("VUSUMUZINYONI",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("SERHIJSEREBRENNIKOV",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("DOMINICFOLEY",(select last_insert_id()));
	
			insert into doelpunt (matchid,persoonid,minuut,owngoal) values ((select last_insert_id()),"DOMINICFOLEY","94",false);
		
	insert into persoonwedstrijd (persoonid,matchid) values ("SAMMYBOSSUT",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("STIJNMINNE",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("KARELDHAENE",(select last_insert_id()));
	
		insert into kaart (matchid,persoonid,kleur,minuut) values ((select last_insert_id()),"KARELDHAENE","geel","73");
	
	insert into persoonwedstrijd (persoonid,matchid) values ("STEVECOLPAERT",(select last_insert_id()));
	
		insert into kaart (matchid,persoonid,kleur,minuut) values ((select last_insert_id()),"STEVECOLPAERT","geel","30");
	
	insert into persoonwedstrijd (persoonid,matchid) values ("BARTBUYSSE",(select last_insert_id()));
	
		insert into kaart (matchid,persoonid,kleur,minuut) values ((select last_insert_id()),"BARTBUYSSE","geel","41");
	
	insert into persoonwedstrijd (persoonid,matchid) values ("STIJNMEERT",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("KEVINROELANDTS",(select last_insert_id()));
	
		insert into kaart (matchid,persoonid,kleur,minuut) values ((select last_insert_id()),"KEVINROELANDTS","geel","75");
	
	insert into persoonwedstrijd (persoonid,matchid) values ("FRANCKBERRIER",(select last_insert_id()));
	
			insert into doelpunt (matchid,persoonid,minuut,owngoal) values ((select last_insert_id()),"FRANCKBERRIER","63",false);
		
		insert into kaart (matchid,persoonid,kleur,minuut) values ((select last_insert_id()),"FRANCKBERRIER","geel","73");
	
	insert into persoonwedstrijd (persoonid,matchid) values ("KHALEEMHYLAND",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("ERNESTNFOR",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("TEDDYCHEVALIER",(select last_insert_id()));
	
			insert into doelpunt (matchid,persoonid,minuut,owngoal) values ((select last_insert_id()),"TEDDYCHEVALIER","16",false);
		
insert into wissel (matchid,inid,uitid,minuut) values ((select last_insert_id()),"VUSUMUZINYONI","ARNARVIDARSSON","69");

insert into wissel (matchid,inid,uitid,minuut) values ((select last_insert_id()),"SERHIJSEREBRENNIKOV","BERNTEVENS","69");

insert into wissel (matchid,inid,uitid,minuut) values ((select last_insert_id()),"DOMINICFOLEY","HONOURGOMBAMI","69");

insert into wedstrijd (speeldag,thuisid,uitid,referee,dag,uur,aantaltoeschouwers) value ("3","KVM","CLU","CLAUDEBOURDOUXHE","2009-08-15","20:00:00","12920");

	insert into persoonwedstrijd (persoonid,matchid) values ("WOUTERBIEBAUW",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("KENNYVANHOEVELEN",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("XAVIERCHEN",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("JONASIVENS",(select last_insert_id()));
	
			insert into doelpunt (matchid,persoonid,minuut,owngoal) values ((select last_insert_id()),"JONASIVENS","43",false);
		
	insert into persoonwedstrijd (persoonid,matchid) values ("ANTONIOGHOMSI",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("DAVIDDESTORME",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("WOUTERVRANCKEN",(select last_insert_id()));
	
		insert into kaart (matchid,persoonid,kleur,minuut) values ((select last_insert_id()),"WOUTERVRANCKEN","rood","14");
	
	insert into persoonwedstrijd (persoonid,matchid) values ("YONIBUYENS",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("JULIENGORIUS",(select last_insert_id()));
	
			insert into doelpunt (matchid,persoonid,minuut,owngoal) values ((select last_insert_id()),"JULIENGORIUS","54",false);
		
	insert into persoonwedstrijd (persoonid,matchid) values ("JOACHIMMUNUNGA",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("ALOISNONG",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("KENNETHVANGOETHEM",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("GIUSEPPEROSSINI",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("ABDULYAKUNIIDDI",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("STIJNSTIJNEN",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("KOENDAERDEN",(select last_insert_id()));
	
		insert into kaart (matchid,persoonid,kleur,minuut) values ((select last_insert_id()),"KOENDAERDEN","geel","42");
	
	insert into persoonwedstrijd (persoonid,matchid) values ("JORNVERMEULEN",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("MICHAELKLUKOWSKI",(select last_insert_id()));
	
		insert into kaart (matchid,persoonid,kleur,minuut) values ((select last_insert_id()),"MICHAELKLUKOWSKI","geel","56");
	
	insert into persoonwedstrijd (persoonid,matchid) values ("ANTOLINALCARAZ",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("KARELGERAERTS",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("JONATHANBLONDEL",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("JEROENSIMAEYS",(select last_insert_id()));
	
		insert into kaart (matchid,persoonid,kleur,minuut) values ((select last_insert_id()),"JEROENSIMAEYS","geel","54");
	
	insert into persoonwedstrijd (persoonid,matchid) values ("VADISODJIDJAOFOE",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("NABILDIRAR",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("JOSEPHAKPALA",(select last_insert_id()));
	
			insert into doelpunt (matchid,persoonid,minuut,owngoal) values ((select last_insert_id()),"JOSEPHAKPALA","49",false);
		
	insert into persoonwedstrijd (persoonid,matchid) values ("RONALDVARGAS",(select last_insert_id()));
	
		insert into kaart (matchid,persoonid,kleur,minuut) values ((select last_insert_id()),"RONALDVARGAS","geel","85");
	
	insert into persoonwedstrijd (persoonid,matchid) values ("DANIELCHAVEZ",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("WESLEYSONCK",(select last_insert_id()));
	
insert into wissel (matchid,inid,uitid,minuut) values ((select last_insert_id()),"KENNETHVANGOETHEM","ALOISNONG","65");

insert into wissel (matchid,inid,uitid,minuut) values ((select last_insert_id()),"GIUSEPPEROSSINI","JOACHIMMUNUNGA","76");

insert into wissel (matchid,inid,uitid,minuut) values ((select last_insert_id()),"ABDULYAKUNIIDDI","DAVIDDESTORME","86");

insert into wissel (matchid,inid,uitid,minuut) values ((select last_insert_id()),"RONALDVARGAS","KOENDAERDEN","45");

insert into wissel (matchid,inid,uitid,minuut) values ((select last_insert_id()),"DANIELCHAVEZ","VADISODJIDJAOFOE","68");

insert into wissel (matchid,inid,uitid,minuut) values ((select last_insert_id()),"WESLEYSONCK","JONATHANBLONDEL","68");

insert into wedstrijd (speeldag,thuisid,uitid,referee,dag,uur,aantaltoeschouwers) value ("3","GNK","GNT","PAULALLAERTS","2009-08-15","20:00:00","18735");

	insert into persoonwedstrijd (persoonid,matchid) values ("DAVINOVERHULST",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("DAVIDHUBERT",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("DIMITRIDAESELEIRE",(select last_insert_id()));
	
		insert into kaart (matchid,persoonid,kleur,minuut) values ((select last_insert_id()),"DIMITRIDAESELEIRE","geel","65");
	
	insert into persoonwedstrijd (persoonid,matchid) values ("ERICMATOUKOU",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("ANELENGCONGCA",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("DANIELPUDIL",(select last_insert_id()));
	
		insert into kaart (matchid,persoonid,kleur,minuut) values ((select last_insert_id()),"DANIELPUDIL","geel","41");
	
	insert into persoonwedstrijd (persoonid,matchid) values ("BALAZSTOTH",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("DANIELTOZSER",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("MOUSSAKOITA",(select last_insert_id()));
	
			insert into doelpunt (matchid,persoonid,minuut,owngoal) values ((select last_insert_id()),"MOUSSAKOITA","8",false);
		
		insert into kaart (matchid,persoonid,kleur,minuut) values ((select last_insert_id()),"MOUSSAKOITA","geel","39");
	
	insert into persoonwedstrijd (persoonid,matchid) values ("FABIENCAMUS",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("ELYANIVBARDA",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("JELLEVOSSEN",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("KEVINDEBRUYNE",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("ISTVANBAKX",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("BOJANJORGACEVIC",(select last_insert_id()));
	
		insert into kaart (matchid,persoonid,kleur,minuut) values ((select last_insert_id()),"BOJANJORGACEVIC","geel","94");
	
	insert into persoonwedstrijd (persoonid,matchid) values ("STEFWILS",(select last_insert_id()));
	
		insert into kaart (matchid,persoonid,kleur,minuut) values ((select last_insert_id()),"STEFWILS","geel","92");
	
	insert into persoonwedstrijd (persoonid,matchid) values ("KENNYTHOMPSON",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("ERLENDHANSTVEIT",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("MARKOSULER",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("STIJNDESMET",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("ADNANCUSTOVIC",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("ADRIANODUARTE",(select last_insert_id()));
	
		insert into kaart (matchid,persoonid,kleur,minuut) values ((select last_insert_id()),"ADRIANODUARTE","rood","41");
	
	insert into persoonwedstrijd (persoonid,matchid) values ("RANDALLAZOFEIFA",(select last_insert_id()));
	
		insert into kaart (matchid,persoonid,kleur,minuut) values ((select last_insert_id()),"RANDALLAZOFEIFA","geel","32");
	
	insert into persoonwedstrijd (persoonid,matchid) values ("MILOSMARIC",(select last_insert_id()));
	
		insert into kaart (matchid,persoonid,kleur,minuut) values ((select last_insert_id()),"MILOSMARIC","geel","36");
	
	insert into persoonwedstrijd (persoonid,matchid) values ("ZLATANLJUBIJANKIC",(select last_insert_id()));
	
			insert into doelpunt (matchid,persoonid,minuut,owngoal) values ((select last_insert_id()),"ZLATANLJUBIJANKIC","39",false);
		
		insert into kaart (matchid,persoonid,kleur,minuut) values ((select last_insert_id()),"ZLATANLJUBIJANKIC","geel","63");
	
	insert into persoonwedstrijd (persoonid,matchid) values ("YASSINEELGHANASSY",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("MBAYELEYE",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("CHRISTOPHELEPOINT",(select last_insert_id()));
	
insert into wissel (matchid,inid,uitid,minuut) values ((select last_insert_id()),"JELLEVOSSEN","ELYANIVBARDA","75");

insert into wissel (matchid,inid,uitid,minuut) values ((select last_insert_id()),"KEVINDEBRUYNE","BALAZSTOTH","75");

insert into wissel (matchid,inid,uitid,minuut) values ((select last_insert_id()),"ISTVANBAKX","FABIENCAMUS","87");

insert into wissel (matchid,inid,uitid,minuut) values ((select last_insert_id()),"YASSINEELGHANASSY","STIJNDESMET","45");

insert into wissel (matchid,inid,uitid,minuut) values ((select last_insert_id()),"MBAYELEYE","ADNANCUSTOVIC","83");

insert into wissel (matchid,inid,uitid,minuut) values ((select last_insert_id()),"CHRISTOPHELEPOINT","ZLATANLJUBIJANKIC","94");

insert into wedstrijd (speeldag,thuisid,uitid,referee,dag,uur,aantaltoeschouwers) value ("3","KOR","MOE","FREDERIKGELDHOF","2009-08-16","18:00:00","5883");

	insert into persoonwedstrijd (persoonid,matchid) values ("GLENNVERBAUWHEDE",(select last_insert_id()));
	
		insert into kaart (matchid,persoonid,kleur,minuut) values ((select last_insert_id()),"GLENNVERBAUWHEDE","geel","83");
	
	insert into persoonwedstrijd (persoonid,matchid) values ("BRAMDELY",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("KARIMBELHOCINE",(select last_insert_id()));
	
			insert into doelpunt (matchid,persoonid,minuut,owngoal) values ((select last_insert_id()),"KARIMBELHOCINE","73",false);
		
	insert into persoonwedstrijd (persoonid,matchid) values ("LORISREINA",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("MLADENLAZAREVIC",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("JIMMYHEMPTE",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("DAVYDEBEULE",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("SVENKUMS",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("BRECHTCAPON",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("NEBOJSAPAVLOVIC",(select last_insert_id()));
	
		insert into kaart (matchid,persoonid,kleur,minuut) values ((select last_insert_id()),"NEBOJSAPAVLOVIC","geel","32");
	
	insert into persoonwedstrijd (persoonid,matchid) values ("LEONBENKO",(select last_insert_id()));
	
			insert into doelpunt (matchid,persoonid,minuut,owngoal) values ((select last_insert_id()),"LEONBENKO","71",false);
		
	insert into persoonwedstrijd (persoonid,matchid) values ("EBRAHIMIBOU",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("TOMSOETAERS",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("JOSÉANTONIOSALCEDO",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("GONZAGUEVANDOOREN",(select last_insert_id()));
	
		insert into kaart (matchid,persoonid,kleur,minuut) values ((select last_insert_id()),"GONZAGUEVANDOOREN","geel","49");
	
	insert into persoonwedstrijd (persoonid,matchid) values ("CHEMCEDINEELARAICHI",(select last_insert_id()));
	
		insert into kaart (matchid,persoonid,kleur,minuut) values ((select last_insert_id()),"CHEMCEDINEELARAICHI","geel","72");
	
	insert into persoonwedstrijd (persoonid,matchid) values ("DAANVANGYSEGHEM",(select last_insert_id()));
	
		insert into kaart (matchid,persoonid,kleur,minuut) values ((select last_insert_id()),"DAANVANGYSEGHEM","geel","59");
	
	insert into persoonwedstrijd (persoonid,matchid) values ("CARLOSDAVIDMORENOHERNANDEZ",(select last_insert_id()));
	
		insert into kaart (matchid,persoonid,kleur,minuut) values ((select last_insert_id()),"CARLOSDAVIDMORENOHERNANDEZ","geel","80");
	
	insert into persoonwedstrijd (persoonid,matchid) values ("GUILLAUMEFRANÇOIS",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("MAXIMELESTIENNE",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("JONATHANJUNCAL",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("MATHIEUASSOU-EKOTTO",(select last_insert_id()));
	
		insert into kaart (matchid,persoonid,kleur,minuut) values ((select last_insert_id()),"MATHIEUASSOU-EKOTTO","geel","70");
	
	insert into persoonwedstrijd (persoonid,matchid) values ("ALEJANDROCORTELL",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("OKWUNWANNEJAYCEE",(select last_insert_id()));
	
			insert into doelpunt (matchid,persoonid,minuut,owngoal) values ((select last_insert_id()),"OKWUNWANNEJAYCEE","48",false);
		
			insert into doelpunt (matchid,persoonid,minuut,owngoal) values ((select last_insert_id()),"OKWUNWANNEJAYCEE","90",false);
		
	insert into persoonwedstrijd (persoonid,matchid) values ("ANDRIASCHIFANO",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("MAMADOUDIAKITE",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("SYLVAINBERTON",(select last_insert_id()));
	
insert into wissel (matchid,inid,uitid,minuut) values ((select last_insert_id()),"EBRAHIMIBOU","BRAMDELY","60");

insert into wissel (matchid,inid,uitid,minuut) values ((select last_insert_id()),"TOMSOETAERS","JIMMYHEMPTE","65");

insert into wissel (matchid,inid,uitid,minuut) values ((select last_insert_id()),"ANDRIASCHIFANO","ALEJANDROCORTELL","79");

insert into wissel (matchid,inid,uitid,minuut) values ((select last_insert_id()),"MAMADOUDIAKITE","MATHIEUASSOU-EKOTTO","83");

insert into wissel (matchid,inid,uitid,minuut) values ((select last_insert_id()),"SYLVAINBERTON","MAXIMELESTIENNE","91");

insert into wedstrijd (speeldag,thuisid,uitid,referee,dag,uur,aantaltoeschouwers) value ("3","CHA","GBA","JEAN-BAPTISTBULTYNCK","2009-08-16","20:30:00","7430");

	insert into persoonwedstrijd (persoonid,matchid) values ("SÉBASTIENCHABBERT",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("MAHAMOUDOUKERE",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("MAXIMEBRILLAULT",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("MOHAMEDCHAKOURI",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("IBRAHIMADIALLO",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("HERVEKAGE",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("SEBASTIENCHABOUD",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("GREGORYCHRIST",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("ABDELMAJIDOULMERS",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("CYRILTHÉREAU",(select last_insert_id()));
	
			insert into doelpunt (matchid,persoonid,minuut,owngoal) values ((select last_insert_id()),"CYRILTHÉREAU","94",false);
		
	insert into persoonwedstrijd (persoonid,matchid) values ("HABIBHABIBOU",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("MOUHSINEIAJOUR",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("ILOMBEMBOYO",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("TOMISLAVPACOVSKI",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("PHILIPPECLEMENT",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("KURTVANDOOREN",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("PIETERJANMONTEYNE",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("JUSTICEWAMFOR",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("WIMDEDECKER",(select last_insert_id()));
	
		insert into kaart (matchid,persoonid,kleur,minuut) values ((select last_insert_id()),"WIMDEDECKER","geel","17");
	
	insert into persoonwedstrijd (persoonid,matchid) values ("MARKDEMAN",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("FARISHAROUN",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("IVANLEKO",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("DANIELCRUZ",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("SHERJILLMACDONALD",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("SANHARIBMALKI",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("TOSINDOSUMNU",(select last_insert_id()));
	
insert into wissel (matchid,inid,uitid,minuut) values ((select last_insert_id()),"MOUHSINEIAJOUR","SEBASTIENCHABOUD","62");

insert into wissel (matchid,inid,uitid,minuut) values ((select last_insert_id()),"ILOMBEMBOYO","HABIBHABIBOU","81");

insert into wissel (matchid,inid,uitid,minuut) values ((select last_insert_id()),"SANHARIBMALKI","DANIELCRUZ","66");

insert into wissel (matchid,inid,uitid,minuut) values ((select last_insert_id()),"TOSINDOSUMNU","IVANLEKO","76");

insert into wedstrijd (speeldag,thuisid,uitid,referee,dag,uur,aantaltoeschouwers) value ("4","STA","CHA","JOHANVERBIST","2009-08-21","20:30:00","27500");

	insert into persoonwedstrijd (persoonid,matchid) values ("SINANBOLAT",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("MARCOSCAMOZZATO",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("CÉDRICCOLLET",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("ELIAQUIMMANGALA",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("MOHAMEDSARR",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("STEVENDEFOUR",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("AXELWITSEL",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("MEHDICARCELA-GONZALEZ",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("WILFRIEDDALMAT",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("DIEUMERCIMBOKANI",(select last_insert_id()));
	
		insert into kaart (matchid,persoonid,kleur,minuut) values ((select last_insert_id()),"DIEUMERCIMBOKANI","geel","40");
	
	insert into persoonwedstrijd (persoonid,matchid) values ("MILANJOVANOVIC",(select last_insert_id()));
	
			insert into doelpunt (matchid,persoonid,minuut,owngoal) values ((select last_insert_id()),"MILANJOVANOVIC","22",false);
		
	insert into persoonwedstrijd (persoonid,matchid) values ("IGORDECAMARGO",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("MOUSSATRAORE",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("GREGORYDUFER",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("SÉBASTIENCHABBERT",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("MAHAMOUDOUKERE",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("MAXIMEBRILLAULT",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("MOHAMEDCHAKOURI",(select last_insert_id()));
	
		insert into kaart (matchid,persoonid,kleur,minuut) values ((select last_insert_id()),"MOHAMEDCHAKOURI","geel","32");
	
	insert into persoonwedstrijd (persoonid,matchid) values ("IBRAHIMADIALLO",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("ADLENEGUEDIOURA",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("HERVEKAGE",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("GREGORYCHRIST",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("ABDELMAJIDOULMERS",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("CYRILTHÉREAU",(select last_insert_id()));
	
		insert into kaart (matchid,persoonid,kleur,minuut) values ((select last_insert_id()),"CYRILTHÉREAU","geel","16");
	
	insert into persoonwedstrijd (persoonid,matchid) values ("HABIBHABIBOU",(select last_insert_id()));
	
			insert into doelpunt (matchid,persoonid,minuut,owngoal) values ((select last_insert_id()),"HABIBHABIBOU","29",false);
		
		insert into kaart (matchid,persoonid,kleur,minuut) values ((select last_insert_id()),"HABIBHABIBOU","geel","72");
	
	insert into persoonwedstrijd (persoonid,matchid) values ("MOUHSINEIAJOUR",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("ALESSANDROCORDARO",(select last_insert_id()));
	
insert into wissel (matchid,inid,uitid,minuut) values ((select last_insert_id()),"IGORDECAMARGO","WILFRIEDDALMAT","63");

insert into wissel (matchid,inid,uitid,minuut) values ((select last_insert_id()),"MOUSSATRAORE","MEHDICARCELA-GONZALEZ","77");

insert into wissel (matchid,inid,uitid,minuut) values ((select last_insert_id()),"GREGORYDUFER","MILANJOVANOVIC","84");

insert into wissel (matchid,inid,uitid,minuut) values ((select last_insert_id()),"MOUHSINEIAJOUR","HABIBHABIBOU","74");

insert into wissel (matchid,inid,uitid,minuut) values ((select last_insert_id()),"ALESSANDROCORDARO","HERVEKAGE","84");

insert into wedstrijd (speeldag,thuisid,uitid,referee,dag,uur,aantaltoeschouwers) value ("4","GNT","LOK","PETERVERVECKEN","2009-08-22","20:00:00","10810");

	insert into persoonwedstrijd (persoonid,matchid) values ("BOJANJORGACEVIC",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("STEFWILS",(select last_insert_id()));
	
			insert into doelpunt (matchid,persoonid,minuut,owngoal) values ((select last_insert_id()),"STEFWILS","54",false);
		
	insert into persoonwedstrijd (persoonid,matchid) values ("KENNYTHOMPSON",(select last_insert_id()));
	
		insert into kaart (matchid,persoonid,kleur,minuut) values ((select last_insert_id()),"KENNYTHOMPSON","geel","56");
	
	insert into persoonwedstrijd (persoonid,matchid) values ("MARKOSULER",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("ROBERTOROSALES",(select last_insert_id()));
	
		insert into kaart (matchid,persoonid,kleur,minuut) values ((select last_insert_id()),"ROBERTOROSALES","geel","51");
	
	insert into persoonwedstrijd (persoonid,matchid) values ("ADNANCUSTOVIC",(select last_insert_id()));
	
			insert into doelpunt (matchid,persoonid,minuut,owngoal) values ((select last_insert_id()),"ADNANCUSTOVIC","6",false);
		
			insert into doelpunt (matchid,persoonid,minuut,owngoal) values ((select last_insert_id()),"ADNANCUSTOVIC","75",false);
		
	insert into persoonwedstrijd (persoonid,matchid) values ("RANDALLAZOFEIFA",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("YASSINEELGHANASSY",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("MBAYELEYE",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("MILOSMARIC",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("ZLATANLJUBIJANKIC",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("ERLENDHANSTVEIT",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("CHRISTOPHELEPOINT",(select last_insert_id()));
	
			insert into doelpunt (matchid,persoonid,minuut,owngoal) values ((select last_insert_id()),"CHRISTOPHELEPOINT","90",false);
		
	insert into persoonwedstrijd (persoonid,matchid) values ("ELIMANECOULIBALY",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("BOUBACARCOPA",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("OLIVIERDOLL",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("FRÉDÉRICDUPRÉ",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("HASSANELMOUATAZ",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("IBRAHIMAGUEYE",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("SULEJMANSMAJIC",(select last_insert_id()));
	
		insert into kaart (matchid,persoonid,kleur,minuut) values ((select last_insert_id()),"SULEJMANSMAJIC","geel","53");
	
	insert into persoonwedstrijd (persoonid,matchid) values ("MARCELMBAYO",(select last_insert_id()));
	
		insert into kaart (matchid,persoonid,kleur,minuut) values ((select last_insert_id()),"MARCELMBAYO","geel","36");
	
	insert into persoonwedstrijd (persoonid,matchid) values ("TSHINYAMATIKO",(select last_insert_id()));
	
		insert into kaart (matchid,persoonid,kleur,minuut) values ((select last_insert_id()),"TSHINYAMATIKO","geel","37");
	
	insert into persoonwedstrijd (persoonid,matchid) values ("MARIOCAREVIC",(select last_insert_id()));
	
			insert into doelpunt (matchid,persoonid,minuut,owngoal) values ((select last_insert_id()),"MARIOCAREVIC","60",false);
		
		insert into kaart (matchid,persoonid,kleur,minuut) values ((select last_insert_id()),"MARIOCAREVIC","geel","33");
	
	insert into persoonwedstrijd (persoonid,matchid) values ("DONOVANDEEKMAN",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("TOMISLAVSOKOTA",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("KILLIANOVERMEIRE",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("DAWIDJANCZYK",(select last_insert_id()));
	
insert into wissel (matchid,inid,uitid,minuut) values ((select last_insert_id()),"ERLENDHANSTVEIT","KENNYTHOMPSON","70");

insert into wissel (matchid,inid,uitid,minuut) values ((select last_insert_id()),"CHRISTOPHELEPOINT","ADNANCUSTOVIC","82");

insert into wissel (matchid,inid,uitid,minuut) values ((select last_insert_id()),"ELIMANECOULIBALY","ZLATANLJUBIJANKIC","89");

insert into wissel (matchid,inid,uitid,minuut) values ((select last_insert_id()),"KILLIANOVERMEIRE","MARCELMBAYO","60");

insert into wissel (matchid,inid,uitid,minuut) values ((select last_insert_id()),"DAWIDJANCZYK","DONOVANDEEKMAN","68");

insert into wedstrijd (speeldag,thuisid,uitid,referee,dag,uur,aantaltoeschouwers) value ("4","GBA","KVM","GEERTBARBRY","2009-08-22","20:00:00","9572");

	insert into persoonwedstrijd (persoonid,matchid) values ("TOMISLAVPACOVSKI",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("PHILIPPECLEMENT",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("KURTVANDOOREN",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("PIETERJANMONTEYNE",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("JUSTICEWAMFOR",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("BARTGOOR",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("WIMDEDECKER",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("MARKDEMAN",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("FARISHAROUN",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("SHERJILLMACDONALD",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("SANHARIBMALKI",(select last_insert_id()));
	
			insert into doelpunt (matchid,persoonid,minuut,owngoal) values ((select last_insert_id()),"SANHARIBMALKI","13",false);
		
	insert into persoonwedstrijd (persoonid,matchid) values ("DANIELCRUZ",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("BAVONTSHIBUABUA",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("VICTORWANYAMA",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("WOUTERBIEBAUW",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("KENNYVANHOEVELEN",(select last_insert_id()));
	
		insert into kaart (matchid,persoonid,kleur,minuut) values ((select last_insert_id()),"KENNYVANHOEVELEN","geel","46");
	
	insert into persoonwedstrijd (persoonid,matchid) values ("XAVIERCHEN",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("JONASIVENS",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("ANTONIOGHOMSI",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("KOENPERSOONS",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("YONIBUYENS",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("JOACHIMMUNUNGA",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("JULIENGORIUS",(select last_insert_id()));
	
			insert into doelpunt (matchid,persoonid,minuut,owngoal) values ((select last_insert_id()),"JULIENGORIUS","9",false);
		
	insert into persoonwedstrijd (persoonid,matchid) values ("DAVIDDESTORME",(select last_insert_id()));
	
		insert into kaart (matchid,persoonid,kleur,minuut) values ((select last_insert_id()),"DAVIDDESTORME","geel","71");
	
	insert into persoonwedstrijd (persoonid,matchid) values ("ALOISNONG",(select last_insert_id()));
	
			insert into doelpunt (matchid,persoonid,minuut,owngoal) values ((select last_insert_id()),"ALOISNONG","46",false);
		
	insert into persoonwedstrijd (persoonid,matchid) values ("GIUSEPPEROSSINI",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("ABDULYAKUNIIDDI",(select last_insert_id()));
	
			insert into doelpunt (matchid,persoonid,minuut,owngoal) values ((select last_insert_id()),"ABDULYAKUNIIDDI","96",false);
		
	insert into persoonwedstrijd (persoonid,matchid) values ("TIDIAMBABAKOUROUMA",(select last_insert_id()));
	
insert into wissel (matchid,inid,uitid,minuut) values ((select last_insert_id()),"DANIELCRUZ","JUSTICEWAMFOR","45");

insert into wissel (matchid,inid,uitid,minuut) values ((select last_insert_id()),"BAVONTSHIBUABUA","SANHARIBMALKI","58");

insert into wissel (matchid,inid,uitid,minuut) values ((select last_insert_id()),"VICTORWANYAMA","WIMDEDECKER","69");

insert into wissel (matchid,inid,uitid,minuut) values ((select last_insert_id()),"GIUSEPPEROSSINI","JOACHIMMUNUNGA","75");

insert into wissel (matchid,inid,uitid,minuut) values ((select last_insert_id()),"ABDULYAKUNIIDDI","ALOISNONG","86");

insert into wissel (matchid,inid,uitid,minuut) values ((select last_insert_id()),"TIDIAMBABAKOUROUMA","DAVIDDESTORME","89");

insert into wedstrijd (speeldag,thuisid,uitid,referee,dag,uur,aantaltoeschouwers) value ("4","ZWA","AND","CLAUDEBOURDOUXHE","2009-08-22","20:00:00","8285");

	insert into persoonwedstrijd (persoonid,matchid) values ("SAMMYBOSSUT",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("STIJNMINNE",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("KARELDHAENE",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("BARTBUYSSE",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("JÉRÉMYTARAVEL",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("STIJNMEERT",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("KEVINROELANDTS",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("STEVECOLPAERT",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("FRANCKBERRIER",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("KHALEEMHYLAND",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("TEDDYCHEVALIER",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("ERNESTNFOR",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("CHRISMAKIESE",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("SILVIOPROTO",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("OLIVIERDESCHACHT",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("ONDREJMAZUCH",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("ROLANDJUHASZ",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("MARCINWASILEWSKI",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("LUCASBIGLIA",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("THOMASCHATELLE",(select last_insert_id()));
	
		insert into kaart (matchid,persoonid,kleur,minuut) values ((select last_insert_id()),"THOMASCHATELLE","geel","68");
	
	insert into persoonwedstrijd (persoonid,matchid) values ("JANPOLAK",(select last_insert_id()));
	
		insert into kaart (matchid,persoonid,kleur,minuut) values ((select last_insert_id()),"JANPOLAK","geel","26");
	
	insert into persoonwedstrijd (persoonid,matchid) values ("MBARKBOUSSOUFA",(select last_insert_id()));
	
			insert into doelpunt (matchid,persoonid,minuut,owngoal) values ((select last_insert_id()),"MBARKBOUSSOUFA","44",false);
		
		insert into kaart (matchid,persoonid,kleur,minuut) values ((select last_insert_id()),"MBARKBOUSSOUFA","geel","33");
	
	insert into persoonwedstrijd (persoonid,matchid) values ("MATIASSUAREZ",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("RUBENILSONKANU",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("ROMELOLUKAKU",(select last_insert_id()));
	
			insert into doelpunt (matchid,persoonid,minuut,owngoal) values ((select last_insert_id()),"ROMELOLUKAKU","89",false);
		
	insert into persoonwedstrijd (persoonid,matchid) values ("JONATHANLEGEAR",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("GUILLAUMEGILLET",(select last_insert_id()));
	
insert into wissel (matchid,inid,uitid,minuut) values ((select last_insert_id()),"ERNESTNFOR","STEVECOLPAERT","57");

insert into wissel (matchid,inid,uitid,minuut) values ((select last_insert_id()),"CHRISMAKIESE","KHALEEMHYLAND","84");

insert into wissel (matchid,inid,uitid,minuut) values ((select last_insert_id()),"ROMELOLUKAKU","RUBENILSONKANU","69");

insert into wissel (matchid,inid,uitid,minuut) values ((select last_insert_id()),"JONATHANLEGEAR","THOMASCHATELLE","75");

insert into wissel (matchid,inid,uitid,minuut) values ((select last_insert_id()),"GUILLAUMEGILLET","MATIASSUAREZ","87");

insert into wedstrijd (speeldag,thuisid,uitid,referee,dag,uur,aantaltoeschouwers) value ("4","MOE","CER","PHILIPPEFLAMENT","2009-08-22","20:00:00","3969");

	insert into persoonwedstrijd (persoonid,matchid) values ("JOSÉANTONIOSALCEDO",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("GONZAGUEVANDOOREN",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("CHEMCEDINEELARAICHI",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("DAANVANGYSEGHEM",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("CARLOSDAVIDMORENOHERNANDEZ",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("GUILLAUMEFRANÇOIS",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("MAXIMELESTIENNE",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("JONATHANJUNCAL",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("MATHIEUASSOU-EKOTTO",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("IDIROUALI",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("OKWUNWANNEJAYCEE",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("MANUELMICOYEBANA",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("ASANDASISHUBA",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("MAMADOUDIAKITE",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("JOCOPPENS",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("DENISVIANE",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("BERNTEVENS",(select last_insert_id()));
	
		insert into kaart (matchid,persoonid,kleur,minuut) values ((select last_insert_id()),"BERNTEVENS","geel","73");
	
	insert into persoonwedstrijd (persoonid,matchid) values ("FREDERIKBOI",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("VUSUMUZINYONI",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("TONYSERGEANT",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("OLEGIACHTCHOUK",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("THOMASBUFFEL",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("DEJANKELHAR",(select last_insert_id()));
	
		insert into kaart (matchid,persoonid,kleur,minuut) values ((select last_insert_id()),"DEJANKELHAR","geel","16");
	
	insert into persoonwedstrijd (persoonid,matchid) values ("HONOURGOMBAMI",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("DOMINICFOLEY",(select last_insert_id()));
	
			insert into doelpunt (matchid,persoonid,minuut,owngoal) values ((select last_insert_id()),"DOMINICFOLEY","35",false);
		
	insert into persoonwedstrijd (persoonid,matchid) values ("ARNARVIDARSSON",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("BOJANBOZOVIC",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("SERHIJSEREBRENNIKOV",(select last_insert_id()));
	
insert into wissel (matchid,inid,uitid,minuut) values ((select last_insert_id()),"MANUELMICOYEBANA","GONZAGUEVANDOOREN","45");

insert into wissel (matchid,inid,uitid,minuut) values ((select last_insert_id()),"ASANDASISHUBA","MAXIMELESTIENNE","45");

insert into wissel (matchid,inid,uitid,minuut) values ((select last_insert_id()),"MAMADOUDIAKITE","CHEMCEDINEELARAICHI","80");

insert into wissel (matchid,inid,uitid,minuut) values ((select last_insert_id()),"ARNARVIDARSSON","THOMASBUFFEL","75");

insert into wissel (matchid,inid,uitid,minuut) values ((select last_insert_id()),"BOJANBOZOVIC","DOMINICFOLEY","75");

insert into wissel (matchid,inid,uitid,minuut) values ((select last_insert_id()),"SERHIJSEREBRENNIKOV","HONOURGOMBAMI","92");

insert into wedstrijd (speeldag,thuisid,uitid,referee,dag,uur,aantaltoeschouwers) value ("4","STVV","ROE","CHRISTOFVIRANT","2009-08-22","20:00:00","7484");

	insert into persoonwedstrijd (persoonid,matchid) values ("SIMONMIGNOLET",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("MARCWAGEMAKERS",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("VINCENTEUVRARD",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("DENISODOI",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("MARIOCANTALUPPI",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("WIMMENNES",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("PETERDELORGE",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("JONATHANWILMET",(select last_insert_id()));
	
			insert into doelpunt (matchid,persoonid,minuut,owngoal) values ((select last_insert_id()),"JONATHANWILMET","70",false);
		
	insert into persoonwedstrijd (persoonid,matchid) values ("ALEXDASILVA",(select last_insert_id()));
	
		insert into kaart (matchid,persoonid,kleur,minuut) values ((select last_insert_id()),"ALEXDASILVA","geel","35");
	
	insert into persoonwedstrijd (persoonid,matchid) values ("CEPHASCHIMEDZA",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("IBRAHIMSIDIBE",(select last_insert_id()));
	
			insert into doelpunt (matchid,persoonid,minuut,owngoal) values ((select last_insert_id()),"IBRAHIMSIDIBE","77",false);
		
	insert into persoonwedstrijd (persoonid,matchid) values ("HERVEONANA",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("LUDOVICBUYSENS",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("JEROENAPPELTANS",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("JURGENSIERENS",(select last_insert_id()));
	
		insert into kaart (matchid,persoonid,kleur,minuut) values ((select last_insert_id()),"JURGENSIERENS","geel","34");
	
	insert into persoonwedstrijd (persoonid,matchid) values ("ANTHONYVANLOO",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("JEREMYHUYGHEBAERT",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("DAMIRMIRVIC",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("STEPANKUCERA",(select last_insert_id()));
	
		insert into kaart (matchid,persoonid,kleur,minuut) values ((select last_insert_id()),"STEPANKUCERA","geel","81");
	
	insert into persoonwedstrijd (persoonid,matchid) values ("VINCENTPROVOOST",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("JOERIDEQUEVY",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("DAANDEPEVER",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("SAMIRELGAAOUIRI",(select last_insert_id()));
	
			insert into doelpunt (matchid,persoonid,minuut,owngoal) values ((select last_insert_id()),"SAMIRELGAAOUIRI","64",false);
		
		insert into kaart (matchid,persoonid,kleur,minuut) values ((select last_insert_id()),"SAMIRELGAAOUIRI","geel","92");
	
	insert into persoonwedstrijd (persoonid,matchid) values ("MAHAMADOUDISSA",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("JOHNCOLLINS",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("JIMMYMULISA",(select last_insert_id()));
	
insert into wissel (matchid,inid,uitid,minuut) values ((select last_insert_id()),"HERVEONANA","PETERDELORGE","66");

insert into wissel (matchid,inid,uitid,minuut) values ((select last_insert_id()),"LUDOVICBUYSENS","JONATHANWILMET","83");

insert into wissel (matchid,inid,uitid,minuut) values ((select last_insert_id()),"JEROENAPPELTANS","ALEXDASILVA","92");

insert into wissel (matchid,inid,uitid,minuut) values ((select last_insert_id()),"JIMMYMULISA","DAANDEPEVER","82");

insert into wedstrijd (speeldag,thuisid,uitid,referee,dag,uur,aantaltoeschouwers) value ("4","CLU","KOR","FRANKDEBLEECKERE","2009-08-23","18:00:00","23666");

	insert into persoonwedstrijd (persoonid,matchid) values ("STIJNSTIJNEN",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("KOENDAERDEN",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("JEROENSIMAEYS",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("JORNVERMEULEN",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("ANTOLINALCARAZ",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("KARELGERAERTS",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("JONATHANBLONDEL",(select last_insert_id()));
	
		insert into kaart (matchid,persoonid,kleur,minuut) values ((select last_insert_id()),"JONATHANBLONDEL","geel","56");
	
	insert into persoonwedstrijd (persoonid,matchid) values ("VADISODJIDJAOFOE",(select last_insert_id()));
	
			insert into doelpunt (matchid,persoonid,minuut,owngoal) values ((select last_insert_id()),"VADISODJIDJAOFOE","63",false);
		
	insert into persoonwedstrijd (persoonid,matchid) values ("DANIELCHAVEZ",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("WESLEYSONCK",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("JOSEPHAKPALA",(select last_insert_id()));
	
			insert into doelpunt (matchid,persoonid,minuut,owngoal) values ((select last_insert_id()),"JOSEPHAKPALA","41",false);
		
	insert into persoonwedstrijd (persoonid,matchid) values ("MICHAELKLUKOWSKI",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("NABILDIRAR",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("MOHAMEDDAHMANE",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("GLENNVERBAUWHEDE",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("DAVIDVANDENBROECK",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("BRECHTCAPON",(select last_insert_id()));
	
		insert into kaart (matchid,persoonid,kleur,minuut) values ((select last_insert_id()),"BRECHTCAPON","geel","50");
	
	insert into persoonwedstrijd (persoonid,matchid) values ("KARIMBELHOCINE",(select last_insert_id()));
	
		insert into kaart (matchid,persoonid,kleur,minuut) values ((select last_insert_id()),"KARIMBELHOCINE","geel","62");
	
	insert into persoonwedstrijd (persoonid,matchid) values ("MLADENLAZAREVIC",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("JIMMYHEMPTE",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("DAVYDEBEULE",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("SVENKUMS",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("NEBOJSAPAVLOVIC",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("LEONBENKO",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("EBRAHIMIBOU",(select last_insert_id()));
	
			insert into doelpunt (matchid,persoonid,minuut,owngoal) values ((select last_insert_id()),"EBRAHIMIBOU","21",false);
		
			insert into doelpunt (matchid,persoonid,minuut,owngoal) values ((select last_insert_id()),"EBRAHIMIBOU","40",false);
		
		insert into kaart (matchid,persoonid,kleur,minuut) values ((select last_insert_id()),"EBRAHIMIBOU","geel","82");
	
	insert into persoonwedstrijd (persoonid,matchid) values ("BRAMDELY",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("TOMSOETAERS",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("BRECHTVERBRUGGHE",(select last_insert_id()));
	
insert into wissel (matchid,inid,uitid,minuut) values ((select last_insert_id()),"MICHAELKLUKOWSKI","KOENDAERDEN","45");

insert into wissel (matchid,inid,uitid,minuut) values ((select last_insert_id()),"NABILDIRAR","KARELGERAERTS","45");

insert into wissel (matchid,inid,uitid,minuut) values ((select last_insert_id()),"MOHAMEDDAHMANE","DANIELCHAVEZ","79");

insert into wissel (matchid,inid,uitid,minuut) values ((select last_insert_id()),"BRAMDELY","BRECHTCAPON","65");

insert into wissel (matchid,inid,uitid,minuut) values ((select last_insert_id()),"TOMSOETAERS","SVENKUMS","77");

insert into wissel (matchid,inid,uitid,minuut) values ((select last_insert_id()),"BRECHTVERBRUGGHE","DAVYDEBEULE","85");

insert into wedstrijd (speeldag,thuisid,uitid,referee,dag,uur,aantaltoeschouwers) value ("4","WES","GNK","JEROMEEFONGNZOLO","2009-08-23","20:30:00","6000");

	insert into persoonwedstrijd (persoonid,matchid) values ("YVESDEWINTER",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("NICOVANKERCKHOVEN",(select last_insert_id()));
	
		insert into kaart (matchid,persoonid,kleur,minuut) values ((select last_insert_id()),"NICOVANKERCKHOVEN","geel","75");
	
	insert into persoonwedstrijd (persoonid,matchid) values ("JEFDELEN",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("JORISVANHOUT",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("WOUTERSCHEELEN",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("LUKASZELENKA",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("EMMANUELSARKI",(select last_insert_id()));
	
		insert into kaart (matchid,persoonid,kleur,minuut) values ((select last_insert_id()),"EMMANUELSARKI","geel","56");
	
	insert into persoonwedstrijd (persoonid,matchid) values ("MOSESADAMS",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("MICHAELMODUBI",(select last_insert_id()));
	
		insert into kaart (matchid,persoonid,kleur,minuut) values ((select last_insert_id()),"MICHAELMODUBI","geel","59");
	
	insert into persoonwedstrijd (persoonid,matchid) values ("BERTINTOMOU",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("MOMODOUCEESAY",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("ODITAOBIORA",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("GLENNVANASTEN",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("DAVINOVERHULST",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("JOAOCARLOS",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("ERICMATOUKOU",(select last_insert_id()));
	
		insert into kaart (matchid,persoonid,kleur,minuut) values ((select last_insert_id()),"ERICMATOUKOU","geel","44");
	
	insert into persoonwedstrijd (persoonid,matchid) values ("ANELENGCONGCA",(select last_insert_id()));
	
		insert into kaart (matchid,persoonid,kleur,minuut) values ((select last_insert_id()),"ANELENGCONGCA","geel","32");
	
	insert into persoonwedstrijd (persoonid,matchid) values ("DAVIDHUBERT",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("DIMITRIDAESELEIRE",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("DANIELPUDIL",(select last_insert_id()));
	
		insert into kaart (matchid,persoonid,kleur,minuut) values ((select last_insert_id()),"DANIELPUDIL","geel","67");
	
	insert into persoonwedstrijd (persoonid,matchid) values ("DANIELTOZSER",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("MOUSSAKOITA",(select last_insert_id()));
	
		insert into kaart (matchid,persoonid,kleur,minuut) values ((select last_insert_id()),"MOUSSAKOITA","geel","31");
	
	insert into persoonwedstrijd (persoonid,matchid) values ("FABIENCAMUS",(select last_insert_id()));
	
			insert into doelpunt (matchid,persoonid,minuut,owngoal) values ((select last_insert_id()),"FABIENCAMUS","69",false);
		
	insert into persoonwedstrijd (persoonid,matchid) values ("ELYANIVBARDA",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("TORBENJONELEIT",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("BALAZSTOTH",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("KEVINDEBRUYNE",(select last_insert_id()));
	
		insert into kaart (matchid,persoonid,kleur,minuut) values ((select last_insert_id()),"KEVINDEBRUYNE","geel","87");
	
insert into wissel (matchid,inid,uitid,minuut) values ((select last_insert_id()),"ODITAOBIORA","MOSESADAMS","73");

insert into wissel (matchid,inid,uitid,minuut) values ((select last_insert_id()),"GLENNVANASTEN","WOUTERSCHEELEN","82");

insert into wissel (matchid,inid,uitid,minuut) values ((select last_insert_id()),"TORBENJONELEIT","ERICMATOUKOU","61");

insert into wissel (matchid,inid,uitid,minuut) values ((select last_insert_id()),"BALAZSTOTH","DAVIDHUBERT","78");

insert into wissel (matchid,inid,uitid,minuut) values ((select last_insert_id()),"KEVINDEBRUYNE","ELYANIVBARDA","82");

insert into wedstrijd (speeldag,thuisid,uitid,referee,dag,uur,aantaltoeschouwers) value ("5","WES","ZWA","FREDERIKGELDHOF","2009-08-28","20:30:00","4000");

	insert into persoonwedstrijd (persoonid,matchid) values ("YVESDEWINTER",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("NICOVANKERCKHOVEN",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("JEFDELEN",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("JORISVANHOUT",(select last_insert_id()));
	
		insert into kaart (matchid,persoonid,kleur,minuut) values ((select last_insert_id()),"JORISVANHOUT","geel","64");
	
	insert into persoonwedstrijd (persoonid,matchid) values ("STEVENDEPETTER",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("RACHIDFARSSI",(select last_insert_id()));
	
			insert into doelpunt (matchid,persoonid,minuut,owngoal) values ((select last_insert_id()),"RACHIDFARSSI","69",false);
		
	insert into persoonwedstrijd (persoonid,matchid) values ("GLENNVANASTEN",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("LUKASZELENKA",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("MOSESADAMS",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("MICHAELMODUBI",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("ODITAOBIORA",(select last_insert_id()));
	
		insert into kaart (matchid,persoonid,kleur,minuut) values ((select last_insert_id()),"ODITAOBIORA","geel","59");
	
	insert into persoonwedstrijd (persoonid,matchid) values ("EMMANUELSARKI",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("MOMODOUCEESAY",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("DIETERDEKELVER",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("SAMMYBOSSUT",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("STIJNMINNE",(select last_insert_id()));
	
		insert into kaart (matchid,persoonid,kleur,minuut) values ((select last_insert_id()),"STIJNMINNE","geel","25");
	
	insert into persoonwedstrijd (persoonid,matchid) values ("KARELDHAENE",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("BARTBUYSSE",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("JÉRÉMYTARAVEL",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("KEVINROELANDTS",(select last_insert_id()));
	
		insert into kaart (matchid,persoonid,kleur,minuut) values ((select last_insert_id()),"KEVINROELANDTS","geel","94");
	
	insert into persoonwedstrijd (persoonid,matchid) values ("FRANCKBERRIER",(select last_insert_id()));
	
			insert into doelpunt (matchid,persoonid,minuut,owngoal) values ((select last_insert_id()),"FRANCKBERRIER","52",false);
		
	insert into persoonwedstrijd (persoonid,matchid) values ("TEDDYCHEVALIER",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("CHRISMAKIESE",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("KHALEEMHYLAND",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("ERNESTNFOR",(select last_insert_id()));
	
			insert into doelpunt (matchid,persoonid,minuut,owngoal) values ((select last_insert_id()),"ERNESTNFOR","93",false);
		
	insert into persoonwedstrijd (persoonid,matchid) values ("STEVECOLPAERT",(select last_insert_id()));
	
		insert into kaart (matchid,persoonid,kleur,minuut) values ((select last_insert_id()),"STEVECOLPAERT","geel","78");
	
	insert into persoonwedstrijd (persoonid,matchid) values ("JARGOWAEGHE",(select last_insert_id()));
	
insert into wissel (matchid,inid,uitid,minuut) values ((select last_insert_id()),"EMMANUELSARKI","NICOVANKERCKHOVEN","45");

insert into wissel (matchid,inid,uitid,minuut) values ((select last_insert_id()),"MOMODOUCEESAY","LUKASZELENKA","59");

insert into wissel (matchid,inid,uitid,minuut) values ((select last_insert_id()),"DIETERDEKELVER","RACHIDFARSSI","86");

insert into wissel (matchid,inid,uitid,minuut) values ((select last_insert_id()),"STEVECOLPAERT","KHALEEMHYLAND","69");

insert into wissel (matchid,inid,uitid,minuut) values ((select last_insert_id()),"JARGOWAEGHE","CHRISMAKIESE","94");

insert into wedstrijd (speeldag,thuisid,uitid,referee,dag,uur,aantaltoeschouwers) value ("5","LOK","MOE","GUNTERBOELEN","2009-08-29","20:00:00","4483");

	insert into persoonwedstrijd (persoonid,matchid) values ("BOUBACARCOPA",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("OLIVIERDOLL",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("YOAVZIV",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("HASSANELMOUATAZ",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("IBRAHIMAGUEYE",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("SULEJMANSMAJIC",(select last_insert_id()));
	
			insert into doelpunt (matchid,persoonid,minuut,owngoal) values ((select last_insert_id()),"SULEJMANSMAJIC","32",false);
		
			insert into doelpunt (matchid,persoonid,minuut,owngoal) values ((select last_insert_id()),"SULEJMANSMAJIC","45",false);
		
	insert into persoonwedstrijd (persoonid,matchid) values ("MARCELMBAYO",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("TSHINYAMATIKO",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("MARIOCAREVIC",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("TOMISLAVSOKOTA",(select last_insert_id()));
	
			insert into doelpunt (matchid,persoonid,minuut,owngoal) values ((select last_insert_id()),"TOMISLAVSOKOTA","52",false);
		
		insert into kaart (matchid,persoonid,kleur,minuut) values ((select last_insert_id()),"TOMISLAVSOKOTA","geel","53");
	
	insert into persoonwedstrijd (persoonid,matchid) values ("DAWIDJANCZYK",(select last_insert_id()));
	
			insert into doelpunt (matchid,persoonid,minuut,owngoal) values ((select last_insert_id()),"DAWIDJANCZYK","25",false);
		
	insert into persoonwedstrijd (persoonid,matchid) values ("KILLIANOVERMEIRE",(select last_insert_id()));
	
		insert into kaart (matchid,persoonid,kleur,minuut) values ((select last_insert_id()),"KILLIANOVERMEIRE","geel","64");
	
	insert into persoonwedstrijd (persoonid,matchid) values ("KATUKUTSHIMANGA",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("IDDIBABA",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("JOSÉANTONIOSALCEDO",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("GONZAGUEVANDOOREN",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("CHEMCEDINEELARAICHI",(select last_insert_id()));
	
		insert into kaart (matchid,persoonid,kleur,minuut) values ((select last_insert_id()),"CHEMCEDINEELARAICHI","geel","35");
	
	insert into persoonwedstrijd (persoonid,matchid) values ("DAANVANGYSEGHEM",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("CARLOSDAVIDMORENOHERNANDEZ",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("GUILLAUMEFRANÇOIS",(select last_insert_id()));
	
		insert into kaart (matchid,persoonid,kleur,minuut) values ((select last_insert_id()),"GUILLAUMEFRANÇOIS","geel","47");
	
	insert into persoonwedstrijd (persoonid,matchid) values ("MAXIMELESTIENNE",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("JONATHANJUNCAL",(select last_insert_id()));
	
		insert into kaart (matchid,persoonid,kleur,minuut) values ((select last_insert_id()),"JONATHANJUNCAL","geel","83");
	
	insert into persoonwedstrijd (persoonid,matchid) values ("MATHIEUASSOU-EKOTTO",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("IDIROUALI",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("OKWUNWANNEJAYCEE",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("ROBERTMAAH",(select last_insert_id()));
	
			insert into doelpunt (matchid,persoonid,minuut,owngoal) values ((select last_insert_id()),"ROBERTMAAH","79",false);
		
	insert into persoonwedstrijd (persoonid,matchid) values ("MAMADOUDIAKITE",(select last_insert_id()));
	
		insert into kaart (matchid,persoonid,kleur,minuut) values ((select last_insert_id()),"MAMADOUDIAKITE","geel","59");
	
	insert into persoonwedstrijd (persoonid,matchid) values ("ASANDASISHUBA",(select last_insert_id()));
	
insert into wissel (matchid,inid,uitid,minuut) values ((select last_insert_id()),"KILLIANOVERMEIRE","TSHINYAMATIKO","45");

insert into wissel (matchid,inid,uitid,minuut) values ((select last_insert_id()),"KATUKUTSHIMANGA","YOAVZIV","79");

insert into wissel (matchid,inid,uitid,minuut) values ((select last_insert_id()),"IDDIBABA","TOMISLAVSOKOTA","89");

insert into wissel (matchid,inid,uitid,minuut) values ((select last_insert_id()),"ROBERTMAAH","GUILLAUMEFRANÇOIS","47");

insert into wissel (matchid,inid,uitid,minuut) values ((select last_insert_id()),"MAMADOUDIAKITE","MATHIEUASSOU-EKOTTO","45");

insert into wissel (matchid,inid,uitid,minuut) values ((select last_insert_id()),"ASANDASISHUBA","MAXIMELESTIENNE","56");

insert into wedstrijd (speeldag,thuisid,uitid,referee,dag,uur,aantaltoeschouwers) value ("5","KOR","GNT","CHRISTOPHEDELACOUR","2009-08-29","20:00:00","7000");

	insert into persoonwedstrijd (persoonid,matchid) values ("GLENNVERBAUWHEDE",(select last_insert_id()));
	
		insert into kaart (matchid,persoonid,kleur,minuut) values ((select last_insert_id()),"GLENNVERBAUWHEDE","geel","57");
	
	insert into persoonwedstrijd (persoonid,matchid) values ("JIMMYHEMPTE",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("DAVIDVANDENBROECK",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("LAURENTCIMAN",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("MLADENLAZAREVIC",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("DAVYDEBEULE",(select last_insert_id()));
	
		insert into kaart (matchid,persoonid,kleur,minuut) values ((select last_insert_id()),"DAVYDEBEULE","geel","21");
	
	insert into persoonwedstrijd (persoonid,matchid) values ("SVENKUMS",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("KARIMBELHOCINE",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("NEBOJSAPAVLOVIC",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("LEONBENKO",(select last_insert_id()));
	
			insert into doelpunt (matchid,persoonid,minuut,owngoal) values ((select last_insert_id()),"LEONBENKO","49",false);
		
	insert into persoonwedstrijd (persoonid,matchid) values ("EBRAHIMIBOU",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("ROBCLAEYS",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("CHRISTIANBENTEKE",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("BOJANJORGACEVIC",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("STEFWILS",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("KENNYTHOMPSON",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("MARKOSULER",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("ROBERTOROSALES",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("TIMSMOLDERS",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("ADNANCUSTOVIC",(select last_insert_id()));
	
		insert into kaart (matchid,persoonid,kleur,minuut) values ((select last_insert_id()),"ADNANCUSTOVIC","geel","23");
	
	insert into persoonwedstrijd (persoonid,matchid) values ("RANDALLAZOFEIFA",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("YASSINEELGHANASSY",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("MBAYELEYE",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("ZLATANLJUBIJANKIC",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("CHRISTOPHELEPOINT",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("ELIMANECOULIBALY",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("ADEKAMNIOLUFADE",(select last_insert_id()));
	
insert into wissel (matchid,inid,uitid,minuut) values ((select last_insert_id()),"ROBCLAEYS","SVENKUMS","86");

insert into wissel (matchid,inid,uitid,minuut) values ((select last_insert_id()),"CHRISTIANBENTEKE","LEONBENKO","88");

insert into wissel (matchid,inid,uitid,minuut) values ((select last_insert_id()),"CHRISTOPHELEPOINT","TIMSMOLDERS","72");

insert into wissel (matchid,inid,uitid,minuut) values ((select last_insert_id()),"ELIMANECOULIBALY","ADNANCUSTOVIC","76");

insert into wissel (matchid,inid,uitid,minuut) values ((select last_insert_id()),"ADEKAMNIOLUFADE","YASSINEELGHANASSY","85");

insert into wedstrijd (speeldag,thuisid,uitid,referee,dag,uur,aantaltoeschouwers) value ("5","KVM","STVV","JOERIVANDEVELDE","2009-08-29","20:00:00","12530");

	insert into persoonwedstrijd (persoonid,matchid) values ("WOUTERBIEBAUW",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("KENNYVANHOEVELEN",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("XAVIERCHEN",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("JONASIVENS",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("ANTONIOGHOMSI",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("KOENPERSOONS",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("YONIBUYENS",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("JOACHIMMUNUNGA",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("JULIENGORIUS",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("DAVIDDESTORME",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("ALOISNONG",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("GIUSEPPEROSSINI",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("JORENDOM",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("AYMARFABRICEMORO",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("SIMONMIGNOLET",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("MARCWAGEMAKERS",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("VINCENTEUVRARD",(select last_insert_id()));
	
		insert into kaart (matchid,persoonid,kleur,minuut) values ((select last_insert_id()),"VINCENTEUVRARD","geel","22");
	
	insert into persoonwedstrijd (persoonid,matchid) values ("DENISODOI",(select last_insert_id()));
	
		insert into kaart (matchid,persoonid,kleur,minuut) values ((select last_insert_id()),"DENISODOI","geel","33");
	
	insert into persoonwedstrijd (persoonid,matchid) values ("MARIOCANTALUPPI",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("WIMMENNES",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("PETERDELORGE",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("CEPHASCHIMEDZA",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("JONATHANWILMET",(select last_insert_id()));
	
			insert into doelpunt (matchid,persoonid,minuut,owngoal) values ((select last_insert_id()),"JONATHANWILMET","68",false);
		
		insert into kaart (matchid,persoonid,kleur,minuut) values ((select last_insert_id()),"JONATHANWILMET","geel","63");
	
	insert into persoonwedstrijd (persoonid,matchid) values ("ALEXDASILVA",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("IBRAHIMSIDIBE",(select last_insert_id()));
	
			insert into doelpunt (matchid,persoonid,minuut,owngoal) values ((select last_insert_id()),"IBRAHIMSIDIBE","82",false);
		
		insert into kaart (matchid,persoonid,kleur,minuut) values ((select last_insert_id()),"IBRAHIMSIDIBE","geel","17");
	
	insert into persoonwedstrijd (persoonid,matchid) values ("HERVEONANA",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("LUDOVICBUYSENS",(select last_insert_id()));
	
insert into wissel (matchid,inid,uitid,minuut) values ((select last_insert_id()),"GIUSEPPEROSSINI","YONIBUYENS","72");

insert into wissel (matchid,inid,uitid,minuut) values ((select last_insert_id()),"JORENDOM","JOACHIMMUNUNGA","83");

insert into wissel (matchid,inid,uitid,minuut) values ((select last_insert_id()),"AYMARFABRICEMORO","ANTONIOGHOMSI","89");

insert into wissel (matchid,inid,uitid,minuut) values ((select last_insert_id()),"HERVEONANA","WIMMENNES","45");

insert into wissel (matchid,inid,uitid,minuut) values ((select last_insert_id()),"LUDOVICBUYSENS","JONATHANWILMET","77");

insert into wedstrijd (speeldag,thuisid,uitid,referee,dag,uur,aantaltoeschouwers) value ("5","ROE","CHA","LAURENTCOLEMONTS","2009-08-29","20:00:00","5500");

	insert into persoonwedstrijd (persoonid,matchid) values ("JURGENSIERENS",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("ANTHONYVANLOO",(select last_insert_id()));
	
		insert into kaart (matchid,persoonid,kleur,minuut) values ((select last_insert_id()),"ANTHONYVANLOO","geel","43");
	
	insert into persoonwedstrijd (persoonid,matchid) values ("JEREMYHUYGHEBAERT",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("DAMIRMIRVIC",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("STEPANKUCERA",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("VINCENTPROVOOST",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("JOERIDEQUEVY",(select last_insert_id()));
	
		insert into kaart (matchid,persoonid,kleur,minuut) values ((select last_insert_id()),"JOERIDEQUEVY","geel","53");
	
	insert into persoonwedstrijd (persoonid,matchid) values ("DAANDEPEVER",(select last_insert_id()));
	
		insert into kaart (matchid,persoonid,kleur,minuut) values ((select last_insert_id()),"DAANDEPEVER","geel","58");
	
	insert into persoonwedstrijd (persoonid,matchid) values ("SAMIRELGAAOUIRI",(select last_insert_id()));
	
			insert into doelpunt (matchid,persoonid,minuut,owngoal) values ((select last_insert_id()),"SAMIRELGAAOUIRI","39",false);
		
	insert into persoonwedstrijd (persoonid,matchid) values ("MAHAMADOUDISSA",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("JOHNCOLLINS",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("STEFANNIKOLIC",(select last_insert_id()));
	
		insert into kaart (matchid,persoonid,kleur,minuut) values ((select last_insert_id()),"STEFANNIKOLIC","geel","67");
	
	insert into persoonwedstrijd (persoonid,matchid) values ("BRAMVANDENBUSSCHE",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("ARTUROTENHEUVEL",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("SÉBASTIENCHABBERT",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("MAHAMOUDOUKERE",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("MAXIMEBRILLAULT",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("MOHAMEDCHAKOURI",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("IBRAHIMADIALLO",(select last_insert_id()));
	
		insert into kaart (matchid,persoonid,kleur,minuut) values ((select last_insert_id()),"IBRAHIMADIALLO","geel","63");
	
	insert into persoonwedstrijd (persoonid,matchid) values ("ALESSANDROCORDARO",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("HERVEKAGE",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("GREGORYCHRIST",(select last_insert_id()));
	
		insert into kaart (matchid,persoonid,kleur,minuut) values ((select last_insert_id()),"GREGORYCHRIST","geel","75");
	
	insert into persoonwedstrijd (persoonid,matchid) values ("ABDELMAJIDOULMERS",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("CYRILTHÉREAU",(select last_insert_id()));
	
			insert into doelpunt (matchid,persoonid,minuut,owngoal) values ((select last_insert_id()),"CYRILTHÉREAU","20",false);
		
			insert into doelpunt (matchid,persoonid,minuut,owngoal) values ((select last_insert_id()),"CYRILTHÉREAU","27",false);
		
	insert into persoonwedstrijd (persoonid,matchid) values ("HABIBHABIBOU",(select last_insert_id()));
	
			insert into doelpunt (matchid,persoonid,minuut,owngoal) values ((select last_insert_id()),"HABIBHABIBOU","30",false);
		
	insert into persoonwedstrijd (persoonid,matchid) values ("ADLENEGUEDIOURA",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("ORLANDODOSSANTOSCOSTA",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("MOUHSINEIAJOUR",(select last_insert_id()));
	
insert into wissel (matchid,inid,uitid,minuut) values ((select last_insert_id()),"STEFANNIKOLIC","DAANDEPEVER","63");

insert into wissel (matchid,inid,uitid,minuut) values ((select last_insert_id()),"BRAMVANDENBUSSCHE","VINCENTPROVOOST","82");

insert into wissel (matchid,inid,uitid,minuut) values ((select last_insert_id()),"ARTUROTENHEUVEL","JOERIDEQUEVY","82");

insert into wissel (matchid,inid,uitid,minuut) values ((select last_insert_id()),"ADLENEGUEDIOURA","ALESSANDROCORDARO","45");

insert into wissel (matchid,inid,uitid,minuut) values ((select last_insert_id()),"ORLANDODOSSANTOSCOSTA","HERVEKAGE","72");

insert into wissel (matchid,inid,uitid,minuut) values ((select last_insert_id()),"MOUHSINEIAJOUR","HABIBHABIBOU","82");

insert into wedstrijd (speeldag,thuisid,uitid,referee,dag,uur,aantaltoeschouwers) value ("5","GNK","GBA","TIMPOTS","2009-08-30","18:00:00","18235");

	insert into persoonwedstrijd (persoonid,matchid) values ("DAVINOVERHULST",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("DAVIDHUBERT",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("DANIELPUDIL",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("ANELENGCONGCA",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("DIMITRIDAESELEIRE",(select last_insert_id()));
	
		insert into kaart (matchid,persoonid,kleur,minuut) values ((select last_insert_id()),"DIMITRIDAESELEIRE","geel","53");
	
	insert into persoonwedstrijd (persoonid,matchid) values ("KEVINDEBRUYNE",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("FABIENCAMUS",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("BALAZSTOTH",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("DANIELTOZSER",(select last_insert_id()));
	
		insert into kaart (matchid,persoonid,kleur,minuut) values ((select last_insert_id()),"DANIELTOZSER","geel","46");
	
	insert into persoonwedstrijd (persoonid,matchid) values ("MARVINOGUNJIMI",(select last_insert_id()));
	
			insert into doelpunt (matchid,persoonid,minuut,owngoal) values ((select last_insert_id()),"MARVINOGUNJIMI","49",false);
		
	insert into persoonwedstrijd (persoonid,matchid) values ("MOUSSAKOITA",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("TORBENJONELEIT",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("JELLEVOSSEN",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("TIMOTHYDURWAEL",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("TOMISLAVPACOVSKI",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("PHILIPPECLEMENT",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("KURTVANDOOREN",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("PIETERJANMONTEYNE",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("MARTIJNMONTEYNE",(select last_insert_id()));
	
		insert into kaart (matchid,persoonid,kleur,minuut) values ((select last_insert_id()),"MARTIJNMONTEYNE","geel","86");
	
	insert into persoonwedstrijd (persoonid,matchid) values ("BARTGOOR",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("WIMDEDECKER",(select last_insert_id()));
	
		insert into kaart (matchid,persoonid,kleur,minuut) values ((select last_insert_id()),"WIMDEDECKER","geel","23");
	
	insert into persoonwedstrijd (persoonid,matchid) values ("JUSTICEWAMFOR",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("IVANLEKO",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("FARISHAROUN",(select last_insert_id()));
	
			insert into doelpunt (matchid,persoonid,minuut,owngoal) values ((select last_insert_id()),"FARISHAROUN","38",false);
		
	insert into persoonwedstrijd (persoonid,matchid) values ("SHERJILLMACDONALD",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("BAVONTSHIBUABUA",(select last_insert_id()));
	
insert into wissel (matchid,inid,uitid,minuut) values ((select last_insert_id()),"TORBENJONELEIT","DAVIDHUBERT","66");

insert into wissel (matchid,inid,uitid,minuut) values ((select last_insert_id()),"JELLEVOSSEN","KEVINDEBRUYNE","76");

insert into wissel (matchid,inid,uitid,minuut) values ((select last_insert_id()),"TIMOTHYDURWAEL","DIMITRIDAESELEIRE","79");

insert into wissel (matchid,inid,uitid,minuut) values ((select last_insert_id()),"BAVONTSHIBUABUA","SHERJILLMACDONALD","89");

insert into wedstrijd (speeldag,thuisid,uitid,referee,dag,uur,aantaltoeschouwers) value ("5","CER","CLU","JOHANVERBIST","2009-08-30","18:00:00","20407");

	insert into persoonwedstrijd (persoonid,matchid) values ("JOCOPPENS",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("DENISVIANE",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("BERNTEVENS",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("ANTHONYPORTIER",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("VUSUMUZINYONI",(select last_insert_id()));
	
		insert into kaart (matchid,persoonid,kleur,minuut) values ((select last_insert_id()),"VUSUMUZINYONI","geel","62");
	
	insert into persoonwedstrijd (persoonid,matchid) values ("TONYSERGEANT",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("OLEGIACHTCHOUK",(select last_insert_id()));
	
			insert into doelpunt (matchid,persoonid,minuut,owngoal) values ((select last_insert_id()),"OLEGIACHTCHOUK","2",false);
		
	insert into persoonwedstrijd (persoonid,matchid) values ("THOMASBUFFEL",(select last_insert_id()));
	
			insert into doelpunt (matchid,persoonid,minuut,owngoal) values ((select last_insert_id()),"THOMASBUFFEL","10",false);
		
	insert into persoonwedstrijd (persoonid,matchid) values ("ARNARVIDARSSON",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("HONOURGOMBAMI",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("DOMINICFOLEY",(select last_insert_id()));
	
		insert into kaart (matchid,persoonid,kleur,minuut) values ((select last_insert_id()),"DOMINICFOLEY","geel","4");
	
	insert into persoonwedstrijd (persoonid,matchid) values ("SERHIJSEREBRENNIKOV",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("BOJANBOZOVIC",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("FREDERIKBOI",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("GEERTDEVLIEGER",(select last_insert_id()));
	
		insert into kaart (matchid,persoonid,kleur,minuut) values ((select last_insert_id()),"GEERTDEVLIEGER","geel","56");
	
	insert into persoonwedstrijd (persoonid,matchid) values ("KOENDAERDEN",(select last_insert_id()));
	
		insert into kaart (matchid,persoonid,kleur,minuut) values ((select last_insert_id()),"KOENDAERDEN","geel","39");
	
	insert into persoonwedstrijd (persoonid,matchid) values ("JORNVERMEULEN",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("MICHAELKLUKOWSKI",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("ANTOLINALCARAZ",(select last_insert_id()));
	
		insert into kaart (matchid,persoonid,kleur,minuut) values ((select last_insert_id()),"ANTOLINALCARAZ","rood","54");
	
	insert into persoonwedstrijd (persoonid,matchid) values ("JONATHANBLONDEL",(select last_insert_id()));
	
		insert into kaart (matchid,persoonid,kleur,minuut) values ((select last_insert_id()),"JONATHANBLONDEL","geel","65");
	
	insert into persoonwedstrijd (persoonid,matchid) values ("VADISODJIDJAOFOE",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("NABILDIRAR",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("RONALDVARGAS",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("WESLEYSONCK",(select last_insert_id()));
	
			insert into doelpunt (matchid,persoonid,minuut,owngoal) values ((select last_insert_id()),"WESLEYSONCK","15",false);
		
			insert into doelpunt (matchid,persoonid,minuut,owngoal) values ((select last_insert_id()),"WESLEYSONCK","77",false);
		
	insert into persoonwedstrijd (persoonid,matchid) values ("JOSEPHAKPALA",(select last_insert_id()));
	
			insert into doelpunt (matchid,persoonid,minuut,owngoal) values ((select last_insert_id()),"JOSEPHAKPALA","66",false);
		
	insert into persoonwedstrijd (persoonid,matchid) values ("KARELGERAERTS",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("GERTJANDEMETS",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("DANIELCHAVEZ",(select last_insert_id()));
	
insert into wissel (matchid,inid,uitid,minuut) values ((select last_insert_id()),"SERHIJSEREBRENNIKOV","TONYSERGEANT","66");

insert into wissel (matchid,inid,uitid,minuut) values ((select last_insert_id()),"BOJANBOZOVIC","DOMINICFOLEY","70");

insert into wissel (matchid,inid,uitid,minuut) values ((select last_insert_id()),"FREDERIKBOI","ARNARVIDARSSON","80");

insert into wissel (matchid,inid,uitid,minuut) values ((select last_insert_id()),"KARELGERAERTS","JONATHANBLONDEL","65");

insert into wissel (matchid,inid,uitid,minuut) values ((select last_insert_id()),"GERTJANDEMETS","WESLEYSONCK","85");

insert into wissel (matchid,inid,uitid,minuut) values ((select last_insert_id()),"DANIELCHAVEZ","RONALDVARGAS","89");

insert into wedstrijd (speeldag,thuisid,uitid,referee,dag,uur,aantaltoeschouwers) value ("5","AND","STA","JEROMEEFONGNZOLO","2009-08-30","20:30:00","23869");

	insert into persoonwedstrijd (persoonid,matchid) values ("SILVIOPROTO",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("OLIVIERDESCHACHT",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("ONDREJMAZUCH",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("ROLANDJUHASZ",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("MARCINWASILEWSKI",(select last_insert_id()));
	
		insert into kaart (matchid,persoonid,kleur,minuut) values ((select last_insert_id()),"MARCINWASILEWSKI","geel","17");
	
	insert into persoonwedstrijd (persoonid,matchid) values ("THOMASCHATELLE",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("JELLEVANDAMME",(select last_insert_id()));
	
		insert into kaart (matchid,persoonid,kleur,minuut) values ((select last_insert_id()),"JELLEVANDAMME","geel","65");
	
	insert into persoonwedstrijd (persoonid,matchid) values ("GUILLAUMEGILLET",(select last_insert_id()));
	
			insert into doelpunt (matchid,persoonid,minuut,owngoal) values ((select last_insert_id()),"GUILLAUMEGILLET","44",false);
		
	insert into persoonwedstrijd (persoonid,matchid) values ("JANPOLAK",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("MATIASSUAREZ",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("MBARKBOUSSOUFA",(select last_insert_id()));
	
		insert into kaart (matchid,persoonid,kleur,minuut) values ((select last_insert_id()),"MBARKBOUSSOUFA","geel","44");
	
	insert into persoonwedstrijd (persoonid,matchid) values ("BAKARYSARE",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("TOMDESUTTER",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("ROMELOLUKAKU",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("SINANBOLAT",(select last_insert_id()));
	
		insert into kaart (matchid,persoonid,kleur,minuut) values ((select last_insert_id()),"SINANBOLAT","geel","89");
	
	insert into persoonwedstrijd (persoonid,matchid) values ("MARCOSCAMOZZATO",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("CÉDRICCOLLET",(select last_insert_id()));
	
		insert into kaart (matchid,persoonid,kleur,minuut) values ((select last_insert_id()),"CÉDRICCOLLET","geel","47");
	
	insert into persoonwedstrijd (persoonid,matchid) values ("ELIAQUIMMANGALA",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("MOHAMEDSARR",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("STEVENDEFOUR",(select last_insert_id()));
	
		insert into kaart (matchid,persoonid,kleur,minuut) values ((select last_insert_id()),"STEVENDEFOUR","geel","91");
	
	insert into persoonwedstrijd (persoonid,matchid) values ("AXELWITSEL",(select last_insert_id()));
	
		insert into kaart (matchid,persoonid,kleur,minuut) values ((select last_insert_id()),"AXELWITSEL","rood","27");
	
	insert into persoonwedstrijd (persoonid,matchid) values ("WILFRIEDDALMAT",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("IGORDECAMARGO",(select last_insert_id()));
	
		insert into kaart (matchid,persoonid,kleur,minuut) values ((select last_insert_id()),"IGORDECAMARGO","geel","10");
	
	insert into persoonwedstrijd (persoonid,matchid) values ("DIEUMERCIMBOKANI",(select last_insert_id()));
	
			insert into doelpunt (matchid,persoonid,minuut,owngoal) values ((select last_insert_id()),"DIEUMERCIMBOKANI","38",false);
		
		insert into kaart (matchid,persoonid,kleur,minuut) values ((select last_insert_id()),"DIEUMERCIMBOKANI","geel","48");
	
	insert into persoonwedstrijd (persoonid,matchid) values ("MILANJOVANOVIC",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("LANDRYMULEMO",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("BENJAMINNICAISE",(select last_insert_id()));
	
insert into wissel (matchid,inid,uitid,minuut) values ((select last_insert_id()),"BAKARYSARE","JANPOLAK","25");

insert into wissel (matchid,inid,uitid,minuut) values ((select last_insert_id()),"TOMDESUTTER","MARCINWASILEWSKI","33");

insert into wissel (matchid,inid,uitid,minuut) values ((select last_insert_id()),"ROMELOLUKAKU","ONDREJMAZUCH","81");

insert into wissel (matchid,inid,uitid,minuut) values ((select last_insert_id()),"LANDRYMULEMO","CÉDRICCOLLET","49");

insert into wissel (matchid,inid,uitid,minuut) values ((select last_insert_id()),"BENJAMINNICAISE","WILFRIEDDALMAT","86");

insert into wedstrijd (speeldag,thuisid,uitid,referee,dag,uur,aantaltoeschouwers) value ("6","STVV","AND","JOHANVERBIST","2009-09-12","18:00:00","11400");

	insert into persoonwedstrijd (persoonid,matchid) values ("SIMONMIGNOLET",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("MARCWAGEMAKERS",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("VINCENTEUVRARD",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("DENISODOI",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("MARIOCANTALUPPI",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("WIMMENNES",(select last_insert_id()));
	
		insert into kaart (matchid,persoonid,kleur,minuut) values ((select last_insert_id()),"WIMMENNES","geel","27");
	
	insert into persoonwedstrijd (persoonid,matchid) values ("PETERDELORGE",(select last_insert_id()));
	
		insert into kaart (matchid,persoonid,kleur,minuut) values ((select last_insert_id()),"PETERDELORGE","geel","52");
	
	insert into persoonwedstrijd (persoonid,matchid) values ("CEPHASCHIMEDZA",(select last_insert_id()));
	
			insert into doelpunt (matchid,persoonid,minuut,owngoal) values ((select last_insert_id()),"CEPHASCHIMEDZA","6",false);
		
	insert into persoonwedstrijd (persoonid,matchid) values ("JONATHANWILMET",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("ALEXDASILVA",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("IBRAHIMSIDIBE",(select last_insert_id()));
	
			insert into doelpunt (matchid,persoonid,minuut,owngoal) values ((select last_insert_id()),"IBRAHIMSIDIBE","9",false);
		
		insert into kaart (matchid,persoonid,kleur,minuut) values ((select last_insert_id()),"IBRAHIMSIDIBE","geel","37");
	
	insert into persoonwedstrijd (persoonid,matchid) values ("LUDOVICBUYSENS",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("HERVEONANA",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("SILVIOPROTO",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("OLIVIERDESCHACHT",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("JELLEVANDAMME",(select last_insert_id()));
	
		insert into kaart (matchid,persoonid,kleur,minuut) values ((select last_insert_id()),"JELLEVANDAMME","geel","57");
	
	insert into persoonwedstrijd (persoonid,matchid) values ("ONDREJMAZUCH",(select last_insert_id()));
	
		insert into kaart (matchid,persoonid,kleur,minuut) values ((select last_insert_id()),"ONDREJMAZUCH","geel","31");
	
	insert into persoonwedstrijd (persoonid,matchid) values ("ROLANDJUHASZ",(select last_insert_id()));
	
			insert into doelpunt (matchid,persoonid,minuut,owngoal) values ((select last_insert_id()),"ROLANDJUHASZ","83",false);
		
	insert into persoonwedstrijd (persoonid,matchid) values ("LUCASBIGLIA",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("THOMASCHATELLE",(select last_insert_id()));
	
		insert into kaart (matchid,persoonid,kleur,minuut) values ((select last_insert_id()),"THOMASCHATELLE","geel","38");
	
	insert into persoonwedstrijd (persoonid,matchid) values ("GUILLAUMEGILLET",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("MBARKBOUSSOUFA",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("MATIASSUAREZ",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("TOMDESUTTER",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("JONATHANLEGEAR",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("ROMELOLUKAKU",(select last_insert_id()));
	
insert into wissel (matchid,inid,uitid,minuut) values ((select last_insert_id()),"LUDOVICBUYSENS","ALEXDASILVA","82");

insert into wissel (matchid,inid,uitid,minuut) values ((select last_insert_id()),"HERVEONANA","JONATHANWILMET","91");

insert into wissel (matchid,inid,uitid,minuut) values ((select last_insert_id()),"JONATHANLEGEAR","THOMASCHATELLE","45");

insert into wissel (matchid,inid,uitid,minuut) values ((select last_insert_id()),"ROMELOLUKAKU","TOMDESUTTER","56");

insert into wedstrijd (speeldag,thuisid,uitid,referee,dag,uur,aantaltoeschouwers) value ("6","CHA","CER","CHRISTOFDIERICK","2009-09-12","20:00:00","7100");

	insert into persoonwedstrijd (persoonid,matchid) values ("SÉBASTIENCHABBERT",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("MAHAMOUDOUKERE",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("MAXIMEBRILLAULT",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("PETERFRANQUAERT",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("MOHAMEDCHAKOURI",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("ADLENEGUEDIOURA",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("HERVEKAGE",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("GREGORYCHRIST",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("ABDELMAJIDOULMERS",(select last_insert_id()));
	
		insert into kaart (matchid,persoonid,kleur,minuut) values ((select last_insert_id()),"ABDELMAJIDOULMERS","geel","83");
	
	insert into persoonwedstrijd (persoonid,matchid) values ("CYRILTHÉREAU",(select last_insert_id()));
	
		insert into kaart (matchid,persoonid,kleur,minuut) values ((select last_insert_id()),"CYRILTHÉREAU","geel","14");
	
	insert into persoonwedstrijd (persoonid,matchid) values ("HABIBHABIBOU",(select last_insert_id()));
	
		insert into kaart (matchid,persoonid,kleur,minuut) values ((select last_insert_id()),"HABIBHABIBOU","geel","65");
	
	insert into persoonwedstrijd (persoonid,matchid) values ("ALESSANDROCORDARO",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("MOUHSINEIAJOUR",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("ILOMBEMBOYO",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("JOCOPPENS",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("DENISVIANE",(select last_insert_id()));
	
		insert into kaart (matchid,persoonid,kleur,minuut) values ((select last_insert_id()),"DENISVIANE","geel","54");
	
	insert into persoonwedstrijd (persoonid,matchid) values ("BERNTEVENS",(select last_insert_id()));
	
		insert into kaart (matchid,persoonid,kleur,minuut) values ((select last_insert_id()),"BERNTEVENS","geel","26");
	
	insert into persoonwedstrijd (persoonid,matchid) values ("HANSCORNELIS",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("DEJANKELHAR",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("TONYSERGEANT",(select last_insert_id()));
	
		insert into kaart (matchid,persoonid,kleur,minuut) values ((select last_insert_id()),"TONYSERGEANT","geel","49");
	
	insert into persoonwedstrijd (persoonid,matchid) values ("SERHIJSEREBRENNIKOV",(select last_insert_id()));
	
			insert into doelpunt (matchid,persoonid,minuut,owngoal) values ((select last_insert_id()),"SERHIJSEREBRENNIKOV","13",false);
		
	insert into persoonwedstrijd (persoonid,matchid) values ("HONOURGOMBAMI",(select last_insert_id()));
	
		insert into kaart (matchid,persoonid,kleur,minuut) values ((select last_insert_id()),"HONOURGOMBAMI","geel","33");
	
	insert into persoonwedstrijd (persoonid,matchid) values ("VUSUMUZINYONI",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("OLEGIACHTCHOUK",(select last_insert_id()));
	
			insert into doelpunt (matchid,persoonid,minuut,owngoal) values ((select last_insert_id()),"OLEGIACHTCHOUK","43",false);
		
	insert into persoonwedstrijd (persoonid,matchid) values ("JELLEVOSSEN",(select last_insert_id()));
	
			insert into doelpunt (matchid,persoonid,minuut,owngoal) values ((select last_insert_id()),"JELLEVOSSEN","79",false);
		
			insert into doelpunt (matchid,persoonid,minuut,owngoal) values ((select last_insert_id()),"JELLEVOSSEN","84",false);
		
	insert into persoonwedstrijd (persoonid,matchid) values ("OLIVIERCLAESSENS",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("ANTHONYPORTIER",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("FREDERIKBOI",(select last_insert_id()));
	
		insert into kaart (matchid,persoonid,kleur,minuut) values ((select last_insert_id()),"FREDERIKBOI","geel","90");
	
insert into wissel (matchid,inid,uitid,minuut) values ((select last_insert_id()),"ALESSANDROCORDARO","HERVEKAGE","45");

insert into wissel (matchid,inid,uitid,minuut) values ((select last_insert_id()),"MOUHSINEIAJOUR","MAXIMEBRILLAULT","45");

insert into wissel (matchid,inid,uitid,minuut) values ((select last_insert_id()),"ILOMBEMBOYO","HABIBHABIBOU","73");

insert into wissel (matchid,inid,uitid,minuut) values ((select last_insert_id()),"OLIVIERCLAESSENS","BERNTEVENS","45");

insert into wissel (matchid,inid,uitid,minuut) values ((select last_insert_id()),"ANTHONYPORTIER","HONOURGOMBAMI","61");

insert into wissel (matchid,inid,uitid,minuut) values ((select last_insert_id()),"FREDERIKBOI","TONYSERGEANT","69");

insert into wedstrijd (speeldag,thuisid,uitid,referee,dag,uur,aantaltoeschouwers) value ("6","GNT ","ROE","LAURENTCOLEMONTS","2009-09-12","20:00:00","10800");

	insert into persoonwedstrijd (persoonid,matchid) values ("BOJANJORGACEVIC",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("STEFWILS",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("KENNYTHOMPSON",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("ADRIANODUARTE",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("ROBERTOROSALES",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("TIMSMOLDERS",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("ADNANCUSTOVIC",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("RANDALLAZOFEIFA",(select last_insert_id()));
	
			insert into doelpunt (matchid,persoonid,minuut,owngoal) values ((select last_insert_id()),"RANDALLAZOFEIFA","39",false);
		
	insert into persoonwedstrijd (persoonid,matchid) values ("YASSINEELGHANASSY",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("MBAYELEYE",(select last_insert_id()));
	
			insert into doelpunt (matchid,persoonid,minuut,owngoal) values ((select last_insert_id()),"MBAYELEYE","59",false);
		
			insert into doelpunt (matchid,persoonid,minuut,owngoal) values ((select last_insert_id()),"MBAYELEYE","79",false);
		
	insert into persoonwedstrijd (persoonid,matchid) values ("ZLATANLJUBIJANKIC",(select last_insert_id()));
	
			insert into doelpunt (matchid,persoonid,minuut,owngoal) values ((select last_insert_id()),"ZLATANLJUBIJANKIC","70",false);
		
	insert into persoonwedstrijd (persoonid,matchid) values ("STIJNDESMET",(select last_insert_id()));
	
			insert into doelpunt (matchid,persoonid,minuut,owngoal) values ((select last_insert_id()),"STIJNDESMET","75",false);
		
	insert into persoonwedstrijd (persoonid,matchid) values ("ADEKAMNIOLUFADE",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("MILOSMARIC",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("JURGENSIERENS",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("ANTHONYVANLOO",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("JEREMYHUYGHEBAERT",(select last_insert_id()));
	
		insert into kaart (matchid,persoonid,kleur,minuut) values ((select last_insert_id()),"JEREMYHUYGHEBAERT","geel","27");
	
	insert into persoonwedstrijd (persoonid,matchid) values ("DAMIRMIRVIC",(select last_insert_id()));
	
		insert into kaart (matchid,persoonid,kleur,minuut) values ((select last_insert_id()),"DAMIRMIRVIC","rood","40");
	
	insert into persoonwedstrijd (persoonid,matchid) values ("STEPANKUCERA",(select last_insert_id()));
	
		insert into kaart (matchid,persoonid,kleur,minuut) values ((select last_insert_id()),"STEPANKUCERA","rood","43");
	
	insert into persoonwedstrijd (persoonid,matchid) values ("STEFAANTANGHE",(select last_insert_id()));
	
		insert into kaart (matchid,persoonid,kleur,minuut) values ((select last_insert_id()),"STEFAANTANGHE","geel","40");
	
	insert into persoonwedstrijd (persoonid,matchid) values ("VINCENTPROVOOST",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("BJARNIVIDARSSON",(select last_insert_id()));
	
			insert into doelpunt (matchid,persoonid,minuut,owngoal) values ((select last_insert_id()),"BJARNIVIDARSSON","90",false);
		
	insert into persoonwedstrijd (persoonid,matchid) values ("JOERIDEQUEVY",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("SAMIRELGAAOUIRI",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("JOHNCOLLINS",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("SERGIOHELLINGS",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("STEFANNIKOLIC",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("JEROENVANTHOURNOUT",(select last_insert_id()));
	
insert into wissel (matchid,inid,uitid,minuut) values ((select last_insert_id()),"STIJNDESMET","ADNANCUSTOVIC","65");

insert into wissel (matchid,inid,uitid,minuut) values ((select last_insert_id()),"ADEKAMNIOLUFADE","YASSINEELGHANASSY","76");

insert into wissel (matchid,inid,uitid,minuut) values ((select last_insert_id()),"MILOSMARIC","RANDALLAZOFEIFA","81");

insert into wissel (matchid,inid,uitid,minuut) values ((select last_insert_id()),"SERGIOHELLINGS","JOHNCOLLINS","71");

insert into wissel (matchid,inid,uitid,minuut) values ((select last_insert_id()),"STEFANNIKOLIC","SAMIRELGAAOUIRI","71");

insert into wissel (matchid,inid,uitid,minuut) values ((select last_insert_id()),"JEROENVANTHOURNOUT","STEFAANTANGHE","76");

insert into wedstrijd (speeldag,thuisid,uitid,referee,dag,uur,aantaltoeschouwers) value ("6","ZWA","KOR","PAULALLAERTS","2009-09-12","20:00:00","6800");

	insert into persoonwedstrijd (persoonid,matchid) values ("SAMMYBOSSUT",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("STIJNMINNE",(select last_insert_id()));
	
		insert into kaart (matchid,persoonid,kleur,minuut) values ((select last_insert_id()),"STIJNMINNE","geel","80");
	
	insert into persoonwedstrijd (persoonid,matchid) values ("KARELDHAENE",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("BARTBUYSSE",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("JÉRÉMYTARAVEL",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("STIJNMEERT",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("KEVINROELANDTS",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("STEVECOLPAERT",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("FRANCKBERRIER",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("ERNESTNFOR",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("TEDDYCHEVALIER",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("BERATSADIK",(select last_insert_id()));
	
		insert into kaart (matchid,persoonid,kleur,minuut) values ((select last_insert_id()),"BERATSADIK","geel","90");
	
	insert into persoonwedstrijd (persoonid,matchid) values ("CHRISMAKIESE",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("LUDWINVANNIEUWENHUYZE",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("GLENNVERBAUWHEDE",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("JIMMYHEMPTE",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("DAVIDVANDENBROECK",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("LAURENTCIMAN",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("MLADENLAZAREVIC",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("DAVYDEBEULE",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("SVENKUMS",(select last_insert_id()));
	
		insert into kaart (matchid,persoonid,kleur,minuut) values ((select last_insert_id()),"SVENKUMS","geel","36");
	
	insert into persoonwedstrijd (persoonid,matchid) values ("KARIMBELHOCINE",(select last_insert_id()));
	
		insert into kaart (matchid,persoonid,kleur,minuut) values ((select last_insert_id()),"KARIMBELHOCINE","geel","90");
	
	insert into persoonwedstrijd (persoonid,matchid) values ("NEBOJSAPAVLOVIC",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("LEONBENKO",(select last_insert_id()));
	
			insert into doelpunt (matchid,persoonid,minuut,owngoal) values ((select last_insert_id()),"LEONBENKO","14",false);
		
	insert into persoonwedstrijd (persoonid,matchid) values ("EBRAHIMIBOU",(select last_insert_id()));
	
		insert into kaart (matchid,persoonid,kleur,minuut) values ((select last_insert_id()),"EBRAHIMIBOU","geel","32");
	
	insert into persoonwedstrijd (persoonid,matchid) values ("BRECHTCAPON",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("CHRISTIANBENTEKE",(select last_insert_id()));
	
			insert into doelpunt (matchid,persoonid,minuut,owngoal) values ((select last_insert_id()),"CHRISTIANBENTEKE","75",false);
		
	insert into persoonwedstrijd (persoonid,matchid) values ("ROBCLAEYS",(select last_insert_id()));
	
insert into wissel (matchid,inid,uitid,minuut) values ((select last_insert_id()),"BERATSADIK","STIJNMEERT","57");

insert into wissel (matchid,inid,uitid,minuut) values ((select last_insert_id()),"CHRISMAKIESE","TEDDYCHEVALIER","57");

insert into wissel (matchid,inid,uitid,minuut) values ((select last_insert_id()),"LUDWINVANNIEUWENHUYZE","STEVECOLPAERT","67");

insert into wissel (matchid,inid,uitid,minuut) values ((select last_insert_id()),"BRECHTCAPON","LEONBENKO","36");

insert into wissel (matchid,inid,uitid,minuut) values ((select last_insert_id()),"CHRISTIANBENTEKE","EBRAHIMIBOU","75");

insert into wissel (matchid,inid,uitid,minuut) values ((select last_insert_id()),"ROBCLAEYS","DAVYDEBEULE","91");

insert into wedstrijd (speeldag,thuisid,uitid,referee,dag,uur,aantaltoeschouwers) value ("6","STA","KVM","STEPHANEBREDA","2009-09-12","20:00:00","27500");

	insert into persoonwedstrijd (persoonid,matchid) values ("SINANBOLAT",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("MARCOSCAMOZZATO",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("ELIAQUIMMANGALA",(select last_insert_id()));
	
			insert into doelpunt (matchid,persoonid,minuut,owngoal) values ((select last_insert_id()),"ELIAQUIMMANGALA","68",false);
		
	insert into persoonwedstrijd (persoonid,matchid) values ("RICARDOROCHA",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("MOHAMEDSARR",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("STEVENDEFOUR",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("MEHDICARCELA-GONZALEZ",(select last_insert_id()));
	
			insert into doelpunt (matchid,persoonid,minuut,owngoal) values ((select last_insert_id()),"MEHDICARCELA-GONZALEZ","56",false);
		
			insert into doelpunt (matchid,persoonid,minuut,owngoal) values ((select last_insert_id()),"MEHDICARCELA-GONZALEZ","59",false);
		
	insert into persoonwedstrijd (persoonid,matchid) values ("IGORDECAMARGO",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("DIEUMERCIMBOKANI",(select last_insert_id()));
	
		insert into kaart (matchid,persoonid,kleur,minuut) values ((select last_insert_id()),"DIEUMERCIMBOKANI","geel","62");
	
	insert into persoonwedstrijd (persoonid,matchid) values ("WILFRIEDDALMAT",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("MILANJOVANOVIC",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("BENJAMINNICAISE",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("GREGORYDUFER",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("GOHIBICYRIAC",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("WOUTERBIEBAUW",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("KENNYVANHOEVELEN",(select last_insert_id()));
	
		insert into kaart (matchid,persoonid,kleur,minuut) values ((select last_insert_id()),"KENNYVANHOEVELEN","geel","67");
	
	insert into persoonwedstrijd (persoonid,matchid) values ("XAVIERCHEN",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("JONASIVENS",(select last_insert_id()));
	
		insert into kaart (matchid,persoonid,kleur,minuut) values ((select last_insert_id()),"JONASIVENS","geel","41");
	
	insert into persoonwedstrijd (persoonid,matchid) values ("ANTONIOGHOMSI",(select last_insert_id()));
	
		insert into kaart (matchid,persoonid,kleur,minuut) values ((select last_insert_id()),"ANTONIOGHOMSI","geel","52");
	
	insert into persoonwedstrijd (persoonid,matchid) values ("DAVIDDESTORME",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("KOENPERSOONS",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("YONIBUYENS",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("JOACHIMMUNUNGA",(select last_insert_id()));
	
		insert into kaart (matchid,persoonid,kleur,minuut) values ((select last_insert_id()),"JOACHIMMUNUNGA","geel","54");
	
	insert into persoonwedstrijd (persoonid,matchid) values ("ALOISNONG",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("JULIENGORIUS",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("BOUBACARDIALIBADIABANG",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("GIUSEPPEROSSINI",(select last_insert_id()));
	
insert into wissel (matchid,inid,uitid,minuut) values ((select last_insert_id()),"BENJAMINNICAISE","STEVENDEFOUR","10");

insert into wissel (matchid,inid,uitid,minuut) values ((select last_insert_id()),"GREGORYDUFER","WILFRIEDDALMAT","39");

insert into wissel (matchid,inid,uitid,minuut) values ((select last_insert_id()),"GOHIBICYRIAC","IGORDECAMARGO","73");

insert into wissel (matchid,inid,uitid,minuut) values ((select last_insert_id()),"BOUBACARDIALIBADIABANG","JOACHIMMUNUNGA","59");

insert into wissel (matchid,inid,uitid,minuut) values ((select last_insert_id()),"GIUSEPPEROSSINI","DAVIDDESTORME","73");

insert into wedstrijd (speeldag,thuisid,uitid,referee,dag,uur,aantaltoeschouwers) value ("6","MOE","WES","GERDBYLOIS","2009-09-12","20:00:00","3500");

	insert into persoonwedstrijd (persoonid,matchid) values ("JANSLOVENCIAK",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("GONZAGUEVANDOOREN",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("CHEMCEDINEELARAICHI",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("DAANVANGYSEGHEM",(select last_insert_id()));
	
		insert into kaart (matchid,persoonid,kleur,minuut) values ((select last_insert_id()),"DAANVANGYSEGHEM","geel","27");
	
	insert into persoonwedstrijd (persoonid,matchid) values ("CARLOSDAVIDMORENOHERNANDEZ",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("MAXIMELESTIENNE",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("MATHIEUASSOU-EKOTTO",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("MAMADOUDIAKITE",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("ASANDASISHUBA",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("ROBERTMAAH",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("OKWUNWANNEJAYCEE",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("GUILLAUMEFRANÇOIS",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("JONATHANJUNCAL",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("IDIROUALI",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("YVESDEWINTER",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("ADNANMRAVAC",(select last_insert_id()));
	
			insert into doelpunt (matchid,persoonid,minuut,owngoal) values ((select last_insert_id()),"ADNANMRAVAC","65",false);
		
	insert into persoonwedstrijd (persoonid,matchid) values ("NICOVANKERCKHOVEN",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("JEFDELEN",(select last_insert_id()));
	
		insert into kaart (matchid,persoonid,kleur,minuut) values ((select last_insert_id()),"JEFDELEN","geel","40");
	
	insert into persoonwedstrijd (persoonid,matchid) values ("JORISVANHOUT",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("MOSESADAMS",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("RACHIDFARSSI",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("STEVENDEPETTER",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("MICHAELMODUBI",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("OLEKSANDRJAKOVENKO",(select last_insert_id()));
	
		insert into kaart (matchid,persoonid,kleur,minuut) values ((select last_insert_id()),"OLEKSANDRJAKOVENKO","geel","80");
	
	insert into persoonwedstrijd (persoonid,matchid) values ("JAIMERUIZ",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("LENSANNAB",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("GLENNVANASTEN",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("BERTINTOMOU",(select last_insert_id()));
	
insert into wissel (matchid,inid,uitid,minuut) values ((select last_insert_id()),"GUILLAUMEFRANÇOIS","MAXIMELESTIENNE","45");

insert into wissel (matchid,inid,uitid,minuut) values ((select last_insert_id()),"JONATHANJUNCAL","OKWUNWANNEJAYCEE","45");

insert into wissel (matchid,inid,uitid,minuut) values ((select last_insert_id()),"IDIROUALI","MAMADOUDIAKITE","73");

insert into wissel (matchid,inid,uitid,minuut) values ((select last_insert_id()),"LENSANNAB","OLEKSANDRJAKOVENKO","85");

insert into wissel (matchid,inid,uitid,minuut) values ((select last_insert_id()),"GLENNVANASTEN","RACHIDFARSSI","90");

insert into wissel (matchid,inid,uitid,minuut) values ((select last_insert_id()),"BERTINTOMOU","JAIMERUIZ","93");

insert into wedstrijd (speeldag,thuisid,uitid,referee,dag,uur,aantaltoeschouwers) value ("6","GBA","LOK","LUCWOUTERS","2009-09-13","18:00:00","8600");

	insert into persoonwedstrijd (persoonid,matchid) values ("TOMISLAVPACOVSKI",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("PHILIPPECLEMENT",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("KURTVANDOOREN",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("PIETERJANMONTEYNE",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("MARTIJNMONTEYNE",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("BARTGOOR",(select last_insert_id()));
	
		insert into kaart (matchid,persoonid,kleur,minuut) values ((select last_insert_id()),"BARTGOOR","geel","9");
	
	insert into persoonwedstrijd (persoonid,matchid) values ("WIMDEDECKER",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("FARISHAROUN",(select last_insert_id()));
	
			insert into doelpunt (matchid,persoonid,minuut,owngoal) values ((select last_insert_id()),"FARISHAROUN","54",false);
		
	insert into persoonwedstrijd (persoonid,matchid) values ("IVANLEKO",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("BAVONTSHIBUABUA",(select last_insert_id()));
	
			insert into doelpunt (matchid,persoonid,minuut,owngoal) values ((select last_insert_id()),"BAVONTSHIBUABUA","15",false);
		
	insert into persoonwedstrijd (persoonid,matchid) values ("SHERJILLMACDONALD",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("DANIELCRUZ",(select last_insert_id()));
	
		insert into kaart (matchid,persoonid,kleur,minuut) values ((select last_insert_id()),"DANIELCRUZ","geel","89");
	
	insert into persoonwedstrijd (persoonid,matchid) values ("TOSINDOSUMNU",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("BOUBACARCOPA",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("OLIVIERDOLL",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("FRÉDÉRICDUPRÉ",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("HASSANELMOUATAZ",(select last_insert_id()));
	
		insert into kaart (matchid,persoonid,kleur,minuut) values ((select last_insert_id()),"HASSANELMOUATAZ","rood","89");
	
	insert into persoonwedstrijd (persoonid,matchid) values ("IBRAHIMAGUEYE",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("SULEJMANSMAJIC",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("MARCELMBAYO",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("TSHINYAMATIKO",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("MARIOCAREVIC",(select last_insert_id()));
	
		insert into kaart (matchid,persoonid,kleur,minuut) values ((select last_insert_id()),"MARIOCAREVIC","geel","80");
	
	insert into persoonwedstrijd (persoonid,matchid) values ("TOMISLAVSOKOTA",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("DAWIDJANCZYK",(select last_insert_id()));
	
			insert into doelpunt (matchid,persoonid,minuut,owngoal) values ((select last_insert_id()),"DAWIDJANCZYK","22",false);
		
		insert into kaart (matchid,persoonid,kleur,minuut) values ((select last_insert_id()),"DAWIDJANCZYK","geel","66");
	
	insert into persoonwedstrijd (persoonid,matchid) values ("SANHARIBMALKI",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("KILLIANOVERMEIRE",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("DONOVANDEEKMAN",(select last_insert_id()));
	
insert into wissel (matchid,inid,uitid,minuut) values ((select last_insert_id()),"DANIELCRUZ","SHERJILLMACDONALD","76");

insert into wissel (matchid,inid,uitid,minuut) values ((select last_insert_id()),"TOSINDOSUMNU","BAVONTSHIBUABUA","78");

insert into wissel (matchid,inid,uitid,minuut) values ((select last_insert_id()),"SANHARIBMALKI","TOMISLAVSOKOTA","30");

insert into wissel (matchid,inid,uitid,minuut) values ((select last_insert_id()),"KILLIANOVERMEIRE","TSHINYAMATIKO","56");

insert into wissel (matchid,inid,uitid,minuut) values ((select last_insert_id()),"DONOVANDEEKMAN","SULEJMANSMAJIC","82");

insert into wedstrijd (speeldag,thuisid,uitid,referee,dag,uur,aantaltoeschouwers) value ("6","CLU","GNK","PIETERVINK","2009-09-13","20:30:00","23500");

	insert into persoonwedstrijd (persoonid,matchid) values ("GEERTDEVLIEGER",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("KOENDAERDEN",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("JEROENSIMAEYS",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("JORNVERMEULEN",(select last_insert_id()));
	
		insert into kaart (matchid,persoonid,kleur,minuut) values ((select last_insert_id()),"JORNVERMEULEN","rood","87");
	
	insert into persoonwedstrijd (persoonid,matchid) values ("MICHAELKLUKOWSKI",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("KARELGERAERTS",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("JONATHANBLONDEL",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("VADISODJIDJAOFOE",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("IVANPERISIC",(select last_insert_id()));
	
			insert into doelpunt (matchid,persoonid,minuut,owngoal) values ((select last_insert_id()),"IVANPERISIC","46",false);
		
	insert into persoonwedstrijd (persoonid,matchid) values ("WESLEYSONCK",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("JOSEPHAKPALA",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("RONALDVARGAS",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("DORGEKOUEMAHA",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("GERTJANDEMETS",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("DAVINOVERHULST",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("DIMITRIDAESELEIRE",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("ERICMATOUKOU",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("TORBENJONELEIT",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("ANELENGCONGCA",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("THOMASBUFFEL",(select last_insert_id()));
	
			insert into doelpunt (matchid,persoonid,minuut,owngoal) values ((select last_insert_id()),"THOMASBUFFEL","20",false);
		
		insert into kaart (matchid,persoonid,kleur,minuut) values ((select last_insert_id()),"THOMASBUFFEL","geel","72");
	
	insert into persoonwedstrijd (persoonid,matchid) values ("DAVIDHUBERT",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("DANIELPUDIL",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("DANIELTOZSER",(select last_insert_id()));
	
		insert into kaart (matchid,persoonid,kleur,minuut) values ((select last_insert_id()),"DANIELTOZSER","geel","9");
	
	insert into persoonwedstrijd (persoonid,matchid) values ("MARVINOGUNJIMI",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("ELYANIVBARDA",(select last_insert_id()));
	
		insert into kaart (matchid,persoonid,kleur,minuut) values ((select last_insert_id()),"ELYANIVBARDA","geel","32");
	
	insert into persoonwedstrijd (persoonid,matchid) values ("MOUSSAKOITA",(select last_insert_id()));
	
	insert into persoonwedstrijd (persoonid,matchid) values ("FABIENCAMUS",(select last_insert_id()));
	
insert into wissel (matchid,inid,uitid,minuut) values ((select last_insert_id()),"RONALDVARGAS","JONATHANBLONDEL","74");

insert into wissel (matchid,inid,uitid,minuut) values ((select last_insert_id()),"DORGEKOUEMAHA","WESLEYSONCK","84");

insert into wissel (matchid,inid,uitid,minuut) values ((select last_insert_id()),"GERTJANDEMETS","RONALDVARGAS","89");

insert into wissel (matchid,inid,uitid,minuut) values ((select last_insert_id()),"MOUSSAKOITA","ELYANIVBARDA","81");

insert into wissel (matchid,inid,uitid,minuut) values ((select last_insert_id()),"FABIENCAMUS","THOMASBUFFEL","89");
