Wimbledon 1969 Ladies' Singles (June 23 - July 4)

	Nation		R128	R64	R32	R16	QF	SF	F	Champion
1.		[1]	Margaret Smith Court
				Margaret Smith Court
2.			bye
					Margaret Smith Court
3.			Betty Ann Grubb		6-4 6-0
				Betty Ann Grubb
4.			bye
						Margaret Smith Court
5.			Helen Gourlay			6-1 6-0
				Helen Gourlay
6.			bye
					Helen Gourlay
7.			Betty Stove		4-6 6-3 6-4
				Betty Stove
8.			bye
							Margaret Smith Court
9.			Alena Palmeova				6-2 6-0
				Alena Palmeova
10.			bye
					Alena Palmeova
11.			Christiane Spinoza		3-6 8-6 7-5
				Christiane Spinoza
12.			bye
						Christine Truman
13.			Christine Truman			6-1 6-1
				Christine Truman
14.			bye
					Christine Truman
15.			Esme Emmanuel		6-3 5-7 6-1
				Esme Emmanuel
16.			bye
								Margaret Smith Court
17.		[7]	Julie Heldman					4-6 6-3 6-3
				Julie Heldman
18.			bye
					Julie Heldman
19.			Jill Cooper		6-2 6-2
				Jill Cooper
20.			bye
						Julie Heldman
21.			Denise Carter			6-2 6-3
				Denise Carter
22.			bye
					Denise Carter
23.			Faye Urban		4-6 6-2 6-2
				Faye Urban
24.			bye
							Julie Heldman
25.			Olga Morozova				6-4 6-3
				Olga Morozova
26.			bye
					Olga Morozova
27.		[LL]	Tine Zwaan		6-3 6-4
				Tine Zwaan
28.			bye
						Olga Morozova
29.			Maryna Godwin			6-3 1-6 6-4
				Maryna Godwin
30.			bye
					Maryna Godwin
31.			Graciela Moran		6-3 6-0
				Graciela Moran
32.			bye
									Ann Haydon Jones
33.		[4]	Ann Haydon Jones						4-6 6-3 6-3
				Ann Haydon Jones
34.			Carmen Coronado	6-0 6-1
					Ann Haydon Jones
35.			Susan Tutt		6-0 6-1
				Susan Tutt
36.		[Q]	Marian Boundy	6-2 6-0
						Ann Haydon Jones
37.		[LL]	Joan Wilshere			6-1 6-2
				Joan Wilshere
38.			Brenda Kirk	6-3 2-6 6-4
					Rosie Reyes
39.			Rosie Reyes		6-1 2-6 6-1
				Rosie Reyes
40.			Raquel Giscafre	6-1 6-2
							Ann Haydon Jones
41.			Anita Van Deventer				6-0 9-7
				Anita Van Deventer
42.			Corinne Molesworth	6-2 6-4
					Anita Van Deventer
43.		[LL]	Lita Liem		6-0 2-6 8-6
				Lita Liem
44.		[Q]	Wendy Hall	6-3 6-4
						Peggy Michel
45.			Christina Sandberg			6-4 6-2
				Christina Sandberg
46.			Frances MacLennan	9-7 6-1
					Peggy Michel
47.			Peggy Michel		6-3 6-0
				Peggy Michel
48.			Lesley Hunt	6-1 6-4
								Ann Haydon Jones
49.		[5]	Nancy Richey					6-2 7-5
				Nancy Richey
50.			Brigitta Lindstrom	6-1 6-1
					Nancy Richey
51.			Wendy Tomlinson		6-3 6-4
				Wendy Tomlinson
52.			Janet Young	2-6 9-7 6-3
						Nancy Richey
53.			Jane Bartkowicz			6-4 8-6
				Jane Bartkowicz
54.			Lucia Bassi	6-1 6-2
					Jane Bartkowicz
55.			Joyce Barclay		6-2 6-0
				Joyce Barclay
56.			Sally Holdsworth	6-1 6-1
							Nancy Richey
57.			Shirley Bloomer				4-6 6-3 7-5
				Shirley Bloomer
58.			Maria Guzman	6-1 6-4
					Karen Krantzcke
59.			Karen Krantzcke		6-1 6-4
				Karen Krantzcke
60.			Kazuko Sawamatsu	11-9 6-4
						Karen Krantzcke
61.			Marijke Jansen			6-0 6-0
				Marijke Jansen
62.			Robin Blakelock	6-4 3-6 6-4
					Pam Teeguarden
63.		[Q]	Pam Teeguarden		2-6 6-4 6-1
				Pam Teeguarden
64.			Marilyn Aschner	6-3 6-2
										Ann Haydon Jones
65.			Helen Amos							3-6 6-3 6-2
				Helen Amos
66.			Alex Cowie	6-2 6-4
					Helen Amos
67.			Suzana Petersen		6-4 3-6 6-4
				Suzana Petersen
68.			Eva Lundqvist	6-4 7-9 6-2
						Kerry Harris
69.			Kerry Harris			6-1 6-0
				Kerry Harris
70.			Stephanie Grant	9-7 2-6 6-1
					Kerry Harris
71.			Tory Fretz		6-4 3-6 7-5
				Tory Fretz
72.			Carol Sherriff	6-0 6-1
							Rosie Casals
73.			Francoise Durr				6-2 6-2
				Francoise Durr
74.			Janice Townsend	6-2 6-3
					Julie Anthony
75.		[Q]	Julie Anthony		0-6 6-3 6-4
				Julie Anthony
76.			Judith Salome	6-1 6-0
						Rosie Casals
77.			Rosie Casals			6-1 6-3
				Rosie Casals
78.			Valerie Ziegenfuss	6-1 7-5
					Rosie Casals
79.		[6]	Kerry Melville		6-2 7-5
				Kerry Melville
80.			Laura Rossouw	6-0 6-2
								Rosie Casals
81.			Gail Sherriff					3-6 9-7 7-5
				Gail Sherriff
82.			Anna Maria Estalella	6-0 6-1
					Mary-Ann Eisel
83.			Mary-Ann Eisel		7-5 6-2
				Mary-Ann Eisel
84.			Maria Teresa Riedl	6-3 6-1
						Lesley Turner
85.			Lesley Turner			8-10 6-4 6-2
				Lesley Turner
86.		[LL]	Elizabeth Ernest	6-4 8-6
					Lesley Turner
87.			Astrid Suurbeek		6-1 6-3
				Astrid Suurbeek
88.			Ana-Maria Arias	6-1 4-6 6-1
							Lesley Turner
89.			Patricia Walkden				6-3 1-6 8-6
				Patricia Walkden
90.			Cecilia Martinez	8-6 6-1
					Patricia Walkden
91.			Patti Hogan		6-4 7-5
				Patti Hogan
92.		[LL]	Lany Kaligis	6-2 6-3
						Patricia Walkden
93.			Fay Toyne			7-5 6-1
				Fay Toyne
94.			Kerstin Seelbach	6-3 6-3
					Virginia Wade
95.		[3]	Virginia Wade		6-1 6-2
				Virginia Wade
96.			Linda Tuero	6-4 6-4
									Billie Jean King
97.			Wendy Gilchrist						6-1 6-0
				Wendy Gilchrist
98.			bye
					Wendy Gilchrist
99.			Ada Bakker		6-3 5-7 9-7
				Ada Bakker
100.			bye
						Nell Truman
101.			Judy Congdon			3-6 6-4 6-1
				Judy Congdon
102.			bye
					Nell Truman
103.			Nell Truman		6-1 6-2
				Nell Truman
104.			bye
							Judy Tegart
105.			Winnie Shaw				6-4 6-4
				Winnie Shaw
106.			bye
					Winnie Shaw
107.			Ingrid Loeys		6-1 6-1
				Ingrid Loeys
108.			bye
						Judy Tegart
109.			Vlasta Kodesova			6-0 7-5
				Vlasta Kodesova
110.			bye
					Judy Tegart
111.		[8]	Judy Tegart		6-1 6-0
				Judy Tegart
112.			bye
								Billie Jean King
113.			Marina Chuvyrina					4-6 7-5 8-6
				Marina Chuvyrina
114.			bye
					Kristy Pigeon
115.			Kristy Pigeon		6-2 6-2
				Kristy Pigeon
116.			bye
						Kristy Pigeon
117.			Carole Caldwell			4-6 6-1 6-2
				Carole Caldwell
118.			bye
					Lea Pericoli
119.			Lea Pericoli		6-1 6-3
				Lea Pericoli
120.			bye
							Billie Jean King
121.			Marianna Brummer				6-0 6-4
				Marianna Brummer
122.			bye
					Marianna Brummer
123.			Evelyne Terras		6-4 4-6 7-5
				Evelyne Terras
124.			bye
						Billie Jean King
125.			Bernice Carr			6-0 6-4
				Bernice Carr
126.			bye
					Billie Jean King
127.		[2]	Billie Jean King		6-2 6-1
				Billie Jean King
128.			bye

(default) 17 queries took 27 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	5
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	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` = '1969' 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` = (1780) 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 (9320, 11278, 9391, 9455, 11136, 11057, 9325, 11099, 9561, 11189, 11191, 11107, 9520, 12418, 11111, 11127, 9412, 11014, 12405, 12223, 12419, 11177, 9398, 9423, 11146, 11211, 9463, 12411, 9503, 11047, 9575, 9399, 9442, 11173, 11192, 9481, 11178, 10980, 11063, 11074, 10880, 11113, 9393, 9539, 11195, 11053, 9573, 12415, 9439, 12425, 11168, 11106, 9458, 12420, 11062, 9356, 12389, 12412, 11239, 9475, 9449, 11185, 9376, 11129, 9363, 11021, 9482, 11017, 9312, 12421, 9486, 11175, 11077, 9599, 9512, 9477, 9337, 11132, 9528, 11179, 9464, 9471, 11171, 11068, 9505, 11123, 11088, 9132, 12422, 11184, 9397, 9414, 11196, 9456, 9415, 9406) 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` = 1780	97	97	1
11	SELECT `Countrycode`.`id`, `Countrycode`.`code` FROM `zavoihu1_db4tennis`.`countrycodes` AS `Countrycode` WHERE `Countrycode`.`id` IN (13, 197, 41, 133, 196, 92, 172, 218, 173, 68, 10, 58, 87, 217, 67, 21, 178, 29, 94, 212, 36)	21	21	1
12	SELECT `Countrycode`.`id`, `Countrycode`.`name` FROM `zavoihu1_db4tennis`.`countrycodes` AS `Countrycode` WHERE `Countrycode`.`id` IN (13, 197, 41, 133, 196, 92, 172, 218, 173, 68, 10, 58, 87, 217, 67, 21, 178, 29, 94, 212, 36)	21	21	1
13	SELECT `Playercontest`.`player_id`, `Playercontest`.`nat_id` FROM `zavoihu1_db4tennis`.`playercontests` AS `Playercontest` WHERE ((`Playercontest`.`player_id` IN (9320, 11278, 9391, 9455, 11136, 11057, 9325, 11099, 9561, 11189, 11191, 11107, 9520, 12418, 11111, 11127, 9412, 11014, 12405, 12223, 12419, 11177, 9398, 9423, 11146, 11211, 9463, 12411, 9503, 11047, 9575, 9399, 9442, 11173, 11192, 9481, 11178, 10980, 11063, 11074, 10880, 11113, 9393, 9539, 11195, 11053, 9573, 12415, 9439, 12425, 11168, 11106, 9458, 12420, 11062, 9356, 12389, 12412, 11239, 9475, 9449, 11185, 9376, 11129, 9363, 11021, 9482, 11017, 9312, 12421, 9486, 11175, 11077, 9599, 9512, 9477, 9337, 11132, 9528, 11179, 9464, 9471, 11171, 11068, 9505, 11123, 11088, 9132, 12422, 11184, 9397, 9414, 11196, 9456, 9415, 9406)) AND (`Playercontest`.`contest_id` = 1780))	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` = 1969	20	20	1
16	SELECT `Category`.`id`, `Category`.`tournament_id` FROM `zavoihu1_db4tennis`.`categories` AS `Category` WHERE `Category`.`id` IN (2, 3, 1, 12, 17, 22, 13, 18, 23, 4, 7, 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 27 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` = '1969' 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` = (1780) 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 (9320, 11278, 9391, 9455, 11136, 11057, 9325, 11099, 9561, 11189, 11191, 11107, 9520, 12418, 11111, 11127, 9412, 11014, 12405, 12223, 12419, 11177, 9398, 9423, 11146, 11211, 9463, 12411, 9503, 11047, 9575, 9399, 9442, 11173, 11192, 9481, 11178, 10980, 11063, 11074, 10880, 11113, 9393, 9539, 11195, 11053, 9573, 12415, 9439, 12425, 11168, 11106, 9458, 12420, 11062, 9356, 12389, 12412, 11239, 9475, 9449, 11185, 9376, 11129, 9363, 11021, 9482, 11017, 9312, 12421, 9486, 11175, 11077, 9599, 9512, 9477, 9337, 11132, 9528, 11179, 9464, 9471, 11171, 11068, 9505, 11123, 11088, 9132, 12422, 11184, 9397, 9414, 11196, 9456, 9415, 9406) 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` = 1780

SELECT `Countrycode`.`id`, `Countrycode`.`code` FROM `zavoihu1_db4tennis`.`countrycodes` AS `Countrycode` WHERE `Countrycode`.`id` IN (13, 197, 41, 133, 196, 92, 172, 218, 173, 68, 10, 58, 87, 217, 67, 21, 178, 29, 94, 212, 36)

SELECT `Countrycode`.`id`, `Countrycode`.`name` FROM `zavoihu1_db4tennis`.`countrycodes` AS `Countrycode` WHERE `Countrycode`.`id` IN (13, 197, 41, 133, 196, 92, 172, 218, 173, 68, 10, 58, 87, 217, 67, 21, 178, 29, 94, 212, 36)

SELECT `Playercontest`.`player_id`, `Playercontest`.`nat_id` FROM `zavoihu1_db4tennis`.`playercontests` AS `Playercontest` WHERE ((`Playercontest`.`player_id` IN (9320, 11278, 9391, 9455, 11136, 11057, 9325, 11099, 9561, 11189, 11191, 11107, 9520, 12418, 11111, 11127, 9412, 11014, 12405, 12223, 12419, 11177, 9398, 9423, 11146, 11211, 9463, 12411, 9503, 11047, 9575, 9399, 9442, 11173, 11192, 9481, 11178, 10980, 11063, 11074, 10880, 11113, 9393, 9539, 11195, 11053, 9573, 12415, 9439, 12425, 11168, 11106, 9458, 12420, 11062, 9356, 12389, 12412, 11239, 9475, 9449, 11185, 9376, 11129, 9363, 11021, 9482, 11017, 9312, 12421, 9486, 11175, 11077, 9599, 9512, 9477, 9337, 11132, 9528, 11179, 9464, 9471, 11171, 11068, 9505, 11123, 11088, 9132, 12422, 11184, 9397, 9414, 11196, 9456, 9415, 9406)) AND (`Playercontest`.`contest_id` = 1780))

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

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