Wimbledon 1985 Ladies' Singles (June 24 - July 6)

	Nation		R128	R64	R32	R16	QF	SF	F	Champion
1.		[1]	Chris Evert
				Chris Evert
2.			Mary Lou Piatek	6-1 6-0
					Chris Evert
3.			Susan Mascarin		6-3 6-0
				Susan Mascarin
4.			Tine Scheuer-Larsen	7-6 3-6 6-3
						Chris Evert
5.		[Q]	Jenny Byrne			6-2 6-1
				Jenny Byrne
6.			Sophie Amiach	6-2 6-3
					Jenny Byrne
7.			Yvonne Vermaak		6-2 6-3
				Yvonne Vermaak
8.			Mima Jausovec	6-3 6-4
							Chris Evert
9.			Lilian Kelaidis Drescher				6-0 6-4
				Lilian Kelaidis Drescher
10.			Marcelis Skuherska	6-3 6-2
					Isabelle Demongeot
11.			Isabelle Demongeot		6-4 6-3
				Isabelle Demongeot
12.		[Q]	Barbara Jordan	6-1 6-4
						Anne Smith
13.			Anne Smith			6-2 6-4
				Anne Smith
14.			Vicki Nelson	6-0 6-2
					Anne Smith
15.		[9]	Bonnie Gadusek		2-6 6-4 6-2
				Bonnie Gadusek
16.			Heather Ludloff	6-1 6-1
								Chris Evert
17.			Barbara Potter					6-2 6-1
				Barbara Potter
18.		[12]	Catarina Lindqvist	6-0 7-5
					Barbara Potter
19.			Sara Gomer		6-4 7-5
				Sara Gomer
20.			Beverly Mould	6-7 7-6 6-3
						Barbara Potter
21.		[Q]	Patty Fendick			7-6 6-1
				Patty Fendick
22.			Melissa Brown	6-4 6-1
					Patty Fendick
23.			Kathleen Cummings		6-1 6-3
				Kathleen Cummings
24.			Kate Brasher	6-3 6-4
							Barbara Potter
25.			Elise Burgin				7-6 6-7 6-1
				Elise Burgin
26.			Patricia Medrado	7-6 6-2
					Elise Burgin
27.			Adriana Villagran		6-0 6-3
				Adriana Villagran
28.			Jenny Klitch	6-7 6-4 6-3
						Jo Durie
29.			Jo Durie			7-5 7-5
				Jo Durie
30.			Kim Jones	6-3 6-2
					Jo Durie
31.		[6]	Claudia Kohde-Kilsch		4-6 6-1 6-2
				Claudia Kohde-Kilsch
32.			Betsy Nagelsen	7-5 6-1
									Chris Evert
33.		[3]	Hana Mandlikova						6-2 6-0
				Hana Mandlikova
34.			Iva Budarova	6-0 6-1
					Hana Mandlikova
35.			Dianne Fromholtz		4-6 6-2 7-5
				Dianne Fromholtz
36.			Neige Dias	6-0 6-2
						Liz Sayers
37.			JoAnne Russell			6-1 7-6
				JoAnne Russell
38.			Petra Keppeler	5-7 6-2 6-1
					Liz Sayers
39.			Liz Sayers		6-4 6-4
				Liz Sayers
40.			Andrea Leand	6-1 6-2
							Kathy Rinaldi
41.			Alycia Moulton				6-2 6-1
				Alycia Moulton
42.			Beth Herr	6-3 6-4
					Alycia Moulton
43.			Sally Reeves		6-2 6-4
				Sally Reeves
44.			Rina Einy	6-3 5-7 6-4
						Kathy Rinaldi
45.			Rosalyn Fairbank			7-6 6-4
				Rosalyn Fairbank
46.			Myriam Schropp	7-5 6-4
					Kathy Rinaldi
47.		[16]	Kathy Rinaldi		7-5 6-4
				Kathy Rinaldi
48.		[Q]	Andrea Betzner	6-3 7-5
								Kathy Rinaldi
49.		[14]	Wendy Turnbull					6-1 1-6 6-1
				Wendy Turnbull
50.			Gretchen Anne Rush	7-5 6-3
					Wendy Turnbull
51.			Elizabeth Minter		7-5 7-5
				Elizabeth Minter
52.			Masako Yanagi	6-3 6-3
						Pascale Paradis
53.			Sylvia Hanika			2-6 7-5 6-1
				Sylvia Hanika
54.			Catherine Suire	6-4 6-2
					Pascale Paradis
55.			Pascale Paradis		7-6 6-7 6-3
				Pascale Paradis
56.			Emiko Okagawa	6-2 6-1
							Helena Sukova
57.			Ann Henricksson				6-4 7-6
				Ann Henricksson
58.			Clare Wood	6-1 7-5
					Wendy White
59.			Wendy White		6-4 2-6 6-4
				Wendy White
60.		[LL]	Kristin Kinney	6-3 2-6 6-4
						Helena Sukova
61.			Virginia Ruzici			6-1 6-4
				Virginia Ruzici
62.			Amy Holton	4-6 6-4 7-5
					Helena Sukova
63.		[7]	Helena Sukova		6-1 6-4
				Helena Sukova
64.			Catrin Jexell	6-3 6-3
										Martina Navratilova
65.		[8]	Zina Garrison							4-6 6-3 6-2
				Zina Garrison
66.		[Q]	Elna Reinach	6-2 6-1
					Zina Garrison
67.			Terry Phelps		6-3 6-1
				Terry Phelps
68.			Katerina Bohmova	6-3 6-3
						Zina Garrison
69.			Andrea Holikova			6-3 6-1
				Andrea Holikova
70.			Pam Casale	5-7 6-1 6-3
					Marcella Mesker
71.			Marcella Mesker		6-2 6-7 6-3
				Marcella Mesker
72.			Kate Gompert	6-3 4-6 6-4
							Zina Garrison
73.			Melissa Gurney				6-1 6-3
				Melissa Gurney
74.			Susan Leo	7-5 6-4
					Catherine Tanvier
75.			Catherine Tanvier		6-3 6-4
				Catherine Tanvier
76.			Marianne Groat	6-3 6-2
						Catherine Tanvier
77.			Camille Benjamin			6-7 6-4 6-1
				Camille Benjamin
78.			Elena Eliseenko	6-4 6-0
					Gabriela Sabatini
79.		[15]	Gabriela Sabatini		6-3 6-4
				Gabriela Sabatini
80.			Amanda Brown	3-6 6-3 6-3
								Zina Garrison
81.		[10]	Kathy Jordan					2-6 6-3 6-0
				Kathy Jordan
82.			Joy Tacon	6-0 6-2
					Larisa Savchenko
83.			Larisa Savchenko		7-5 3-6 6-3
				Larisa Savchenko
84.			Sabrina Goles	6-1 4-6 6-3
						Molly Van Nostrand
85.		[Q]	Molly Van Nostrand			7-6 3-6 7-5
				Molly Van Nostrand
86.			Sharon Walsh	7-5 6-3
					Molly Van Nostrand
87.			Mareen Louie		6-2 6-3
				Mareen Louie
88.			Helen Kelesi	6-2 6-4
							Molly Van Nostrand
89.			Eva Pfaff				7-5 6-2
				Eva Pfaff
90.			Shawn Foltz	6-3 6-3
					Robin White
91.			Robin White		6-3 6-2
				Robin White
92.			Sandra Collins	6-2 6-2
						Manuela Maleeva
93.			Terry Holladay			6-3 6-3
				Terry Holladay
94.			Janine Thompson	6-1 6-3
					Manuela Maleeva
95.		[4]	Manuela Maleeva		6-7 6-1 6-4
				Manuela Maleeva
96.			Micheala Washington	6-0 6-1
									Martina Navratilova
97.		[5]	Pam Shriver						6-4 7-6
				Pam Shriver
98.			Anne White	6-3 6-7 6-3
					Pam Shriver
99.			Anne Hobbs		6-3 6-2
				Anne Hobbs
100.			Grace Kim	6-4 6-2
						Pam Shriver
101.			Barbara Gerken			6-2 5-7 6-2
				Barbara Gerken
102.			Corinne Vanier	6-3 6-2
					Virginia Wade
103.			Virginia Wade		6-3 6-7 7-5
				Virginia Wade
104.			Lea Antonoplis	6-4 7-5
							Pam Shriver
105.			Etsuko Inoue				3-6 6-2 6-4
				Etsuko Inoue
106.		[Q]	Elizabeth Ekblom	6-2 6-1
					Stephanie Rehe
107.			Stephanie Rehe		6-1 6-3
				Stephanie Rehe
108.			Christiane Jolissaint	6-4 6-3
						Steffi Graf
109.			Andrea Temesvari			6-3 6-2
				Andrea Temesvari
110.			Katerina Maleeva	3-6 7-6 6-4
					Steffi Graf
111.		[11]	Steffi Graf		6-3 7-6
				Steffi Graf
112.			Lisa Spain	6-7 6-4 6-2
								Martina Navratilova
113.		[13]	Carling Bassett					7-6 6-3
				Carling Bassett
114.			Mercedes Paz	6-0 3-6 6-3
					Rene Uys
115.			Rene Uys		0-6 7-6 6-3
				Rene Uys
116.			Joanne Louis	7-6 4-6 6-2
						Rene Uys
117.		[Q]	Hu Na			6-2 4-6 6-0
				Hu Na
118.			Annabel Croft	6-3 7-5
					Hu Na
119.		[LL]	Lea Plchova		7-5 6-4
				Lea Plchova
120.			Carina Karlsson	2-6 6-4 6-3
							Martina Navratilova
121.			Sandra Cecchini				6-2 6-2
				Sandra Cecchini
122.			Julie Salmon	7-6 6-1
					Bettina Bunge
123.			Bettina Bunge		6-3 6-2
				Bettina Bunge
124.			Lori McNeil	6-3 6-3
						Martina Navratilova
125.			Anne Minter			7-6 6-3
				Anne Minter
126.			Pilar Vasquez	6-0 6-2
					Martina Navratilova
127.		[2]	Martina Navratilova		6-4 6-1
				Martina Navratilova
128.			Lisa Bonder	6-0 6-2

(default) 17 queries took 42 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	2
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	14
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	2
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	2
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	8
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` = '1985' 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` = (1796) 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 (9672, 9690, 9705, 9752, 9739, 9725, 9711, 9670, 9732, 9730, 9938, 9644, 9678, 9713, 9673, 9714, 9675, 9753, 9743, 9751, 9857, 9841, 11346, 11310, 9744, 11268, 9747, 11301, 9692, 9733, 9654, 9636, 9648, 9699, 9513, 11341, 11303, 9749, 9661, 9704, 9708, 9728, 12469, 11329, 9658, 9754, 9717, 11343, 9507, 9802, 9729, 9755, 9665, 9716, 9721, 9778, 9763, 9851, 9703, 11351, 9638, 11319, 9677, 11318, 9706, 9780, 9795, 9676, 9757, 9842, 9640, 11353, 11335, 9628, 9695, 12470, 9709, 11328, 9883, 9718, 9689, 12471, 9750, 11313, 9765, 9515, 11270, 9771, 9828, 9740, 13428, 9748, 9762, 9766, 9702, 9738, 9656, 9686, 9682, 11331, 9735, 9687, 9528, 9693, 9724, 9608, 9996, 9657, 9741, 9756, 9715, 9760, 9723, 9962, 11333, 12467, 9767, 9737, 11320, 9736, 10091, 9803, 9671, 9727, 9646, 9799, 9582, 9764) ORDER BY `Player`.`lastname` ASC, `Player`.`firstname` ASC	128	128	1
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` = 1796	129	129	1
11	SELECT `Countrycode`.`id`, `Countrycode`.`code` FROM `zavoihu1_db4tennis`.`countrycodes` AS `Countrycode` WHERE `Countrycode`.`id` IN (68, 197, 36, 212, 217, 196, 13, 92, 29, 179, 178, 218, 172, 219, 94, 31, 133, 10, 153, 54, 84, 147, NULL)	22	22	1
12	SELECT `Countrycode`.`id`, `Countrycode`.`name` FROM `zavoihu1_db4tennis`.`countrycodes` AS `Countrycode` WHERE `Countrycode`.`id` IN (68, 197, 36, 212, 217, 196, 13, 92, 29, 179, 178, 218, 172, 219, 94, 31, 133, 10, 153, 54, 84, 147, NULL)	22	22	1
13	SELECT `Playercontest`.`player_id`, `Playercontest`.`nat_id` FROM `zavoihu1_db4tennis`.`playercontests` AS `Playercontest` WHERE ((`Playercontest`.`player_id` IN (9672, 9690, 9705, 9752, 9739, 9725, 9711, 9670, 9732, 9730, 9938, 9644, 9678, 9713, 9673, 9714, 9675, 9753, 9743, 9751, 9857, 9841, 11346, 11310, 9744, 11268, 9747, 11301, 9692, 9733, 9654, 9636, 9648, 9699, 9513, 11341, 11303, 9749, 9661, 9704, 9708, 9728, 12469, 11329, 9658, 9754, 9717, 11343, 9507, 9802, 9729, 9755, 9665, 9716, 9721, 9778, 9763, 9851, 9703, 11351, 9638, 11319, 9677, 11318, 9706, 9780, 9795, 9676, 9757, 9842, 9640, 11353, 11335, 9628, 9695, 12470, 9709, 11328, 9883, 9718, 9689, 12471, 9750, 11313, 9765, 9515, 11270, 9771, 9828, 9740, 13428, 9748, 9762, 9766, 9702, 9738, 9656, 9686, 9682, 11331, 9735, 9687, 9528, 9693, 9724, 9608, 9996, 9657, 9741, 9756, 9715, 9760, 9723, 9962, 11333, 12467, 9767, 9737, 11320, 9736, 10091, 9803, 9671, 9727, 9646, 9799, 9582, 9764)) AND (`Playercontest`.`contest_id` = 1796))	128	128	1
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` = 1985	19	19	1
16	SELECT `Category`.`id`, `Category`.`tournament_id` FROM `zavoihu1_db4tennis`.`categories` AS `Category` WHERE `Category`.`id` IN (2, 3, 1, 12, 17, 22, 18, 13, 23, 4, 14, 24, 25, 26, 19, 15, 16, 20, 21) AND `Category`.`gender` = 'Women' AND `Category`.`type` = 'Singles'	4	4	1
17	SELECT `Tournament`.`slug`, `Tournament`.`name` FROM `zavoihu1_db4tennis`.`tournaments` AS `Tournament` WHERE `Tournament`.`id` IN (1, 2, 3, 4)	4	4	1

(default) 17 queries took 42 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` = '1985' 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` = (1796) 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 (9672, 9690, 9705, 9752, 9739, 9725, 9711, 9670, 9732, 9730, 9938, 9644, 9678, 9713, 9673, 9714, 9675, 9753, 9743, 9751, 9857, 9841, 11346, 11310, 9744, 11268, 9747, 11301, 9692, 9733, 9654, 9636, 9648, 9699, 9513, 11341, 11303, 9749, 9661, 9704, 9708, 9728, 12469, 11329, 9658, 9754, 9717, 11343, 9507, 9802, 9729, 9755, 9665, 9716, 9721, 9778, 9763, 9851, 9703, 11351, 9638, 11319, 9677, 11318, 9706, 9780, 9795, 9676, 9757, 9842, 9640, 11353, 11335, 9628, 9695, 12470, 9709, 11328, 9883, 9718, 9689, 12471, 9750, 11313, 9765, 9515, 11270, 9771, 9828, 9740, 13428, 9748, 9762, 9766, 9702, 9738, 9656, 9686, 9682, 11331, 9735, 9687, 9528, 9693, 9724, 9608, 9996, 9657, 9741, 9756, 9715, 9760, 9723, 9962, 11333, 12467, 9767, 9737, 11320, 9736, 10091, 9803, 9671, 9727, 9646, 9799, 9582, 9764) 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` = 1796

129

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

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

SELECT `Playercontest`.`player_id`, `Playercontest`.`nat_id` FROM `zavoihu1_db4tennis`.`playercontests` AS `Playercontest` WHERE ((`Playercontest`.`player_id` IN (9672, 9690, 9705, 9752, 9739, 9725, 9711, 9670, 9732, 9730, 9938, 9644, 9678, 9713, 9673, 9714, 9675, 9753, 9743, 9751, 9857, 9841, 11346, 11310, 9744, 11268, 9747, 11301, 9692, 9733, 9654, 9636, 9648, 9699, 9513, 11341, 11303, 9749, 9661, 9704, 9708, 9728, 12469, 11329, 9658, 9754, 9717, 11343, 9507, 9802, 9729, 9755, 9665, 9716, 9721, 9778, 9763, 9851, 9703, 11351, 9638, 11319, 9677, 11318, 9706, 9780, 9795, 9676, 9757, 9842, 9640, 11353, 11335, 9628, 9695, 12470, 9709, 11328, 9883, 9718, 9689, 12471, 9750, 11313, 9765, 9515, 11270, 9771, 9828, 9740, 13428, 9748, 9762, 9766, 9702, 9738, 9656, 9686, 9682, 11331, 9735, 9687, 9528, 9693, 9724, 9608, 9996, 9657, 9741, 9756, 9715, 9760, 9723, 9962, 11333, 12467, 9767, 9737, 11320, 9736, 10091, 9803, 9671, 9727, 9646, 9799, 9582, 9764)) AND (`Playercontest`.`contest_id` = 1796))

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` = 1985

SELECT `Category`.`id`, `Category`.`tournament_id` FROM `zavoihu1_db4tennis`.`categories` AS `Category` WHERE `Category`.`id` IN (2, 3, 1, 12, 17, 22, 18, 13, 23, 4, 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 (1, 2, 3, 4)