Wimbledon 1974 Ladies' Singles (June 24 - July 5)

	Nation		R128	R64	R32	R16	QF	SF	F	Champion
1.		[1]	Billie Jean King
				Billie Jean King
2.			bye
					Billie Jean King
3.			Kathy May		6-1 6-1
				Kathy May
4.			bye
						Billie Jean King
5.			Mariana Simionescu			6-1 7-5
				Mariana Simionescu
6.			bye
					Francoise Durr
7.			Francoise Durr		6-2 6-0
				Francoise Durr
8.			bye
							Billie Jean King
9.			Christine Truman				6-3 6-0
				Christine Truman
10.			bye
					Christine Truman
11.			Virginia Ruzici		6-4 6-2
				Virginia Ruzici
12.			bye
						Lesley Charles
13.			Elvira Weisenberger			4-6 6-3 6-0
				Elvira Weisenberger
14.			bye
					Lesley Charles
15.			Lesley Charles		6-8 6-4 6-2
				Lesley Charles
16.			bye
								Olga Morozova
17.		[8]	Olga Morozova					7-5 6-2
				Olga Morozova
18.			bye
					Olga Morozova
19.			Shirley Bloomer		6-1 6-0
				Shirley Bloomer
20.			bye
						Olga Morozova
21.			Wendy Gilchrist			2-6 6-0 9-7
				Wendy Gilchrist
22.			bye
					Wendy Gilchrist
23.			Ingrid Lofdahl		6-3 6-2
				Ingrid Lofdahl
24.			bye
							Olga Morozova
25.			Winnie Shaw				9-7 6-4
				Winnie Shaw
26.			bye
					Winnie Shaw
27.		[Q]	Nerida Gregory		6-0 6-0
				Nerida Gregory
28.			bye
						Karen Krantzcke
29.			Karen Krantzcke			6-2 9-7
				Karen Krantzcke
30.			bye
					Karen Krantzcke
31.			Laura Rossouw		6-0 6-3
				Laura Rossouw
32.			bye
									Olga Morozova
33.		[4]	Rosie Casals						1-6 7-5 6-4
				Rosie Casals
34.			Penny Moor	6-2 6-1
					Rosie Casals
35.			Pam Teeguarden		6-2 9-8
				Pam Teeguarden
36.		[Q]	Helena Anliot	8-6 6-2
						Rosie Casals
37.			Sue Mappin			6-3 6-4
				Sue Mappin
38.			Christina Sandberg	9-8 6-1
					Mima Jausovec
39.		[Q]	Mima Jausovec		6-4 6-1
				Mima Jausovec
40.			Martina Navratilova	6-4 3-6 6-3
							Linky Boshoff
41.			Michele Gurdal				6-2 6-3
				Michele Gurdal
42.			Vlasta Kodesova	w/o
					Linky Boshoff
43.			Linky Boshoff		6-3 7-5
				Linky Boshoff
44.			Sue Barker	6-0 9-7
						Linky Boshoff
45.			Helen Gourlay			6-3 5-7 9-7
				Helen Gourlay
46.			Peggy Michel	6-4 7-5
					Helen Gourlay
47.			Renata Tomanova		6-4 6-2
				Renata Tomanova
48.			Lindsay Blachford	6-2 3-6 6-3
								Virginia Wade
49.		[5]	Virginia Wade					6-3 6-2
				Virginia Wade
50.			Veronica Burton	6-0 6-0
					Virginia Wade
51.			Julie Anthony		7-5 6-3
				Julie Anthony
52.			Odile De Roubin	6-0 6-3
						Virginia Wade
53.			Betsy Nagelsen			6-3 6-2
				Betsy Nagelsen
54.		[Q]	Laurie Tenney	6-1 8-9 6-4
					Betsy Nagelsen
55.			Gail Sherriff		7-5 6-3
				Gail Sherriff
56.			Beatriz Araujo	6-1 6-0
							Virginia Wade
57.			Ann Kiyomura				6-3 6-1
				Ann Kiyomura
58.			Jackie Fayter	6-0 9-8
					Ann Kiyomura
59.			Marina Kroschina		8-6 2-6 6-3
				Marina Kroschina
60.			Dianne Fromholtz	6-4 6-1
						Patti Hogan
61.			Patti Hogan			6-4 6-2
				Patti Hogan
62.			Wendy Overton	8-6 8-6
					Patti Hogan
63.			Brigette Cuypers		6-3 6-0
				Brigette Cuypers
64.			Claire Colman	6-1 6-2
										Chris Evert
65.			Greer Stevens							6-0 6-4
				Greer Stevens
66.		[LL]	Sue Stap	1-6 6-1 6-1
					Greer Stevens
67.			Mimi Wikstedt		6-3 6-3
				Mimi Wikstedt
68.		[LL]	Elly Appel	6-3 4-6 6-4
						Tory Fretz
69.			Tory Fretz			6-3 6-2
				Tory Fretz
70.			Judith Dibar	2-6 6-1 6-2
					Tory Fretz
71.			Wendy Turnbull		7-5 6-3
				Wendy Turnbull
72.			Barbara Downs	6-2 6-2
							Kerry Melville
73.			Julie Heldman				5-1 rtd.
				Julie Heldman
74.			Lisa Fleming	6-3 6-0
					Kazuko Sawamatsu
75.			Kazuko Sawamatsu		6-4 6-4
				Kazuko Sawamatsu
76.		[Q]	Patricia Bostrom	6-2 6-2
						Kerry Melville
77.		[Q]	Robin Tenney			6-2 6-3
				Robin Tenney
78.			Corinne Molesworth	6-2 6-3
					Kerry Melville
79.		[6]	Kerry Melville		6-4 6-1
				Kerry Melville
80.			Betty Stove	4-6 6-4 6-4
								Kerry Melville
81.			Kristien Kemmer Shaw					9-7 1-6 6-2
				Kristien Kemmer Shaw
82.			Linda Mottram	6-0 6-3
					Kristien Kemmer Shaw
83.			Sharon Walsh		1-6 6-2 6-3
				Sharon Walsh
84.			Jeanne Evert	8-6 6-4
						Kristien Kemmer Shaw
85.			Fiorella Bonicelli			6-4 3-6 8-6
				Fiorella Bonicelli
86.			Marie Neumanova	6-3 6-4
					Fiorella Bonicelli
87.			Kate Latham		2-6 7-5 6-2
				Kate Latham
88.		[Q]	Sally Greer	6-1 9-8
							Evonne Goolagong
89.			Paulina Peisachov				6-1 6-4
				Paulina Peisachov
90.			Carolyn Meyer	6-4 6-3
					Kerry Harris
91.			Kerry Harris		6-3 6-3
				Kerry Harris
92.			Lindsey Beaven	6-2 6-3
						Evonne Goolagong
93.			Ilana Kloss			4-6 7-5 6-4
				Ilana Kloss
94.			Lany Kaligis	6-1 6-2
					Evonne Goolagong
95.		[3]	Evonne Goolagong		6-2 6-4
				Evonne Goolagong
96.			Marijke Jansen	6-1 6-1
									Chris Evert
97.			Annette Coe						6-2 6-3
				Annette Coe
98.			bye
					Janet Young
99.			Janet Young		6-2 6-8 8-6
				Janet Young
100.			bye
						Helga Niessen
101.			Helga Niessen			5-7 9-8 7-5
				Helga Niessen
102.			bye
					Helga Niessen
103.			Joyce Barclay		9-8 6-4
				Joyce Barclay
104.			bye
							Helga Niessen
105.			Valerie Ziegenfuss				6-2 6-4
				Valerie Ziegenfuss
106.			bye
					Raquel Giscafre
107.			Raquel Giscafre		1-6 6-1 6-2
				Raquel Giscafre
108.			bye
						Raquel Giscafre
109.			Glynis Coles			6-3 6-2
				Glynis Coles
110.			bye
					Tine Zwaan
111.		[LL]	Tine Zwaan		6-3 5-7 6-2
				Tine Zwaan
112.			bye
								Chris Evert
113.		[Q]	Chris O'Neil					6-4 6-2
				Chris O'Neil
114.			bye
					Chris O'Neil
115.			Rowena Whitehouse		1-6 6-2 6-2
				Rowena Whitehouse
116.			bye
						Mona Schallau
117.			Nathalie Fuchs			6-2 6-3
				Nathalie Fuchs
118.			bye
					Mona Schallau
119.			Mona Schallau		6-0 6-0
				Mona Schallau
120.			bye
							Chris Evert
121.		[Q]	Chris Matison				7-5 6-1
				Chris Matison
122.			bye
					Maria-Isabel Fernandez
123.			Maria-Isabel Fernandez		6-2 5-7 6-3
				Maria-Isabel Fernandez
124.			bye
						Chris Evert
125.			Lesley Hunt			6-1 6-1
				Lesley Hunt
126.			bye
					Chris Evert
127.		[2]	Chris Evert		8-6 5-7 11-9
				Chris Evert
128.			bye

(default) 17 queries took 32 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` = '1974' 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` = (1785) 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 (9406, 11256, 11215, 12389, 9325, 9638, 11228, 9544, 9520, 10880, 9464, 11089, 9505, 9562, 9393, 11129, 9449, 11233, 9573, 9552, 9577, 9503, 9670, 9582, 9545, 11088, 11220, 9554, 9391, 9575, 9606, 9540, 9528, 11226, 11239, 11117, 9636, 11231, 9363, 11234, 9564, 9569, 11240, 9513, 9512, 11199, 11249, 12438, 9651, 12433, 9574, 11237, 11062, 9459, 9507, 11210, 9561, 12437, 9539, 9609, 11227, 11211, 9376, 9455, 11216, 9591, 9515, 11241, 9451, 9660, 9701, 9588, 11238, 11266, 9458, 9553, 11254, 9477, 9452, 11195, 12440, 9481, 9396, 11063, 11185, 9423, 9533, 12418, 9571, 11250, 9529, 9519, 9525, 11201, 9399, 9672) ORDER BY `Player`.`lastname` ASC, `Player`.`firstname` ASC	96	96	6
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` = 1785	96	96	1
11	SELECT `Countrycode`.`id`, `Countrycode`.`code` FROM `zavoihu1_db4tennis`.`countrycodes` AS `Countrycode` WHERE `Countrycode`.`id` IN (178, 197, 133, 10, 196, 198, 172, 68, 43, 13, 153, 21, 219, 87, 217, 218, 212, 91, 94)	19	19	1
12	SELECT `Countrycode`.`id`, `Countrycode`.`name` FROM `zavoihu1_db4tennis`.`countrycodes` AS `Countrycode` WHERE `Countrycode`.`id` IN (178, 197, 133, 10, 196, 198, 172, 68, 43, 13, 153, 21, 219, 87, 217, 218, 212, 91, 94)	19	19	5
13	SELECT `Playercontest`.`player_id`, `Playercontest`.`nat_id` FROM `zavoihu1_db4tennis`.`playercontests` AS `Playercontest` WHERE ((`Playercontest`.`player_id` IN (9406, 11256, 11215, 12389, 9325, 9638, 11228, 9544, 9520, 10880, 9464, 11089, 9505, 9562, 9393, 11129, 9449, 11233, 9573, 9552, 9577, 9503, 9670, 9582, 9545, 11088, 11220, 9554, 9391, 9575, 9606, 9540, 9528, 11226, 11239, 11117, 9636, 11231, 9363, 11234, 9564, 9569, 11240, 9513, 9512, 11199, 11249, 12438, 9651, 12433, 9574, 11237, 11062, 9459, 9507, 11210, 9561, 12437, 9539, 9609, 11227, 11211, 9376, 9455, 11216, 9591, 9515, 11241, 9451, 9660, 9701, 9588, 11238, 11266, 9458, 9553, 11254, 9477, 9452, 11195, 12440, 9481, 9396, 11063, 11185, 9423, 9533, 12418, 9571, 11250, 9529, 9519, 9525, 11201, 9399, 9672)) AND (`Playercontest`.`contest_id` = 1785))	96	96	5
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` = 1974	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	0

(default) 17 queries took 32 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` = '1974' 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` = (1785) 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 (9406, 11256, 11215, 12389, 9325, 9638, 11228, 9544, 9520, 10880, 9464, 11089, 9505, 9562, 9393, 11129, 9449, 11233, 9573, 9552, 9577, 9503, 9670, 9582, 9545, 11088, 11220, 9554, 9391, 9575, 9606, 9540, 9528, 11226, 11239, 11117, 9636, 11231, 9363, 11234, 9564, 9569, 11240, 9513, 9512, 11199, 11249, 12438, 9651, 12433, 9574, 11237, 11062, 9459, 9507, 11210, 9561, 12437, 9539, 9609, 11227, 11211, 9376, 9455, 11216, 9591, 9515, 11241, 9451, 9660, 9701, 9588, 11238, 11266, 9458, 9553, 11254, 9477, 9452, 11195, 12440, 9481, 9396, 11063, 11185, 9423, 9533, 12418, 9571, 11250, 9529, 9519, 9525, 11201, 9399, 9672) 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` = 1785

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

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

SELECT `Playercontest`.`player_id`, `Playercontest`.`nat_id` FROM `zavoihu1_db4tennis`.`playercontests` AS `Playercontest` WHERE ((`Playercontest`.`player_id` IN (9406, 11256, 11215, 12389, 9325, 9638, 11228, 9544, 9520, 10880, 9464, 11089, 9505, 9562, 9393, 11129, 9449, 11233, 9573, 9552, 9577, 9503, 9670, 9582, 9545, 11088, 11220, 9554, 9391, 9575, 9606, 9540, 9528, 11226, 11239, 11117, 9636, 11231, 9363, 11234, 9564, 9569, 11240, 9513, 9512, 11199, 11249, 12438, 9651, 12433, 9574, 11237, 11062, 9459, 9507, 11210, 9561, 12437, 9539, 9609, 11227, 11211, 9376, 9455, 11216, 9591, 9515, 11241, 9451, 9660, 9701, 9588, 11238, 11266, 9458, 9553, 11254, 9477, 9452, 11195, 12440, 9481, 9396, 11063, 11185, 9423, 9533, 12418, 9571, 11250, 9529, 9519, 9525, 11201, 9399, 9672)) AND (`Playercontest`.`contest_id` = 1785))

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

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)