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

	Nation		R128	R64	R32	R16	QF	SF	F	Champion
1.		[1]	Chris Evert
				Chris Evert
2.			Chris O'Neil	6-2 6-0
					Chris Evert
3.			Elly Appel		6-1 6-0
				Elly Appel
4.			bye
						Chris Evert
5.			Robin Tenney			6-2 6-2
				Robin Tenney
6.			bye
					Kazuko Sawamatsu
7.			Kazuko Sawamatsu		6-4 6-3
				Kazuko Sawamatsu
8.		[Q]	Laurie Tenney	6-3 6-3
							Chris Evert
9.			Judy Tegart				6-2 6-4
				Judy Tegart
10.			Annette Coe	9-7 6-3
					Lindsey Beaven
11.			Lindsey Beaven		6-3 6-1
				Lindsey Beaven
12.			bye
						Lindsey Beaven
13.			Brigette Cuypers			6-4 6-2
				Brigette Cuypers
14.			bye
					Linda Mottram
15.			Linda Mottram		6-3 6-3
				Linda Mottram
16.		[Q]	Roberta Stark	4-6 6-4 6-0
								Chris Evert
17.		[8]	Kerry Melville					5-7 7-5 6-0
				Kerry Melville
18.			Yelena Granaturova	6-2 2-6 6-4
					Sue Barker
19.			Sue Barker		6-4 1-0 rtd.
				Sue Barker
20.			bye
						Betty Stove
21.			Betsy Nagelsen			6-0 4-6 6-2
				Betsy Nagelsen
22.			bye
					Betty Stove
23.			Betty Stove		7-5 6-1
				Betty Stove
24.			Helena Anliot	6-2 6-8 6-2
							Betty Stove
25.			Winnie Shaw				9-7 6-3
				Winnie Shaw
26.			Lindsay Blachford	3-6 6-1 6-2
					Winnie Shaw
27.			Sharon Walsh		9-7 6-4
				Sharon Walsh
28.			bye
						Winnie Shaw
29.			Peggy Michel			6-4 6-4
				Peggy Michel
30.			Janet Young	6-1 6-0
					Peggy Michel
31.			Lea Pericoli		6-1 6-4
				Lea Pericoli
32.			bye
									Billie Jean King
33.		[3]	Billie Jean King						2-6 6-2 6-3
				Billie Jean King
34.			Elizabeth Truter	6-1 6-4
					Billie Jean King
35.			Veronica Burton		6-1 6-3
				Veronica Burton
36.			bye
						Billie Jean King
37.			Julie Anthony			6-2 6-3
				Julie Anthony
38.			Margareta Strandberg	6-3 6-2
					Julie Anthony
39.			Paulina Peisachov		6-2 6-3
				Paulina Peisachov
40.			bye
							Billie Jean King
41.			Odile De Roubin				6-1 6-2
				Odile De Roubin
42.			bye
					Michele Gurdal
43.			Michele Gurdal		6-0 6-1
				Michele Gurdal
44.		[Q]	Naoko Sato	6-1 6-1
						Michele Gurdal
45.			Valerie Ziegenfuss			6-3 6-3
				Valerie Ziegenfuss
46.			bye
					Valerie Ziegenfuss
47.			Rosie Reyes		8-6 6-3
				Rosie Reyes
48.			Virginia Ruzici	6-8 6-2 9-7
								Billie Jean King
49.		[8]	Olga Morozova					6-3 6-3
				Olga Morozova
50.			bye
					Olga Morozova
51.			Francoise Durr		6-3 4-6 6-1
				Francoise Durr
52.			Mariana Simionescu	6-4 7-5
						Olga Morozova
53.			Tine Zwaan			4-6 9-7 6-1
				Tine Zwaan
54.			Maria Teresa Nasuelli	7-5 6-2
					Kathy May
55.		[Q]	Kathy May		6-1 6-1
				Kathy May
56.			bye
							Olga Morozova
57.			Mima Jausovec				6-4 6-2
				Mima Jausovec
58.			bye
					Mima Jausovec
59.			Pam Teeguarden		3-6 6-1 11-9
				Pam Teeguarden
60.			Donna Ganz	6-2 6-4
						Mima Jausovec
61.			Nathalie Fuchs			6-2 9-7
				Nathalie Fuchs
62.			bye
					Patricia Reese
63.		[Q]	Patricia Reese		0-6 6-2 rtd.
				Patricia Reese
64.			Chris Matison	3-6 6-2 6-1
										Billie Jean King
65.			Lesley Hunt							6-0 6-1
				Lesley Hunt
66.			bye
					Rosie Casals
67.			Rosie Casals		5-7 6-3 8-6
				Rosie Casals
68.			Gail Sherriff	6-2 2-6 6-1
						Rosie Casals
69.			Nancy Richey			6-2 6-1
				Nancy Richey
70.			bye
					Linky Boshoff
71.			Linky Boshoff		3-6 6-2 6-4
				Linky Boshoff
72.			Marie Neumanova	6-0 6-4
							Virginia Wade
73.			Janet Newberry				6-4 4-6 6-4
				Janet Newberry
74.			bye
					Janet Newberry
75.			Lany Kaligis		6-3 6-1
				Lany Kaligis
76.			bye
						Virginia Wade
77.			Iris Riedel			6-2 6-8 8-6
				Iris Riedel
78.			Barbara Downs	5-7 6-0 7-5
					Virginia Wade
79.		[6]	Virginia Wade		6-1 6-3
				Virginia Wade
80.			bye
								Evonne Goolagong
81.		[Q]	Jenny Dimond					5-7 6-3 9-7
				Jenny Dimond
82.			bye
					Jenny Dimond
83.			Jackie Fayter		6-3 6-2
				Jackie Fayter
84.		[Q]	Heidi Eisterlehner	6-2 2-6 7-5
						Jenny Dimond
85.			Cynthia Sieler			6-4 6-4
				Cynthia Sieler
86.			Wendy Gilchrist	8-6 6-0
					Michelle Tyler
87.			Michelle Tyler		0-6 9-7 6-4
				Michelle Tyler
88.			bye
							Evonne Goolagong
89.			Ilana Kloss				6-2 6-4
				Ilana Kloss
90.			bye
					Ilana Kloss
91.			Linda Rupert		6-3 7-5
				Linda Rupert
92.		[LL]	Janet Haas	6-4 6-4
						Evonne Goolagong
93.			Helen Gourlay			6-3 6-2
				Helen Gourlay
94.			Joyce Barclay	7-5 6-4
					Evonne Goolagong
95.		[4]	Evonne Goolagong		3-6 6-1 6-1
				Evonne Goolagong
96.			bye
									Evonne Goolagong
97.			Raquel Giscafre						6-4 6-4
				Raquel Giscafre
98.			bye
					Patti Hogan
99.			Patti Hogan		6-2 2-6 6-2
				Patti Hogan
100.			Ann Kiyomura	6-2 6-2
						Glynis Coles
101.			Glynis Coles			7-5 6-3
				Glynis Coles
102.			bye
					Glynis Coles
103.			Fiorella Bonicelli		7-5 6-4
				Fiorella Bonicelli
104.			Yvonne Vermaak	4-6 6-2 6-0
							Margaret Smith Court
105.			Renata Tomanova				6-2 6-2
				Renata Tomanova
106.			bye
					Renata Tomanova
107.			Judith Connor		6-0 6-2
				Judith Connor
108.			Florence Guedy	6-3 2-6 14-12
						Margaret Smith Court
109.			Sally Greer			6-0 6-0
				Sally Greer
110.			bye
					Margaret Smith Court
111.		[5]	Margaret Smith Court		6-2 6-3
				Margaret Smith Court
112.			Dianne Fromholtz	6-1 6-2
								Margaret Smith Court
113.			Natasha Chmyreva					6-3 6-4
				Natasha Chmyreva
114.			Carolyn Meyer	6-2 6-3
					Natasha Chmyreva
115.		[LL]	Corinne Molesworth		6-0 6-4
				Corinne Molesworth
116.			bye
						Natasha Chmyreva
117.			Rowena Whitehouse			8-6 7-5
				Rowena Whitehouse
118.			Terry Holladay	6-3 6-4
					Lesley Charles
119.			Lesley Charles		6-2 6-4
				Lesley Charles
120.			bye
							Martina Navratilova
121.			Laura DuPont				6-1 6-0
				Laura DuPont
122.			bye
					Greer Stevens
123.			Greer Stevens		8-6 6-1
				Greer Stevens
124.			Ingrid Lofdahl	6-2 6-2
						Martina Navratilova
125.			Sue Mappin			6-4 6-3
				Sue Mappin
126.			bye
					Martina Navratilova
127.		[2]	Martina Navratilova		6-1 6-2
				Martina Navratilova
128.			Wendy Turnbull	6-2 8-6

(default) 17 queries took 20 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	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` = 3 AND `Contest`.`category_id` = 19 AND `Contest`.`slug` = '1975' 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` = (1786) 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, 11237, 11227, 9539, 11231, 9132, 12440, 9553, 11249, 9591, 12443, 9376, 12444, 9554, 9636, 9455, 9552, 9505, 9540, 9515, 9575, 9481, 9414, 9406, 12445, 11226, 11239, 9559, 11238, 11117, 9545, 9620, 11185, 9398, 9638, 9520, 12389, 11215, 12418, 11180, 11256, 9670, 9573, 11235, 9529, 11230, 9525, 9399, 9449, 9363, 9442, 11220, 9660, 9551, 9477, 11245, 11210, 9528, 9572, 9569, 9604, 9467, 9464, 9607, 11254, 12446, 11219, 9391, 11063, 9452, 9423, 9512, 9564, 9533, 9451, 9711, 9606, 9611, 11212, 9588, 9320, 9513, 9585, 11266, 11211, 11250, 9762, 9544, 9587, 9651, 11089, 9577, 9582, 9507) ORDER BY `Player`.`lastname` ASC, `Player`.`firstname` ASC	95	95	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` = 1786	96	96	1
11	SELECT `Countrycode`.`id`, `Countrycode`.`code` FROM `zavoihu1_db4tennis`.`countrycodes` AS `Countrycode` WHERE `Countrycode`.`id` IN (178, 197, 133, 196, 198, 172, 135, 218, 68, 13, 213, 10, 21, 219, 87, 92, 217, 84, 91, 212, 153, 94)	22	22	1
12	SELECT `Countrycode`.`id`, `Countrycode`.`name` FROM `zavoihu1_db4tennis`.`countrycodes` AS `Countrycode` WHERE `Countrycode`.`id` IN (178, 197, 133, 196, 198, 172, 135, 218, 68, 13, 213, 10, 21, 219, 87, 92, 217, 84, 91, 212, 153, 94)	22	22	1
13	SELECT `Playercontest`.`player_id`, `Playercontest`.`nat_id` FROM `zavoihu1_db4tennis`.`playercontests` AS `Playercontest` WHERE ((`Playercontest`.`player_id` IN (9672, 9571, 11237, 11227, 9539, 11231, 9132, 12440, 9553, 11249, 9591, 12443, 9376, 12444, 9554, 9636, 9455, 9552, 9505, 9540, 9515, 9575, 9481, 9414, 9406, 12445, 11226, 11239, 9559, 11238, 11117, 9545, 9620, 11185, 9398, 9638, 9520, 12389, 11215, 12418, 11180, 11256, 9670, 9573, 11235, 9529, 11230, 9525, 9399, 9449, 9363, 9442, 11220, 9660, 9551, 9477, 11245, 11210, 9528, 9572, 9569, 9604, 9467, 9464, 9607, 11254, 12446, 11219, 9391, 11063, 9452, 9423, 9512, 9564, 9533, 9451, 9711, 9606, 9611, 11212, 9588, 9320, 9513, 9585, 11266, 11211, 11250, 9762, 9544, 9587, 9651, 11089, 9577, 9582, 9507)) AND (`Playercontest`.`contest_id` = 1786))	95	95	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` = 1975	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	0
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 20 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` = '1975' 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` = (1786) 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, 11237, 11227, 9539, 11231, 9132, 12440, 9553, 11249, 9591, 12443, 9376, 12444, 9554, 9636, 9455, 9552, 9505, 9540, 9515, 9575, 9481, 9414, 9406, 12445, 11226, 11239, 9559, 11238, 11117, 9545, 9620, 11185, 9398, 9638, 9520, 12389, 11215, 12418, 11180, 11256, 9670, 9573, 11235, 9529, 11230, 9525, 9399, 9449, 9363, 9442, 11220, 9660, 9551, 9477, 11245, 11210, 9528, 9572, 9569, 9604, 9467, 9464, 9607, 11254, 12446, 11219, 9391, 11063, 9452, 9423, 9512, 9564, 9533, 9451, 9711, 9606, 9611, 11212, 9588, 9320, 9513, 9585, 11266, 11211, 11250, 9762, 9544, 9587, 9651, 11089, 9577, 9582, 9507) 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` = 1786

SELECT `Countrycode`.`id`, `Countrycode`.`code` FROM `zavoihu1_db4tennis`.`countrycodes` AS `Countrycode` WHERE `Countrycode`.`id` IN (178, 197, 133, 196, 198, 172, 135, 218, 68, 13, 213, 10, 21, 219, 87, 92, 217, 84, 91, 212, 153, 94)

SELECT `Countrycode`.`id`, `Countrycode`.`name` FROM `zavoihu1_db4tennis`.`countrycodes` AS `Countrycode` WHERE `Countrycode`.`id` IN (178, 197, 133, 196, 198, 172, 135, 218, 68, 13, 213, 10, 21, 219, 87, 92, 217, 84, 91, 212, 153, 94)

SELECT `Playercontest`.`player_id`, `Playercontest`.`nat_id` FROM `zavoihu1_db4tennis`.`playercontests` AS `Playercontest` WHERE ((`Playercontest`.`player_id` IN (9672, 9571, 11237, 11227, 9539, 11231, 9132, 12440, 9553, 11249, 9591, 12443, 9376, 12444, 9554, 9636, 9455, 9552, 9505, 9540, 9515, 9575, 9481, 9414, 9406, 12445, 11226, 11239, 9559, 11238, 11117, 9545, 9620, 11185, 9398, 9638, 9520, 12389, 11215, 12418, 11180, 11256, 9670, 9573, 11235, 9529, 11230, 9525, 9399, 9449, 9363, 9442, 11220, 9660, 9551, 9477, 11245, 11210, 9528, 9572, 9569, 9604, 9467, 9464, 9607, 11254, 12446, 11219, 9391, 11063, 9452, 9423, 9512, 9564, 9533, 9451, 9711, 9606, 9611, 11212, 9588, 9320, 9513, 9585, 11266, 11211, 11250, 9762, 9544, 9587, 9651, 11089, 9577, 9582, 9507)) AND (`Playercontest`.`contest_id` = 1786))

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

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)