US Open 1981 Women's Singles (September 1 - September 13)

	Nation		R128	R64	R32	R16	QF	SF	F	Champion
1.		[1]	Chris Evert
				Chris Evert
2.			Kerry Neill	6-1 6-1
					Chris Evert
3.			Kate Latham		6-1 6-0
				Kate Latham
4.			Sue Saliba	6-2 6-2
						Chris Evert
5.			Alycia Moulton			6-3 6-0
				Alycia Moulton
6.			Betty Stove	6-2 6-0
					Alycia Moulton
7.			Mareen Louie		6-3 7-5
				Mareen Louie
8.			Deborah Jevans	6-3 6-0
							Chris Evert
9.		[Q]	Leigh-Anne Thompson				6-1 6-0
				Leigh-Anne Thompson
10.			Sandra Collins	6-4 6-3
					Leigh-Anne Thompson
11.			Kim Jones		6-1 6-0
				Kim Jones
12.			Marie Neumanova	6-3 6-4
						Bettina Bunge
13.			Ann Kiyomura			2-6 7-6 6-3
				Ann Kiyomura
14.			Marianne Van Der Torre	7-5 7-5
					Bettina Bunge
15.		[12]	Bettina Bunge		6-3 3-6 6-3
				Bettina Bunge
16.			Marcie Louie	6-2 6-1
								Chris Evert
17.		[9]	Virginia Ruzici					6-1 6-3
				Virginia Ruzici
18.			Wendy White	6-2 6-1
					Virginia Ruzici
19.			Elise Burgin		5-7 7-5 6-2
				Elise Burgin
20.			Lea Antonoplis	6-3 6-3
						Duk-Hee Lee
21.			Duk-Hee Lee			6-1 4-6 7-5
				Duk-Hee Lee
22.			Susan Leo	6-3 6-4
					Duk-Hee Lee
23.			Susan Mascarin		6-7 6-4 7-6
				Susan Mascarin
24.			Nancy Yeargin	3-6 6-2 6-4
							Hana Mandlikova
25.			Barbara Jordan				6-1 6-0
				Barbara Jordan
26.		[Q]	Felicia Hutnick	7-5 6-1
					Glynis Coles
27.			Glynis Coles		6-3 7-6
				Glynis Coles
28.			Sheila McInerney	6-3 6-0
						Hana Mandlikova
29.			Candy Reynolds			6-2 6-1
				Candy Reynolds
30.			Kim Sands	6-3 6-0
					Hana Mandlikova
31.		[5]	Hana Mandlikova		6-4 6-4
				Hana Mandlikova
32.			Mary Lou Piatek	6-7 7-6 6-3
									Martina Navratilova
33.		[4]	Martina Navratilova						7-5 4-6 6-4
				Martina Navratilova
34.			Nerida Gregory	6-0 6-1
					Martina Navratilova
35.			Anne White		6-2 6-3
				Anne White
36.			Claudia Pasquale	4-6 6-1 6-3
						Martina Navratilova
37.			JoAnne Russell			6-2 6-1
				JoAnne Russell
38.			Lisa Bonder	1-6 6-3 6-3
					JoAnne Russell
39.			Marjorie Blackwood		6-2 6-4
				Marjorie Blackwood
40.			Kim Steinmetz	6-4 6-4
							Martina Navratilova
41.			Corinne Vanier				6-1 6-0
				Corinne Vanier
42.			Leslie Allen	1-6 6-2 6-2
					Corinne Vanier
43.			Tanya Harford		2-6 6-2 7-6
				Tanya Harford
44.			Yvona Brzakova	6-4 6-2
						Kathy Jordan
45.			Catherine Tanvier			6-2 6-1
				Catherine Tanvier
46.			Pilar Vasquez	6-2 5-7 6-1
					Kathy Jordan
47.		[14]	Kathy Jordan		6-1 6-1
				Kathy Jordan
48.			Elizabeth Little	6-0 6-1
								Martina Navratilova
49.			Anne Smith					7-5 6-4
				Anne Smith
50.		[16]	Dianne Fromholtz	6-3 6-3
					Anne Smith
51.			Roberta McCallum		6-0 6-0
				Roberta McCallum
52.			Jane Preyer	6-2 6-3
						Anne Smith
53.			Joyce Portman			6-1 6-0
				Joyce Portman
54.		[LL]	Jill Davis	6-2 7-5
					Joyce Portman
55.			Lisa Doherty		7-5 6-0
				Lisa Doherty
56.			Naoko Sato	7-5 6-1
							Anne Smith
57.			Renata Tomanova				6-4 1-6 7-5
				Renata Tomanova
58.			Lele Forood	6-3 6-3
					Renata Tomanova
59.			Vicki Nelson		6-4 6-2
				Vicki Nelson
60.			Beth Herr	6-2 1-6 7-6
						Pam Shriver
61.			Jeanne Duvall			6-3 6-2
				Jeanne Duvall
62.			Stacy Margolin	3-6 6-4 6-0
					Pam Shriver
63.		[8]	Pam Shriver		6-3 6-2
				Pam Shriver
64.			Dana Gilbert	6-1 6-0
										Tracy Austin
65.		[6]	Sylvia Hanika							1-6 7-6(4) 7-6(1)
				Sylvia Hanika
66.			Brenda Remilton	6-2 6-2
					Sylvia Hanika
67.			Rene Blount		7-5 6-2
				Rene Blount
68.		[LL]	Lucy Gordon	6-2 6-0
						Sylvia Hanika
69.			Marcella Mesker			4-6 6-1 6-2
				Marcella Mesker
70.			Katerina Bohmova	6-3 6-2
					Marcella Mesker
71.			Elly Appel		6-2 6-2
				Elly Appel
72.			Anna-Maria Fernandez	6-4 6-4
							Sylvia Hanika
73.			Virginia Wade				6-2 7-5
				Virginia Wade
74.			Pam Teeguarden	6-3 6-7 6-2
					Virginia Wade
75.			Jennifer Mundel		6-1 6-3
				Jennifer Mundel
76.		[Q]	Jean Hepner	7-5 6-1
						Sharon Walsh
77.			Sharon Walsh			7-5 4-6 6-3
				Sharon Walsh
78.			Kathleen Cummings	6-1 6-3
					Sharon Walsh
79.		[15]	Sue Barker		5-7 6-3 rtd.
				Sue Barker
80.			Laura DuPont	6-4 4-6 6-3
								Tracy Austin
81.			Rosie Casals					6-4 6-3
				Rosie Casals
82.		[13]	Regina Marsikova	6-2 6-2
					Rosie Casals
83.		[LL]	Jody Appelbaum		6-0 6-2
				Jody Appelbaum
84.			Liz Sayers	6-4 3-6 6-2
						Rosie Casals
85.			Sherry Acker			3-6 6-1 6-4
				Sherry Acker
86.			Betty Ann Grubb	7-6 6-4
					Sherry Acker
87.			Diane Morrison		6-4 6-3
				Diane Morrison
88.			Anne Minter	0-6 6-3 6-3
							Tracy Austin
89.			Pam Casale				6-1 6-3
				Pam Casale
90.			Iva Budarova	6-2 6-1
					Pam Casale
91.		[Q]	Kate Gompert		6-4 6-0
				Kate Gompert
92.			Patricia Medrado	7-5 6-3
						Tracy Austin
93.			Betsy Nagelsen			6-3 6-0
				Betsy Nagelsen
94.			Carol Baily	7-5 6-3
					Tracy Austin
95.		[3]	Tracy Austin		6-3 6-0
				Tracy Austin
96.			Anne Hobbs	6-1 6-2
									Tracy Austin
97.		[7]	Wendy Turnbull						6-1 6-3
				Wendy Turnbull
98.			Zina Garrison	3-6 6-3 6-2
					Wendy Turnbull
99.			Lucia Romanov		6-1 6-3
				Lucia Romanov
100.		[Q]	Tina Mochizuki	2-6 6-1 6-0
						Barbara Gerken
101.		[Q]	Barbara Gerken			6-3 7-5
				Barbara Gerken
102.			Rosalyn Fairbank	6-3 6-4
					Barbara Gerken
103.			Andrea Buchanan		6-4 7-5
				Andrea Buchanan
104.			Eva Pfaff	6-3 6-2
							Barbara Gerken
105.			Jo Durie				7-6 6-1
				Jo Durie
106.			Diane Desfor	6-3 6-3
					Jo Durie
107.			Barbara Hallquist		6-3 6-3
				Barbara Hallquist
108.			Trey Lewis	6-4 3-6 6-2
						Jo Durie
109.			Kathy Horvath			6-4 3-6 6-4
				Kathy Horvath
110.			Kathy Rinaldi	7-5 3-6 7-5
					Kathy Horvath
111.		[10]	Mima Jausovec		6-3 6-7 6-3
				Mima Jausovec
112.			Laura Arraya	6-2 6-2
								Barbara Potter
113.		[11]	Barbara Potter					7-5 7-5
				Barbara Potter
114.			Claudia Kohde-Kilsch	6-7 6-1 6-2
					Barbara Potter
115.			Susan Rollinson		6-3 6-2
				Susan Rollinson
116.		[Q]	Kate Brasher	6-4 6-2
						Barbara Potter
117.			Lindsay Morse			4-6 6-2 7-5
				Lindsay Morse
118.			Debbie Freeman	6-3 6-2
					Lindsay Morse
119.			Paula Smith		6-2 6-4
				Paula Smith
120.			Ruta Gerulaitis	6-4 6-2
							Barbara Potter
121.			Julie Harrington				6-7 7-6 6-3
				Julie Harrington
122.		[LL]	Beatrix Klein	6-0 6-3
					Julie Harrington
123.			Yvonne Vermaak		6-4 1-6 6-6 rtd.
				Yvonne Vermaak
124.			Beth Norton	2-6 6-1 6-2
						Andrea Leand
125.			Andrea Leand			6-4 6-3
				Andrea Leand
126.			Renee Richards	6-4 2-6 7-5
					Andrea Leand
127.		[2]	Andrea Jaeger		6-1 5-7 6-3
				Andrea Jaeger
128.		[Q]	Maria-Christine Calleja	6-1 6-0

(default) 17 queries took 23 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	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` = (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` = '1981' 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` = (1400) 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, 9596, 9701, 9625, 9708, 9455, 11270, 11296, 11302, 9748, 9733, 9660, 9564, 9792, 9671, 9659, 9638, 9703, 9744, 9693, 9532, 9628, 9705, 9679, 9644, 9650, 9533, 12453, 9668, 9635, 9648, 9690, 9582, 9562, 9686, 11304, 11303, 9764, 9694, 9696, 9687, 9688, 9664, 11300, 9695, 9799, 9689, 9626, 9678, 9513, 11290, 9712, 11292, 11321, 13442, 9620, 9606, 9653, 9713, 9728, 11279, 11288, 9656, 11289, 9665, 9685, 9631, 13443, 9640, 9676, 11237, 9720, 9528, 9573, 9700, 11315, 9515, 11346, 9554, 9587, 9449, 9613, 13445, 9661, 9691, 11278, 9649, 9646, 9842, 9699, 11353, 11268, 9636, 13446, 9697, 9682, 9507, 9706, 11282, 9789, 9735, 9658, 11295, 9828, 9692, 9655, 9663, 11298, 9897, 9717, 9670, 9948, 9675, 9654, 11293, 11310, 9652, 11291, 9680, 11273, 11287, 11243, 9711, 9632, 9704, 13447, 9681, 9669) ORDER BY `Player`.`lastname` ASC, `Player`.`firstname` ASC	128	128	2
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` = 1400	130	130	2
11	SELECT `Countrycode`.`id`, `Countrycode`.`code` FROM `zavoihu1_db4tennis`.`countrycodes` AS `Countrycode` WHERE `Countrycode`.`id` IN (197, 133, 196, 36, 217, 212, 68, 172, 13, 147, NULL, 219, 84, 100, 29, 179, 153, 94)	17	17	1
12	SELECT `Countrycode`.`id`, `Countrycode`.`name` FROM `zavoihu1_db4tennis`.`countrycodes` AS `Countrycode` WHERE `Countrycode`.`id` IN (197, 133, 196, 36, 217, 212, 68, 172, 13, 147, NULL, 219, 84, 100, 29, 179, 153, 94)	17	17	1
13	SELECT `Playercontest`.`player_id`, `Playercontest`.`nat_id` FROM `zavoihu1_db4tennis`.`playercontests` AS `Playercontest` WHERE ((`Playercontest`.`player_id` IN (9672, 9596, 9701, 9625, 9708, 9455, 11270, 11296, 11302, 9748, 9733, 9660, 9564, 9792, 9671, 9659, 9638, 9703, 9744, 9693, 9532, 9628, 9705, 9679, 9644, 9650, 9533, 12453, 9668, 9635, 9648, 9690, 9582, 9562, 9686, 11304, 11303, 9764, 9694, 9696, 9687, 9688, 9664, 11300, 9695, 9799, 9689, 9626, 9678, 9513, 11290, 9712, 11292, 11321, 13442, 9620, 9606, 9653, 9713, 9728, 11279, 11288, 9656, 11289, 9665, 9685, 9631, 13443, 9640, 9676, 11237, 9720, 9528, 9573, 9700, 11315, 9515, 11346, 9554, 9587, 9449, 9613, 13445, 9661, 9691, 11278, 9649, 9646, 9842, 9699, 11353, 11268, 9636, 13446, 9697, 9682, 9507, 9706, 11282, 9789, 9735, 9658, 11295, 9828, 9692, 9655, 9663, 11298, 9897, 9717, 9670, 9948, 9675, 9654, 11293, 11310, 9652, 11291, 9680, 11273, 11287, 11243, 9711, 9632, 9704, 13447, 9681, 9669)) AND (`Playercontest`.`contest_id` = 1400))	128	128	2
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` = 1981	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 23 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` = '1981' 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` = (1400) 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, 9596, 9701, 9625, 9708, 9455, 11270, 11296, 11302, 9748, 9733, 9660, 9564, 9792, 9671, 9659, 9638, 9703, 9744, 9693, 9532, 9628, 9705, 9679, 9644, 9650, 9533, 12453, 9668, 9635, 9648, 9690, 9582, 9562, 9686, 11304, 11303, 9764, 9694, 9696, 9687, 9688, 9664, 11300, 9695, 9799, 9689, 9626, 9678, 9513, 11290, 9712, 11292, 11321, 13442, 9620, 9606, 9653, 9713, 9728, 11279, 11288, 9656, 11289, 9665, 9685, 9631, 13443, 9640, 9676, 11237, 9720, 9528, 9573, 9700, 11315, 9515, 11346, 9554, 9587, 9449, 9613, 13445, 9661, 9691, 11278, 9649, 9646, 9842, 9699, 11353, 11268, 9636, 13446, 9697, 9682, 9507, 9706, 11282, 9789, 9735, 9658, 11295, 9828, 9692, 9655, 9663, 11298, 9897, 9717, 9670, 9948, 9675, 9654, 11293, 11310, 9652, 11291, 9680, 11273, 11287, 11243, 9711, 9632, 9704, 13447, 9681, 9669) 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` = 1400

130

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

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

SELECT `Playercontest`.`player_id`, `Playercontest`.`nat_id` FROM `zavoihu1_db4tennis`.`playercontests` AS `Playercontest` WHERE ((`Playercontest`.`player_id` IN (9672, 9596, 9701, 9625, 9708, 9455, 11270, 11296, 11302, 9748, 9733, 9660, 9564, 9792, 9671, 9659, 9638, 9703, 9744, 9693, 9532, 9628, 9705, 9679, 9644, 9650, 9533, 12453, 9668, 9635, 9648, 9690, 9582, 9562, 9686, 11304, 11303, 9764, 9694, 9696, 9687, 9688, 9664, 11300, 9695, 9799, 9689, 9626, 9678, 9513, 11290, 9712, 11292, 11321, 13442, 9620, 9606, 9653, 9713, 9728, 11279, 11288, 9656, 11289, 9665, 9685, 9631, 13443, 9640, 9676, 11237, 9720, 9528, 9573, 9700, 11315, 9515, 11346, 9554, 9587, 9449, 9613, 13445, 9661, 9691, 11278, 9649, 9646, 9842, 9699, 11353, 11268, 9636, 13446, 9697, 9682, 9507, 9706, 11282, 9789, 9735, 9658, 11295, 9828, 9692, 9655, 9663, 11298, 9897, 9717, 9670, 9948, 9675, 9654, 11293, 11310, 9652, 11291, 9680, 11273, 11287, 11243, 9711, 9632, 9704, 13447, 9681, 9669)) AND (`Playercontest`.`contest_id` = 1400))

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

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)