Wimbledon 1986 Ladies' Singles (June 23 - July 5)

	Nation		R128	R64	R32	R16	QF	SF	F	Champion
1.		[1]	Martina Navratilova
				Martina Navratilova
2.			Amanda Tobin	6-3 6-2
					Martina Navratilova
3.		[LL]	Jane Forman		6-0 6-4
				Jane Forman
4.			Eva Pfaff	7-5 6-4
						Martina Navratilova
5.			Kristin Kinney			6-0 6-2
				Kristin Kinney
6.		[WC]	Sally Reeves	3-6 6-4 6-2
					Kristin Kinney
7.			Sara Gomer		2-6 7-6 6-3
				Sara Gomer
8.			Anne White	4-6 7-5 6-4
							Martina Navratilova
9.			Susan Sloane Lundy				6-3 6-3
				Susan Sloane Lundy
10.			Michelle Torres	6-3 6-4
					Terry Phelps
11.			Terry Phelps		6-4 6-2
				Terry Phelps
12.		[WC]	Amanda Grunfeld	6-2 6-0
						Isabelle Demongeot
13.			Isabelle Demongeot			6-3 6-2
				Isabelle Demongeot
14.			Janine Thompson	6-1 6-2
					Isabelle Demongeot
15.			Jenny Byrne		6-4 6-1
				Jenny Byrne
16.		[14]	Wendy Turnbull	7-6 6-2
								Martina Navratilova
17.			Larisa Savchenko					6-1 6-3
				Larisa Savchenko
18.		[12]	Stephanie Rehe	1-6 6-4 8-6
					Bettina Bunge
19.			Bettina Bunge		6-7 6-0 7-5
				Bettina Bunge
20.			Gigi Fernandez	4-6 6-4 6-1
						Bettina Bunge
21.			Patty Fendick			6-2 6-3
				Patty Fendick
22.			Beth Herr	6-3 6-1
					Patty Fendick
23.			Mary Lou Piatek		6-0 6-3
				Mary Lou Piatek
24.		[LL]	Penny Barg	6-0 6-1
							Bettina Bunge
25.			Liz Sayers				3-6 6-2 6-3
				Liz Sayers
26.		[Q]	Dianne Van Rensburg	6-3 6-2
					Liz Sayers
27.			Wendy White		6-1 1-6 12-10
				Wendy White
28.			Elna Reinach	6-4 6-1
						Manuela Maleeva
29.			Susan Mascarin			7-6 6-1
				Susan Mascarin
30.		[Q]	Jana Novotna	3-6 7-6 6-2
					Manuela Maleeva
31.		[8]	Manuela Maleeva		6-4 7-6
				Manuela Maleeva
32.			Kate Gompert	6-2 1-0 rtd.
									Martina Navratilova
33.		[4]	Claudia Kohde-Kilsch						6-2 6-2
				Claudia Kohde-Kilsch
34.			Etsuko Inoue	0-6 6-1 6-2
					Claudia Kohde-Kilsch
35.			Alycia Moulton		6-2 6-2
				Alycia Moulton
36.			Katerina Bohmova	7-6 6-4
						Raffaella Reggi
37.			Hu Na			6-4 6-1
				Hu Na
38.		[WC]	Joanne Louis	6-0 6-2
					Raffaella Reggi
39.			Raffaella Reggi		6-2 6-4
				Raffaella Reggi
40.			Carina Karlsson	5-7 6-0 6-1
							Gabriela Sabatini
41.		[Q]	Anna-Maria Fernandez				6-4 1-6 6-3
				Anna-Maria Fernandez
42.			Sandra Cecchini	6-1 6-2
					Barbara Gerken
43.			Barbara Gerken		5-7 7-6 6-4
				Barbara Gerken
44.			Debbie Spence	6-3 6-2
						Gabriela Sabatini
45.			Catherine Suire			6-2 6-1
				Catherine Suire
46.			Patricia Medrado	6-4 3-6 6-4
					Gabriela Sabatini
47.		[10]	Gabriela Sabatini		6-3 6-3
				Gabriela Sabatini
48.			Christiane Jolissaint	6-2 1-6 6-4
								Gabriela Sabatini
49.		[15]	Catarina Lindqvist					6-2 6-3
				Catarina Lindqvist
50.		[Q]	Gretchen Anne Rush	3-6 7-5 6-3
					Catarina Lindqvist
51.			Helen Kelesi		6-3 3-6 6-1
				Helen Kelesi
52.			Anne Smith	4-6 6-3 6-3
						Catarina Lindqvist
53.			Jennifer Mundel			3-6 7-6 6-3
				Jennifer Mundel
54.			Molly Van Nostrand	6-3 6-2
					Elizabeth Minter
55.			Elizabeth Minter		6-4 6-1
				Elizabeth Minter
56.		[Q]	Diane Farrell	6-1 3-6 6-1
							Catarina Lindqvist
57.			Dianne Fromholtz				7-5 7-6
				Dianne Fromholtz
58.			Yvonne Vermaak	6-4 6-3
					Dianne Fromholtz
59.			Candy Reynolds		6-2 6-3
				Candy Reynolds
60.			Niurka Sodupe	6-3 6-4
						Dianne Fromholtz
61.			Jo Durie			5-7 6-3 6-2
				Jo Durie
62.			Regina Marsikova	6-3 1-6 8-6
					Jo Durie
63.			Nathalie Herreman		6-3 7-5
				Nathalie Herreman
64.		[6]	Kathy Rinaldi	7-6 6-4
										Martina Navratilova
65.			Betsy Nagelsen							7-6 6-3
				Betsy Nagelsen
66.		[5]	Pam Shriver	4-6 6-3 6-4
					Betsy Nagelsen
67.			Lisa Spain		6-1 7-6
				Lisa Spain
68.			Sylvia Hanika	3-6 6-2 6-4
						Betsy Nagelsen
69.			Katerina Maleeva			6-4 6-1
				Katerina Maleeva
70.			Mercedes Paz	6-3 6-2
					Katerina Maleeva
71.			Nathalie Tauziat		6-4 6-2
				Nathalie Tauziat
72.			Vicki Nelson	6-1 6-2
							Lori McNeil
73.			Lori McNeil				7-5 6-1
				Lori McNeil
74.		[LL]	Rebecca Bryant	6-4 6-3
					Lori McNeil
75.			Marcella Mesker		4-5 rtd.
				Marcella Mesker
76.			Laura Arraya	6-3 6-1
						Lori McNeil
77.			Elise Burgin			6-3 6-2
				Elise Burgin
78.			Svetlana Cherneva	6-0 6-2
					Elise Burgin
79.		[LL]	Ronnie Reis		6-1 7-5
				Ronnie Reis
80.			Amanda Brown	6-1 3-6 7-5
								Hana Mandlikova
81.		[11]	Carling Bassett					6-7 6-0 6-2
				Carling Bassett
82.		[WC]	Glynis Coles	1-6 7-5 6-1
					Carling Bassett
83.			Rosalyn Fairbank		6-1 7-6
				Rosalyn Fairbank
84.			Mareen Louie	6-4 6-2
						Carling Bassett
85.			Neige Dias			6-4 6-2
				Neige Dias
86.			Annabel Croft	1-6 6-2 6-4
					Maria-Christine Calleja
87.			Maria-Christine Calleja		6-2 6-4
				Maria-Christine Calleja
88.			Laura Garrone	6-4 3-6 6-0
							Hana Mandlikova
89.			Camille Benjamin				6-4 7-6
				Camille Benjamin
90.			Pascale Paradis	1-6 6-3 6-2
					Iva Budarova
91.			Iva Budarova		7-6 7-6
				Iva Budarova
92.			Sabrina Goles	6-1 6-2
						Hana Mandlikova
93.			Catherine Tanvier			6-2 6-0
				Catherine Tanvier
94.			Caroline Kuhlman	2-6 6-4 8-6
					Hana Mandlikova
95.		[3]	Hana Mandlikova		7-5 6-2
				Hana Mandlikova
96.		[WC]	Joy Tacon	6-1 6-1
									Hana Mandlikova
97.		[7]	Helena Sukova						7-6 7-5
				Helena Sukova
98.		[WC]	Denise Parnell	6-1 6-1
					Helena Sukova
99.			Andrea Betzner		6-2 6-1
				Andrea Betzner
100.		[WC]	Julie Salmon	6-0 7-6
						Helena Sukova
101.			Anne Minter			6-1 6-4
				Anne Minter
102.			Angeliki Kanellopoulous	6-2 6-0
					Anne Minter
103.			Lisa Bonder		3-6 6-2 6-2
				Lisa Bonder
104.			Mima Jausovec	6-3 4-6 6-4
							Helena Sukova
105.			Andrea Holikova				6-3 6-0
				Andrea Holikova
106.			Grace Kim	6-3 6-2
					Robin White
107.			Robin White		6-1 6-3
				Robin White
108.			Kim Sands	6-3 6-4
						Robin White
109.			Anne Hobbs			6-4 6-2
				Anne Hobbs
110.		[WC]	Belinda Borneo	6-0 2-6 6-4
					Anne Hobbs
111.		[9]	Zina Garrison		6-4 0-6 6-4
				Zina Garrison
112.			Beverly Bowes	6-1 6-4
								Chris Evert
113.		[16]	Kathy Jordan					7-6 4-6 6-4
				Kathy Jordan
114.			Tina Mochizuki	6-1 6-3
					Kathy Jordan
115.			Ann Henricksson		6-1 6-1
				Ann Henricksson
116.		[Q]	Julie Richardson	7-6 6-1
						Kathy Jordan
117.			Melissa Gurney			6-4 6-1
				Melissa Gurney
118.			Belinda Cordwell	6-0 6-7 6-0
					Melissa Gurney
119.			Tine Scheuer-Larsen		6-4 6-2
				Tine Scheuer-Larsen
120.			Lea Antonoplis	6-2 6-4
							Chris Evert
121.			Kathy Horvath				7-5 6-2
				Kathy Horvath
122.		[Q]	Kim Steinmetz	6-1 7-5
					Kathy Horvath
123.			Adriana Villagran		6-4 6-4
				Adriana Villagran
124.		[Q]	Kay McDaniel	6-4 2-6 6-4
						Chris Evert
125.			Pam Casale			6-4 6-1
				Pam Casale
126.			Petra Huber	6-0 6-0
					Chris Evert
127.		[2]	Chris Evert		6-0 5-7 6-1
				Chris Evert
128.			Mary Joe Fernandez	6-4 6-1

(default) 17 queries took 24 ms
Nr	Query	Affected	Num. rows	Took (ms)
1	SELECT `Tournament`.`id`, `Tournament`.`name`, `Tournament`.`slug`, `Tournament`.`subtitle`, `Tournament`.`description`, `Tournament`.`surface`, `Tournament`.`venue`, `Tournament`.`eras`, `Tournament`.`history`, `Tournament`.`president`, `Tournament`.`PrizeMoney`, `Tournament`.`grandslam`, `Tournament`.`created`, `Tournament`.`modified` FROM `zavoihu1_db4tennis`.`tournaments` AS `Tournament` WHERE `Tournament`.`slug` = 'wimbledon' LIMIT 1	1	1	1
2	SELECT `Category`.`id`, `Category`.`name`, `Category`.`slug`, `Category`.`tournament_id`, `Category`.`gender`, `Category`.`type`, `Category`.`surface`, `Category`.`venue`, `Category`.`president`, `Category`.`name_of_the_tournament`, `Category`.`created`, `Category`.`modified`, `Category`.`created_by`, `Category`.`modified_by` FROM `zavoihu1_db4tennis`.`categories` AS `Category` WHERE `Category`.`tournament_id` = (3)	5	5	1
3	SELECT `Quote`.`id`, `Quote`.`tournament_id`, `Quote`.`quote`, `Quote`.`by`, `Quote`.`source`, `Quote`.`created`, `Quote`.`created_by`, `Quote`.`modified`, `Quote`.`modified_by` FROM `zavoihu1_db4tennis`.`quotes` AS `Quote` WHERE `Quote`.`tournament_id` = (3)	4	4	1
4	SELECT `Tournamenttotal`.`id`, `Tournamenttotal`.`tournament_id`, `Tournamenttotal`.`year`, `Tournamenttotal`.`price_money`, `Tournamenttotal`.`attendance`, `Tournamenttotal`.`created`, `Tournamenttotal`.`created_by`, `Tournamenttotal`.`modified`, `Tournamenttotal`.`modified_by` FROM `zavoihu1_db4tennis`.`tournamenttotals` AS `Tournamenttotal` WHERE `Tournamenttotal`.`tournament_id` = (3)	57	57	1
5	SELECT `Category`.`id`, `Category`.`name`, `Category`.`slug`, `Category`.`tournament_id`, `Category`.`gender`, `Category`.`type`, `Category`.`surface`, `Category`.`venue`, `Category`.`president`, `Category`.`name_of_the_tournament`, `Category`.`created`, `Category`.`modified`, `Category`.`created_by`, `Category`.`modified_by`, `Tournament`.`id`, `Tournament`.`name`, `Tournament`.`slug`, `Tournament`.`subtitle`, `Tournament`.`description`, `Tournament`.`surface`, `Tournament`.`venue`, `Tournament`.`eras`, `Tournament`.`history`, `Tournament`.`president`, `Tournament`.`PrizeMoney`, `Tournament`.`grandslam`, `Tournament`.`created`, `Tournament`.`modified` FROM `zavoihu1_db4tennis`.`categories` AS `Category` LEFT JOIN `zavoihu1_db4tennis`.`tournaments` AS `Tournament` ON (`Category`.`tournament_id` = `Tournament`.`id`) WHERE `Tournament`.`slug` = 'wimbledon' AND `Category`.`slug` = 'women-singles' LIMIT 1	1	1	1
6	SELECT `Contest`.`id`, `Contest`.`category_id`, `Contest`.`year`, `Contest`.`slug`, `Contest`.`ch`, `Contest`.`date_from`, `Contest`.`date_to`, `Contest`.`book`, `Contest`.`name_of_the_tournament`, `Contest`.`location`, `Contest`.`venue`, `Contest`.`surface`, `Contest`.`participants`, `Contest`.`prize_money`, `Contest`.`attendance`, `Contest`.`misc`, `Contest`.`final_misc`, `Contest`.`created`, `Contest`.`created_by`, `Contest`.`modified`, `Contest`.`modified_by` FROM `zavoihu1_db4tennis`.`contests` AS `Contest` WHERE `Contest`.`category_id` = (19) ORDER BY `Contest`.`year` ASC	130	130	3
7	SELECT `Contest`.`id`, `Contest`.`category_id`, `Contest`.`year`, `Contest`.`slug`, `Contest`.`ch`, `Contest`.`date_from`, `Contest`.`date_to`, `Contest`.`book`, `Contest`.`name_of_the_tournament`, `Contest`.`location`, `Contest`.`venue`, `Contest`.`surface`, `Contest`.`participants`, `Contest`.`prize_money`, `Contest`.`attendance`, `Contest`.`misc`, `Contest`.`final_misc`, `Contest`.`created`, `Contest`.`created_by`, `Contest`.`modified`, `Contest`.`modified_by`, `Category`.`id`, `Category`.`name`, `Category`.`slug`, `Category`.`tournament_id`, `Category`.`gender`, `Category`.`type`, `Category`.`surface`, `Category`.`venue`, `Category`.`president`, `Category`.`name_of_the_tournament`, `Category`.`created`, `Category`.`modified`, `Category`.`created_by`, `Category`.`modified_by` FROM `zavoihu1_db4tennis`.`contests` AS `Contest` LEFT JOIN `zavoihu1_db4tennis`.`categories` AS `Category` ON (`Contest`.`category_id` = `Category`.`id`) WHERE `Category`.`tournament_id` = 3 AND `Contest`.`category_id` = 19 AND `Contest`.`slug` = '1986' LIMIT 1	1	1	2
8	SELECT `Match`.`id`, `Match`.`contest_id`, `Match`.`player_a_id`, `Match`.`player_aa_id`, `Match`.`player_b_id`, `Match`.`player_bb_id`, `Match`.`results`, `Match`.`long`, `Match`.`attendance`, `Match`.`no`, `Match`.`round`, `Match`.`round_id`, `Match`.`note`, `Match`.`created`, `Match`.`created_by`, `Match`.`modified`, `Match`.`modified_by` FROM `zavoihu1_db4tennis`.`matches` AS `Match` WHERE `Match`.`contest_id` = (1797) ORDER BY `Match`.`round_id` ASC, `Match`.`no` ASC	127	127	2
9	SELECT `Player`.`id`, `Player`.`name`, `Player`.`gender`, `Player`.`slug` FROM `zavoihu1_db4tennis`.`players` AS `Player` WHERE `Player`.`id` IN (9582, 9617, 12472, 9828, 11351, 12469, 9743, 9686, 10008, 11307, 9795, 12473, 9938, 9766, 9739, 9507, 9750, 9996, 9671, 9719, 9857, 9728, 9690, 9858, 9661, 9793, 9703, 9780, 9705, 9848, 9702, 11353, 9654, 9724, 9708, 9676, 9767, 12467, 9722, 9736, 9720, 10091, 9735, 11339, 9716, 11268, 9883, 9657, 9753, 9802, 9771, 9678, 9700, 9765, 9729, 12474, 9513, 9711, 9668, 11349, 9692, 9613, 9888, 9717, 9636, 9656, 9760, 9665, 9756, 9962, 10017, 9713, 9727, 9758, 9640, 9948, 9744, 9745, 9902, 9718, 9723, 9533, 9658, 11270, 11341, 9737, 9669, 11337, 9709, 9721, 9699, 11313, 9695, 10019, 9648, 12471, 9677, 12475, 11343, 9803, 9646, 11334, 9764, 9670, 9757, 11331, 13428, 9635, 9682, 12476, 9706, 9773, 9689, 9789, 9763, 9807, 11335, 9761, 9752, 9693, 9897, 9696, 9747, 11276, 9842, 11336, 9672, 9909) ORDER BY `Player`.`lastname` ASC, `Player`.`firstname` ASC	128	128	3
10	SELECT `Playercontest`.`id`, `Playercontest`.`player_id`, `Playercontest`.`contest_id`, `Playercontest`.`nat_id`, `Playercontest`.`draw` FROM `zavoihu1_db4tennis`.`playercontests` AS `Playercontest` WHERE `Playercontest`.`contest_id` = 1797	130	130	1
11	SELECT `Countrycode`.`id`, `Countrycode`.`code` FROM `zavoihu1_db4tennis`.`countrycodes` AS `Countrycode` WHERE `Countrycode`.`id` IN (197, 36, 212, 217, 196, 13, 68, 92, 218, 135, 29, 172, 147, 219, 14, 94, 179, 74, 178, 31, 133, 10, 54, NULL)	23	23	1
12	SELECT `Countrycode`.`id`, `Countrycode`.`name` FROM `zavoihu1_db4tennis`.`countrycodes` AS `Countrycode` WHERE `Countrycode`.`id` IN (197, 36, 212, 217, 196, 13, 68, 92, 218, 135, 29, 172, 147, 219, 14, 94, 179, 74, 178, 31, 133, 10, 54, NULL)	23	23	1
13	SELECT `Playercontest`.`player_id`, `Playercontest`.`nat_id` FROM `zavoihu1_db4tennis`.`playercontests` AS `Playercontest` WHERE ((`Playercontest`.`player_id` IN (9582, 9617, 12472, 9828, 11351, 12469, 9743, 9686, 10008, 11307, 9795, 12473, 9938, 9766, 9739, 9507, 9750, 9996, 9671, 9719, 9857, 9728, 9690, 9858, 9661, 9793, 9703, 9780, 9705, 9848, 9702, 11353, 9654, 9724, 9708, 9676, 9767, 12467, 9722, 9736, 9720, 10091, 9735, 11339, 9716, 11268, 9883, 9657, 9753, 9802, 9771, 9678, 9700, 9765, 9729, 12474, 9513, 9711, 9668, 11349, 9692, 9613, 9888, 9717, 9636, 9656, 9760, 9665, 9756, 9962, 10017, 9713, 9727, 9758, 9640, 9948, 9744, 9745, 9902, 9718, 9723, 9533, 9658, 11270, 11341, 9737, 9669, 11337, 9709, 9721, 9699, 11313, 9695, 10019, 9648, 12471, 9677, 12475, 11343, 9803, 9646, 11334, 9764, 9670, 9757, 11331, 13428, 9635, 9682, 12476, 9706, 9773, 9689, 9789, 9763, 9807, 11335, 9761, 9752, 9693, 9897, 9696, 9747, 11276, 9842, 11336, 9672, 9909)) AND (`Playercontest`.`contest_id` = 1797))	128	128	2
14	SELECT `Contest`.`slug`, `Contest`.`year` FROM `zavoihu1_db4tennis`.`contests` AS `Contest` WHERE `Contest`.`category_id` = 19 ORDER BY `Contest`.`date_from` ASC	130	130	1
15	SELECT `Contest`.`id`, `Contest`.`category_id` FROM `zavoihu1_db4tennis`.`contests` AS `Contest` WHERE `Contest`.`year` = 1986	15	15	1
16	SELECT `Category`.`id`, `Category`.`tournament_id` FROM `zavoihu1_db4tennis`.`categories` AS `Category` WHERE `Category`.`id` IN (12, 17, 22, 18, 13, 23, 14, 24, 25, 26, 19, 15, 16, 20, 21) AND `Category`.`gender` = 'Women' AND `Category`.`type` = 'Singles'	3	3	1
17	SELECT `Tournament`.`slug`, `Tournament`.`name` FROM `zavoihu1_db4tennis`.`tournaments` AS `Tournament` WHERE `Tournament`.`id` IN (2, 3, 4)	3	3	1

(default) 17 queries took 24 ms

Query

Error

Affected

Num. rows

Took (ms)

SELECT `Tournament`.`id`, `Tournament`.`name`, `Tournament`.`slug`, `Tournament`.`subtitle`, `Tournament`.`description`, `Tournament`.`surface`, `Tournament`.`venue`, `Tournament`.`eras`, `Tournament`.`history`, `Tournament`.`president`, `Tournament`.`PrizeMoney`, `Tournament`.`grandslam`, `Tournament`.`created`, `Tournament`.`modified` FROM `zavoihu1_db4tennis`.`tournaments` AS `Tournament` WHERE `Tournament`.`slug` = 'wimbledon' LIMIT 1

SELECT `Quote`.`id`, `Quote`.`tournament_id`, `Quote`.`quote`, `Quote`.`by`, `Quote`.`source`, `Quote`.`created`, `Quote`.`created_by`, `Quote`.`modified`, `Quote`.`modified_by` FROM `zavoihu1_db4tennis`.`quotes` AS `Quote` WHERE `Quote`.`tournament_id` = (3)

SELECT `Tournamenttotal`.`id`, `Tournamenttotal`.`tournament_id`, `Tournamenttotal`.`year`, `Tournamenttotal`.`price_money`, `Tournamenttotal`.`attendance`, `Tournamenttotal`.`created`, `Tournamenttotal`.`created_by`, `Tournamenttotal`.`modified`, `Tournamenttotal`.`modified_by` FROM `zavoihu1_db4tennis`.`tournamenttotals` AS `Tournamenttotal` WHERE `Tournamenttotal`.`tournament_id` = (3)

SELECT `Category`.`id`, `Category`.`name`, `Category`.`slug`, `Category`.`tournament_id`, `Category`.`gender`, `Category`.`type`, `Category`.`surface`, `Category`.`venue`, `Category`.`president`, `Category`.`name_of_the_tournament`, `Category`.`created`, `Category`.`modified`, `Category`.`created_by`, `Category`.`modified_by`, `Tournament`.`id`, `Tournament`.`name`, `Tournament`.`slug`, `Tournament`.`subtitle`, `Tournament`.`description`, `Tournament`.`surface`, `Tournament`.`venue`, `Tournament`.`eras`, `Tournament`.`history`, `Tournament`.`president`, `Tournament`.`PrizeMoney`, `Tournament`.`grandslam`, `Tournament`.`created`, `Tournament`.`modified` FROM `zavoihu1_db4tennis`.`categories` AS `Category` LEFT JOIN `zavoihu1_db4tennis`.`tournaments` AS `Tournament` ON (`Category`.`tournament_id` = `Tournament`.`id`) WHERE `Tournament`.`slug` = 'wimbledon' AND `Category`.`slug` = 'women-singles' LIMIT 1

130

SELECT `Contest`.`id`, `Contest`.`category_id`, `Contest`.`year`, `Contest`.`slug`, `Contest`.`ch`, `Contest`.`date_from`, `Contest`.`date_to`, `Contest`.`book`, `Contest`.`name_of_the_tournament`, `Contest`.`location`, `Contest`.`venue`, `Contest`.`surface`, `Contest`.`participants`, `Contest`.`prize_money`, `Contest`.`attendance`, `Contest`.`misc`, `Contest`.`final_misc`, `Contest`.`created`, `Contest`.`created_by`, `Contest`.`modified`, `Contest`.`modified_by`, `Category`.`id`, `Category`.`name`, `Category`.`slug`, `Category`.`tournament_id`, `Category`.`gender`, `Category`.`type`, `Category`.`surface`, `Category`.`venue`, `Category`.`president`, `Category`.`name_of_the_tournament`, `Category`.`created`, `Category`.`modified`, `Category`.`created_by`, `Category`.`modified_by` FROM `zavoihu1_db4tennis`.`contests` AS `Contest` LEFT JOIN `zavoihu1_db4tennis`.`categories` AS `Category` ON (`Contest`.`category_id` = `Category`.`id`) WHERE `Category`.`tournament_id` = 3 AND `Contest`.`category_id` = 19 AND `Contest`.`slug` = '1986' LIMIT 1

SELECT `Match`.`id`, `Match`.`contest_id`, `Match`.`player_a_id`, `Match`.`player_aa_id`, `Match`.`player_b_id`, `Match`.`player_bb_id`, `Match`.`results`, `Match`.`long`, `Match`.`attendance`, `Match`.`no`, `Match`.`round`, `Match`.`round_id`, `Match`.`note`, `Match`.`created`, `Match`.`created_by`, `Match`.`modified`, `Match`.`modified_by` FROM `zavoihu1_db4tennis`.`matches` AS `Match` WHERE `Match`.`contest_id` = (1797) ORDER BY `Match`.`round_id` ASC, `Match`.`no` ASC

127

SELECT `Player`.`id`, `Player`.`name`, `Player`.`gender`, `Player`.`slug` FROM `zavoihu1_db4tennis`.`players` AS `Player` WHERE `Player`.`id` IN (9582, 9617, 12472, 9828, 11351, 12469, 9743, 9686, 10008, 11307, 9795, 12473, 9938, 9766, 9739, 9507, 9750, 9996, 9671, 9719, 9857, 9728, 9690, 9858, 9661, 9793, 9703, 9780, 9705, 9848, 9702, 11353, 9654, 9724, 9708, 9676, 9767, 12467, 9722, 9736, 9720, 10091, 9735, 11339, 9716, 11268, 9883, 9657, 9753, 9802, 9771, 9678, 9700, 9765, 9729, 12474, 9513, 9711, 9668, 11349, 9692, 9613, 9888, 9717, 9636, 9656, 9760, 9665, 9756, 9962, 10017, 9713, 9727, 9758, 9640, 9948, 9744, 9745, 9902, 9718, 9723, 9533, 9658, 11270, 11341, 9737, 9669, 11337, 9709, 9721, 9699, 11313, 9695, 10019, 9648, 12471, 9677, 12475, 11343, 9803, 9646, 11334, 9764, 9670, 9757, 11331, 13428, 9635, 9682, 12476, 9706, 9773, 9689, 9789, 9763, 9807, 11335, 9761, 9752, 9693, 9897, 9696, 9747, 11276, 9842, 11336, 9672, 9909) ORDER BY `Player`.`lastname` ASC, `Player`.`firstname` ASC

128

SELECT `Playercontest`.`id`, `Playercontest`.`player_id`, `Playercontest`.`contest_id`, `Playercontest`.`nat_id`, `Playercontest`.`draw` FROM `zavoihu1_db4tennis`.`playercontests` AS `Playercontest` WHERE `Playercontest`.`contest_id` = 1797

130

SELECT `Countrycode`.`id`, `Countrycode`.`code` FROM `zavoihu1_db4tennis`.`countrycodes` AS `Countrycode` WHERE `Countrycode`.`id` IN (197, 36, 212, 217, 196, 13, 68, 92, 218, 135, 29, 172, 147, 219, 14, 94, 179, 74, 178, 31, 133, 10, 54, NULL)

SELECT `Countrycode`.`id`, `Countrycode`.`name` FROM `zavoihu1_db4tennis`.`countrycodes` AS `Countrycode` WHERE `Countrycode`.`id` IN (197, 36, 212, 217, 196, 13, 68, 92, 218, 135, 29, 172, 147, 219, 14, 94, 179, 74, 178, 31, 133, 10, 54, NULL)

SELECT `Playercontest`.`player_id`, `Playercontest`.`nat_id` FROM `zavoihu1_db4tennis`.`playercontests` AS `Playercontest` WHERE ((`Playercontest`.`player_id` IN (9582, 9617, 12472, 9828, 11351, 12469, 9743, 9686, 10008, 11307, 9795, 12473, 9938, 9766, 9739, 9507, 9750, 9996, 9671, 9719, 9857, 9728, 9690, 9858, 9661, 9793, 9703, 9780, 9705, 9848, 9702, 11353, 9654, 9724, 9708, 9676, 9767, 12467, 9722, 9736, 9720, 10091, 9735, 11339, 9716, 11268, 9883, 9657, 9753, 9802, 9771, 9678, 9700, 9765, 9729, 12474, 9513, 9711, 9668, 11349, 9692, 9613, 9888, 9717, 9636, 9656, 9760, 9665, 9756, 9962, 10017, 9713, 9727, 9758, 9640, 9948, 9744, 9745, 9902, 9718, 9723, 9533, 9658, 11270, 11341, 9737, 9669, 11337, 9709, 9721, 9699, 11313, 9695, 10019, 9648, 12471, 9677, 12475, 11343, 9803, 9646, 11334, 9764, 9670, 9757, 11331, 13428, 9635, 9682, 12476, 9706, 9773, 9689, 9789, 9763, 9807, 11335, 9761, 9752, 9693, 9897, 9696, 9747, 11276, 9842, 11336, 9672, 9909)) AND (`Playercontest`.`contest_id` = 1797))

128

SELECT `Contest`.`slug`, `Contest`.`year` FROM `zavoihu1_db4tennis`.`contests` AS `Contest` WHERE `Contest`.`category_id` = 19 ORDER BY `Contest`.`date_from` ASC

130

SELECT `Contest`.`id`, `Contest`.`category_id` FROM `zavoihu1_db4tennis`.`contests` AS `Contest` WHERE `Contest`.`year` = 1986

SELECT `Category`.`id`, `Category`.`tournament_id` FROM `zavoihu1_db4tennis`.`categories` AS `Category` WHERE `Category`.`id` IN (12, 17, 22, 18, 13, 23, 14, 24, 25, 26, 19, 15, 16, 20, 21) AND `Category`.`gender` = 'Women' AND `Category`.`type` = 'Singles'

SELECT `Tournament`.`slug`, `Tournament`.`name` FROM `zavoihu1_db4tennis`.`tournaments` AS `Tournament` WHERE `Tournament`.`id` IN (2, 3, 4)