US Open 1985 Women's Singles (August 27 - September 8)

	Nation		R128	R64	R32	R16	QF	SF	F	Champion
1.		[1]	Chris Evert
				Chris Evert
2.			Janine Thompson	6-1 6-3
					Chris Evert
3.			Raffaella Reggi		6-0 6-3
				Raffaella Reggi
4.			Carina Karlsson	4-6 6-3 6-3
						Chris Evert
5.			Mary Lou Piatek			6-0 6-2
				Mary Lou Piatek
6.			Christiane Jolissaint	6-2 6-4
					Grace Kim
7.			Grace Kim		7-6(5) 7-6(5)
				Grace Kim
8.			Bettina Bunge	6-4 6-4
							Chris Evert
9.			Robin White				6-2 6-4
				Robin White
10.			Catherine Tanvier	0-6 7-6(8) 6-4
					Robin White
11.			Petra Keppeler		6-2 6-2
				Petra Keppeler
12.			Andrea Betzner	6-1 3-6 6-3
						Robin White
13.			Mima Jausovec			1-6 6-1 6-2
				Mima Jausovec
14.			Dianne Fromholtz	7-5 6-1
					Bonnie Gadusek
15.		[14]	Bonnie Gadusek		6-0 4-6 6-2
				Bonnie Gadusek
16.			Gigi Fernandez	6-2 7-5
								Chris Evert
17.		[12]	Wendy Turnbull					6-3 6-3
				Wendy Turnbull
18.			Virginia Ruzici	6-4 6-1
					Wendy Turnbull
19.			Beth Herr		7-5 6-2
				Beth Herr
20.			Sharon Walsh	6-3 6-2
						Wendy Turnbull
21.			Michelle Torres			7-6(3) 6-1
				Michelle Torres
22.			Kim Jones	7-6(6) 6-7(4) 6-2
					Michelle Torres
23.			Katerina Bohmova		3-6 6-2 6-0
				Katerina Bohmova
24.			Sophie Amiach	6-4 6-7(8) 6-2
							Claudia Kohde-Kilsch
25.			Ann Henricksson				5-7 7-5 6-2
				Ann Henricksson
26.			Kathy Horvath	6-0 6-4
					Ann Henricksson
27.			Mary Joe Fernandez		6-1 6-4
				Mary Joe Fernandez
28.			Sara Gomer	6-1 6-4
						Claudia Kohde-Kilsch
29.			Adriana Villagran			6-3 6-4
				Adriana Villagran
30.			Angeliki Kanellopoulous	7-6(7) 3-6 6-4
					Claudia Kohde-Kilsch
31.		[5]	Claudia Kohde-Kilsch		6-1 6-1
				Claudia Kohde-Kilsch
32.			Neige Dias	7-6(4) 6-1
									Hana Mandlikova
33.		[3]	Hana Mandlikova						4-6 6-2 6-3
				Hana Mandlikova
34.			Amanda Brown	6-2 6-1
					Hana Mandlikova
35.			Annabel Croft		6-3 6-3
				Annabel Croft
36.			Marcelis Skuherska	6-1 7-5
						Hana Mandlikova
37.			Leslie Allen			6-3 6-4
				Leslie Allen
38.			Catherine Suire	6-4 6-2
					Sylvia Hanika
39.			Sylvia Hanika		6-0 6-0
				Sylvia Hanika
40.			Rosalyn Fairbank	7-5 6-3
							Hana Mandlikova
41.			Kathy Jordan				7-5 3-6 6-1
				Kathy Jordan
42.			Marcella Mesker	2-6 6-1 6-2
					Kathy Jordan
43.			Andrea Jaeger		3-6 6-2 6-2
				Andrea Jaeger
44.			Laura Arraya	7-5 2-6 6-1
						Kathy Jordan
45.			Terry Phelps			7-5 6-1
				Terry Phelps
46.			Stephanie Rehe	6-1 6-4
					Terry Phelps
47.			Barbara Potter		5-7 7-5 6-3
				Barbara Potter
48.		[10]	Gabriela Sabatini	6-4 6-2
								Hana Mandlikova
49.		[15]	Carling Bassett					7-6(4) 7-5
				Carling Bassett
50.			Iva Budarova	6-0 6-7(3) 7-5
					Carling Bassett
51.			Mercedes Paz		6-2 6-1
				Mercedes Paz
52.			Vicki Nelson	0-6 6-1 6-0
						Carling Bassett
53.			Linda Gates			6-4 6-4
				Linda Gates
54.			Lea Antonoplis	6-4 6-2
					Linda Gates
55.			Lisa Spain		6-0 2-6 6-3
				Lisa Spain
56.		[Q]	Anna-Maria Fernandez	6-3 6-4
							Helena Sukova
57.			Camille Benjamin				4-6 7-6(6) 7-5
				Camille Benjamin
58.			Isabelle Demongeot	6-4 6-3
					Camille Benjamin
59.			Laura Garrone		6-1 6-2
				Laura Garrone
60.		[Q]	Barbara Jordan	6-2 6-4
						Helena Sukova
61.			Beverly Bowes			6-0 7-5
				Beverly Bowes
62.		[Q]	Susan Sloane Lundy	6-4 6-3
					Helena Sukova
63.		[7]	Helena Sukova		6-3 6-1
				Helena Sukova
64.		[LL]	Jennifer Mundel	6-1 6-0
										Hana Mandlikova
65.		[8]	Manuela Maleeva							7-6(3) 1-6 7-6(2)
				Manuela Maleeva
66.			Susan Mascarin	6-1 6-1
					Manuela Maleeva
67.			Isabel Cueto		6-0 7-6(5)
				Isabel Cueto
68.			Jenny Klitch	6-3 7-5
						Manuela Maleeva
69.			Petra Huber			6-4 7-5
				Petra Huber
70.			Debbie Spence	7-6(3) 6-1
					Elise Burgin
71.			Elise Burgin		6-4 6-4
				Elise Burgin
72.			Yvonne Vermaak	6-0 6-1
							Steffi Graf
73.			Anne White				6-2 6-2
				Anne White
74.			Helen Kelesi	6-3 2-6 6-4
					Anne White
75.			Shawn Foltz		6-4 6-1
				Shawn Foltz
76.			Mareen Louie	7-6(9) 6-3
						Steffi Graf
77.			Anne Minter			6-4 6-2
				Anne Minter
78.			Elizabeth Minter	6-3 6-4
					Steffi Graf
79.		[11]	Steffi Graf		6-3 7-6(4)
				Steffi Graf
80.			Patty Fendick	6-4 1-6 7-5
								Steffi Graf
81.		[16]	Andrea Temesvari					7-6(4) 6-7(4) 7-6(4)
				Andrea Temesvari
82.			Katerina Maleeva	6-2 4-6 6-4
					Caroline Kuhlman
83.		[Q]	Caroline Kuhlman		2-6 6-2 6-2
				Caroline Kuhlman
84.			Lori McNeil	6-1 6-3
						Alycia Moulton
85.			Alycia Moulton			6-4 1-6 7-6(5)
				Alycia Moulton
86.			Beverly Mould	6-2 7-5
					Alycia Moulton
87.			Sabrina Goles		7-5 6-4
				Sabrina Goles
88.			Rene Uys	6-7(5) 6-1 7-6(4)
							Pam Shriver
89.			Rosie Casals				6-3 6-4
				Rosie Casals
90.			Betsy Nagelsen	1-0 rtd.
					Anne Hobbs
91.			Anne Hobbs		2-6 6-3 7-6(7)
				Anne Hobbs
92.			Jo Durie	7-5 6-1
						Pam Shriver
93.			Hu Na			6-2 6-3
				Hu Na
94.			Eva Pfaff	6-4 6-4
					Pam Shriver
95.		[4]	Pam Shriver		6-2 7-6(5)
				Pam Shriver
96.			Tine Scheuer-Larsen	6-3 6-3
									Martina Navratilova
97.		[6]	Zina Garrison						6-2 6-3
				Zina Garrison
98.			Barbara Gerken	7-5 6-3
					Zina Garrison
99.			Pam Casale		6-2 6-4
				Pam Casale
100.		[Q]	Eleni Rossides	6-3 6-2
						Zina Garrison
101.		[Q]	Marianne Werdel			6-4 6-4
				Marianne Werdel
102.			Myriam Schropp	6-2 6-4
					Belinda Cordwell
103.			Belinda Cordwell		6-2 7-6(2)
				Belinda Cordwell
104.		[Q]	Maria Lindstrom	6-3 6-4
							Zina Garrison
105.			Kate Gompert				6-3 6-2
				Kate Gompert
106.			Patricia Medrado	6-3 6-4
					Kate Gompert
107.		[Q]	Jane Young		6-3 6-1
				Jane Young
108.			JoAnne Russell	7-6(5) 6-3
						Kate Gompert
109.			Lilian Kelaidis Drescher			6-4 7-6(2)
				Lilian Kelaidis Drescher
110.			Terry Holladay	6-0 6-2
					Andrea Holikova
111.			Andrea Holikova		6-3 2-6 6-4
				Andrea Holikova
112.		[9]	Kathy Rinaldi	7-6(3) 7-6(6)
								Martina Navratilova
113.		[13]	Catarina Lindqvist					6-2 6-3
				Catarina Lindqvist
114.			Melissa Gurney	6-1 6-0
					Catarina Lindqvist
115.			Amy Holton		6-1 6-2
				Amy Holton
116.			Liz Sayers	5-7 6-4 6-1
						Catarina Lindqvist
117.			Leigh-Anne Thompson			7-5 6-0
				Leigh-Anne Thompson
118.			Sandra Collins	6-1 3-6 6-1
					Leigh-Anne Thompson
119.			Regina Marsikova		6-4 2-5 rtd.
				Regina Marsikova
120.			Emilse Raponi	6-3 6-2
							Martina Navratilova
121.			Molly Van Nostrand				6-4 7-5
				Molly Van Nostrand
122.			Wendy White	7-6(6) 6-1
					Sandra Cecchini
123.			Sandra Cecchini		6-4 6-4
				Sandra Cecchini
124.			Etsuko Inoue	2-6 6-1 6-2
						Martina Navratilova
125.			Lisa Bonder			6-0 6-1
				Lisa Bonder
126.			Anna Ivan	6-2 4-6 6-3
					Martina Navratilova
127.		[2]	Martina Navratilova		6-1 6-1
				Martina Navratilova
128.			Pascale Paradis	6-2 6-1

(default) 17 queries took 25 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` = 'us-open' LIMIT 1	1	1	2
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` = (4)	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` = (4)	3	3	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` = (4)	2	2	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` = 'us-open' 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` = (24) ORDER BY `Contest`.`year` ASC	138	138	2
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` = 4 AND `Contest`.`category_id` = 24 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` = (1404) 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, 9766, 9722, 9736, 9690, 9657, 11331, 9671, 13428, 9695, 9749, 11343, 9670, 9513, 9673, 9719, 9507, 9638, 9728, 9515, 11307, 9733, 9676, 9725, 9763, 9897, 9909, 9743, 9747, 11334, 9654, 11341, 9648, 9718, 9737, 9730, 9688, 9716, 9665, 9658, 9689, 9640, 9681, 9948, 9795, 9996, 9675, 9883, 9723, 9699, 9962, 9713, 9759, 9693, 9760, 9720, 9709, 9938, 11337, 9644, 9773, 10008, 9677, 9700, 9702, 9705, 9973, 11301, 11336, 11339, 9744, 9711, 9686, 9771, 9740, 11270, 9646, 9729, 9715, 9857, 9741, 9756, 10019, 9727, 9708, 9751, 11313, 11333, 9449, 9636, 9682, 9692, 9767, 9828, 9656, 9752, 9706, 9735, 9842, 13433, 9798, 9754, 9761, 9861, 11353, 11268, 13435, 11303, 9732, 9762, 9757, 9717, 9753, 11335, 11319, 9661, 11302, 9748, 9613, 11275, 9765, 9703, 10091, 9724, 9764, 9887, 9582, 9721) 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` = 1404	128	128	3
11	SELECT `Countrycode`.`id`, `Countrycode`.`code` FROM `zavoihu1_db4tennis`.`countrycodes` AS `Countrycode` WHERE `Countrycode`.`id` IN (197, 68, 36, 212, 217, 196, 92, 135, 29, 179, 172, 13, 147, 219, 14, 94, 74, 178, 31, 133, 10, 153, 54, 84)	24	24	1
12	SELECT `Countrycode`.`id`, `Countrycode`.`name` FROM `zavoihu1_db4tennis`.`countrycodes` AS `Countrycode` WHERE `Countrycode`.`id` IN (197, 68, 36, 212, 217, 196, 92, 135, 29, 179, 172, 13, 147, 219, 14, 94, 74, 178, 31, 133, 10, 153, 54, 84)	24	24	1
13	SELECT `Playercontest`.`player_id`, `Playercontest`.`nat_id` FROM `zavoihu1_db4tennis`.`playercontests` AS `Playercontest` WHERE ((`Playercontest`.`player_id` IN (9672, 9766, 9722, 9736, 9690, 9657, 11331, 9671, 13428, 9695, 9749, 11343, 9670, 9513, 9673, 9719, 9507, 9638, 9728, 9515, 11307, 9733, 9676, 9725, 9763, 9897, 9909, 9743, 9747, 11334, 9654, 11341, 9648, 9718, 9737, 9730, 9688, 9716, 9665, 9658, 9689, 9640, 9681, 9948, 9795, 9996, 9675, 9883, 9723, 9699, 9962, 9713, 9759, 9693, 9760, 9720, 9709, 9938, 11337, 9644, 9773, 10008, 9677, 9700, 9702, 9705, 9973, 11301, 11336, 11339, 9744, 9711, 9686, 9771, 9740, 11270, 9646, 9729, 9715, 9857, 9741, 9756, 10019, 9727, 9708, 9751, 11313, 11333, 9449, 9636, 9682, 9692, 9767, 9828, 9656, 9752, 9706, 9735, 9842, 13433, 9798, 9754, 9761, 9861, 11353, 11268, 13435, 11303, 9732, 9762, 9757, 9717, 9753, 11335, 11319, 9661, 11302, 9748, 9613, 11275, 9765, 9703, 10091, 9724, 9764, 9887, 9582, 9721)) AND (`Playercontest`.`contest_id` = 1404))	128	128	1
14	SELECT `Contest`.`slug`, `Contest`.`year` FROM `zavoihu1_db4tennis`.`contests` AS `Contest` WHERE `Contest`.`category_id` = 24 ORDER BY `Contest`.`date_from` ASC	138	138	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 25 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` = 'us-open' 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` = (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` = (4)

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` = 'us-open' AND `Category`.`slug` = 'women-singles' LIMIT 1

138

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` = 4 AND `Contest`.`category_id` = 24 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` = (1404) 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, 9766, 9722, 9736, 9690, 9657, 11331, 9671, 13428, 9695, 9749, 11343, 9670, 9513, 9673, 9719, 9507, 9638, 9728, 9515, 11307, 9733, 9676, 9725, 9763, 9897, 9909, 9743, 9747, 11334, 9654, 11341, 9648, 9718, 9737, 9730, 9688, 9716, 9665, 9658, 9689, 9640, 9681, 9948, 9795, 9996, 9675, 9883, 9723, 9699, 9962, 9713, 9759, 9693, 9760, 9720, 9709, 9938, 11337, 9644, 9773, 10008, 9677, 9700, 9702, 9705, 9973, 11301, 11336, 11339, 9744, 9711, 9686, 9771, 9740, 11270, 9646, 9729, 9715, 9857, 9741, 9756, 10019, 9727, 9708, 9751, 11313, 11333, 9449, 9636, 9682, 9692, 9767, 9828, 9656, 9752, 9706, 9735, 9842, 13433, 9798, 9754, 9761, 9861, 11353, 11268, 13435, 11303, 9732, 9762, 9757, 9717, 9753, 11335, 11319, 9661, 11302, 9748, 9613, 11275, 9765, 9703, 10091, 9724, 9764, 9887, 9582, 9721) 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` = 1404

128

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

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

SELECT `Playercontest`.`player_id`, `Playercontest`.`nat_id` FROM `zavoihu1_db4tennis`.`playercontests` AS `Playercontest` WHERE ((`Playercontest`.`player_id` IN (9672, 9766, 9722, 9736, 9690, 9657, 11331, 9671, 13428, 9695, 9749, 11343, 9670, 9513, 9673, 9719, 9507, 9638, 9728, 9515, 11307, 9733, 9676, 9725, 9763, 9897, 9909, 9743, 9747, 11334, 9654, 11341, 9648, 9718, 9737, 9730, 9688, 9716, 9665, 9658, 9689, 9640, 9681, 9948, 9795, 9996, 9675, 9883, 9723, 9699, 9962, 9713, 9759, 9693, 9760, 9720, 9709, 9938, 11337, 9644, 9773, 10008, 9677, 9700, 9702, 9705, 9973, 11301, 11336, 11339, 9744, 9711, 9686, 9771, 9740, 11270, 9646, 9729, 9715, 9857, 9741, 9756, 10019, 9727, 9708, 9751, 11313, 11333, 9449, 9636, 9682, 9692, 9767, 9828, 9656, 9752, 9706, 9735, 9842, 13433, 9798, 9754, 9761, 9861, 11353, 11268, 13435, 11303, 9732, 9762, 9757, 9717, 9753, 11335, 11319, 9661, 11302, 9748, 9613, 11275, 9765, 9703, 10091, 9724, 9764, 9887, 9582, 9721)) AND (`Playercontest`.`contest_id` = 1404))

128

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

138

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)