Wimbledon 1981 Ladies' Singles (June 22 - July 3)

	Nation		R128	R64	R32	R16	QF	SF	F	Champion
1.		[1]	Chris Evert
				Chris Evert
2.		[Q]	Chris O'Neil	6-3 6-0
					Chris Evert
3.			Yvonne Vermaak		6-1 6-2
				Yvonne Vermaak
4.			bye
						Chris Evert
5.			Kim Sands			6-2 7-6
				Kim Sands
6.			Susie Jaeger	6-1 6-2
					Lele Forood
7.			Lele Forood		6-1 7-5
				Lele Forood
8.			bye
							Chris Evert
9.			Kathy Rinaldi				6-0 6-0
				Kathy Rinaldi
10.			Susan Rollinson	6-3 2-6 9-7
					Claudia Pasquale
11.		[Q]	Claudia Pasquale		3-6 6-0 6-0
				Claudia Pasquale
12.			bye
						Claudia Pasquale
13.			Petra Delhees			3-6 6-2 7-5
				Petra Delhees
14.			Lesley Charles	7-5 7-6
					Dianne Fromholtz
15.		[11]	Dianne Fromholtz		7-6 6-4
				Dianne Fromholtz
16.			bye
								Chris Evert
17.		[10]	Mima Jausovec					6-2 6-3
				Mima Jausovec
18.			Mareen Louie	0-6 6-2 6-4
					Mima Jausovec
19.		[Q]	Christiane Jolissaint		6-3 6-3
				Christiane Jolissaint
20.			bye
						Mima Jausovec
21.			Rene Blount			6-2 7-5
				Rene Blount
22.			bye
					Rene Blount
23.			Tanya Harford		2-6 7-6 6-3
				Tanya Harford
24.			Anne White	6-2 6-4
							Mima Jausovec
25.			Leslie Allen				6-4 7-6
				Leslie Allen
26.			Anthea Cooper	6-1 6-3
					Leslie Allen
27.			Marie Neumanova		4-6 6-2 6-1
				Marie Neumanova
28.			bye
						Andrea Jaeger
29.			Betty Stove			6-1 6-2
				Betty Stove
30.			bye
					Andrea Jaeger
31.		[5]	Andrea Jaeger		4-6 6-4 6-3
				Andrea Jaeger
32.			Nerida Gregory	6-1 6-1
									Chris Evert
33.		[3]	Tracy Austin						6-3 6-1
				Tracy Austin
34.		[LL]	Jennifer Mundel	6-0 6-2
					Tracy Austin
35.			Lea Antonoplis		6-1 6-1
				Lea Antonoplis
36.			bye
						Tracy Austin
37.		[Q]	Glaucia Langela			6-4 7-6
				Glaucia Langela
38.			bye
					Susan Leo
39.			Susan Leo		6-1 4-6 6-2
				Susan Leo
40.			Ivanna Madruga	6-3 2-6 6-4
							Tracy Austin
41.			Sue Saliba				6-4 6-0
				Sue Saliba
42.			bye
					Sandra Collins
43.			Sandra Collins		6-3 6-1
				Sandra Collins
44.			Rosie Casals	6-3 6-2
						Barbara Potter
45.			Claudia Kohde-Kilsch			6-4 6-1
				Claudia Kohde-Kilsch
46.			Ann Kiyomura	6-3 6-0
					Barbara Potter
47.		[14]	Barbara Potter		6-4 7-6
				Barbara Potter
48.			bye
								Pam Shriver
49.			Lucia Romanov					7-5 6-4
				Lucia Romanov
50.		[15]	Regina Marsikova	5-7 6-1 6-3
					Jo Durie
51.			Jo Durie		3-6 6-4 6-3
				Jo Durie
52.			bye
						Jo Durie
53.			Pam Casale			7-5 6-2
				Pam Casale
54.			Kate Brasher	7-5 6-3
					Wendy White
55.			Wendy White		3-6 7-5 6-3
				Wendy White
56.			bye
							Pam Shriver
57.			Paula Smith				6-3 6-4
				Paula Smith
58.			bye
					Glynis Coles
59.			Glynis Coles		3-6 6-0 6-4
				Glynis Coles
60.			Terry Holladay	7-5 6-4
						Pam Shriver
61.		[Q]	Elizabeth Little			6-0 6-3
				Elizabeth Little
62.			bye
					Pam Shriver
63.		[7]	Pam Shriver		6-0 6-3
				Pam Shriver
64.			Elizabeth Ekblom	3-6 6-1 6-2
										Chris Evert
65.		[8]	Virginia Ruzici							6-2 6-2
				Virginia Ruzici
66.			Kathleen Cummings	6-3 6-4
					Virginia Ruzici
67.		[Q]	Mimi Wikstedt		4-6 7-6 6-4
				Mimi Wikstedt
68.			bye
						Virginia Ruzici
69.			Nina Bohm			3-6 7-6 8-6
				Nina Bohm
70.			Stacy Margolin	6-0 6-7 6-3
					Nina Bohm
71.			Heidi Eisterlehner		7-6 4-6 6-2
				Heidi Eisterlehner
72.			bye
							Virginia Ruzici
73.			Hana Strachonova				3-6 6-4 6-3
				Hana Strachonova
74.			Claudia Casabianca	6-1 6-4
					Sherry Acker
75.			Sherry Acker		4-6 6-1 6-4
				Sherry Acker
76.			bye
						Kathy Jordan
77.		[Q]	Marcella Mesker			6-3 6-4
				Marcella Mesker
78.			Kim Jones	6-2 6-3
					Kathy Jordan
79.		[12]	Kathy Jordan		6-4 6-3
				Kathy Jordan
80.			bye
								Martina Navratilova
81.		[13]	Bettina Bunge					6-2 6-3
				Bettina Bunge
82.			bye
					Sue Barker
83.			Sue Barker		6-7 6-3 6-3
				Sue Barker
84.			Marjorie Blackwood	3-6 6-2 6-3
						Betsy Nagelsen
85.			Betsy Nagelsen			2-6 6-2 6-3
				Betsy Nagelsen
86.			Isabelle Bianchi	6-2 6-1
					Betsy Nagelsen
87.		[Q]	Elizabeth Gordon		6-0 2-6 6-2
				Elizabeth Gordon
88.			bye
							Martina Navratilova
89.			Liz Sayers				6-3 6-1
				Liz Sayers
90.			bye
					Sharon Walsh
91.			Sharon Walsh		7-5 6-3
				Sharon Walsh
92.			Beth Norton	6-2 7-6
						Martina Navratilova
93.			Susan Mascarin			6-1 2-6 6-0
				Susan Mascarin
94.			bye
					Martina Navratilova
95.		[4]	Martina Navratilova		6-0 6-1
				Martina Navratilova
96.			Joyce Portman	6-4 6-0
									Hana Mandlikova
97.		[6]	Wendy Turnbull						7-5 4-6 6-1
				Wendy Turnbull
98.			Diane Desfor	7-5 6-3
					Wendy Turnbull
99.			Deborah Jevans		6-2 6-2
				Deborah Jevans
100.			bye
						Wendy Turnbull
101.			Duk-Hee Lee			6-3 6-2
				Duk-Hee Lee
102.			bye
					Rosalyn Fairbank
103.			Rosalyn Fairbank		6-3 6-1
				Rosalyn Fairbank
104.			Candy Reynolds	6-2 3-6 6-3
							Wendy Turnbull
105.			Eva Pfaff				6-4 6-1
				Eva Pfaff
106.			Debbie Freeman	6-3 6-3
					Renata Tomanova
107.			Renata Tomanova		6-2 1-6 6-2
				Renata Tomanova
108.			bye
						Pam Teeguarden
109.			Laura DuPont			6-4 6-3
				Laura DuPont
110.			bye
					Pam Teeguarden
111.			Pam Teeguarden		6-3 3-6 6-4
				Pam Teeguarden
112.		[16]	JoAnne Russell	6-2 6-7 11-9
								Hana Mandlikova
113.			Mary Lou Piatek					6-0 6-0
				Mary Lou Piatek
114.		[9]	Sylvia Hanika	6-4 7-5
					Mary Lou Piatek
115.			Lindsay Morse		7-6 6-1
				Lindsay Morse
116.			bye
						Anne Hobbs
117.			Anne Hobbs			7-6 1-6 7-5
				Anne Hobbs
118.			Iris Riedel	6-1 6-1
					Anne Hobbs
119.			Virginia Wade		6-1 7-6
				Virginia Wade
120.			bye
							Hana Mandlikova
121.			Andrea Buchanan				6-3 6-2
				Andrea Buchanan
122.			bye
					Andrea Buchanan
123.			Barbara Hallquist		0-6 6-3 6-3
				Barbara Hallquist
124.			Elly Appel	3-6 6-4 6-3
						Hana Mandlikova
125.			Anne Smith			6-3 6-0
				Anne Smith
126.			bye
					Hana Mandlikova
127.		[2]	Hana Mandlikova		6-1 6-4
				Hana Mandlikova
128.			Corinne Vanier	6-3 7-5

(default) 17 queries took 34 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` = '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` = (1792) 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, 9571, 9711, 9635, 12458, 9653, 9717, 11293, 11304, 9710, 9544, 9513, 9670, 11270, 9657, 9631, 9664, 9686, 9688, 12449, 9660, 9455, 9681, 9562, 9697, 9700, 9693, 12460, 9628, 11269, 9625, 9748, 9449, 9654, 9564, 9675, 11282, 9613, 9692, 9842, 11310, 9703, 9680, 9533, 9762, 9626, 9656, 9608, 9638, 11346, 9574, 9605, 11288, 9604, 9662, 11265, 9691, 9640, 9733, 9689, 9671, 9554, 9694, 9636, 9683, 12461, 9661, 9515, 9632, 9705, 9582, 11292, 9507, 9655, 11296, 9532, 9658, 9668, 9828, 11291, 9606, 9587, 9573, 11303, 9690, 9665, 9652, 9682, 11245, 9528, 11295, 9663, 11237, 9678, 9648, 9687) ORDER BY `Player`.`lastname` ASC, `Player`.`firstname` ASC	96	96	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` = 1792	97	97	2
11	SELECT `Countrycode`.`id`, `Countrycode`.`code` FROM `zavoihu1_db4tennis`.`countrycodes` AS `Countrycode` WHERE `Countrycode`.`id` IN (197, 133, 196, 36, 178, 212, 10, 179, 213, 172, 13, 219, 29, 100, 217, 153, 68, 84)	18	18	1
12	SELECT `Countrycode`.`id`, `Countrycode`.`name` FROM `zavoihu1_db4tennis`.`countrycodes` AS `Countrycode` WHERE `Countrycode`.`id` IN (197, 133, 196, 36, 178, 212, 10, 179, 213, 172, 13, 219, 29, 100, 217, 153, 68, 84)	18	18	1
13	SELECT `Playercontest`.`player_id`, `Playercontest`.`nat_id` FROM `zavoihu1_db4tennis`.`playercontests` AS `Playercontest` WHERE ((`Playercontest`.`player_id` IN (9672, 9571, 9711, 9635, 12458, 9653, 9717, 11293, 11304, 9710, 9544, 9513, 9670, 11270, 9657, 9631, 9664, 9686, 9688, 12449, 9660, 9455, 9681, 9562, 9697, 9700, 9693, 12460, 9628, 11269, 9625, 9748, 9449, 9654, 9564, 9675, 11282, 9613, 9692, 9842, 11310, 9703, 9680, 9533, 9762, 9626, 9656, 9608, 9638, 11346, 9574, 9605, 11288, 9604, 9662, 11265, 9691, 9640, 9733, 9689, 9671, 9554, 9694, 9636, 9683, 12461, 9661, 9515, 9632, 9705, 9582, 11292, 9507, 9655, 11296, 9532, 9658, 9668, 9828, 11291, 9606, 9587, 9573, 11303, 9690, 9665, 9652, 9682, 11245, 9528, 11295, 9663, 11237, 9678, 9648, 9687)) AND (`Playercontest`.`contest_id` = 1792))	96	96	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` = 1981	19	19	12
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 34 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` = '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` = (1792) 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, 9571, 9711, 9635, 12458, 9653, 9717, 11293, 11304, 9710, 9544, 9513, 9670, 11270, 9657, 9631, 9664, 9686, 9688, 12449, 9660, 9455, 9681, 9562, 9697, 9700, 9693, 12460, 9628, 11269, 9625, 9748, 9449, 9654, 9564, 9675, 11282, 9613, 9692, 9842, 11310, 9703, 9680, 9533, 9762, 9626, 9656, 9608, 9638, 11346, 9574, 9605, 11288, 9604, 9662, 11265, 9691, 9640, 9733, 9689, 9671, 9554, 9694, 9636, 9683, 12461, 9661, 9515, 9632, 9705, 9582, 11292, 9507, 9655, 11296, 9532, 9658, 9668, 9828, 11291, 9606, 9587, 9573, 11303, 9690, 9665, 9652, 9682, 11245, 9528, 11295, 9663, 11237, 9678, 9648, 9687) ORDER BY `Player`.`lastname` ASC, `Player`.`firstname` ASC

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

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

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

SELECT `Playercontest`.`player_id`, `Playercontest`.`nat_id` FROM `zavoihu1_db4tennis`.`playercontests` AS `Playercontest` WHERE ((`Playercontest`.`player_id` IN (9672, 9571, 9711, 9635, 12458, 9653, 9717, 11293, 11304, 9710, 9544, 9513, 9670, 11270, 9657, 9631, 9664, 9686, 9688, 12449, 9660, 9455, 9681, 9562, 9697, 9700, 9693, 12460, 9628, 11269, 9625, 9748, 9449, 9654, 9564, 9675, 11282, 9613, 9692, 9842, 11310, 9703, 9680, 9533, 9762, 9626, 9656, 9608, 9638, 11346, 9574, 9605, 11288, 9604, 9662, 11265, 9691, 9640, 9733, 9689, 9671, 9554, 9694, 9636, 9683, 12461, 9661, 9515, 9632, 9705, 9582, 11292, 9507, 9655, 11296, 9532, 9658, 9668, 9828, 11291, 9606, 9587, 9573, 11303, 9690, 9665, 9652, 9682, 11245, 9528, 11295, 9663, 11237, 9678, 9648, 9687)) AND (`Playercontest`.`contest_id` = 1792))

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