US Open 1974 Women's Singles (August 28 - September 9)

	Nation		R64	R32	R16	QF	SF	F	Champion
1.		[2]	Chris Evert
				Chris Evert
2.			Gail Sherriff	6-1 6-1
					Chris Evert
3.			Helen Gourlay		6-1 6-1
				Helen Gourlay
4.			Raquel Giscafre	1-6 6-2 6-2
						Chris Evert
5.			Patti Hogan			6-2 6-2
				Patti Hogan
6.			Sally Greer	6-2 6-0
					Patti Hogan
7.			Lindsey Beaven		6-1 6-2
				Lindsey Beaven
8.			Helle Sparre	6-4 4-6 6-0
							Chris Evert
9.			Sue Mappin				7-6 6-3
				Sue Mappin
10.			Lea Antonoplis	3-6 6-3 6-2
					Sue Mappin
11.			Francoise Durr		7-5 7-6
				Francoise Durr
12.			Janet Haas	6-3 6-4
						Lesley Hunt
13.			Mima Jausovec			6-2 6-0
				Mima Jausovec
14.			Kristien Kemmer Shaw	6-4 6-2
					Lesley Hunt
15.		[8]	Lesley Hunt		6-2 6-3
				Lesley Hunt
16.			Kazuko Sawamatsu	6-4 7-5
								Evonne Goolagong
17.		[4]	Kerry Melville					6-0 6-7 6-3
				Kerry Melville
18.			Ana-Maria Arias	4-0 rtd.
					Kerry Melville
19.			Kate Latham		6-3 7-6
				Kate Latham
20.			Sue Stap	6-4 6-2
						Kerry Melville
21.			Carolyn Meyer			7-6 1-6 6-1
				Carolyn Meyer
22.			Julie Anthony	6-4 6-2
					Carolyn Meyer
23.			Cecilia Martinez		7-6 6-4
				Cecilia Martinez
24.			Kathy Kuykendall	6-7 6-1 6-4
							Evonne Goolagong
25.			Katja Burgemeister				6-4 7-5
				Katja Burgemeister
26.			Laurie Fleming Rowley	6-1 6-0
					Katja Burgemeister
27.			Paulina Peisachov		4-6 7-5 7-5
				Paulina Peisachov
28.			Lesley Charles	6-2 7-5
						Evonne Goolagong
29.			Tine Zwaan			6-0 6-0
				Tine Zwaan
30.			Karen Krantzcke	1-6 6-2 6-3
					Evonne Goolagong
31.		[5]	Evonne Goolagong		6-1 6-2
				Evonne Goolagong
32.			Jeanne Evert	6-3 6-0
									Billie Jean King
33.		[7]	Virginia Wade						3-6 6-3 7-5
				Virginia Wade
34.			Mona Schallau	6-1 6-1
					Ann Kiyomura
35.			Ann Kiyomura		7-6 2-6 7-5
				Ann Kiyomura
36.			Peggy Michel	6-3 6-0
						Nancy Richey
37.			Nancy Richey			6-2 6-2
				Nancy Richey
38.			Chris O'Neil	6-1 2-6 6-2
					Nancy Richey
39.			Patricia McClenaughan		4-6 6-1 6-3
				Patricia McClenaughan
40.			Virginia Ruzici	2-6 6-3 6-3
							Julie Heldman
41.			Julie Heldman				7-5 7-6
				Julie Heldman
42.			Marcie Louie	6-0 6-1
					Julie Heldman
43.			Janet Young		2-6 6-3 6-4
				Janet Young
44.			Jackie Fayter	6-2 6-1
						Julie Heldman
45.			Betty Stove			6-4 6-4
				Betty Stove
46.			Nathalie Fuchs	6-4 6-2
					Martina Navratilova
47.			Martina Navratilova		6-2 6-2
				Martina Navratilova
48.			Rayni Fox	3-6 7-5 7-6
								Billie Jean King
49.		[6]	Rosie Casals					2-6 6-3 6-1
				Rosie Casals
50.			Barbara Downs	6-2 6-2
					Rosie Casals
51.			Ilana Kloss		6-3 6-4
				Ilana Kloss
52.			Janet Newberry	6-2 4-6 7-5
						Rosie Casals
53.			Dianne Fromholtz			7-6 6-2
				Dianne Fromholtz
54.			Laura DuPont	6-1 6-2
					Dianne Fromholtz
55.			Mariana Simionescu		1-6 6-2 6-4
				Mariana Simionescu
56.			Donna Ganz	7-5 7-6
							Billie Jean King
57.			Betsy Nagelsen				6-1 7-6
				Betsy Nagelsen
58.			Marie Neumanova	6-7 6-2 6-3
					Betsy Nagelsen
59.			Pam Teeguarden		6-3 6-3
				Pam Teeguarden
60.			Wendy Overton	6-3 6-1
						Billie Jean King
61.			Sharon Walsh			6-4 6-2
				Sharon Walsh
62.			Robin Tenney	6-3 6-3
					Billie Jean King
63.		[1]	Billie Jean King		6-0 6-1
				Billie Jean King
64.			Maria-Isabel Fernandez	6-2 6-2

(default) 17 queries took 56 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	31
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	3
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	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` = (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` = '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` = (1392) ORDER BY `Match`.`round_id` ASC, `Match`.`no` ASC	63	63	1
9	SELECT `Player`.`id`, `Player`.`name`, `Player`.`gender`, `Player`.`slug` FROM `zavoihu1_db4tennis`.`players` AS `Player` WHERE `Player`.`id` IN (9672, 9363, 9391, 9423, 9512, 9588, 9553, 11272, 9577, 9693, 12389, 11219, 9670, 11216, 9399, 9539, 9376, 11175, 9701, 12433, 11266, 11239, 9599, 11252, 9618, 11242, 11238, 9544, 12418, 9393, 9452, 11241, 9528, 9519, 9564, 9575, 9442, 9571, 9354, 9638, 9561, 9659, 9481, 9569, 9455, 9529, 9582, 9616, 9449, 11210, 11254, 9551, 9513, 9587, 11215, 11235, 9636, 9660, 9573, 11199, 9515, 11227, 9406, 11201) ORDER BY `Player`.`lastname` ASC, `Player`.`firstname` ASC	64	64	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` = 1392	64	64	2
11	SELECT `Countrycode`.`id`, `Countrycode`.`code` FROM `zavoihu1_db4tennis`.`countrycodes` AS `Countrycode` WHERE `Countrycode`.`id` IN (197, 41, 196, 68, 212, 43, 13, 10, 219, 172, 217, 91, 153, 94, 133, 54)	16	16	2
12	SELECT `Countrycode`.`id`, `Countrycode`.`name` FROM `zavoihu1_db4tennis`.`countrycodes` AS `Countrycode` WHERE `Countrycode`.`id` IN (197, 41, 196, 68, 212, 43, 13, 10, 219, 172, 217, 91, 153, 94, 133, 54)	16	16	2
13	SELECT `Playercontest`.`player_id`, `Playercontest`.`nat_id` FROM `zavoihu1_db4tennis`.`playercontests` AS `Playercontest` WHERE ((`Playercontest`.`player_id` IN (9672, 9363, 9391, 9423, 9512, 9588, 9553, 11272, 9577, 9693, 12389, 11219, 9670, 11216, 9399, 9539, 9376, 11175, 9701, 12433, 11266, 11239, 9599, 11252, 9618, 11242, 11238, 9544, 12418, 9393, 9452, 11241, 9528, 9519, 9564, 9575, 9442, 9571, 9354, 9638, 9561, 9659, 9481, 9569, 9455, 9529, 9582, 9616, 9449, 11210, 11254, 9551, 9513, 9587, 11215, 11235, 9636, 9660, 9573, 11199, 9515, 11227, 9406, 11201)) AND (`Playercontest`.`contest_id` = 1392))	64	64	1
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` = 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	1

(default) 17 queries took 56 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` = '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` = (1392) ORDER BY `Match`.`round_id` ASC, `Match`.`no` ASC

SELECT `Player`.`id`, `Player`.`name`, `Player`.`gender`, `Player`.`slug` FROM `zavoihu1_db4tennis`.`players` AS `Player` WHERE `Player`.`id` IN (9672, 9363, 9391, 9423, 9512, 9588, 9553, 11272, 9577, 9693, 12389, 11219, 9670, 11216, 9399, 9539, 9376, 11175, 9701, 12433, 11266, 11239, 9599, 11252, 9618, 11242, 11238, 9544, 12418, 9393, 9452, 11241, 9528, 9519, 9564, 9575, 9442, 9571, 9354, 9638, 9561, 9659, 9481, 9569, 9455, 9529, 9582, 9616, 9449, 11210, 11254, 9551, 9513, 9587, 11215, 11235, 9636, 9660, 9573, 11199, 9515, 11227, 9406, 11201) 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` = 1392

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

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

SELECT `Playercontest`.`player_id`, `Playercontest`.`nat_id` FROM `zavoihu1_db4tennis`.`playercontests` AS `Playercontest` WHERE ((`Playercontest`.`player_id` IN (9672, 9363, 9391, 9423, 9512, 9588, 9553, 11272, 9577, 9693, 12389, 11219, 9670, 11216, 9399, 9539, 9376, 11175, 9701, 12433, 11266, 11239, 9599, 11252, 9618, 11242, 11238, 9544, 12418, 9393, 9452, 11241, 9528, 9519, 9564, 9575, 9442, 9571, 9354, 9638, 9561, 9659, 9481, 9569, 9455, 9529, 9582, 9616, 9449, 11210, 11254, 9551, 9513, 9587, 11215, 11235, 9636, 9660, 9573, 11199, 9515, 11227, 9406, 11201)) AND (`Playercontest`.`contest_id` = 1392))

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